Developing SQL Databases

ideal for

IT Professionals who want to become skilled on SQL Server product features and technologies for implementing a database. Who are developers from other product platforms looking to become skilled in the implementation of a SQL Server database.

Objectives

After completing this course, students will be able to:

• Design and Implement Tables.

• Describe advanced table designs

• Ensure Data Integrity through Constraints. 

• Describe indexes, including Optimized and Columnstore indexes

• Design and Implement Views.

• Design and Implement Stored Procedures. 

• Design and Implement User Defined Functions. 

• Respond to data manipulation using triggers.

• Design and Implement In-Memory Tables. 

• Implement Managed Code in SQL Server.

• Store and Query XML Data.

• Work with Spatial Data.

• Store and Query Blobs and Text Documents

Prerequisite Knowledge

• Basic knowledge of the Microsoft Windows operating system and its core functionality.

• Working knowledge of Transact-SQL.

• Working knowledge of relational databases.

Course Program

• Introduction to Database Development

• Designing and Implementing Tables

• Advanced Table Designs

• Ensuring Data Integrity through Constraints

• Introduction to Indexes

• Designing Optimized Index Strategies

• Columnstore Indexes

• Designing and Implementing Views

• Designing and Implementing Stored Procedures

• Designing and Implementing User-Defined Functions

• Responding to Data Manipulation via Triggers

• Using In-Memory Tables

• Implementing Managed Code in SQL Server

• Storing and Querying XML Data in SQL Server

• Storing and Querying Spatial Data in SQL Server

• Storing and Querying BLOBs and Text Documents in SQL Server

• SQL Server Concurrency

• Performance and Monitoring