Detailed Course Outline
Course Contents - DAY 1
Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
Session 1: RELATIONAL DATABASE CONCEPTS
- What is a Relational Database?
- Relational Database Structures
- Tables, Rows and Columns
- Indexes, Primary Keys and Foreign Keys
- Data Types
- The Data Dictionary
Session 2: RETRIEVING DATA WITH THE SELECT STATEMENT
- The Select Statement
- The Select and From Clauses
- Conditions and the Where Clause
- Other Conditional Operators
- Logical Operators
- The Order By Clause
- Column Aliases
- Arithmetic Operations
- Precedence of Operators
Session 3: AGGREGATE FUNCTIONS
- Overview of Built in Aggregate Functions
- The Group By Clause
- The Having Clause
Session 4: JOINING TABLES
- Overview of Table Joins
- Inner Joins
- Table Aliases
- Outer Joins
- Self Joins
- ANSI Join Syntax
Session 5: BASIC SUBQUERIES AND SET OPERATORS
- Overview of Subqueries
- Basic Subqueries
- Set Operators