Oracle 12c OCP 1Z0-061: SQL Fundamentals

Curriculum

Module 1 Introduction To Oracle 12c SQL Fundamentals
1.1 Introduction To Course
1.2 Intro To Oracle 12c SQL Fundamentals
1.3 Structure Of SQL
1.4 Basic Select Statements
1.5 Basic Select Statements Demo

Module 2 Retrieving Data
2.1 Modifying Reported Output
2.2 The Where Clause
2.3 The Order By Clause
2.4 Left And Right Outer Joins
2.5 The Where Clause Demo
2.6 MultiTable Selection Demo

Module 3 SQL Functions
3.1 Single Row Functions
3.2 Aggregate Functions
3.3 SingleRow Functions Demo
3.4 MultiRow Functions Demo
3.5 Group By
3.6 Grouping Demo
3.7 Conversion Functions
3.8 Conversion Functions Demo
3.9 Datetime Functions
3.10 Datetime Functions Demo

Module 4 Subqueries
4.1 SingleRow Subqueries
4.2 SingleRow Subqueries Demo
4.3 MultiRow Subqueries
4.4 MultiRow Subqueries Demo
4.5 Other Subquery Types
4.6 Other Subquery Types Demo

Module 5 Data Manipulation Language
5.1 Adding Data
5.2 Changing Data
5.3 Deleting Data
5.4 DML Demo

Module 6 Data Control Language
6.1 Security
6.2 Object Privileges
6.3 DCL Demo

Module 7 Data Definition Language
7.1 Creating Objects In The Database
7.2 Creating Objects In The Database Demo
7.3 Sequences
7.4 Sequenced Demo
7.5 Indexes
7.6 Views

Module 8 Combining Queries
8.1 Combining Queries

Module 9 Oracle 12C SQL Fundamentals Review
9.1 Oracle 12c SQL Fundamentals Review-Part 1
9.2 Oracle 12c SQL Fundamentals Review-Part 2
9.3 Oracle 12c SQL Fundamentals Review-Part 3
9.4 Conclusion