Home > Course Catalog > Choose By Delivery Format > Self-Paced On-Demand > Oracle 12c OCP 1Z0-061: SQL Fundamentals On-Demand
$595
Course Duration: 4 hours 1 minute
Plan Type | Delivery Format | Days | Status | Price | Enroll |
---|---|---|---|---|---|
Self-Paced On-Demand | 365 | Yearly Subscription | $595 |
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.
Module 1: Introduction To Oracle 12c SQL
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
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