SQL ESSENTIALS

Course Overview

Learn how to write SQL (Structured Query Language) from scratch with our 1 day SQL Essentials training course. Our expert instructors will easily step you through writing SQL using Microsoft's SQL Server Management Studio to allow you to retrieve, sort, filter, group, aggregate and calculate data stored in a SQL Server database. SQL skills are highly sought after in web development, programming, data analysis and reporting environments.

Who Should Attend

This course is designed for people wanting to learn how to interrogate data from a relational database, however should you wish to learn how to manipulate this data (Insert, update, delete records) then our 1 day SQL Essentials – Data Management training course will be a natural progression for you.

Although we use SQL Server to interrogate data throughout this course, SQL is a common language easily adapted to other RDBMS (relational database management systems) such as MySQL, IBM DB2, PostgreSQL, Oracle, Ingres, Sybase and Microsoft Access.

Course Prerequisites

A solid understanding of database concepts or Access Advanced Course

Raising the Bar

1300 937 782

www.rtb.com.au

Understanding SQL

Database Basics
What is SQL?

Retrieving Data

The SELECT Statement
Retrieving Individual Columns
Retrieving Multiple Columns
Retrieving All Columns

Sorting Retrieved Data

Sorting Data
Sorting By Multiple Columns
Sorting By Column Position
Specifying Sort Direction

Filtering Data

Using the WHERE Clause
The WHERE Clause Operators

Advanced Data Filtering

Combining WHERE Clauses
Using the IN Operator
Using the NOT Operator

Using Wildcard Filtering

Using the LIKE Operator
Tips For Using Wildcards

Creating Calculated Fields

Understanding Calculated Fields
Concatenating Fields
Performing Mathematical Operations

Using Data Manipulation Functions

Understanding Functions
Using Functions

Summarizing Data

Using Aggregate Functions
Aggregates on Distinct Values
Combining Aggregate Functions

Grouping Data

Understanding Data Grouping
Creating Groups
Filtering Groups
Grouping and Sorting
SELECT Clause Ordering

Working with Subqueries

Understanding Subqueries
Filtering By Subquery
Using Subqueries As Calculated Fields

Joining Tables

Understanding Joins
Creating a Join

Creating Advanced Joins

Using Table Aliases
Using Different Join Types
Using Joins With Aggregate Functions
Using Joins And Join Conditions

Combining Queries

Understanding Combined Queries
Creating Combined Queries