Oracle Database SQL Certified Associate 1Z0-071

Become Oracle SQL Certified ( OCA ) / Covers ORACLE university track 100%. All the presentations + scripts are attached

Created by: Khaled Alkhudari
Sr Oracle Developer/ Sr system analyst

What Will I Learn?

• The Full track of Oracle Database 12c: Introduction to SQL Ed 2.
• You will be prepared 100% to pass exams Oracle Database SQL 1Z0-071 And also exam Oracle Database 12c: SQL Fundamentals 1Z0-061
• Very strong introduction to make you understand the oracle database and RDBMS.
• Oracle Database 12c Architecture
• Downloading and installing oracle database 12c in details
• Connecting to the Database
• Retrieving data using the select statement / Restricting and Sorting Data
• Substitution Variables
• Using Single-Row Functions to Customize Output
• Reporting Aggregated Data Using the Group Functions
• Displaying Data from multiple tables using joins
• Using Subqueries to Solve Queries
• Using the Set Operators
• Managing tables using DML Statments ( Insert, Update, Delete )
• Data Definition Language / Creating tables
• Data Dictionary Views
• Creating sequences, synonyms, and indexes
• Creating Views in details
• Managing Schema Objects
• Retrieving Data By Using Subqueries
• Manipulating Data By Using Subqueries
• Controlling User Access in details
• Manipulating Data
• Managing Data in Different Time Zones
• Exam information / Exams Details / Exam Practice
• many other information, you can see the full curriculum

Requirements

• This course start from zero knowledge to expert level.
• Windows Operating system is preferred, but this is not mandatory if you have the knowledge of downloading Oracle database 12c on other OS.
• Downloading oracle database and this will be covered in details on Windows OS.
• No need for any prerequisite database skills, this course designed from Zero to certified level.

Target audience

• Students who wants to be expert in oracle database 12c.
• Students who wants to be certified in oracle database from Oracle University.
• Fresh IT students who need strong SQL and database knowledge.
• Fresh and junior programmers who need to find better jobs by gaining oracle certification.