This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server database. It includes the T-SQL language constructs, programming modules and data layer objects creating. This is the main class for DBAs and DB Developers, who want to have a good foundation of their T-SQL skills.

The primary audience for this course is IT Professionals who want to become skilled on SQL Server product features and technologies for implementing a database. Those are primarily Database Developers in the beginning of their career path and DBAs who want to be familiar with data layer and data access layer of databases they administer. The secondary audiences for this course are individuals who use other database product platforms and look for gaining knowledge in SQL Server database development.

Prerequisites: Querying with T-SQL or alternative knowledge and experience in writing basic SELECT statements, as well as basic understanding of relational database models

• Develop code in SQL Server database – data layer objects and programming objects
• Use best practices when writing code, and avoid writing code that leads to performance problems
• Understand and use data types, understand indexes, their structure and use cases
• Understand the different types of JOIN, sub-queries, CTE, derived tables, Windowing functions and when and how to use them
• Understand the principles of Execution Plans, reading and troubleshooting simple plans
• Develop error handling for programming objects in a database
• Understand Transactions and SQL Server Locking architecture

Module 1. SQL Server and T-SQL Overview

Module 2. The SELECT module

Module 3. Joins, Subqueries and derived tables

Module 4. Data Types, Tables and Constraints

Module 5. SQL Server Indexing

Module 6. Query Execution and Reading Query Plans

Module 7. Data Modifications and Data Loading

Module 8. Dynamic SQL, language constructs and temp objects

Module 9. T-SQL Programming Objects – Stored Procedures, Triggers, Functions

Module 10. Transactions Management and Error Handling