Strategic Business IT Planning, Deployment & Management Courses


Advanced SQL Training

REF: 15092_293025
DATE: 01 - 05 Dec 2024
LOCATION:

Dubai (UAE)

INDIVIDUAL FEE:

4500 Euro



Introduction:

This course includes plenty of chances to experiment with what you are being taught and ask questions if you’re not sure of something. We make sure that no-one is left behind.

By the time you finish, you’ll be comfortable using a wide variety of advanced SQL queries.

A complete advanced SQL course that covers all of the advanced concepts and techniques. Plenty of one to one attention and time to ask questions.

Course Objectives:

At the end of this course the participants will be able to:

  • Write basic SELECT statements including wildcard characters and comparison operators.
  • Carry out mathematical calculations in SQL
  • Group and Count your data.
  • Learn how to use IF, CASE, and UNION queries.
  • Understand the basic error trapping techniques and using commit and rollback.
  • Create views and use stored procedures.

Course Content:

Unit 1: SQL Scripts:

  • Good practice when writing SQL queries
  • Exploring the templates and stored procedures available in SSMS
  • Saving script files v saving stored procedures
  • Using Parameterised queries

Unit 2: Advanced SQL SELECT Statements:

  • Recap on writing JOIN statements and column and table aliases
  • ISNULL() function v IS NULL criterion
  • Useful string, date and convert functions
  • Aggregate functions
  • Group by clause including rollup
  • IF and CASE
  • UNION queries

Unit 3: DML and Transaction Control:

  • Working with INSERT
  • Working with UPDATE
  • Working with DELETE
  • Creating computed columns
  • Using Begin transactions with Commit and Rollback
  • Simple error trapping

Unit 4: Sub Queries and Window Functions:

  • Writing subqueries
  • Over() and Over(Partition by)
  • Row() v Rank()

Unit 5: Managing Views:

  • Creating a view
  • Selecting data using a view
  • Altering and dropping views

Unit 6: Stored Procedures (USP)

  • Introduction to Stored Procedures
  • Advantages of Stored Procedures
  • Creating and Using Stored Procedures
  • Dealing with an INSERT

Strategic Business IT Planning, Deployment & Management Courses
Advanced SQL Training (15092_293025)

REF: 15092_293025   DATE: 01.Dec.2024 - 05.Dec.2024   LOCATION: Dubai (UAE)  INDIVIDUAL FEE: 4500 Euro

 

Mercury dynamic schedule is constantly reviewed and updated to ensure that every category is being addressed at least once a month, if not once every week. Please check the training courses listed below and if you do not find the subject you are interested in, email us or give us a call and we will do our best to assist.