Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Columnstore Indexes $74.95
SQL Server 2016 Indexes and Views $74.95
Performance Tuning $74.95
Optimize SQL Database Objects and Infrastructure $74.95
SQL Server 2016 Database Objects $74.95
Triggers and Functions $74.95
Programmability Objects $74.95
Managing Database Concurrency $74.95
Database Instances $74.95

Bundle Price: $319.00
Total Savings: $355.55


Columnstore Indexes

Columnstore indexes work differently from traditional indexes in SQL Server 2016. This course covers how to implement columnstore indexes in SQL Server 2016, as well as the various columnstore performance considerations that can impact operations. This course also covers nonclustered indexes, in-memory indexes, and XML indexes. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.

Learning Objectives
  • Start the course
  • Recognize when to use columnstore indexes
  • Determine when to implement a columnstore index
  • Create a clustered columnstore index
  • Describe columnstore index data loading
  • Describe columnstore versioned feature summary
  • Improve columnstore index query performance
  • Implement real-time operational analytics
  • Describe columnstore index data warehousing
  • Implement columnstore index defragmentation
  • Differentiate between clustered and nonclustered columnstore indexes in SQL Server 2016
  • Create a nonclustered columnstore index
  • Change data in a nonclustered columnstore index
  • Describe in-memory nonclustered hash indexes
  • Create tables with nonclustered hash indexes
  • Describe in-memory index performance considerations
  • Describe XML indexes
  • Describe secondary XML indexes
  • Describe XML index performance considerations
  • Implement and configure columnstore indexes

SQL Server 2016 Indexes and Views

SQL Server 2016 uses indexes to speed up the performance of queries and improve overall database performance. This course covers how to design and implement the various index types available in SQL Server 2016. In addition, this course covers enhancing usability in SQL Server 2016 by using views. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.

Learning Objectives
  • Start the course
  • Recognize the basic guidelines to follow when designing and implementing indexes
  • Describe when to use tables without clustered indexes
  • Recognize the basic guidelines to follow when designing and implementing indexes
  • Create clustered indexes
  • Create nonclustered indexes
  • Create unique indexes
  • Create filtered indexes
  • Create indexes with included columns
  • Delete indexes
  • Modify indexes
  • Describe the use of views
  • Recognize how to design and implement views
  • Describe the various types of views
  • Create views
  • Create an indexed view
  • Modify views
  • Modify data using a view
  • Create partitioned views
  • Rename and delete a view
  • Create an index with included columns

Performance Tuning

SQL Server 2016 provides a comprehensive set of tools for monitoring and tuning to ensure optimal performance for an environment. This course covers performance metrics and monitoring, as well as the various logging tools available with SQL Server, such as perfmon and dynamic management objects. In addition, this course covers Extended Events, and the event-handling system used for monitoring SQL Server instances. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.

Learning Objectives
  • Start the course
  • Describe performance metrics
  • Establish a server performance baseline
  • Demonstrate how to use perfmon
  • Demonstrate how to use dynamic management objects
  • Compare baseline metrics to observed metrics in order to troubleshoot performance issues
  • Monitor Azure SQL Database performance
  • Demonstrate how to enable and view live query statistics
  • Use the activity monitor in SQL Server 2016
  • Demonstrate how to use the task manager windows monitoring tool
  • Demonstrate how execute database consistency checker commands
  • Use system stored procedures for monitoring tasks
  • Describe the benefits of using extended events
  • Describe extended events tasks
  • Differentiate between extended events packages, targets, and sessions
  • Distinguish between extended events targets
  • Describe the SQL trace architecture
  • Create a trace using transact-sql
  • Optimize SQL trace to minimize performance costs
  • Demonstrate how to schedule tracing in SQL Server
  • Using various tools to monitor performance

Optimize SQL Database Objects and Infrastructure

Optimizing statistics helps ensure the most efficient means of executing statements in SQL Server 2016. This course covers how to create, modify, and troubleshoot statistics and indexes in SQL Server 2016. This course also covers how to analyze and troubleshoot query plans in SQL Server 2016. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.

Learning Objectives
  • Start the course
  • Create statistics and determine accuracy of results
  • Modify existing statistics
  • View statistic properties
  • Update query optimization statistics
  • Describe available maintenance tasks to perform
  • Perform database tuning using the database engine tuning advisor
  • Demonstrate how to create a maintenance plan
  • Perform index defragmentation
  • Review current index usage and identify missing indexes
  • Identify and consolidate overlapping indexes
  • Capture query plans using extended events and traces
  • Describe logical operators and how they are used
  • Describe physical operators and how they are used
  • Recognize best practices to follow with the Query Store
  • Describe when and where to use the Query Store
  • Determine how to start query performance troubleshooting
  • Identify underperforming query plan operators
  • Compare query plans and related metadata
  • Configure the Azure SQL Database Performance Insight
  • Use statistics objects and index optimization methods

SQL Server 2016 Database Objects

In order to properly design and implement a relational database schema, it is important to have an understanding of the fundamentals of SQL Server 2016. This course covers creating and altering tables, designing normalization, as well as the various data types available in SQL Server 2016. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.

Learning Objectives
  • Start the course
  • Create tables in SQL Server 2016
  • Use the DROP TABLE statement to drop a table from a database
  • Use the ALTER TABLE statement to modify a table
  • Add and removing columns from a table
  • Duplicate a table
  • Rename a table
  • Use constraints to ensure integrity of data
  • Describe the best practices to follow when selecting a naming convention
  • Describe the numeric data type category in SQL Server 2016
  • Describe the date and time data type category in SQL Server 2016
  • Describe the character and unicode data type category in SQL Server 2016
  • Describe the binary strings data type category in SQL Server 2016
  • Describe the special data types category in SQL Server 2016
  • Recognize the process of normalization in SQL Server 2016
  • Describe the first normal form level of normalization
  • Describe the second normal form level of normalization
  • Describe the third normal form level of normalization
  • Discuss when to denormalize a database
  • Demonstrate how to create a SQL Table

