Oracle 12c OCP 1Z0-061: SQL Fundamentals

About this course

With Oracle Database 12c: SQL Fundamentals, you experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c: SQL Fundamentals certifications emphasize the full set of skills that DBAs need in today’s competitive marketplace

Course Outline

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

Reviews