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