Triggers and Functions

Triggers in SQL Server 2016 are sets of statements that execute automatically when a specific event occurs in a database. This course covers the design and implementation of the various types of triggers found in SQL Server 2016. In addition, this course cover functions, including scalar-valued, table-valued, deterministic, and nondeterministic. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.

Learning Objectives
  • Start the course
  • Create DML triggers
  • Create CLR triggers
  • Recognize best practices regarding DML trigger security
  • Implement DDL triggers
  • Gather information regarding DDL triggers
  • Describe DDL events and event groups
  • Recognize when to use the various types of triggers
  • Implement first and last triggers
  • Manage transactions within a logon trigger
  • Disable logon triggers
  • Demonstrate how to use the AFTER trigger
  • Demonstrate how to use the INSTEAD trigger
  • Describe user-defined functions
  • Recognize the various components of user-defined functions
  • Use scalar-valued functions
  • Use table-valued functions
  • Use built-in functions
  • Use deterministic functions
  • Use nondeterministic functions
  • Configure triggers in SQL Server 2016

Programmability Objects

Constraints can be used in SQL Server 2016 to ensure data integrity. This covers how to design and implement constraints for tables and columns. This course also covers stored procedures, a SQL Server feature that allows you to reuse the code over and over, providing advantages such as performance, productivity, and ease of use. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.

Learning Objectives
  • Start the course
  • Recognize the three basic forms of data integrity: domain, entity, referential
  • Use the various mechanisms used to enforce data integrity
  • Describe entity and referential integrity
  • Describe the use of the PRIMARY Key constraint
  • Use the FOREIGN KEY constraint
  • Describe the UNIQUE constraint I
  • Describe the IDENTITY constraint
  • Recognize the common considerations to be aware of when working with constraints
  • Demonstrate how to write Transact-SQL statements to add constraints to tables
  • Demonstrate how to identify results of DML statements given exiting tables and constraints
  • Describe stored procedures and their benefits
  • Design stored procedures components and structure based on business requirements
  • Describe how to use the input and output parameters
  • Demonstrate how to use table-valued parameters
  • Implement return codes
  • Streamline existing stored procedure logic
  • Implement error handling and transaction control logic within stored procedures
  • Alter a stored procedure using the Transact-SQL ALTER PROCEDURE statement
  • Obfuscate stored procedures using the WITH ENCRYPTIONS clause
  • Configure constraints in SQL Server 2016

Managing Database Concurrency

Locking is a feature in SQL Server 2016 that helps ensure the physical integrity of each transaction. This course covers how to implement and troubleshoot locking, as well as how to minimize, handle, and remediate deadlocks. This course also covers memory-optimized tables, which are used to improve the performance of transaction processing, as well as native stored procedures - a feature used to enable efficient execution of the queries. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.

Learning Objectives
  • Start the course
  • Provide an overview of locking
  • Discuss the types of concurrency and their effects
  • Describe deadlock behavior
  • Minimize deadlocks
  • Demonstrate how to handle deadlocks
  • Demonstrate how to remediate, detect, and end deadlocks
  • Demonstrate how to troubleshoot locking issues
  • Describe lock escalation behaviors
  • Provide an overview of memory-optimized tables and discuss use cases for memory-optimized tables vs. traditional disk-based tables
  • Create memory-optimized tables
  • Optimize performance by adjusting durability settings
  • Describe considerations for statistics on memory-optimized tables
  • Describe the methods used to query memory-optimized tables
  • Describe the characteristics of natively compiled stored procedures
  • Recognize best-case usage scenarios for natively compiled stored procedures
  • Describe atomic blocks in natively compiled stored procedures
  • Demonstrate how to create a natively compiled stored procedure
  • Demonstrate how to monitor performance for natively compiled stored procedures
  • Describe the best practices for calling natively compiled stored procedures
  • Demonstrate how to troubleshoot deadlocks

Database Instances

SQL Server Resource Governor is a feature used to manage SQL Server workloads and resource consumption by specifying limits on resources such as CPU, IO, and memory. This course covers the Resource Governor and the cloud database service, Microsoft Azure Cloud SQL Database. In addition, monitoring and troubleshooting database instances is also covered. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.

Learning Objectives
  • Start the course
  • Describe workloads
  • Manage workloads and system resource consumption using Resource Governor
  • Enable Resource Governor
  • Configure Resource Governor properties
  • Create a resource pool
  • Create a workload group
  • Disable Resource Governor
  • Optimize memory configuration
  • Describe service tiers
  • Describe common service tier use cases
  • Describe elastic database pools
  • Describe elastic scaling
  • Optimize tempdb configuration files
  • Demonstrate how to create an Azure SQL Server 2016 database
  • Demonstrate how to connect to an Azure SQL Server 2016 database
  • Describe the data collector service for monitoring SQL Server 2016 databases
  • Enable and configure a management data warehouse for the data collector service
  • Configure a data collection
  • Monitor and diagnose scheduling and wait statistics using dynamic management objects
  • Troubleshoot storage, IO, and cache issues
  • Demonstrate how to monitor Azure SQL Database query plans
  • Demonstrate how to use the SQL Server Monitor
Register Now
Microsoft SQL Server 2016: Developing e-learning bundle
  • Course ID:
    271437
  • Duration:
    n/a
  • Price:
    $319