Oracle 12c OCP 1Z0-061: SQL Fundamentals
$99.00
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
- Introduction
- Intro To Oracle 12c-SQL Fundamentals
- Structure Of SQL
- Basic Select Statements
- Basic Select Statements Demo
Module 2: Retrieving Data
- Modifying Reported Output
- The Where Clause
- The Order By Clause
- Left And Right Outer Joins
- The Where Clause Demo
- Multi-Table Selection Demo
Module 3: SQL Functions
- Single Row Functions
- Aggregate Functions
- Single Row Functions Demo
- Muiltrow Functions Demo
- Group By
- Grouping Demo
- Conversion Functions
- Conversion Functions Demo
- Datetime Functions
- Datetime Functions Demo
Module 4: Subqueries
- Single-Row Subqueries
- Single-Row Subqueries Demo
- Multi-Row Subqueries
- Multi-Row Subqueries Demo
- Other Subquery Types
- Other Subquery Types Demo
Module 5: Data Manipulation Language
- Adding Data
- Changing Data
- Deleting Data
- DML Demo
Module 6: Data Control Language
- Security
- Object Privileges
- DCL Demo
Module 7: Data Definition Language
- Creating Objects In The Database
- Creating Objects In The Database Demo
- Sequences
- Sequenced Demo
- Indexes
- Views
Module 8: Combining Queries
- Combining Queries
Module 9: Oracle 12C SQL Fundamentals Review
- Oracle 12c SQL Fundamentals Review - Part 1
- Oracle 12c SQL Fundamentals Review - Part 2
- Oracle 12c SQL Fundamentals Review - Part 3
- Conclusion

16 Hours 1 Minute |
|
45 Course Videos |
|
245 Test Questions |