Learn the basics of database design and the different SQL data types. Then master the core concepts for the exam. In this track, you’ll learn how to write queries, functions, and stored procedures. You’ll also find out how to manage transactions, handle errors, and improve query performance.

1-Introduction-to-SQL-Server

2-Introduction-to-Relational-Databases-in-SQL

3-Intermediate-SQL-Server

4-Time-Series-Analsis-in-SQL-Server

5-Functions-for-Manipulating-Data-in-SQL-Server

6-Database-Design

7-Hierarchical-and-Recursive-Queries-in-SQL-Server

8-Transactions-and-Error-Handling-in-SQL-Server

9-Writing-Functions-and-Stored-Procedures-in-SQL-Server

10-Building-and-Optimizing-Triggers-in-SQL-Server

11-Improving-Query-Performance-in-SQL-Server