 |
|
|
|
|
|
|
Fail fast and fail often
T. Watson |
 |
|
|
 |
|
|
|
| |
|
|
|
SQL Scripting - Introduction
Course Objectives:
On completion of this course delegates will be able to write SQL code to ANSI standard
Target Audience:
This course is designed for those that need to know how to query databases using SQL
Pre-requisites:
Delegates must be able to use a Microsoft Windows and a mouse |
|
| Introduction of Database Concepts |
Overview of Databases
Overview of Fields & Data Types
Overview of Fields & Data Types
|
| The SELECT clause |
Overview of the SELECT clause
Using Field Aliases
Writing String Formulas
Writing DateTime Formulas
Using the CAST & CONVERT functions
Using the CASE Statement
|
| The FROM clause |
Overview of the FROM clause
Linking
Using Table Aliases
Joining Multiple Tables
Overview of the Join Types
|
| The WHERE clause |
Overview of the WHERE clause
Creating single Criteria
Using the AND, OR & IN operators
Using Parameters
|
| The ORDER BY clause |
Overview of the ORDER BY clause
The Order By syntax
Top/Bottom N
Top/Bottom Percentage
|
| Aggregate SQL Statements |
Overview of the Aggregate functions
Overview of the GROUP BY clause
Overview of the HAVING clause
|
|
|
|
