SQL is an industry-standard language for accessing mainframe, midrange, and LAN-based, multi-user relational databases. This Lab will teach the delegate how to read and write good SQL for querying, updating, and maintaining SQL databases. The Lab progresses through the elements of the language to build a thorough appreciation and understanding of SQL's capabilities and power. It covers ANSI-standard SQL and some of the common extensions.
This lab is made up of a mix of theory and practical sessions. You will complete a series of exercises that cover all the important components of the language and allow you to practice your SQL.
Please Note: The Lab will use a Microsoft SQL Server platform and T-SQL to illustrate the use of the SQL language
Upon completion of this lab you will be able to:
This lab is intended for:
You should possess:
July 9th, 2020 - Enabled direct browser RDP connection for a streamlined experience
March 12th, 2020 - Included a student guide to provide reference material to aid in completing the exercises and understanding the solutions
January 13th, 2020 - Updated lab to use a newer version of Windows and increased default SSMS output font size for readability