Course Outlines

---

Querying Microsoft SQL Server

1. Introduction to Microsoft SQL Server 2014.
2. Introduction to T-SQL Querying.
3. Writing SELECT Queries.
4. Querying Multiple Tables.
5. Sorting and Filtering Data.
6. Working with SQL Server 2014 Data Types.
7. Using DML to Modify Data.
8. Using Built-In Functions.
9. Grouping and Aggregating Data.
10. Using Subqueries.
11. Using Table Expressions.
12. Using Set Operators.
13. Using Window Ranking, Offset, and Aggregate Functions.
14. Pivoting and Grouping Sets.
15. Executing Stored Procedures.
16. Programming with T-SQL.
17. Implementing Error Handling.
18. Implementing Transactions.
19. Improving Query Performance.
20. Querying SQL Server Metadata.

Developing Microsoft SQL Server Databases

1. Introduction to Database Development.
2. Designing and Implementing Tables.
3. Ensuring Data Integrity through Constraints.
4. Introduction to Indexing.
5. Advanced Indexing.
6. Columnstore Indexes.
7. Designing and Implementing Views.
8. Designing and Implementing Stored Procedures.
9. Designing and Implementing User-Defined Functions.
10. Responding to Data Manipulation via Triggers.
11. Using In-Memory Tables.
12. Implementing Managed Code in SQL Server
13. Storing and Querying XML Data in SQL Server.
14. Working with SQL Server Spatial Data.

Administering Microsoft SQL Server

1. Introduction to SQL Server 2014 Database Administration.
2. Installing and Configuring SQL Server 2014.
3. Working with Databases and Storage.
4. Planning and Implementing a Backup Strategy.
5. Restoring SQL Server 2014 Databases.
6. Importing and Exporting Data.
7. Monitoring SQL Server 2014.
8. Tracing SQL Server Activity.
9. Managing SQL Server Security.
10. Auditing Data Access and Encrypting Data.
11. Performing Ongoing Database Maintenance.
12. Automating SQL Server 2014 Management.
13. Monitoring SQL Server 2014 by Using Alerts and Notifications.
14. Pivoting and Grouping Sets.
15. Executing Stored Procedures.
16. Programming with T-SQL.
17. Implementing Error Handling.
18. Implementing Transactions.
19. Improving Query Performance.
20. Querying SQL Server Metadata.