D80174 – Oracle Database: Introduction to SQL Ed 2

• Duration: 5 days

Curriculum

• Module 1: Introduction
• Module 2: Working with Oracle Cloud Exadata Express Cloud Service
• Module 3: Restricting and Sorting Data
• Module 4: Using Single-Row Functions to Customize Output
• Module 5: Using Conversion Functions and Conditional Expressions
• Module 6: Reporting Aggregated Data Using the Group Functions
• Module 7: Displaying Data from Multiple Tables Using Joins
  
• Module 9: Using the SET Operators
• Module 10: Managing Tables using DML statements
• Module 11: Introduction to Data Definition Language
• Module 12: Introduction to Data Dictionary Views
• Module 13: Creating Sequences, Synonyms, Indexes
• Module 14: Creating Views
• Module 15: Managing Schema Objects
• Module 16: Retrieving Data by Using Subqueries
• Module 17: Manipulating Data by Using Subqueries
• Module 18: Controlling User Access
• Module 19: Manipulating Data
• Module 20: Managing Data in Different Time Zones