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.

0
Course Videos
0
Duration (hrs)
0
Questions

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