1­-855­-778­-7246

Developing SQL Databases (20762)

 

Course Content

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

Who should attend

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

Prerequisites

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

Course Objectives

  • 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

Follow On Courses

Outline: Developing SQL Databases (20762)

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

Labs

  • Designing and Implementing Tables
  • Using Advanced Table Designs
  • Ensuring Data Integrity through Constraints
  • Implementing Indexes
  • Optimizing Indexes
  • Using Columnstore Indexes
  • Designing and Implementing Views
  • Designing and Implementing Stored Procedures
  • Designing and Implementing User-Defined Functions
  • Responding to Data Manipulation by Using Triggers
  • Using In-Memory Database Capabilities
  • Implementing Managed Code in SQL Server
  • Storing and Querying XML Data in SQL Server
  • Working with SQL Server Spatial Data
  • Storing and Querying BLOBs and Text Documents in SQL Server
Online Training

Duration 5 days

Price
  • CAD 2,895
  • SA Voucher: 4
Classroom Training

Duration 5 days

Price
  • Canada: CAD 2,895
  • SA Voucher: 4
 
Click on town name to book Schedule
This is an Instructor-Led Classroom course
Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom.
  *   This class is delivered by a partner.
Canada

Currently there are no training dates scheduled for this course.  For enquiries please write to info@fastlaneca.com.

Fast Lane Flex™ Classroom If you can't find a suitable date, don't forget to check our world-wide FLEX training schedule.