Oracle Database 12c R2 – SQL Fundamentals | Exam 1Z0-071
Description
Aan al onze trainingen kunt klassikaal deelnemen. Daarnaast worden onze klassikale trainingen ook nog steeds gegeven via onze Dynamic Virtual Classroom. Zo kunt u kiezen voor de optie waar u zich prettig bij voelt. In onze Dynamic Virtual Classroom zijn zowel de docent als de cursisten zichtbaar met elkaar verbonden en kunnen documenten en beeldschermen met alle deelnemers worden gedeeld. Cursisten hebben de mogelijkheid, net zoals in een klassikale training, om zowel onderling als met de docent te communiceren en opdrachten te maken. Een actieve klassikale training maar dan op afstand.
Daarnaast zijn veel van onze trainingen ook beschikbaar
als
E-Learning in onze Education On Demand Omgeving. Deze
E-Learning trainingen kunt u volgen vanaf iedere gewenste locatie,
op ieder moment en heeft u 365 dagen toegang tot de online
training.
Bij DutchTrain staan wij voor u klaar.
Dutchtrain "Verder niks nodig"
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
Work…

Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Aan al onze trainingen kunt klassikaal deelnemen. Daarnaast worden onze klassikale trainingen ook nog steeds gegeven via onze Dynamic Virtual Classroom. Zo kunt u kiezen voor de optie waar u zich prettig bij voelt. In onze Dynamic Virtual Classroom zijn zowel de docent als de cursisten zichtbaar met elkaar verbonden en kunnen documenten en beeldschermen met alle deelnemers worden gedeeld. Cursisten hebben de mogelijkheid, net zoals in een klassikale training, om zowel onderling als met de docent te communiceren en opdrachten te maken. Een actieve klassikale training maar dan op afstand.
Daarnaast zijn veel van onze trainingen ook beschikbaar
als
E-Learning in onze Education On Demand Omgeving. Deze
E-Learning trainingen kunt u volgen vanaf iedere gewenste locatie,
op ieder moment en heeft u 365 dagen toegang tot de online
training.
Bij DutchTrain staan wij voor u klaar.
Dutchtrain "Verder niks nodig"
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.
Stay up-to-date on new reviews
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.