Developing SQL Databases 2016 Training

Developing SQL Databases 2016 Training (M20762)


Developing SQL Databases 2016 Training Course Description

This four-day instructor-led Developing SQL Databases 2016 Training course provides you with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The Developing SQL Databases 2016 Training course teaches you how to use SQL Server 2016 product features and tools related to developing a database.

Customize It:

With onsite Training, courses can be scheduled on a date that is convenient for you, and because they can be scheduled at your location, you don’t incur travel costs and students won’t be away from home. Onsite classes can also be tailored to meet your needs. You might shorten a 5-day class into a 3-day class, or combine portions of several related courses into a single course, or have the instructor vary the emphasis of topics depending on your staff’s and site’s requirements.

Audience/Target Group

IT Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database.

Developing SQL Databases 2016 Training (M20762)Related Courses:

Duration: 4 days

Class Prerequisites:

Basic knowledge of the Microsoft Windows operating system and its core functionality
Working knowledge of Transact-SQL and relational databases

What You Will Learn:

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

Course Content:

Module 1: Introduction to Database Development

Introduction to the SQL Server Platform
SQL Server Database Development Tasks

Module 2: Designing and Implementing Tables

Designing Tables
Data Types
Working with Schemas
Creating and Altering Tables

Module 3: Advanced Table Designs

Partitioning Data
Compressing Data
Temporal Tables

Module 4: Ensuring Data Integrity through Constraints

Enforcing Data Integrity
Implementing Data Domain Integrity
Implementing Entity and Referential Integrity

Module 5: Introduction to Indexes

Core Indexing Concepts
Data Types and Indexes
Heaps, Clustered, and Nonclustered Indexes
Single Column and Composite Indexes

Module 6: Designing Optimized Index Strategies

Index Strategies
Managing Indexes
Execution Plans
The Database Engine Tuning Advisor
Query Store

Module 7: Columnstore Indexes

Creating Columnstore Indexes
Working with Columnstore Indexes

Module 8: Designing and Implementing Views

Creating and Managing Views
Performance Considerations for Views

Module 9: Designing and Implementing Stored Procedures

Working with Stored Procedures
Implementing Parameterized Stored Procedures
Controlling Execution Context

Module 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

Module 11: Responding to Data Manipulation via Triggers

Designing DML Triggers
Implementing DML Triggers
Advanced Trigger Concepts

Module 12: Using In-Memory Tables

Memory-Optimized Tables
Natively Compiled Stored Procedures

Module 13: Implementing Managed Code in SQL Server

Introduction to CLR Integration in SQL Server
Implementing and Publishing CLR Assemblies

Module 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

Module 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

Module 16: Storing and Querying BLOBs and Text Documents in SQL Server

Considerations for BLOB Data
Working with FILESTREAM
Using Full-Text Search


Request More Information

    Time Frame: 0-3 Months4-12 Months

    Print Friendly, PDF & Email