SQL Essentials

This course will be conducted using a Microsoft SQL Server.

• Introduction to databases

• Selecting data

• Grouping data

• Multiple table queries

• Working with joins

Course Overview

This course offers end-users a sound background on the concepts of a Relational Database Management System.

It is primarily aimed at end-users who need to understand SQL in order to effectively and efficiently query their corporate database either directly or through third-party Query and Reporting Tools.

Audience:

Users who will be querying the corporate database either directly or through third-party Query and Reporting Tools.

Prerequisites:

There are no particular requirements for this course.

Inclusions

• Training Manual with step by step instructions

• Practice files with relevant to the training material

• Training Completed files you are free to take away any completed files for review

• Unlimited online support as training does not stop when you walk out our door

Course Content

Learning Outcomes

At the end of the course students will be able to:

• Understand the basics of what a database is

• Formulate simple SELECT statements

• Qualify queries using the WHERE clause

• Summarise data using the GROUP BY and HAVING clauses

• Formulate complex queries which span multiple tables

• Gain an appreciation for performance when developing queries

• Gain confidence in developing accurate and efficient SQL queries

Introduction To Databases

• Defining a Databases Management System

• Defining a Relational Database Management System

• Defining Normalisation

• What Does SQL Do?

Basic SELECT Statement

• The SELECT Statement

• Restricting Columns

• Performing Arithmetic Computing

• SQL Functions

• Eliminating Duplicate Rows

• Sorting Data

Qualifying Data

• The WHERE Clause

• Comparison Operators

• Logical Operators

• Selecting NULL Values

• Subqueries

• ANY and ALL Predicates

• String Components

Combining Tables

• What is a Join?

• Why We Join Tables?

• How to Get a Good Join

• Formulation of a Join

Summarising Information

• Aggregate Functions

• Grouping Data

• Qualifying Groups of Data

• The Having Clause

More Complex SQL

• Exists Predicate

• Outer Joins

• Pattern Matching and String Manipulations

• Handling Date Comparisons and Manipulation