D80174 – Oracle Database: Introduction to SQL Ed 2

• Duration: 10 weeks

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 8: Using Subqueries to Solve Queries
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