This course is intended for T-SQL developers, DBAs and SQL Server power users who work with SQL Server and need to write queries and develop code using Transact-SQL—SQL Server’s dialect of the standard ANSI-SQL language. The course covers querying, including retrieving and modifying data, and also provides an overview of programmable objects supported by SQL Server.
This course is intended both for people who just started working with SQL Server, as well as for people with some experience (for example, developers who are not SQL-focused). Even if you are a more experienced SQL Server practitioner, if you are self-taught and gained your knowledge “by the seat of your pants” and are looking for more organized training to cover gaps and holes in your knowledge, this course is for you. This course doesn’t get into performance discussions and advanced problems* rather focuses on the logical aspects of T-SQL. Note though that it is not merely a step-by-step course. It doesn’t just focus on syntactical elements of T-SQL, rather explains the logic behind the language and its elements.
There are many aspects of SQL that are unique to this language, and are very different than other programming languages. This course will help students adopt the right state of mind and get a true understanding of the language elements. Students will learn how to think in terms of sets and follow good SQL programming practices.
The course is not version specific; it does, however, cover language elements that were introduced in recent versions of SQL Server. Throughout the course the instructor will specify the version in which the elements were introduced.
The topics covered in the course include: Background to T-SQL Querying and Programming; Single-Table Queries; Joins; Subqueries; Table Expressions; Set Operations; Pivot, Unpivot and Grouping Sets; Data Modification; Transactions; Overview of Programmable Objects.
To complement the learning experience, students will be provided with exercises that will enable them to practice what they’ve learned.
* Note: If you are a very experienced T-SQL practitioner and are looking for an Advanced T-SQL course that dives deeply into the complexities of T-SQL Querying and Programming including deep coverage of query and index tuning, please see the course Advanced T-SQL Querying Programming ans Tuning for SQL Server
This course is intended for:
- T-SQL Programmers and DBAs, Architects, Analysts and Power Users
- Those that need to write or review code in SQL Server 2005 and 2008
Before attending this course, it is recommended that students have the following skills:
- Familiarity with basic relational database concepts and SQL
- Understand the logic behind T-SQL and thinking in terms of sets
- Write T-SQL code to create tables and define data integrity
- Write queries against single and multiple tables
- Write T-SQL statements that modify data
- Get familiar with T-SQL programmable objects