Oracle Database 12c R2 – SQL Fundamentals | Exam 1Z0-071

Oracle Database 12c R2 – SQL Fundamentals | Exam 1Z0-071

This Oracle Database SQL fundamentals training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. This course will help you understand the advanced features of SQL. Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL through expert instruction.

Prerequisites

Working knowledge of SQL and use of PL/SQL packages.

Course outcome

– Understand the basic concepts of relational databases ensure refined code by developers
– Create reports of sorted and restricted data
– Run data manipulation statements (DML)
– Control database access to specific objects
– Manage schema objects
– Manage objects with data dictionary views
– Retrieve row and column data from tables
– Control privileges at the object and system level
– Create indexes and constraints; alter existing schema objects
– Create and query external tables

Audience

– Database Administrators
– System Administrators
– Developers

Package Includes

– 12 Months Online Access featuring ondemand instructor-led classroom sessions with full audio and video lectures
– TestPrep Exam simulation
– Tips & Tricks

Hybrid Learning is a unique mix of training material, videos and exercises that the user can independently apply to his learning demand. You have access to the online training material for up to 12 months. This way you can read and practice the material you have learned several times to optimally prepare for the 1Z0-071 exam..

Course content

– Using Structured Query Language (SQL)
– Data Manipulation Language and Transaction Control Language
– Using Basic SELECT statements
– Conversion Functions and Conditional Expressions
– Displaying Data from Multiple Tables
– Using the Set Operators
– Managing Objects with Data Dictionary Views
– Managing Schema Objects
– Data Definition Language (DDL)
– SQL*Plus
– Restricting and Sorting Data
– Using Single-Row Functions to Customize Output
– Reporting Aggregated Data Using the Group Functions
– Using Subqueries to Solve Queries
– Creating Other Schema Objects
– Controlling User Access
– Manipulating Data Using Advanced Queries

Exam not included

1Z0-071 Oracle Database SQL

DutchTrain is an officially accredited Test Center for Pearson Vue Test, Prometric, Kryterion, Castle Worldwide, Certiport & PSI. You are most welcome with us for exams that are available through these Test Centers. Exams can be taken every day, within office hours.

Date

You can start at any time! Please contact one of our training advisers if you would like to start.

Location

Self-study - It is possible to login 24/7 from any location to our Education On Demand Portal.

Learning method

E-Learning

Language

English

More information

Check our website for detailed lesson content, exams and more details of this training.

This training is also available as

- Instructor-led classroom training
– Incompany, please contact one of our training advisers.