SQL250 Transact-SQL for Developers

During this 5-day course, students will learn Transact-SQL as implemented in SQL Server 2008, 2012 and 2014. The course starts by establishing a foundation understanding of database concepts and terminology. Students are then prepared to use various Microsoft tools to submit queries and view the result.

Following a logical process for creating SQL queries from business requirements, students learn how to write a query based on the way SQL Server processes the SQL statement. This differs from most courses, which present SQL as a set of features. This approach uses the natural way of breaking down the problem into a logical set of steps. Each step can be validated before moving to the next step.

Finally, the course teaches the student how to use T-SQL statements inside common database objects like Views, Stored Procedures and User-Defined Functions.

Lectures that highlight and explain T-SQL concepts are reinforced with extensive demonstrations and hands-on labs.

• Describe the objects that make up a database, data relationships within the database and how databases guarantee uniqueness of defined objects.
• Understand different sublanguages of SQL.
• Use the SQL Server Management Studio
• Write a simple SELECT statement, returning all the columns and rows.
• Formulate and write a meaningful join strategy to bring together all necessary data.
• Utilize a subquery to reshape data before using it in a query
• Write a WHERE clause to filter the rows
• Control the display of data
• Write Transact-SQL queries and aggregated values
• Define the attributes of a database transaction and generate a result set
• Create a database view and in-line table value functions and execute simple scalar/multi-statement user-defined functions
• Write procedural logic for Stored Procedures and User-defined Functions

This course is intended for SQL Server Developers, Database Administrators, and System Engineers who are responsible for writing T-SQL queries for an application.