Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
All things good to know, are difficult to learn
 
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

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


If you require a tailored course click here