Introduction to SQL Training Course

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 Standard Joins

Session 5: BASIC SUBQUERIES AND SET OPERATORS

• • Overview of Subqueries
• • Basic Subqueries
• • Set Operators