UEC4 - Microsoft SQL Server Development & Performance

This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2019 (or earlier) database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database: logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Topics: SELECT Fundamentals, Aggregating Data, Joining Multiple Tables, Modifying Data, Ensuring Data Integrity through Constraints, Introduction to Indexes, Query execution and query plans, Designing and Implementing Views, Designing and Implementing Stored Procedures, SQL Server Concurrency, Importing and Exporting Data.