Oracle Database 12c SQL Fundamentals

Course Syllabus

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 FundamentalsReview

• 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