Developing SQL Databases

Gain the knowledge and skills to develop a Microsoft SQL server 2016 database.  If you are an IT professional or a developer from other product platforms, you will learn needed skills in using SQL Server 2016 product features and technologies for implementing a database. 

No prior product knowledge is needed.

Course length: 5 days, Delivery: Online or In-class.

Please call (475) 328-2227 with questions.

Course Overview

Upcoming Classes

1.  Introduction to Database Development

• Introduction to the SQL Server Platform

• SQL Server Database Development Tasks
   

2.  Designing and Implementing Tables

• Designing Tables

• Data Types

• Working with Schemas

• Creating and Altering Tables

• Designing and Implementing Tables
   

3.  Advanced Table Designs

• Partitioning Data

• Compressing Data

• Temporal Tables

• Using Advanced Table Designs
   

4.  Ensuring Data Integrity through Constraints

• Enforcing Data Integrity

• Implementing Data Domain Integrity

• Implementing Entity and Referential Integrity

• Using Data Integrity Through Constraints
   

5.  Introduction to Indexes

• Core Indexing Concepts

• Data Types and Indexes

• Heaps, Clustered, and Nonclustered Indexes

• Single Column and Composite Indexes

• Implementing Indexes
   

6.  Designing Optimized Index Strategies

• Index Strategies

• Managing Indexes

• Execution Plans

• The Database Engine Tuning Advisor

• Query Store

• Optimizing Indexes
   

7.  Columnstore Indexes

• Introduction to Columnstore Indexes

• Creating Columnstore Indexes

• Working with Columnstore Indexes

• Using Columnstore Indexes
   

8.  Designing and Implementing Views

• Introduction to Views

• Creating and Managing Views

• Performance Considerations for Views

• Designing and Implementing Views
   

9.  Designing and Implementing Stored Procedures

• Introduction to Stored Procedures

• Working with Stored Procedures

• Implementing Parameterized Stored Procedures

• Controlling Execution Context

• Designing and Implementing Stored Procedures

10. Designing and Implementing User-Defined Functions 

• Overview of Functions

• Designing and Implementing Scalar Functions

• Designing and Implementing Table-Valued Functions

• Considerations for Implementing Functions

• Alternatives to Functions

• Designing and Implementing User-Defined Functions 

​

11. Responding to Data Manipulation via Triggers 

• Designing DML Triggers

• Implementing DML Triggers

• Advanced Trigger Concepts

• Responding to Data Manipulation by Using Triggers 

​

12. Using In-Memory Tables 

• Memory-Optimized Tables

• Natively Compiled Stored Procedures

• Using In-Memory Database Capabilities 

​

13. Implementing Managed Code in SQL Server 

• Introduction to CLR Integration in SQL Server

• Implementing and Publishing CLR Assemblies

• Implementing Managed Code in SQL Server 

​

14. Storing and Querying XML Data in SQL Server 

• Introduction to XML and XML Schemas

• Storing XML Data and Schemas in SQL Server

• Implementing the XML Data Type

• Using the Transact-SQL FOR XML Statement

• Getting Started with XQuery

• Shredding XML

• Storing and Querying XML Data in SQL Server 

​

15. Storing and Querying Spatial Data in SQL Server 

• Introduction to Spatial Data

• Working with SQL Server Spatial Data Types

• Using Spatial Data in Applications

• Working with SQL Server Spatial Data 

​

16. Storing and Querying BLOBs and Text Documents in SQL Server 

• Considerations for BLOB Data

• Working with FILESTREAM

• Using Full-Text Search

• Storing and Querying BLOBs and Text Documents in SQL Server 

​

17. SQL Server Concurrency 

• Concurrency and Transactions

• Locking Internals

• SQL Server Concurrency 

​

18. Performance and Monitoring 

• Extended Events

• Working with extended Events

• Live Query Statistics

• Optimize Database File Configuration

• Metrics

• Monitoring, Tracing, and Baselining