About This Course
Transact-SQL is an essential skill for database professionals and developers working with SQL databases. This course takes you from your first SELECT statement to implementing transactional programmatic logic through a combination of expert instruction, demonstrations, and practical labs.
The course consists of multiple modules, each exploring a key area of the Transact-SQL language, with a focus on querying and modifying data in Microsoft SQL Server or Azure SQL Database. Course instructors Geoff Allix and Graeme Malcolm have over thirty years of experience in teaching database technologies between them, and emphasize a practical approach to learning each language element through demonstration and hands-on practice. The labs are based on a sample database that you can deploy easily in Azure SQL Database, enabling you to get hands-on experience with Transact-SQL without any need to install and configure a database server.
Who Should Attend This Course
This course is designed for anyone who needs to learn how to write Transact-SQL code to query data in Microsoft SQL Server or Azure SQL Database. Consider attending this course if you are:
- An aspiring database professional
- An application developer who needs to integrate a database into an application
- An information worker who needs to create reports from data in a database