What you'll 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