Detailed Course Outline
- Introduction
- Using Single-Row Functions to Customize Output
- Displaying Data from Multiple Tables Using Joins
- Managing Tables using DML statements
- Creating Sequences, Synonyms, Indexes
- Retrieving Data by Using Subqueries
- Manipulating Data
- Retrieving Data using the SQL SELECT Statement
- Using Conversion Functions and Conditional Expressions
- Using Subqueries to Solve Queries
- Introduction to Data Definition Language
- Creating Views
- Manipulating Data by Using Subqueries
- Managing Data in Different Time Zones
- Restricting and Sorting Data
- Reporting Aggregated Data Using the Group Functions
- Using the SET Operators
- Introduction to Data Dictionary Views
- Managing Schema Objects
- Controlling User Access