SQL Training – Advanced

This advanced SQL training course will further develop your use of SQL to manage a relational database.

By the end of this advanced course you will be a very capable SQL user confident to use its more complex commands when viewing and managing tables. You will also be able to run complex queries.

To develop your knowledge of writing SQL scripts to manage data stored in a relational database.
This course is suitable for anyone who wants to learn the advanced SQL querying whether they work with Microsoft SQL Server, Microsoft Access, Oracle, MySQL, Google BigQuery or other database systems.

Delegates for this course should have a basic understanding of SQL select statements.

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

This is a fun, hands-on course during which you will be encouraged to work individually to practice the techniques that you are being taught.

Please see here if you are looking for Microsoft SQL Server specific courses.

 

Our courses run from 9.30 am to approximately 4.30pm.
We include everything that you will need for a productive day’s training.
 When you book a course with us you get the following:
  • A full colour advanced SQL course manual.
  • The exercises that you have worked on during your course to allow you to practice afterwards.
  • USB stick to take the exercises away (where relevant).
  • Freshly prepared lunch in our onsite cafeteria (in Guildford).
  • Refreshments though out the day.
  • Training in fully air conditioned facilities from an experienced SQL instructor.

We do not have a dress code. Please come wearing whatever your are most comfortable wearing.

• 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