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

Product type
Logo DutchTrain
Provider rating: starstarstarstarstar_border 7.7 DutchTrain has an average rating of 7.7 (out of 52 reviews)

Tip: need more info about the programme or price? Request information for free!

Description

Al onze klassikale trainingen worden op dit moment gegeven in onze Dynamic Virtual Classroom. 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…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle, PL/SQL, M&A (Mergers & Acquisitions), CompTIA A+ / Network+ / Security+, and IT Security.

Al onze klassikale trainingen worden op dit moment gegeven in onze Dynamic Virtual Classroom. 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

There are no reviews yet.

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.

Where should we send the information?

Gender
(optional)
(optional)
(optional)
(optional)
(optional)
We store your personal details, and share them with DutchTrain, in order to help you along via email and potentially via phone. You can find more info in our privacy policy.