Enable Technology

SQL 

SQL




Course Overview


SQL (Structured Query Language) is central to working with any form of database. In this practical hands on course participants learn how to use the full potential of SQL to write complex queries. The course covers select statements, grouping and aggregating  data,  joins,  subqueries and unions. Participants will also learn how to insert, update and delete data and how to create and alter Views and Stored Procedures. The course will significantly help anyone who needs to retrieve or manipulate information in a relational database. No prior knowledge of SQL is required.

Duration: 2 day course



Course Content


Relational Databases
Tables 
Rows
Columns 
Relationships 
Datatypes   
Primary Keys
Foreign Keys
Relational Database Management System 
Popular Databases  

Simple SELECT Statements
Comments
Whitespace and Semi-colons
Case Sensitivity
Selecting All Columns in All Rows
Selecting Specific Columns
Sorting Records 
Sorting By a Single Column
Sorting By Multiple Columns  
Sorting By Column Position
Ascending and Descending Sorts        

The WHERE Clause and Operator Symbols 
Checking for Equality
Checking for Inequality    
 Using the WHERE clause to check for greater or less than
Checking for NULL 
WHERE and ORDER BY  

The WHERE Clause and Operator Words    
The BETWEEN Operator   
The IN Operator 
The LIKE Operator   
The NOT Operator 

Checking Multiple Conditions 
AND
OR
Order of Evaluation  

Advanced SELECTs    
Calculated Fields
Concatenation
Mathematical Calculations
Aliases
Aggregate Functions
Grouping and Aggregating Data    
Selecting Distinct Records
Common Math Functions    
Common String Functions
Common Date Functions 

Subqueries, Joins and Unions
Subqueries      
Joins
Table Aliases  
Multi-table Joins  
Outer Joins

Conditional Processing with CASE

CASE syntax
Using CASE 

Inserting, Updating and Deleting Records
INSERT
UPDATE
DELETE   

Creating and Modifying Tables 
Data Types
Creating Tables
NULL Values 
Primary Keys
Foreign Keys   
Creating Tables
Adding and Dropping Columns
Renaming Tables    
Dropping Tables

Views  
Creating Views
Dropping Views
Benefits of Views 

Stored Procedures
Creating Stored Procedures 
Dropping Stored Procedures
Benefits of Stored Procedures


Email us about this courses


Telephone on 01952 305730