Level 1

SQL Query Writing & Fundamentals

You’ll build a strong foundation in SQL and Databases, this will then allow you to start
building SQL queries and perform more complex reporting on a database.

  • Level: Beginner to Intermediate
  • Hours: 25 hours approximately

 

Level 1 SQL

Course Modules

  • 1. Databases – An Overview
  • 2. SQL – An Overview
  • 3. Getting Started with Microsoft SQL Server
  • 4. Retrieving data
  • 5. Working with Multi-table Queries
  • 6. Using SQL Functions in Queries
  • 7. Grouping Data
  • 8. Create, Modify and Delete Tables and Databases
  • 9. Manipulating data in a Table
  • 10. Working with Views and Stored Procedures

Level 2

SQL Intermediate to Advanced

You’ll be able to design and implement database models and database storage objects; deal with user-defined functions, triggers, stored procedures, advanced SQL query writing and reporting.

  • Level: Intermediate to Advanced
  • Hours: 40 hours approximately

 

Level 2 SQL Course

Course Modules

  • 1. Working with Query Fundamentals
  • 2. Querying Multiple Tables
  • 3. Implementing Aggregate Queries
  • 4. Combine and Compare Datasets
  • 5. Working with Transactions and Locking
  • 6. Modifying Data
  • 7. Working with Data Types and Creating Tables
  • 8. Implementing Data Integrity
  • 9. Using Advanced Query Techniques
  • 10. Using Programming Objects
  • 11. Working with Triggers and Views
  • 12. Improving Query Performance
  • 13. Working with Indexes and Partitions
  • 14. Working with XML in the database
  • 15. Working with SQLCLR and FILESTREAM
  • 16. Using Additional Functionality
  • 17. Implementing the Service Broker
  • 18. Using SQL Server Manageability Features
  • 19. Tracking Data Changes

Training Benefits

  • Flexible elearning
    You choose the hours you want to train
  • Specialised Teacher Support
    You will have support for your questions
  • Realistic Interactive Simulations
    To give you hands on skills and practice
  • Assessments
    Helps you to concentrate on problem areas
  • Audio Narration
    Choose to listen to the training
  • Reference Guides
    Print out course in Manual format to keep
  • Certificate of Completion
    Helps you get more job interviews

SQL Jobs

Our training is directly aligned with the job market. These are the current salary ranges.

Analyst – Data or Business - Salary $63,500 to $100,000+

Database Developer - Salary $64,000 to $100,000+

Database Architect or Analyst - Salary $104,000+

Consultant - Salary $112,000+

You’ll be eligible to sit the following Microsoft exams

  • 70-461 Querying Microsoft SQL Server
  • 70-464 Database Development SQL Server

A typical course module uses the structure below

method

What our customers are saying

Having someone to answer my questions was a real help. It got me over the barriers that were blocking me before.
Abha Patel
Abha Patel
Dallas
The step-by-step training method they use allowed me to follow the logic of the query writing, so I could learn it quicker.
Sally Warne
Sally Warne
Boston
The Technical Support guys were really patient with me, thanks again.
Peter Marsh
Peter Marsh
Washington
Enquire Now And receive our free ebook on SQL Joins