Develop your SQL skills to an advanced level on this 2-day course using MS SQL Server.

This course is hands-on. This means that there is plenty of time to experiment with what you are being taught, try things out for yourself and ask questions.

By the time you finish, you’ll be comfortable using 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.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and help with issues you have after the course.

What Will I Learn?

By the end of this advanced course, you will be a very capable SQL user.

You will be confident about using its more complex commands when viewing and managing tables, and able to run complex queries.

Am I Ready For This Course?

You should have a basic understanding of SQL select statements before attending this course.

It assumes a knowledge of SQL to the level of our Introduction course.

The Training Day

Our courses run from 9.30am to roughly 4.15pm with refreshments throughout the day and a break for a tasty, freshly prepared lunch.

We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the nicest instructors on the planet.

Also, you’ll receive:

✔ A full-colour manual covering everything in the course so that you can recap.
✔ A USB stick for the course exercises to let you practice more in your own time.
✔ A Certificate of Attendance.

• Relational database concepts
• The role of SQL and ANSI standards

• Creating a database
• Creating tables
• SQL data types
• Altering tables (adding, dropping and renaming columns)
• Table and column constraints
• The role of indexes
• Inserting data
• Importing data

• 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

• 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

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

• Writing sub queries
• Over() and Over(Partition by)
• Row() v Rank()

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

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