Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Don't rely on others to show you the way, carry your own map
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

SQL Scripting - Introduction

1 day

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


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

If you require a tailored course click here