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