Enable Technology

Database 

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






Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.




West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;