SQL (Structured Query Language) Training

SQL (Structured Query Language) is a widely used database language. It is used by a number of database systems to create queries and manipulate data. SQL certified individuals are valued for their knowledge and skill. SQL is also compatible with the majority of databases as it is so generic, as a result training for SQL is critical.

During the course delegates will carry out tasks and excercises enabling delegates to become familiar with SQL in practical terms.

This introduction to SQL training course explores the following modules:

Course:
SQL (Structured Query Language) Training
Duration:
2 days
Delivery:
Instructor Led with hands on excercises
Events:

Private and Bespoke Training available on demand

Attendees:
BI Developers and Architects
Numbers:
Up to 15 delegates per training.

Agenda:

Day 1

  • What is SQL?
    • What Can SQL do?          
    • SQL Syntax
    • Keys     
    • Primary Key       
    • Composite Key 
    • Foreign Key       
  • SQL Select Distinct       
  • 3 SQL Order By 
  • SQL Where
  • SQL And, Or, Not
    • Order of Evaluation-SQL processes ANDs before ORs.     
  • SQL Min, Max, Count, Average and Sum            
    • Count   
    • Avg       
    • Max      
    • Min
    • SQL Group By
    • SQL Having         
  • SQL Like and SQL Wildcards
  • SQL In
  • SQL Between
  • SQL Aliases
  • SQL Calculated Fields
    • Percentages
  • SQL Data Manipulation Functions      
  • SQL Dates     
  • SQL Joins      
    • SQL Inner Join         
    • SQL Left Outer Join
    • SQL Right Outer Join             
    • SQL Full Join             
    • SQL Self Join            
  • SQL Sub Query           
    • Type of Subqueries   

Day 2

  • SQL Union    
  • SQL Exists     
  • SQL Any, All 
  • SQL Select Into           
  • SQL Insert Into Select              
  • SQL Null Functions    
  • SQL Comments          
  • SQL Update 
  • SQL Delete   
  • SQL Select Top            
  • Temporary Tables
  • With (Common Table Expressions)    
  • Views
  • Declare and Set a Variable     
  • IF Exists, Then Else
  • SQL Store Procedures
  • SQL Server Profiler   
  • Indexing       
    • Clustered Indexes           
    • Non Clustered Indexes  

 

Want to improve your SQL skills? Make an enquiry now to book onto our training course!