-
Always Encrypted
After watching this video; you will be able to use the Always Encrypted feature of SQL Server 2016.
-
AlwaysOn
After watching this video; you will be able to use the enhanced AlwaysOn high availability in SQL Server 2016.
-
In-Memory OLTP
After watching this video; you will be able to use the updated in-memory OLTP for SQL Server 2016.
-
Installing CTP2
After watching this video; you will be able to install the second community technical preview of SQL Server 2016.
-
Native JSON
After watching this video; you will be able to use native JSON in SQL Server 2016 databases.
-
PolyBase
After watching this video; you will be able to use PolyBase to access data stored in Hadoop or Azure Blob Storage from SQL Server 2016.
-
Real-time Operational Analytics
After watching this video; you will be able to use real-time operational analytics in SQL Server 2016.
-
Row Level Security
After watching this video; you will be able to enforce row level security in SQL Server 2016.
-
SQL 2016 and Azure SQL Data Warehouse
After watching this video; you will be able to connect SQL Server 2016 and Azure SQL Data Warehouse.
-
SQL Server 2016 Interface
After watching this video; you will be able to navigate the interface of SQL Server 2016.
-
Stretch Database
After watching this video; you will be able to use Stretch Database to extend your SQL Server 2016 database to Azure SQL Database.
-
Temporal Tables
After watching this video; you will be able to use the new Temporal Tables feature in SQL Server 2016.
-
Using the Query Store
After watching this video; you will be able to use the new SQL Server 2016 Query Store.
-
Microsoft SQL Server 2016: Multiple Instances of SQL Server
After watching this video, you will be able to describe the three approaches you can use to manage memory when running multiple instances of the database engine.
-
Microsoft SQL Server 2016: SQL Server Management Studio Memory Management
After watching this video, you will be able to demonstrate how to configure memory options including min server memory and max server memory.
-
Microsoft SQL Server 2016: Configuring and Viewing Memory Using T-SQL
After watching this video, you will be able to demonstrate how to configure and view memory options using T-SQL.
-
Microsoft SQL Server 2016: SQL Server Operators
After watching this video, you will be able to describe the role of operators in SQL Server 2016.
-
Microsoft SQL Server 2016: Creating an Operator in SQL Server 2016
After watching this video, you will be able to demonstrate how to create an operator in SQL Server 2016.
-
Microsoft SQL Server 2016: Deleting an Operator in SQL Server 2016
After watching this video, you will be able to perform the necessary steps to delete an operator in SQL Server 2016.
-
Microsoft SQL Server 2016: Viewing Operator Information
After watching this video, you will be able to access and view operator information in SQL Server 2016.
-
Microsoft SQL Server 2016: Designating a Fail-safe Operator
After watching this video, you will be able to demonstrate how to designate a fail-safe operator in SQL Server 2016.
-
Microsoft SQL Server 2016: Configuring Operator Availability
After watching this video, you will be able to demonstrate how to configure operator availability in SQL Server 2016.
-
Microsoft SQL Server 2016: Editing an Existing Operator
After watching this video, you will be able to edit an existing operator in SQL Server 2016.
-
Microsoft SQL Server 2016:: Configure Encryption in Azure SQL
After watching this video, you will be able to configure encryption for Azure SQL Databases.
-
Microsoft SQL Server 2016: Elastic Database Pools
After watching this video, you will be able to configure elastic database pools to scale resources automatically.
-
Microsoft SQL Server 2016: Configuring the Database Scope
After watching this video, you will be able to configure the database scope in SQL Server 2016.
-
Microsoft SQL Server 2016: Evaluate Database Performance
After watching this video, you will be able to describe how to evaluate and tune database performance.
-
Microsoft SQL Server 2016: Changing Service Tiers
After watching this video, you will be able to demonstrate how to improve performance by changing service tiers.
-
Microsoft SQL Server 2016: Configuring Availability Sets for Redundancy
After watching this video, you will be able to demonstrate how to configure multiple VMs in an availability set for redundancy.
-
Microsoft SQL Server 2016: Configuring Application Tiers
After watching this video, you will be able to configure each application tier into separate availability sets for redundancy.
-
Microsoft SQL Server 2016: Data Compression
After watching this video, you will be able to explain how using data compression reduces overall I/O.
-
Microsoft SQL Server 2016: Microsoft Azure Platform Events
After watching this video, you will be able to describe the different types of platform events that can affect the availability of VMs.
-
Microsoft SQL Server 2016: Microsoft Azure VM Wizard
After watching this video, you will be able to migrate data using the Microsoft Azure VM wizard.
-
Microsoft SQL Server 2016: Connection Strings
After watching this video, you will be able to explain the role of connection strings.
-
Microsoft SQL Server 2016: Azure Load Balancer
After watching this video, you will be able to describe the benefits of combining Azure load balancer with availability sets.
-
Microsoft SQL Server 2016: Multiple Storage Accounts
After watching this video, you will be able to configure multiple storage accounts for each availability set.
-
Microsoft SQL Server 2016: VM Disk Options
After watching this video, you will be able to explain how to effectively tune data disks in Azure.
-
Microsoft SQL Server 2016: VM Disk Caching
After watching this video, you will be able to describe how VM disk caching works.
-
Microsoft SQL Server 2016: Creating and Starting the Pipeline
After watching this video, you will be able to demonstrate how to define, create, and start the pipeline.
-
Microsoft SQL Server 2016: Manage Data using Azure Data Factory
After watching this video, you will be able to manage data using the Azure Data Factory.
-
Microsoft SQL Server 2016: Microsoft Azure Import/Export Service
After watching this video, you will be able to explain the Microsoft Azure import/export service.
-
Microsoft SQL Server 2016: Benchmarking Overview
After watching this video, you will be able to describe the benefits of generating benchmark data.
-
Microsoft SQL Server 2016: Backing Up to a File and URL
After watching this video, you will be able to describe alternative deployment options such as backing up to a file and URL.
-
Microsoft SQL Server 2016: AZCopy Command-line Utility
After watching this video, you will be able to demonstrate how to detach and copy to URL and attach from URL using the AZCopy command-line utility.
-
Microsoft SQL Server 2016: Running IOMeter Tests
After watching this video, you will be able to demonstrate how to use the IOMeter tool to gather benchmark data.
-
Microsoft SQL Server 2016: FIO Tool
After watching this video, you will be able to explain how the FIO tool can be used to gather benchmark data on Azure VMs.
-
Microsoft SQL Server 2016: Cache Warming
After watching this video, you will be able to explain why it is important to perform cache warming prior to gathering benchmark data.
-
Microsoft SQL Server 2016: IOMeter Tool
After watching this video, you will be able to describe the Iometer tool and how it can be used to gather benchmark data.
-
Microsoft SQL Server 2016: Azure VM Deployment Wizard
After watching this video, you will be able to demonstrate how to use the Azure VM deployment wizard.
-
Microsoft SQL Server 2016: Microsoft Azure Database Wizard
After watching this video, you will be able to demonstrate how to migrate a SQL Server database using the Microsoft Azure database wizard.
-
Microsoft SQL Server 2016: Compatibility Testing
After watching this video, you will be able to recognize the tools available to test for SQL Database compatibility.
-
Microsoft SQL Server 2016: Migrating Non-SQL Server Databases
After watching this video, you will be able to describe how to migrate a non-SQL Server database.
-
Microsoft SQL Server 2016: Azure Data Factory
After watching this video, you will be able to explain the Azure data factory.
-
Microsoft SQL Server 2016: Comparing Migration Methods
After watching this video, you will be able to describe tools used to fix issues detected during a database migration.
-
Microsoft SQL Server 2016: Creating a BACPAC File
After watching this video, you will be able to demonstrate how to create a BACPAC file to use in a database migration.
-
Microsoft SQL Server 2016: Creating Linked Services
After watching this video, you will be able to create linked services that connect to data sources in Azure data factory.
-
Microsoft SQL Server 2016: Creating Tables to Access Datasets
After watching this video, you will be able to define and create tables to specify how to access datasets.
-
Microsoft SQL Server 2016: Data Transformation Activities
After watching this video, you will be able to describe the data transformation activities supported by Azure data factory.
-
Microsoft SQL Server 2016: Installing the Data Management Gateway
After watching this video, you will be able to demonstrate how to install the data management gateway.
-
Microsoft SQL Server 2016: Assigning Alerts to an Operator in SQL Server 2016
After watching this video, you will be able to assign alerts to an operator in SQL Server 2016.
-
Microsoft SQL Server 2016: Managing Alerts in SQL Server 2016
After watching this video, you will be able to manage alerts in SQL Server 2016.
-
Microsoft SQL Server 2016: Monitoring Metrics
After watching this video, you will be able to configure alerts based on monitoring metrics in SQL Server 2016.
-
Microsoft SQL Server 2016: Creating an Alert Rule on a Metric
After watching this video, you will be able to create an alert rule on a metric within the Azure portal.
-
Microsoft SQL Server 2016: Architectural Considerations
After watching this video, you will be able to recognize the architectural considerations that influence choosing between a single vs multi tenant.
-
Microsoft SQL Server 2016: Multiple Tenant Considerations
After watching this video, you will be able to explain considerations, such as economic, security, tenant, relating to multiple tenants.
-
Microsoft SQL Server 2016: Single Tenant vs Multi Tenant
After watching this video, you will be able to explain the difference between single tenant and multi tenant data architectures.
-
Microsoft SQL Server 2016: Deploying Applications to Azure SQL Database
After watching this video, you will be able to demonstrate how to manage deployments that support multiple tenants.
-
Microsoft SQL Server 2016: Migrating a Database Overview
After watching this video, you will be able to recognize the various steps and considerations involved with migrating on-premise SQL Server databases to Azure.
-
Microsoft SQL Server 2016: Managing Multi-tenant Data
After watching this video, you will be able to describe how to manage multi-tenant data in SQL Server 2016.
-
Microsoft SQL Server 2016: Isolating Tenant Data
After watching this video, you will be able to describe the benefits of partitioning and isolating tenant data.
-
Microsoft SQL Server 2016: Migration Methods
After watching this video, you will be able to describe the primary migration methods available when migrating to Azure VMs.
-
Microsoft SQL Server 2016: Azure VMs and Cloud Services
After watching this video, you will be able to describe the 2-tier and 3-tier using the Azure VMs and Cloud services application pattern.
-
Microsoft SQL Server 2016: N-Tier Hybrid
After watching this video, you will be able to explain the N-Tier hybrid application pattern.
-
Microsoft SQL Server 2016: Business Tier Scale Out
After watching this video, you will be able to describe the business tier scale out application pattern.
-
Microsoft SQL Server 2016: High Availability and Disaster Recovery
After watching this video, you will be able to describe the 2-tier and 3-tier presentation and business tiers scale out and HADR application pattern.
-
Microsoft SQL Server 2016: Create a Traffic Manager Profile
After watching this video, you will be able to demonstrate how to create a traffic manager profile.
-
Microsoft SQL Server 2016: Optimize Performance in SQL Server 2016
After watching this video, you will be able to optimize SQL Server 2016 database performance.
-
Microsoft SQL Server 2016: 3-Tier: Multiple Virtual Machine
After watching this video, you will be able to explain the 3-tier application pattern.
-
Microsoft SQL Server 2016: Presentation Tier Scale Out
After watching this video, you will be able to explain the presentation tier scale out application pattern.
-
Microsoft SQL Server 2016: Performance Traffic Routing
After watching this video, you will be able to explain the performance traffic routing method.
-
Microsoft SQL Server 2016: 1-Tier: Single Virtual Machine
After watching this video, you will be able to describe the 1-tier application pattern.
-
Microsoft SQL Server 2016: Retry Logic
After watching this video, you will be able to develop application retry connection logic.
-
Microsoft SQL Server 2016: Load Balancer
After watching this video, you will be able to describe the different options for distributing network traffic using Azure.
-
Microsoft SQL Server 2016: Explicit Storage Endpoint
After watching this video, you will be able to create a connection string to an explicit storage endpoint.
-
Microsoft SQL Server 2016: Parsing Connection Strings
After watching this video, you will be able to parse a connection string from a configuration file.
-
Microsoft SQL Server 2016: Weighted Traffic Routing
After watching this video, you will be able to explain the weighted traffic routing method.
-
Microsoft SQL Server 2016: Traffic Manager Overview
After watching this video, you will be able to describe the traffic manager feature found in Azure.
-
Microsoft SQL Server 2016: Priority Traffic Routing
After watching this video, you will be able to explain the priority traffic routing method.
-
Microsoft SQL Server 2016: Connection Strings for Azure Storage Accounts
After watching this video, you will be able to demonstrate how to create connection strings for Azure storage accounts.
-
Microsoft SQL Server 2016: Shared Access Signatures
After watching this video, you will be able to create a connection string using a shared access signature.
-
Microsoft SQL Server 2016: Storing Connection Strings
After watching this video, you will be able to describe the use of connection strings in Azure.
-
Microsoft SQL Server 2016: Transparent Data Encryption
After watching this video, you will be able to describe Transparent Data Encryption and the keys used for encrypting and decrypting data.
-
Microsoft SQL Server 2016: Using Transparent Data Encryption
After watching this video, you will be able to use Transparent Data Encryption.
-
Microsoft SQL Server 2016: Configure Connection Encryption
After watching this video, you will be able to enable encrypted connections to a database.
-
Microsoft SQL Server 2016: Troubleshooting Encryption
After watching this video, you will be able to troubleshoot encryption.
-
Microsoft SQL Server 2016: Using Encryption in SQL Server 2016
After watching this video, you will be able to configure encryption in SQL Server 2016.
-
Microsoft SQL Server 2016: Encryption with Azure SQL Database
After watching this video, you will be able to describe support and limitations for encryption with Azure SQL Database.
-
Microsoft SQL Server 2016: Backup Encryption
After watching this video, you will be able to describe the benefits, requirements, restrictions, methods, and recommended practices for backup encryption.
-
Microsoft SQL Server 2016: Creating an Encrypted Backup
After watching this video, you will be able to create an encrypted backup.
-
Microsoft SQL Server 2016: Cell-level Encryption
After watching this video, you will be able to recognize the purpose of cell-level encryption and how to use Transact-SQL and symmetric encryption to configure it.
-
Microsoft SQL Server 2016: Always Encrypted
After watching this video, you will be able to describe the features and limitations of Always Encrypted.
-
Microsoft SQL Server 2016: Using the Always Encrypted Wizard
After watching this video, you will be able to use the Always Encrypted Wizard.
-
Microsoft SQL Server 2016: Configuring Always Encrypted Using SSMS
After watching this video, you will be able to configure Always Encrypted using SQL Server Management Studio.
-
Microsoft SQL Server 2016: Configuring Always Encrypted Using PowerShell
After watching this video, you will be able to configure Always Encrypted using PowerShell.
-
Microsoft SQL Server 2016: Encryption Features
After watching this video, you will be able to describe the encryption features supported in SQL Server 2016.
-
Microsoft SQL Server 2016: Managing SQL Server 2016 High Availability
After watching this video, you will be able to manage high availability in SQL Server 2016.
-
Microsoft SQL Server 2016: Configuring Read-Only Routing Using T-SQL
After watching this video, you will be able to configure read-only routing for an availability group using Transact-SQL.
-
Microsoft SQL Server 2016: Distributed Availability Groups
After watching this video, you will be able to describe the purpose of distributed availability groups.
-
Microsoft SQL Server 2016: Creating a Distributed Availability Group
After watching this video, you will be able to create a distributed availability group with Transact-SQL.
-
Microsoft SQL Server 2016: Configuring Cluster Shared Volumes
After watching this video, you will be able to configure cluster shared volumes.
-
Microsoft SQL Server 2016: Auto Update Statistics
After watching this video, you will be able to describe the purpose and characteristics of the auto_update_statistics option.
-
Microsoft SQL Server 2016: Implementing Auto Update Statistics
After watching this video, you will be able to implement Auto Update Statistics.
-
Microsoft SQL Server 2016: Implementing Statistics for Large Tables
After watching this video, you will be able to implement statistics for large tables.
-
Microsoft SQL Server 2016: Managing Indexes in SQL Server 2016
After watching this video, you will be able to manage indexes in SQL Server 2016.
-
Microsoft SQL Server 2016: Identifying Outdated Statistics
After watching this video, you will be able to identify and correct outdated statistics.
-
Microsoft SQL Server 2016: Improving Columnstore Index Performance
After watching this video, you will be able to improve columnstore index performance.
-
Microsoft SQL Server 2016: Defragmenting Columnstore Indexes
After watching this video, you will be able to defragment columnstore indexes.
-
Microsoft SQL Server 2016: Repairing Index Fragmentation Using T-SQL
After watching this video, you will be able to repair index fragmentation using Transact-SQL.
-
Microsoft SQL Server 2016: Identifying and Creating Missing Indexes
After watching this video, you will be able to use the Missing Indexes feature to identify missing indexes and to create them, if needed.
-
Microsoft SQL Server 2016: Finding and Removing Underutilized Indexes
After watching this video, you will be able to find and remove underutilized indexes.
-
Microsoft SQL Server 2016: Columnstore Indexes
After watching this video, you will be able to describe the purpose of columnstore indexes, as well as why and when to use them.
-
Microsoft SQL Server 2016: Windows Server Failover Clustering
After watching this video, you will be able to describe the capabilities provided by Windows Server Failover Clustering and its relationship to AlwaysOn components.
-
Microsoft SQL Server 2016: Health Monitoring
After watching this video, you will be able to describe how high availability is accomplished by monitoring cluster resources.
-
Microsoft SQL Server 2016: Creating an Availability Group
After watching this video, you will be able to create a new availability group.
-
Microsoft SQL Server 2016: Changing the Failover Mode
After watching this video, you will be able to change the failover mode in an AlwaysOn availability group.
-
Microsoft SQL Server 2016: AlwaysOn Availability Groups
After watching this video, you will be able to describe the features and benefits of AlwaysOn Availability Groups.
-
Microsoft SQL Server 2016: Failover
After watching this video, you will be able to describe the purpose of the failover process and the available failover modes.
-
Microsoft SQL Server 2016: Monitoring Log Shipping
After watching this video, you will be able to recognize the tables and stored procedures used for monitoring log shipping.
-
Microsoft SQL Server 2016: Log Shipping
After watching this video, you will be able to recognize the purpose and benefits of log shipping.
-
Microsoft SQL Server 2016: Configuring Log Shipping with SSMS
After watching this video, you will be able to configure log shipping with SQL Server Management Studio.
-
Microsoft SQL Server 2016: Configuring Log Shipping with T-SQL
After watching this video, you will be able to configure log shipping with Transact-SQL.
-
Microsoft SQL Server 2016: Log Shipping Management
After watching this video, you will be able to describe log shipping management tasks such as adding databases, removing log shipping, failing over, and changing roles.
-
Microsoft SQL Server 2016: Restoring a Database from an Azure URL
After watching this video, you will be able to perform a restore from an Azure storage account to an Azure VM.
-
Microsoft SQL Server 2016: Configuring Automatic SQL Server Updates in Azure VM
After watching this video, you will be able to configure automatic patching and updating of an Azure VM running SQL Server.
-
Microsoft SQL Server 2016: Create a Sysadmin Account
After watching this video, you will be able to demonstrate how to create a sysadmin account.
-
Microsoft SQL Server 2016: Elastic Database Pools
After watching this video, you will be able to explain elastic database pools.
-
Microsoft SQL Server 2016: Service Tiers
After watching this video, you will be able to explain service tiers in SQL Server 2016.
-
Microsoft SQL Server 2016: Common Service Tier Use Cases
After watching this video, you will be able to describe common service tier use cases.
-
Microsoft SQL Server 2016: Provision an Azure SQL Database
After watching this video, you will be able to describe how to provision an Azure SQL Server 2016 database.
-
Microsoft SQL Server 2016: Create an Azure SQL Database
After watching this video, you will be able to demonstrate how to create an Azure SQL Server 2016 database.
-
Microsoft SQL Server 2016: Selecting the Appropriate Service Tier
After watching this video, you will be able to describe when to use the appropriate service tier.
-
Microsoft SQL Server 2016: Database Transaction Units
After watching this video, you will be able to explain SQL Server 2016 database transaction units.
-
Microsoft SQL Server 2016: Customer Experience Improvement Program (CEIP)
After watching this video, you will be able to describe the customer experience improvement program (CEIP).
-
Microsoft SQL Server 2016: Upgrade Advisor
After watching this video, you will be able to demonstrate how to use the upgrade advisor in SQL Server 2016.
-
Microsoft SQL Server 2016: SQL Server Distributed Replay
After watching this video, you will be able to describe the SQL Server distributed replay feature.
-
Microsoft SQL Server 2016: Usage Scenarios
After watching this video, you will be able to recognize SQL Server Azure VM usage scenarios.
-
Microsoft SQL Server 2016: Licensing Considerations
After watching this video, you will be able to explain per-minute licensing.
-
Microsoft SQL Server 2016: Choose Server 2016 Installation Options
After watching this video, you will be able to determine the appropriate installation options and features for a given scenario.
-
Microsoft SQL Server 2016: SQL Server on Azure VM Overview
After watching this video, you will be able to explain SQL Server on Azure virtual machines.
-
Microsoft SQL Server 2016: Migrate a Database to a SQL Server Azure VM
After watching this video, you will be able to demonstrate how to migrate a database to a SQL Server Azure VM.
-
Microsoft SQL Server 2016: Backing up a Database to an Azure URL
After watching this video, you will be able to perform a backup of a database to an Azure storage account.
-
Microsoft SQL Server 2016: IaaS vs On-premises Deployment Options
After watching this video, you will be able to recognize the differences between IaaS and on-premises deployments.
-
Microsoft SQL Server 2016: Connecting to the SQL Server Azure VM
After watching this video, you will be able to demonstrate how to connect to a SQL Server Azure VM.
-
Microsoft SQL Server 2016: Unattended Installation Options
After watching this video, you will be able to recognize unattended installation options.
-
Microsoft SQL Server 2016: Performing an Unattended Installation
After watching this video, you will be able to perform an unattended SQL Server 2016 installation.
-
Microsoft SQL Server 2016: Post-installation Best Practices
After watching this video, you will be able to recognize post-installation best practices.
-
Microsoft SQL Server 2016: SQL Server Servicing Installation
After watching this video, you will be able to demonstrate SQL Server servicing installation.
-
Microsoft SQL Server 2016: Supported Upgrades
After watching this video, you will be able to recognize the supported upgrade paths for SQL Server 2016.
-
Microsoft SQL Server 2016: Data Migration Assistant
After watching this video, you will be able to use the data migration assistance in SQL Server 2016.
-
Microsoft SQL Server 2016: Creating an Upgrade Strategy
After watching this video, you will be able to create an upgrade strategy for SQL Server 2016.
-
Microsoft SQL Server 2016: Side-by-side Upgrade
After watching this video, you will be able to explain how and when to use the side-by-side upgrade option.
-
Microsoft SQL Server 2016: Hybrid and Rolling Upgrade Options
After watching this video, you will be able to describe hybrid and rolling upgrade options in SQL Server 2016.
-
Microsoft SQL Server 2016: Upgrading from SQL Server 2005
After watching this video, you will be able to explain how to upgrade from SQL Server 2005.
-
Microsoft SQL Server 2016: In-place Upgrade
After watching this video, you will be able to explain how and when to use the in-place upgrade option.
-
Microsoft SQL Server 2016: SQL Server 2016 Installation Requirements
After watching this video, you will be able to determine the requirements for a successful SQL Server deployment.
-
Microsoft SQL Server 2016: Tempdb Files
After watching this video, you will be able to explain SQL Server 2016 tempdb files.
-
Microsoft SQL Server 2016: SQL Installation Options
After watching this video, you will be able to describe SQL installation options.
-
Microsoft SQL Server 2016: Installing SQL Server 2016
After watching this video, you will be able to demonstrate how to install SQL Server 2016.
-
Microsoft SQL Server 2016: Tempdb Attributes
After watching this video, you will be able to describe tempdb attributes.
-
Microsoft SQL Server 2016: Tempdb Sizing
After watching this video, you will be able to understand tempdb sizing.
-
Microsoft SQL Server 2016: Creating a Dynamic Data Mask
After watching this video, you will be able to demonstrate how to create a dynamic data mask.
-
Microsoft SQL Server 2016: Configure Dynamic Data Masking in the Azure Portal
After watching this video, you will be able to demonstrate how to configure dynamic data masking using the Azure portal.
-
Microsoft SQL Server 2016: Querying for Masked Columns
After watching this video, you will be able to demonstrate how to query masked columns in SQL Server 2016.
-
Microsoft SQL Server 2016: Dynamic Data Masking Limitations and Restrictions
After watching this video, you will be able to explain the limitations and restrictions of dynamic data masking.
-
Microsoft SQL Server 2016: Configure Dynamic Data Masking Using PowerShell
After watching this video, you will be able to demonstrate how to configure dynamic data masking using PowerShell.
-
Microsoft SQL Server 2016: SQL Server Authorization
After watching this video, you will be able to explain how authorization can be used when securing SQL Server databases.
-
Microsoft SQL Server 2016: Dynamic Data Masking Polices and Permissions
After watching this video, you will be able to explain how to implement dynamic data masking policies and permissions.
-
Microsoft SQL Server 2016: Dynamic Data Masking Overview
After watching this video, you will be able to describe dynamic data masking.
-
Microsoft SQL Server 2016: Defining a Dynamic Data Mask
After watching this video, you will be able to describe the four types of dynamic data masks.
-
Microsoft SQL Server 2016: Authentication
After watching this video, you will be able to describe how to implement authentication in SQL Server 2016.
-
Microsoft SQL Server 2016: Contained Database Users
After watching this video, you will be able to describe considerations involving the implementation of contained database users.
-
Microsoft SQL Server 2016: Connection Security
After watching this video, you will be able to explain how to restrict and secure a connection to a SQL Server database.
-
Microsoft SQL Server 2016: TCP Ports
After watching this video, you will be able to explain how the connection process redirects machines to a different IP address and port.
-
Microsoft SQL Server 2016: Managing Logins and Users
After watching this video, you will be able to explain the restrictions involving managing logins and users.
-
Microsoft SQL Server 2016: SQL Database Auditing
After watching this video, you will be able to describe how to implement SQL database auditing.
-
Microsoft SQL Server 2016: Configuring SQL Server Firewall Rules
After watching this video, you will be able to demonstrate how to configure SQL Server 2016 firewall rules.
-
Microsoft SQL Server 2016: Managing Existing Firewall Rules in Azure
After watching this video, you will be able to demonstrate how to manage existing firewall rules in the Azure portal.
-
Microsoft SQL Server 2016: Determining Storage Configuration
After watching this video, you will be able to determine effective disk or storage configuration for a given scenario.
-
Microsoft SQL Server 2016: SQL Server Firewall
After watching this video, you will be able to describe the benefits of enabling a SQL Server firewall.
-
Microsoft SQL Server 2016: Buffer Pool Extension
After watching this video, you will be able to describe how SQL Server uses the buffer pool extension.
-
Microsoft SQL Server 2016: Configuring the Buffer Pool Extension
After watching this video, you will be able to demonstrate how to configure the storage buffer pool extension.
-
Microsoft SQL Server 2016: Creating User Databases
After watching this video, you will be able to demonstrate how to create user databases in SQL Server 2016.
-
Microsoft SQL Server 2016: Filegroups
After watching this video, you will be able to explain the use of filegroups in SQL Server 2016.
-
Microsoft SQL Server 2016: Other Storage Options
After watching this video, you will be able to describe other possible storage solutions, including NAS, DAS, and SAN.
-
Microsoft SQL Server 2016: Storage Spaces
After watching this video, you will be able to explain how storage spaces can be used in SQL Server 2016.
-
Microsoft SQL Server 2016: Storage Layouts for a SQL Server Virtual Machine
After watching this video, you will be able to describe storage layout considerations when using virtual machines.
-
Microsoft SQL Server 2016: Implementing RAID Levels
After watching this video, you will be able to explain the different types of RAID configurations.
-
Microsoft SQL Server 2016: SQL Server System Databases
After watching this video, you will be able to differentiate between the five SQL Server system databases.
-
Microsoft SQL Server 2016: Storage Considerations
After watching this video, you will be able to discuss considerations when planning disk storage devices.
-
Microsoft SQL Server 2016: Connect to an Azure SQL Database
After watching this video, you will be able to demonstrate how to connect to an Azure SQL Server 2016 database.
-
Microsoft SQL Server 2016: Hosting a SQL Server Instance Using Azure VMs
After watching this video, you will be able to explain how to host a SQL Server instance using Azure VMs.
-
Microsoft SQL Server 2016: Deploying SQL Server by Using Templates
After watching this video, you will be able to demonstrate how to deploy SQL Server using templates.
-
Microsoft SQL Server 2016: Data Storage Overview
After watching this video, you will be able to provide an introduction to data storage with SQL Server.
-
Microsoft SQL Server 2016: Azure Automation
After watching this video, you will be able to recognize the benefits of using Azure automation.
-
Microsoft SQL Server 2016: Azure Resource Manager
After watching this video, you will be able to explain how and when to use Azure resource manager.
-
Microsoft SQL Server 2016:: Determine Azure Deployment Options
After watching this video, you will be able to determine when to deploy SQL to Azure VMs and databases.
-
Microsoft SQL Server 2016: SQL Server Instances Overview
After watching this video, you will be able to describe SQL Server instances.
-
Microsoft SQL Server 2016: Use Cases for Cell-level Encryption
After watching this video, you will be able to recognize when to use cell-level encryption.
-
Microsoft SQL Server 2016: Security Permissions
After watching this video, you will be able to describe the security permissions required for cell-level encryption.
-
Microsoft SQL Server 2016: Configuring Cell-level Encryption
After watching this video, you will be able to demonstrate how to encrypt data using simple symmetric encryption.
-
Microsoft SQL Server 2016: Moving a TDE Protected Database
After watching this video, you will be able to discuss how to move a TDE protected database.
-
Microsoft SQL Server 2016: Always Encrypted (Database Engine)
After watching this video, you will be able to describe the Always Encrypted database engine feature.
-
Microsoft SQL Server 2016: Disable TDE Using the Azure Portal
After watching this video, you will be able to demonstrate how to disable TDE using the Azure portal.
-
Microsoft SQL Server 2016: Database Permissions
After watching this video, you will be able to describe the available database permissions in SQL Server 2016.
-
Microsoft SQL Server 2016: Use Cases for Cell-level Encryption
After watching this video, you will be able to recognize when to use cell-level encryption.
-
Microsoft SQL Server 2016: Common Use Cases
After watching this video, you will be able to recognize when to use the Always Encrypted feature in SQL Server 2016.
-
Microsoft SQL Server 2016: Configuring Always Encrypted
After watching this video, you will be able to configure Always Encrypted in SQL Server 2016.
-
Microsoft SQL Server 2016: Enable TDE Using PowerShell
After watching this video, you will be able to demonstrate how to enable and disable TDE using PowerShell.
-
Microsoft SQL Server 2016: TDE Considerations
After watching this video, you will be able to describe considerations when implementing TDE.
-
Microsoft SQL Server 2016: Enable TDE Using the Azure Portal
After watching this video, you will be able to demonstrate how to enable TDE using the Azure portal.
-
Microsoft SQL Server 2016: Configure Azure SQL Database Firewall Rules
After watching this video, you will be able to configure firewall rules in Azure SQL database.
-
Microsoft SQL Server 2016: Transparent Data Encryption Overview
After watching this video, you will be able to provide a general overview of transparent data encryption.
-
Microsoft SQL Server 2016: TDE Catalog Views
After watching this video, you will be able to describe the TDE catalog views in SQL Server 2016.
-
Microsoft SQL Server 2016: TDE Dynamic Management Views
After watching this video, you will be able to describe the TDE dynamic management views in SQL Server 2016.
-
Microsoft SQL Server 2016: Implementing Transparent Data Encryption
After watching this video, you will be able to demonstrate how to use transparent data encryption.
-
Microsoft SQL Server 2016: TDE Commands and Functions
After watching this video, you will be able to demonstrate how to use transparent data encryption commands and functions.
-
Microsoft SQL Server 2016: Creating SQL Server Agent Alerts
After watching this video, you will be able to create SQL Server Agent alerts and configure their actions using SQL Server Management Studio.
-
Microsoft SQL Server 2016: Creating Alerts for User-Defined Events
After watching this video, you will be able to create alerts that respond to user-defined events.
-
Microsoft SQL Server 2016: Defining Failure Actions
After watching this video, you will be able to define actions a SQL Server Agent should take in the event of job failure.
-
Microsoft SQL Server 2016: SQL Server Agent Operators
After watching this video, you will be able to describe the purpose of SQL Server Agent operators, the types of contact methods, and notifications.
-
Microsoft SQL Server 2016: Creating a SQL Server Agent Operator Using SSMS
After watching this video, you will be able to create a SQL Server Agent operator using SQL Server Management Studio.
-
Microsoft SQL Server 2016: SQL Server Agent Alerts
After watching this video, you will be able to describe the purpose of SQL Server Agent alerts, how they are triggered, and what they can do.
-
Microsoft SQL Server 2016: Troubleshoot SQL Server Agent Alerts
After watching this video, you will be able to recognize the troubleshooting process for SQL Server Agent alerts and notifications.
-
Microsoft SQL Server 2016: Database Mail
After watching this video, you will be able to describe Database Mail, mail profiles, and the importance of security.
-
Microsoft SQL Server 2016: Logs and Retention in Database Mail
After watching this video, you will be able to describe the logging levels and the need for a retention policy in Database Mail.
-
Microsoft SQL Server 2016: Configuring Database Mail
After watching this video, you will be able to configure Database Mail.
-
Microsoft SQL Server 2016: SQL Server Agent
After watching this video, you will be able to recognize the features, benefits, and components of SQL Server Agent.
-
Microsoft SQL Server 2016: Monitoring Instances in SQL Server 2016
After watching this video, you will be able to monitor instances in SQL Server 2016.
-
Microsoft SQL Server 2016: Indexes
After watching this video, you will be able to describe the types of indexes available in SQL Server and the importance of managing them properly.
-
Microsoft SQL Server 2016: Detecting Index Fragmentation
After watching this video, you will be able to detect fragmented indexes and determine the degree of fragmentation.
-
Microsoft SQL Server 2016: Repairing Index Fragmentation Using SSMS
After watching this video, you will be able to repair index fragmentation using SQL Server Management Studio.
-
Microsoft SQL Server 2016: Identifying Available Space on Data Volumes
After watching this video, you will be able to identify used and available space on data volumes.
-
Microsoft SQL Server 2016: Performance Baselines
After watching this video, you will be able to recognize what affects the performance of a server and when to use baseline measurements.
-
Microsoft SQL Server 2016: Isolating Performance and Bottleneck Issues
After watching this video, you will be able to recognize performance issues that may affect SQL Server.
-
Microsoft SQL Server 2016: Policy-Based Management
After watching this video, you will be able to describe the purpose and components of Policy-Based Management.
-
Microsoft SQL Server 2016: Configuring Policy-Based Management Properties
After watching this video, you will be able to configure Policy-Based Management properties and failure notification alerts.
-
Microsoft SQL Server 2016: Creating a Policy-Based Management Policy
After watching this video, you will be able to create a Policy-Based Management policy using SQL Server Management Studio.
-
Microsoft SQL Server 2016: Policy Management
After watching this video, you will be able to recognize how to manage an existing Policy-Based Management policy.
-
Microsoft SQL Server 2016: Utility Control Points
After watching this video, you will be able to describe the purpose of Utility Control Point and the requirements for its use.
-
Microsoft SQL Server 2016: Identifying Execution Plan Issues
After watching this video, you will be able to identify issues with execution plans.
-
Microsoft SQL Server 2016: Monitoring Activity in SQL Server 2016
After watching this video, you will be able to monitor database activity in SQL Server 2016.
-
Microsoft SQL Server 2016: Using SQL Trace
After watching this video, you will be able to describe the uses of SQL Trace.
-
Microsoft SQL Server 2016: Monitoring Performance Using Extended Events
After watching this video, you will be able to describe the features, benefits, and architecture of performance monitoring with Extended Events.
-
Microsoft SQL Server 2016: Creating an Extended Events Session
After watching this video, you will be able to create an Extended Events session.
-
Microsoft SQL Server 2016: Troubleshooting with Extended Events
After watching this video, you will be able to recognize how Extended Events can be used to troubleshoot performance issues.
-
Microsoft SQL Server 2016: SQL Trace
After watching this video, you will be able to describe the features, benefits, and architecture of SQL Trace.
-
Microsoft SQL Server 2016: Creating a Utility Control Point Part 1
After watching this video, you will be able to use the Create UCP Wizard to create a SQL Server Utility Control Point.
-
Microsoft SQL Server 2016: Creating a Utility Control Point Part 2
After watching this video, you will be able to complete the creation of a SQL Server Utility Control Point.
-
Microsoft SQL Server 2016: The Query Store
After watching this video, you will be able to describe the purpose of the Query Store, its features, and configuration options.
-
Microsoft SQL Server 2016: Query Store Usage
After watching this video, you will be able to describe scenarios for using the Query Store.
-
Microsoft SQL Server 2016: Creating Database Audit Specifications
After watching this video, you will be able to create database audit specifications.
-
Microsoft SQL Server 2016: Auditing Views
After watching this video, you will be able to use dynamic management and system views to manage an audit.
-
Microsoft SQL Server 2016: Azure SQL Database Auditing
After watching this video, you will be able to compare auditing in Azure SQL Database with SQL Server auditing and describe its purpose.
-
Microsoft SQL Server 2016: Configuring Auditing for Azure SQL Database
After watching this video, you will be able to configure auditing for Azure SQL Database.
-
Microsoft SQL Server 2016: Audit Actions and Groups
After watching this video, you will be able to describe the purpose of actions and actions groups.
-
Microsoft SQL Server 2016: Creating Server Audit Specifications
After watching this video, you will be able to create server audit specifications.
-
Microsoft SQL Server 2016: Defining an Audit
After watching this video, you will be able to define an audit using SQL Server Audit.
-
Microsoft SQL Server 2016: Viewing the Audit Log
After watching this video, you will be able to view the audit log using SQL Server Management Studio or sys.fn_get_audit_file.
-
Microsoft SQL Server 2016: Extended Events
After watching this video, you will be able to describe the purpose of Extended Events.
-
Microsoft SQL Server 2016: SQL Server Audit
After watching this video, you will be able to describe the purpose of SQL Server Audit, auditing levels, and components.
-
Microsoft SQL Server 2016: Creating Backups using SSMS
After watching this video, you will be able to create a backup using SQL Server Management Studio.
-
Microsoft SQL Server 2016: Creating Backups using T-SQL
After watching this video, you will be able to create a backup using Transact-SQL.
-
Microsoft SQL Server 2016: Transaction Logs and Backups
After watching this video, you will be able to describe how transaction log backup works.
-
Microsoft SQL Server 2016: Automating Backup
After watching this video, you will be able to create an automated backup job in SQL Server Management Studio.
-
Microsoft SQL Server 2016: Backup Strategies
After watching this video, you will be able to determine the appropriate strategy for backing up a database.
-
Microsoft SQL Server 2016: Backup Media
After watching this video, you will be able to determine the appropriate media for backing up a database.
-
Microsoft SQL Server 2016: Backup Retention Policies
After watching this video, you will be able to recognize how to plan a retention policy for backing up databases.
-
Microsoft SQL Server 2016: Audit Logs and Reports
After watching this video, you will be able to describe the purpose of audit logs and reports when auditing in Azure SQL Database.
-
Microsoft SQL Server 2016: Analyzing Audit Logs and Reports
After watching this video, you will be able to analyze audit logs and reports when auditing in Azure SQL Database.
-
Microsoft SQL Server 2016: Configuring Auditing in SQL Server 2016
After watching this video, you will be able to configure auditing in SQL Server 2016.
-
Microsoft SQL Server 2016: Database Backups
After watching this video, you will be able to describe the reasons for backing up a database and supported backup types.
-
Microsoft SQL Server 2016: Database-level Roles
After watching this video, you will be able to describe database-level roles and their purpose.
-
Microsoft SQL Server 2016: Server-level Roles
After watching this video, you will be able to describe server-level roles and their purpose.
-
Microsoft SQL Server 2016: Application Roles
After watching this video, you will be able to describe the purpose of application roles.
-
Microsoft SQL Server 2016: Custom Roles
After watching this video, you will be able to recognize why you would use and how to create a custom role.
-
Microsoft SQL Server 2016: User Access
After watching this video, you will be able to recognize the steps involved in granting a user access to a database and its objects.
-
Microsoft SQL Server 2016: Granting Database Object Access
After watching this video, you will be able to grant access to database objects.
-
Microsoft SQL Server 2016: Revoking Database Object Access
After watching this video, you will be able to revoke access to database objects.
-
Microsoft SQL Server 2016: Database Users
After watching this video, you will be able to describe the types of database users and their purpose.
-
Microsoft SQL Server 2016: Creating a Database User with SSMS
After watching this video, you will be able to create a database user using SQL Server Management Studio.
-
Microsoft SQL Server 2016: Creating a Database User with T-SQL
After watching this video, you will be able to create a database user using Transact-SQL.
-
Microsoft SQL Server 2016: Permissions
After watching this video, you will be able to describe available server permissions.
-
Microsoft SQL Server 2016: Configuring Data Access and Permissions
After watching this video, you will be able to configure data access and permissions in SQL Server 2016.
-
Microsoft SQL Server 2016: Auditing
After watching this video, you will be able to describe why auditing is required and auditing methods.
-
Microsoft SQL Server 2016: Auditing with Triggers
After watching this video, you will be able to use triggers for auditing.
-
Microsoft SQL Server 2016: Auditing with Temporal Tables Part 1
After watching this video, you will be able to use temporal tables for auditing.
-
Microsoft SQL Server 2016: Connecting to an Azure SQL Database using SSMS
After watching this video, you will be able to connect to and manage an Azure SQL Database using a local instance of SSMS.
-
Microsoft SQL Server 2016: Azure SQL Database Overview
After watching this video, you will be able to describe the benefits and features of using Azure SQL Database.
-
Microsoft SQL Server 2016: Configuring an Azure SQL Database
After watching this video, you will be able to create and configure a new Azure SQL Database.
-
Microsoft SQL Server 2016: Row-level Security
After watching this video, you will be able to describe the purpose of row-level security and how to implement it.
-
Microsoft SQL Server 2016: Implementing Row-level Security Part 1
After watching this video, you will be able to implement row-level security using T-SQ: and predicates.
-
Microsoft SQL Server 2016: Dynamic Data Masking
After watching this video, you will be able to describe the purpose of dynamic data masking.
-
Microsoft SQL Server 2016: Defining a Dynamic Data Mask
After watching this video, you will be able to define dynamic data masking.
-
Microsoft SQL Server 2016: Performing Checks on Databases
After watching this video, you will be able to describe the types of consistency checks appropriate for tabular databases.
-
Microsoft SQL Server 2016: Performing Checks on Tables and Indexes
After watching this video, you will be able to perform consistency checks on indexes.
-
Microsoft SQL Server 2016: Consistency Check Errors
After watching this video, you will be able to recognize common consistency check errors and their resolutions.
-
Microsoft SQL Server 2016: Database Corruption
After watching this video, you will be able to recognize possible causes of database corruption.
-
Microsoft SQL Server 2016: Restoring a Database in SQL Server 2016
After watching this video, you will be able to restore a database in SQL Server 2016.
-
Microsoft SQL Server 2016: Database Consistency Checker
After watching this video, you will be able to describe the purpose of the Database Consistency Checker.
-
Microsoft SQL Server 2016: Using Database Consistency Checker in SSMS
After watching this video, you will be able to use the Database Consistency Checker in SQL Server Management Studio.
-
Microsoft SQL Server 2016: Viewing Progress Reports for DBCC Commands
After watching this video, you will be able to describe the types of consistency checks appropriate for multidimensional databases.
-
Microsoft SQL Server 2016: Piecemeal Restore with the Simple Recovery Model
After watching this video, you will be able to describe the purpose and requirements of piecemeal restore in the simple recovery model.
-
Microsoft SQL Server 2016: Piecemeal Restore with the Full Recovery Model
After watching this video, you will be able to describe the purpose and requirements of piecemeal restore in the full recovery model.
-
Microsoft SQL Server 2016: Piecemeal Restores
After watching this video, you will be able to describe the purpose and process of piecemeal restore.
-
Microsoft SQL Server 2016: Data Collection Design
After watching this video, you will be able to describe the components that make up the data collection system.
-
Microsoft SQL Server 2016: Configuring the Data Collector
After watching this video, you will be able to configure the Data Collector.
-
Microsoft SQL Server 2016: Monitoring Resource Usage
After watching this video, you will be able to use System Monitor to monitor resource usage.
-
Microsoft SQL Server 2016: Activity Monitor
After watching this video, you will be able to recognize the types of activities that can be monitored using Activity Monitor.
-
Microsoft SQL Server 2016: Using Activity Monitor in SSMS
After watching this video, you will be able to use Activity Monitor in SQL Server Management Studio to monitor database activity.
-
Microsoft SQL Server 2016: Identifying Blocks
After watching this video, you will be able to identify blocks using Activity Monitor and stored procedures.
-
Microsoft SQL Server 2016: The Data Collector
After watching this video, you will be able to describe the role of the Data Collector.
-
Microsoft SQL Server 2016: Identifying Database Corruption
After watching this video, you will be able to detect corruption in a SQL Server database.
-
Microsoft SQL Server 2016: Recovering from Database Corruption
After watching this video, you will be able to recover from database corruption.
-
Microsoft SQL Server 2016: Ensuring Database Consistency
After watching this video, you will be able to use SQL Server 2016 tools to ensure database consistency.
-
Microsoft SQL Server 2016: Managing Backup In SQL Server 2016
After watching this video, you will be able to manage and implement a backup strategy in SQL Server 2016.
-
Microsoft SQL Server 2016: Database Restore
After watching this video, you will be able to recognize what is involved in restoring a database, what can be restored, and restore scenario models.
-
Microsoft SQL Server 2016: Complete Database Restores with the Simple Model
After watching this video, you will be able to describe the purpose and prerequisites of restoring a database backup under the simple recovery model.
-
Microsoft SQL Server 2016: Restoring a Database with the Simple Model
After watching this video, you will be able to restore a database under the simple recovery model.
-
Microsoft SQL Server 2016: Recovery Models
After watching this video, you will be able to describe the purpose of the three recovery models.
-
Microsoft SQL Server 2016: Managing Recovery Models with SSMS
After watching this video, you will be able to view and change recovery models using SQL Server Management Studio.
-
Microsoft SQL Server 2016: Managing Recovery Models with T-SQL
After watching this video, you will be able to recognize how to view and change recovery models using Transact-SQL.
-
Microsoft SQL Server 2016: Recovery Model Recommendations
After watching this video, you will be able to describe tasks that should be completed after changing the recovery model.
-
Microsoft SQL Server 2016: Backups to Azure Blob Storage Service
After watching this video, you will be able to describe the features and benefits of backing up a database to the Azure Blob Storage Service.
-
Microsoft SQL Server 2016: Azure Blog Storage Service Backup Considerations
After watching this video, you will be able to describe best practice and troubleshooting tips for backing up to the Azure Blob Storage Service.
-
Microsoft SQL Server 2016: Backing Up a Database to Azure Blob Storage Service
After watching this video, you will be able to backup a database to Azure.
-
Microsoft SQL Server 2016: Restoring Files to a New Location
After watching this video, you will be able to restore files to a new location.
-
Microsoft SQL Server 2016: Restoring File and Filegroups over Existing Files
After watching this video, you will be able to restore files and filegroups over existing files.
-
Microsoft SQL Server 2016: Page Restores
After watching this video, you will be able to recognize when a page restore is useful, as well as its limitations and restrictions.
-
Microsoft SQL Server 2016: Restoring Pages Using SSMS
After watching this video, you will be able to restore pages using SQL Server Management Studio and Transact-SQL.
-
Microsoft SQL Server 2016: Performing Point-in-time Recovery with SSMS
After watching this video, you will be able to describe point-in-time recovery and perform point-in-time recovery using SQL Server Management Studio.
-
Microsoft SQL Server 2016: Performing Point-in-time Recovery with T-SQL
After watching this video, you will be able to perform point-in-time recovery using Transact-SQL.
-
Microsoft SQL Server 2016: File Restores
After watching this video, you will be able to describe the goal of file restore and how it differs in the simple recovery model versus the full recovery model.
-
Microsoft SQL Server 2016: Restoring File and Filegroups
After watching this video, you will be able to restore files and filegroups.
-
Microsoft SQL Server 2016: Automating and Testing Restores
After watching this video, you will be able to automate and test restores.
-
Microsoft SQL Server 2016: Complete Database Restores with the Full Model
After watching this video, you will be able to describe the purpose of and considerations for restoring a database under the full recovery model.
-
Microsoft SQL Server 2016: Restoring a Database with the Full Model Part 1
After watching this video, you will be able to restore a database under the full recovery model.
-
Microsoft SQL Server 2016: SQLIOSim Tool
After watching this video, you will be able to demonstrate how to use the SQLIOSim tool in SQL Server 2016.
-
Microsoft SQL Server 2016: Diskspd Tool
After watching this video, you will be able to demonstrate how to use the Diskspd tool in SQL Server 2016.
-
Microsoft SQL Server 2016: SQL Server Services
After watching this video, you will be able to describe the various services used by SQL Server 2016.
-
Microsoft SQL Server 2016: Account Types
After watching this video, you will be able to describe the various account types available in SQL Server 2016.
-
Microsoft SQL Server 2016: Parallelism
After watching this video, you will be able to describe parallelism in SQL Server 2016.
-
Microsoft SQL Server 2016: I/O Operations
After watching this video, you will be able to explain I/O operations in SQL Server 2016.
-
Microsoft SQL Server 2016: SQL Server Software Requirements
After watching this video, you will be able to understand the various software requirements for SQL Server 2016.
-
Microsoft SQL Server 2016: I/O Subsystems for SQL Server
After watching this video, you will be able to describe considerations when implementing I/O subsystems for SQL Server 2016.
-
Microsoft SQL Server 2016: Network Protocols
After watching this video, you will be able to explain the different network protocols supported by SQL Server 2016.
-
Microsoft SQL Server 2016: SQL Server Hardware Requirements
After watching this video, you will be able to understand the various hardware requirements for SQL Server 2016.
-
Microsoft SQL Server 2016: SQL Server Memory Management
After watching this video, you will be able to explain SQL Server 2016 Server memory management.
-
Microsoft SQL Server 2016: Architecture Layers
After watching this video, you will be able to recognize the different SQL Server 2016 architecture layers.
-
Microsoft SQL Server 2016: SQL Server CPU Usage
After watching this video, you will be able to explain SQL Server 2016 CPU usage.
-
Microsoft SQL Server 2016: SQL Server Components
After watching this video, you will be able to recognize the SQL Server 2016 components.
-
Microsoft SQL Server 2016: SQL Server Instances
After watching this video, you will be able to describe SQL Server 2016 instances.
-
Microsoft SQL Server 2016: 32-bit Systems
After watching this video, you will be able to explain SQL Server 2016 32-bit systems.
-
Microsoft SQL Server 2016: 64-bit Systems
After watching this video, you will be able to explain SQL Server 2016 64-bit systems.
-
Microsoft SQL Server 2016: SQL Server Editions
After watching this video, you will be able to describe SQL Server 2016 editions.
-
Microsoft SQL Server 2016: SQL Server Versions
After watching this video, you will be able to describe SQL Server 2016 versions.
-
Transact-SQL: Subqueries Overview
After watching this video, you will be able to recognize when and where to use subqueries in SQL Server 2016.
-
Transact-SQL: Scalar Subqueries
After watching this video, you will be able to describe the benefits of using scalar subqueries.
-
Transact-SQL: Aggregate Functions Overview
After watching this video, you will be able to recognize the aggregate functions available using Transact-SQL.
-
Transact-SQL: Using Aggregate Functions in SQL
After watching this video, you will be able to use aggregate functions in SQL Server 2016.
-
Transact-SQL: Outputting XML Data
After watching this video, you will be able to demonstrate how to query and output XML data in SQL Server 2016.
-
Transact-SQL: Using Database Programmability Objects
After watching this video, you will be able to use database programmability objects in SQL Server 2016.
-
Transact-SQL: Temporal Data Types
After watching this video, you will be able to describe temporal data types in SQL Server 2016.
-
Transact-SQL: Temporal Tables
After watching this video, you will be able to work with temporal tables in SQL Server 2016.
-
Transact-SQL: TRY…CATCH error handling
After watching this video, you will be able to demonstrate TRY...CATCH error handling.
-
Transact-SQL: RAISERROR Statements
After watching this video, you will be able to demonstrate how to use RAISERROR in SQL 2016.
-
Transact-SQL: Table-valued Functions
After watching this video, you will be able to recognize table-valued functions in SQL Server 2016.
-
Transact-SQL: Scalar-valued User-defined Functions
After watching this video, you will be able to describe scalar-valued user-defined functions in SQL Server 2016.
-
Transact-SQL: Input parameters
After watching this video, you will be able to demonstrate how to input parameters in SQL Server 2016.
-
Transact-SQL: Output parameters
After watching this video, you will be able to demonstrate how to output parameters in SQL Server 2016.
-
Transact-SQL: XML Data
After watching this video, you will be able to describe XML data.
-
Transact-SQL: JSON Data
After watching this video, you will be able to describe JSON data.
-
Transact-SQL: Output JSON Data
After watching this video, you will be able to demonstrate how to query and output JSON data in SQL Server 2016.
-
Transact-SQL: GROUP BY Clause and Aggregate Functions
After watching this video, you will be able to describe how to use GROUP BY with aggregate functions in SQL Server 2016.
-
Transact-SQL: GROUP BY clauses using GROUPING Sets
After watching this video, you will be able to demonstrate using complex GROUP BY clauses using GROUPING sets.
-
Transact-SQL: HAVING Clause
After watching this video, you will be able to recognize how to filter groups using the HAVING clause.
-
Transact-SQL: Pivot and Unpivot Overview
After watching this video, you will be able to recognize how to use PIVOT and UNPIVOT relational operators in SQL Server 2016.
-
Transact-SQL: Logical Order of Operations
After watching this video, you will be able to describe how to process queries using the logical order of operations.
-
Transact-SQL: GROUP BY Workflow
After watching this video, you will be able to describe the GROUP BY workflow process.
-
Transact-SQL: Group and Rank Results
After watching this video, you will be able to demonstrate how to group and rank the results of a query using the windowing functions in SQL Server 2016.
-
Transact-SQL: COUNT Aggregate Function
After watching this video, you will be able to list the built-in aggregate function COUNT in SQL Server 2016.
-
Transact-SQL: Aggregating Distinct Values
After watching this video, you will be able to describe how to aggregate distinct values using DISTINCT.
-
Transact-SQL: NULL and Aggregate Functions
After watching this video, you will be able to demonstrate how to use aggregate functions with NULL.
-
Transact-SQL: GROUP BY Overview
After watching this video, you will be able to recognize when and where to use the GROUP BY clause.
-
Transact-SQL: Multi-valued Subqueries
After watching this video, you will be able to recognize how to write multi-valued subqueries in SQL Server 2016.
-
Transact-SQL: Correlated Subqueries Overview
After watching this video, you will be able to work with correlated subqueries in SQL Server 2016.
-
Transact-SQL: Writing Correlated Subqueries
After watching this video, you will be able to describe how to write correlated subqueries.
-
Transact-SQL: Correlated Subqueries with Aliases
After watching this video, you will be able to recognize how to write correlated subqueries with aliases.
-
Transact-SQL: Writing Effective Scalar Subqueries
After watching this video, you will be able to demonstrate how to write scalar subqueries in SQL Server 2016.
-
Transact-SQL: Using PIVOT
After watching this video, you will be able to demonstrate how to use PIVOT in SQL Server 2016.
-
Transact-SQL: Using UNPIVOT
After watching this video, you will be able to demonstrate how to use UNPIVOT in SQL Server 2016.
-
Transact-SQL: NULL Values in PIVOT and UNPIVOT Queries
After watching this video, you will be able to describe how to determine the impact on NULL values in PIVOT and UNPIVOT queries.
-
Transact-SQL: Implicit and Explicit Conversations
After watching this video, you will be able to work with implicit and explicit data type conversions in SQL Server 2016.
-
Transact-SQL: Scalar Functions
After watching this video, you will be able to work with scalar functions in SQL Server 2016.
-
Transact-SQL: Aggregate Functions
After watching this video, you will be able to describe aggregate functions in SQL Server 2016.
-
Transact-SQL: Windows Functions
After watching this video, you will be able to list Windows functions in SQL Server 2016.
-
Transact-SQL: Rowset Functions
After watching this video, you will be able to describe rowset functions in SQL Server 2016.
-
Transact-SQL: SUM Aggregate Function
After watching this video, you will be able to describe the built-in aggregate function SUM in SQL Server 2016.
-
Transact-SQL: AVG Aggregate Function
After watching this video, you will be able to describe the built-in aggregate function AVG in SQL Server 2016.
-
Transact-SQL: MIN Aggregate Function
After watching this video, you will be able to list the built-in aggregate function in MIN Server 2016.
-
Transact-SQL: MAX Aggregate Function
After watching this video, you will be able to list the built-in aggregate function MAX in SQL Server 2016.
-
Transact-SQL: Using Functions in SQL Server 2016
After watching this video, you will be able to use functions in SQL Server 2016.
-
Transact-SQL: NULL Value Overview
After watching this video, you will be able to describe the NULL value in SQL Server 2016.
-
Transact-SQL: Using Operators in SQL Server 2016
After watching this video, you will be able to use operators in SQL Server 2016.
-
Transact-SQL: Understanding Stored Procedures
After watching this video, you will be able to describe stored procedures in SQL Server 2016.
-
Transact-SQL: Using Stored Procedures
After watching this video, you will be able to use and create stored procedures in SQL Server 2016.
-
Transact-SQL: CROSS APPLY Operator
After watching this video, you will be able to use CROSS APPLY operators in SQL Server 2016.
-
Microsoft SQL Server 2016: User-defined Functions Components
After watching this video, you will be able to recognize the various components of user-defined functions.
-
Transact-SQL: APPLY Operator Overview
After watching this video, you will be able to recognize when to use the APPLY operator in SQL Server 2016.
-
Microsoft SQL Server 2016: INSTEAD Trigger
After watching this video, you will be able to demonstrate how to use the INSTEAD trigger.
-
Transact-SQL: Writing APPLY Statements
After watching this video, you will be able to use APPLY statements that return given data based on supplied data in SQL Server 2016.
-
Microsoft SQL Server 2016: User-defined Functions Overview
After watching this video, you will be able to describe user-defined functions.
-
Microsoft SQL Server 2016: Built-in Functions
After watching this video, you will be able to use built-in functions.
-
Microsoft SQL Server 2016: Deterministic Functions
After watching this video, you will be able to use deterministic functions.
-
Microsoft SQL Server 2016: Scalar-valued Functions
After watching this video, you will be able to use scalar-valued functions.
-
Microsoft SQL Server 2016: Table-valued Functions
After watching this video, you will be able to use table-valued functions.
-
Microsoft SQL Server 2016: Transactions
After watching this video, you will be able to recognize when to use transactions.
-
Microsoft SQL Server 2016: BEGIN TRANSACTION
After watching this video, you will be able to demonstrate how to use the BEGIN TRANSACTION statement.
-
Microsoft SQL Server 2016: Nondeterministic Functions
After watching this video, you will be able to use nondeterministic functions.
-
Microsoft SQL Server 2016: Configure Triggers
After watching this video, you will be able to configure triggers in SQL Server 2016.
-
Transact-SQL: NULL Values with the INTERSECT Operator
After watching this video, you will be able to determine the effect of NULL values on the INTERSECT operator.
-
Microsoft SQL Server 2016: DML Trigger Security
After watching this video, you will be able to recognize best practices regarding DML trigger security.
-
Microsoft SQL Server 2016: Implementing DDL Triggers
After watching this video, you will be able to implement DDL triggers.
-
Microsoft SQL Server 2016: Creating DML Triggers
After watching this video, you will be able to create DML triggers.
-
Microsoft SQL Server 2016: Creating CLR Triggers
After watching this video, you will be able to create CLR triggers.
-
Microsoft SQL Server 2016: DDL Events and Event Groups
After watching this video, you will be able to describe DDL events and event groups.
-
Microsoft SQL Server 2016: Implementing Triggers
After watching this video, you will be able to recognize when to use the various types of triggers.
-
Microsoft SQL Server 2016: Gathering DDL Trigger Information
After watching this video, you will be able to gather information regarding DDL triggers.
-
Microsoft SQL Server 2016: Disabling Logon Triggers
After watching this video, you will be able to disable logon triggers.
-
Microsoft SQL Server 2016: AFTER Trigger
After watching this video, you will be able to demonstrate how to use the AFTER trigger.
-
Microsoft SQL Server 2016: Specifying First and Last Trigger
After watching this video, you will be able to implement first and last triggers.
-
Microsoft SQL Server 2016: Managing Transactions in Logon Triggers
After watching this video, you will be able to manage transactions within a logon trigger.
-
Transact-SQL: NOT EXISTS and OUTER JOINs
After watching this video, you will be able to demonstrate how to use NOT EXISTS with OUTER JOINs.
-
Transact-SQL: Writing Queries That Use EXISTS with Subqueries
After watching this video, you will be able to describe how to write queries using EXISTS with subqueries.
-
Transact-SQL: EXISTS and NULLs
After watching this video, you will be able to demonstrate how to use EXISTS and NULLs in SQL Server 2016.
-
Transact-SQL: EXISTS and INNER JOINs
After watching this video, you will be able to describe how to use EXISTS and INNER JOINs in SQL Server 2016.
-
Microsoft SQL Server 2016: Return Codes
After watching this video, you will be able to implement return codes.
-
Microsoft SQL Server 2016: Stored Procedure Logic
After watching this video, you will be able to streamline existing stored procedure logic.
-
Microsoft SQL Server 2016: Obfuscating Stored Procedures
After watching this video, you will be able to obfuscate stored procedures using the WITH ENCRYPTIONS clause.
-
Microsoft SQL Server 2016: Configure Constraints
After watching this video, you will be able to configure constraints in SQL Server 2016.
-
Microsoft SQL Server 2016: Error Handling and Transaction Control Logic
After watching this video, you will be able to implement error handling and transaction control logic within stored procedures.
-
Microsoft SQL Server 2016: Error Handling and Transaction Control Logic
After watching this video, you will be able to alter a stored procedure using the Transact-SQL ALTER PROCEDURE statement.
-
Transact-SQL: Correlated Subqueries with Comparison Operators
After watching this video, you will be able to describe how to write correlated subqueries with aliases.
-
Transact-SQL: Correlated Subqueries within a HAVING Clause
After watching this video, you will be able to describe how to write correlated subqueries in a HAVING clause.
-
Transact-SQL: EXISTS Predicate Overview
After watching this video, you will be able to describe how the EXISTS predicate evaluates data in SQL Server 2016.
-
Transact-SQL: EXCEPT and INTERSECT Operators
After watching this video, you will be able to recognize when to use the EXCEPT operator in SQL Server 2016.
-
Transact-SQL: Using EXCEPT and INTERSECT Operators
After watching this video, you will be able to demonstrate how to use the EXCEPT and INTERSECT operators in SQL Server 2016.
-
Transact-SQL: Order of Input Using the EXCEPT Operator
After watching this video, you will be able to determine the results of reversing the order of input with the EXCEPT operator.
-
Transact-SQL: Writing Queries That Use the UNION Operator
After watching this video, you will be able to demonstrate how to write SQL Server 2016 queries that use the UNION operator.
-
Transact-SQL: Writing Queries That Use the UNION ALL Operator
After watching this video, you will be able to demonstrate how to write SQL Server 2016 queries that use the UNION ALL operator.
-
Transact-SQL: Mixed UNION and UNION ALL Operators
After watching this video, you will be able to demonstrate how to use the UNION and UNION ALL operators together.
-
Transact-SQL: UNION vs. UNION ALL Operator s
After watching this video, you will be able to distinguish when to use the UNION and UNION All operators in SQL Server 2016.
-
Transact-SQL: NOT EXISTS and OUTER JOINs
After watching this video, you will be able to use subqueries in SQL Server 2016.
-
Microsoft SQL Server 2016: Creating Statistics
After watching this video, you will be able to create statistics and determine accuracy of results.
-
Microsoft SQL Server 2016: Modifying Statistics
After watching this video, you will be able to modify existing statistics.
-
Microsoft SQL Server 2016: Best Practices
After watching this video, you will be able to describe the best practices for calling natively compiled stored procedures.
-
Microsoft SQL Server 2016: Troubleshoot Deadlocks
After watching this video, you will be able to demonstrate how to troubleshoot deadlocks.
-
Microsoft SQL Server 2016: Viewing Statistics Properties
After watching this video, you will be able to view statistic properties.
-
Microsoft SQL Server 2016: Updating Statistics
After watching this video, you will be able to update query optimization statistics.
-
Microsoft SQL Server 2016: Creating Natively Compiled Stored Procedures
After watching this video, you will be able to demonstrate how to create a natively compiled stored procedure.
-
Microsoft SQL Server 2016: Monitoring Performance
After watching this video, you will be able to demonstrate how to monitor performance for natively compiled stored procedures.
-
Microsoft SQL Server 2016: Use Cases for Natively Compiled Stored Procedures
After watching this video, you will be able to recognize best-case usage scenarios for natively compiled stored procedures.
-
Microsoft SQL Server 2016: Atomic Blocks
After watching this video, you will be able to describe atomic blocks in natively compiled stored procedures.
-
Microsoft SQL Server 2016: Creating Memory-optimized tables
After watching this video, you will be able to create memory-optimized tables.
-
Microsoft SQL Server 2016: Durability Settings
After watching this video, you will be able to optimize performance by adjusting durability settings.
-
Microsoft SQL Server 2016: Lock Escalation Behavior
After watching this video, you will be able to describe lock escalation behaviors.
-
Microsoft SQL Server 2016: Memory-optimized Tables Overview
After watching this video, you will be able to provide an overview of memory-optimized tables and discuss use cases for memory-optimized tables vs. traditional disk-based tables.
-
Microsoft SQL Server 2016: Natively Compiled Stored Procedures
After watching this video, you will be able to describe the characteristics of natively compiled stored procedures.
-
Microsoft SQL Server 2016: Statistics for Memory-optimized tables
After watching this video, you will be able to describe considerations for statistics on memory-optimized tables.
-
Microsoft SQL Server 2016: Querying Memory-optimized tables
After watching this video, you will be able to describe the methods used to query memory-optimized tables.
-
Microsoft SQL Server 2016: Remediating Deadlocks
After watching this video, you will be able to demonstrate how to remediate, detect, and end deadlocks.
-
Microsoft SQL Server 2016: Troubleshooting Locking Issues
After watching this video, you will be able to demonstrate how to troubleshoot locking issues.
-
Microsoft SQL Server 2016: Handling Deadlocks
After watching this video, you will be able to demonstrate how to handle deadlocks.
-
Microsoft SQL Server 2016: READ COMMITTED
After watching this video, you will be able to use the READ COMMITTED isolation level.
-
Microsoft SQL Server 2016: Isolation Levels: Performance Impact
After watching this video, you will be able to describe performance impact considerations of given isolation levels.
-
Microsoft SQL Server 2016: Manage Transactions
After watching this video, you will be able to demonstrate how to administer transactions.
-
Microsoft SQL Server 2016: SNAPSHOT Isolation
After watching this video, you will be able to use the SNAPSHOT isolation level.
-
Microsoft SQL Server 2016: Isolation Levels: Concurrent Queries
After watching this video, you will be able to define the results of concurrent queries based on isolation levels.
-
Microsoft SQL Server 2016: Understanding Deadlocks
After watching this video, you will be able to describe deadlock behavior.
-
Microsoft SQL Server 2016: Minimizing Deadlocks
After watching this video, you will be able to minimize deadlocks.
-
Microsoft SQL Server 2016: Locking Basics
After watching this video, you will be able to provide an overview of locking.
-
Microsoft SQL Server 2016: Concurrency Effects
After watching this video, you will be able to discuss the types of concurrency and their effects.
-
Microsoft SQL Server 2016: REPEATABLE READ
After watching this video, you will be able to use the REPEATABLE READ isolation level.
-
Microsoft SQL Server 2016: SERIALIZED
After watching this video, you will be able to use the SERIALIZED isolation level.
-
Microsoft SQL Server 2016: COMMIT TRANSACTION
After watching this video, you will be able to use the COMMIT TRANSACTION to mark the end of a successful implicit or explicit transaction.
-
Microsoft SQL Server 2016: COMMIT WORK
After watching this video, you will be able to use the COMMIT WORK statement to mark the end of a transaction.
-
Microsoft SQL Server 2016: DML Statements and Transactions
After watching this video, you will be able to identify DML statement results based on transaction behavior.
-
Microsoft SQL Server 2016: Transactions in High-concurrency Databases
After watching this video, you will be able to determine the role of transactions in high-concurrency SQL Server 2016 databases.
-
Microsoft SQL Server 2016: ROLLBACK WORK
After watching this video, you will be able to use the ROLLBACK WORK statement to roll back a user-specified transaction.
-
Microsoft SQL Server 2016: SAVE TRANSACTION
After watching this video, you will be able to use the SAVE TRANSACTION statement to set a savepoint within a transaction.
-
Microsoft SQL Server 2016: Snapshot Isolation and Row Versioning
After watching this video, you will be able to describe snapshot isolation and row versioning.
-
Microsoft SQL Server 2016: READ UNCOMMITTED
After watching this video, you will be able to use the READ UNCOMMITTED isolation level.
-
Microsoft SQL Server 2016: Transactions in High-concurrency Databases
After watching this video, you will be able to describe explicit transactions.
-
Microsoft SQL Server 2016: Implicit Transactions
After watching this video, you will be able to describe implicit transactions.
-
Microsoft SQL Server 2016: ROLLBACK TRANSACTION
After watching this video, you will be able to use the ROLLBACK TRANSACTION to roll back an explicit or implicit transaction.
-
Microsoft SQL Server 2016: Creating an Azure SQL Database
After watching this video, you will be able to demonstrate how to create an Azure SQL Server 2016 database
-
Microsoft SQL Server 2016: Elastic Scale
After watching this video, you will be able to describe elastic scaling
-
Microsoft SQL Server 2016: Tempdb Files
After watching this video, you will be able to optimize tempdb configuration files
-
Microsoft SQL Server 2016: Creating a Workload Group
After watching this video, you will be able to create a workload group.
-
Microsoft SQL Server 2016: Disabling Resource Governor
After watching this video, you will be able to disable resource governor.
-
Microsoft SQL Server 2016: Creating a Resource Pool
After watching this video, you will be able to create a resource pool.
-
Microsoft SQL Server 2016: Common Service Tier Use Cases
After watching this video, you will be able to describe common service tier use cases.
-
Microsoft SQL Server 2016: Memory Configuration
After watching this video, you will be able to optimize memory configuration.
-
Microsoft SQL Server 2016: Service Tiers
After watching this video, you will be able to describe service tiers.
-
Microsoft SQL Server 2016: Enabling Resource Governor
After watching this video, you will be able to enable resource governor.
-
Microsoft SQL Server 2016: Configuring Resource Governor
After watching this video, you will be able to configure resource governor properties.
-
Microsoft SQL Server 2016: Workloads
After watching this video, you will be able to describe workloads.
-
Microsoft SQL Server 2016: Resource Governor
After watching this video, you will be able to manage workloads and system resource consumption using resource governor.
-
Microsoft SQL Server 2016: Query Store Usage Scenarios
After watching this video, you will be able to describe when and where to use the Query Store.
-
Microsoft SQL Server 2016: Query Performance Troubleshooting
After watching this video, you will be able to determine how to start query performance troubleshooting.
-
Microsoft SQL Server 2016: Azure SQL Database Performance Insight
After watching this video, you will be able to configure the Azure SQL Database Performance Insight.
-
Microsoft SQL Server 2016: Work with Statistics and Optimize Indexes
After watching this video, you will be able to use statistics objects and index optimization methods.
-
Microsoft SQL Server 2016: Query Plan Operator Performance
After watching this video, you will be able to identify underperforming query plan operators.
-
Microsoft SQL Server 2016: Reviewing Query Results
After watching this video, you will be able to compare query plans and related metadata.
-
Microsoft SQL Server 2016: Logical Operators
After watching this video, you will be able to describe logical operators and how they are used.
-
Microsoft SQL Server 2016: Physical Operators
After watching this video, you will be able to describe physical operators and how they are used.
-
Microsoft SQL Server 2016: Overlapping Indexes
After watching this video, you will be able to identify and consolidate overlapping indexes.
-
Microsoft SQL Server 2016: Capturing Query Plans
After watching this video, you will be able to capture query plans using extended events and traces.
-
Microsoft SQL Server 2016: Query Store Best Practices
After watching this video, you will be able to recognize best practices to follow with the Query Store.
-
Microsoft SQL Server 2016: Maintenance Tasks
After watching this video, you will be able to describe available maintenance tasks to perform.
-
Microsoft SQL Server 2016: Defragmenting Indexes
After watching this video, you will be able to perform index defragmentation.
-
Microsoft SQL Server 2016: Reviewing Dynamic Management Objects
After watching this video, you will be able to review current index usage and identify missing indexes.
-
Microsoft SQL Server 2016: Database Engine Tuning Advisor
After watching this video, you will be able to perform database tuning using the database engine tuning advisor.
-
Microsoft SQL Server 2016: Creating a Maintenance Plan
After watching this video, you will be able to demonstrate how to create a maintenance plan.
-
Microsoft SQL Server 2016: Input and Output Parameters
After watching this video, you will be able to describe how to use the input and output parameters.
-
Microsoft SQL Server 2016: Table-valued Parameters
After watching this video, you will be able to demonstrate how to use table-valued parameters.
-
Microsoft SQL Server 2016: IDENTITY Constraints
After watching this video, you will be able to describe the IDENTITY constraint.
-
Microsoft SQL Server 2016: Constraint Checking
After watching this video, you will be able to recognize the common considerations to be aware of when working with constraints.
-
Microsoft SQL Server 2016: FOREIGN KEY Constraints
After watching this video, you will be able to use the FOREIGN KEY constraint.
-
Microsoft SQL Server 2016: UNIQUE Constraints
After watching this video, you will be able to describe the UNIQUE constraint I.
-
Microsoft SQL Server 2016: Stored Procedures Overview
After watching this video, you will be able to describe stored procedures and their benefits.
-
Microsoft SQL Server 2016: Designing Stored Procedures
After watching this video, you will be able to design stored procedures components and structure based on business requirements.
-
Microsoft SQL Server 2016: Adding Constraints to Tables
After watching this video, you will be able to demonstrate how to write Transact-SQL statements to add constraints to tables.
-
Microsoft SQL Server 2016: Identifying Results Given Existing Constraints
After watching this video, you will be able to demonstrate how to identify results of DML statements given exiting tables and constraints.
-
Transact-SQL: SQL Server 2016 Data Types Overview
After watching this video, you will be able to describe how SQL Server 2016 uses data types.
-
Transact-SQL: Data Type Conversions
After watching this video, you will be able to recognize when data type conversions occur in SQL Server 2016.
-
Transact-SQL: Testing for NULL
After watching this video, you will be able to describe how to test for NULL in SQL Server 2016.
-
Transact-SQL: WHERE clause
After watching this video, you will be able to demonstrate how to filter data in SQL Server 2016 using the WHERE clause.
-
Transact-SQL: Predicates and Operators
After watching this video, you will be able to describe how to use predicates and operators in SQL Server 2016.
-
Transact-SQL: Three-valued Logic
After watching this video, you will be able to describe three-valued logic in SQL Server 2016.
-
Transact-SQL: NULL in Queries
After watching this video, you will be able to work with NULL in Queries in SQL Server 2016.
-
Transact-SQL: Manipulating Data in SQL Server 2016
After watching this video, you will be able to demonstrate how to query and manipulate data in SQL Server 2016.
-
Transact-SQL: ORDER BY Clause
After watching this video, you will be able to describe the ORDER BY clause in SQL Server 2016.
-
Transact-SQL: Sorting Data
After watching this video, you will be able to demonstrate how to sort data in SQL Server 2016 using the ORDER BY clause.
-
Transact-SQL: Filtering Data
After watching this video, you will be able to recognize how to filter data in SQL Server 2016.
-
Transact-SQL: OUTPUT Clause
After watching this video, you will be able to demonstrate how to use the OUTPUT clause to monitor data in SQL Server 2016.
-
Transact-SQL: Modifying Data in SQL Server 2016
After watching this video, you will be able to demonstrate how to filter and modify data in SQL Server 2016.
-
Transact-SQL: SQL Server Built-in Function Types
After watching this video, you will be able to list the built-in function types used in SQL Server 2016.
-
Transact-SQL: Populating Tables Using SELECT INTO
After watching this video, you will be able to describe how to populate tables in SQL Server 2016 using the SELECT INTO statement.
-
Transact-SQL: Add Data Using INSERT
After watching this video, you will be able to demonstrate how to add data using INSERT statement.
-
Transact-SQL: Modify Data Using UPDATE and MERGE
After watching this video, you will be able to describe how to use UPDATE and MERGE statements to modify data.
-
Transact-SQL: Remove Data Using DELETE and TRUNCATE
After watching this video, you will be able to describe how to use DELETE and TRUNCATE statements to remove data.
-
Transact-SQL: Implicit and Explicit Conversions
After watching this video, you will be able to demonstrate implicit and explicit conversions.
-
Transact-SQL: Character Data
After watching this video, you will be able to describe different types of character data in SQL Server 2016.
-
Transact-SQL: Manipulating Character Data
After watching this video, you will be able to demonstrate how to manipulate character data in SQL Server 2016.
-
Transact-SQL: Data Manipulation Language Overview
After watching this video, you will be able to list the benefits of using data manipulation language (DML) in SQL Server 2016.
-
Transact-SQL: NULL Values and Joins
After watching this video, you will be able to demonstrate how to write queries with NULLs on joins.
-
Transact-SQL: Set Operators
After watching this video, you will be able to describe the characteristics of sets in SQL Server 2016.
-
Transact-SQL: Set Theory
After watching this video, you will be able to describe the set theory and how it relates to SQL Server 2015.
-
Transact-SQL: Set Theory and SQL Server 2016 Queries
After watching this video, you will be able to describe applying set theory to SQL server queries.
-
Transact-SQL: Predicate Logic Overview
After watching this video, you will be able to define predicate logic in SQL Server 2016.
-
Transact-SQL: T-SQL Expressions
After watching this video, you will be able to demonstrate how to implement T-SQL expressions in SQL Server 2016.
-
Transact-SQL: T-SQL Control of Flow, Errors, and Transactions
After watching this video, you will be able to work with T-SQL control of flow, errors, and transactions in SQL Server 2016.
-
Transact-SQL: T-SQL Comments
After watching this video, you will be able to use T-SQL comments in SQL Server 2016.
-
Transact-SQL: T-SQL Batch Separators
After watching this video, you will be able to work with T-SQL batch separators.
-
Transact-SQL: T-SQL Variables
After watching this video, you will be able to create T-SQL Variables in SQL Server 2016.
-
Transact-SQL: T-SQL Statements
After watching this video, you will be able to configure T-SQL statements in SQL Server 2016.
-
Transact-SQL: T-SQL Functions
After watching this video, you will be able to work with T-SQL Language functions in SQL Server 2016.
-
Transact-SQL: Calculated Expressions
After watching this video, you will be able to demonstrate how to use calculations in the SELECT clause.
-
Transact-SQL: Understanding DISTINCT Statements in SQL Server 2016
After watching this video, you will be able to describe the purpose of DISTINCT in SQL Server 2016.
-
Transact-SQL: SELECT DISTINCT Syntax
After watching this video, you will be able to describe how to execute a SELECT DISTINCT.
-
Transact-SQL: Eliminating Duplicates Using DISTINCT
After watching this video, you will be able to demonstrate how to eliminate duplicates using DISTINCT.
-
Transact-SQL: Querying Data with Transact-SQL
After watching this video, you will be able to demonstrate querying data in SQL Server 2016.
-
Transact-SQL: SELECT Statements Overview
After watching this video, you will be able to recognize elements of simple SQL Server 2016 SELECT queries.
-
Transact-SQL: Writing SELECT Statements in SQL Server 2016
After watching this video, you will be able to demonstrate how to write simple SELECT statements in SQL Server 2016.
-
Transact-SQL: Logical Order of Operations
After watching this video, you will be able to define the logical order of operations.
-
Transact-SQL: Applying Logical Order of Operations
After watching this video, you will be able to demonstrate the logical order of operations when writing SELECT statements.
-
Transact-SQL: Elements of a SELECT Statement
After watching this video, you will be able to recognize the elements of a SELECT statement in SQL Server 2016.
-
Transact-SQL: SQL Server 2016 Architecture Overview
After watching this video, you will be able to recognize features of SQL Server 2016.
-
Transact-SQL: SQL Server 2016 Editions and Components
After watching this video, you will be able to list SQL Server 2016 editions and components.
-
Transact-SQL: SQL Server 2016 Functions and Capabilities
After watching this video, you will be able to identify SQL Server 2016 functions and capabilities.
-
Transact-SQL: SQL Server Management Studio
After watching this video, you will be able to list features of SQL Server Management Studio.
-
Microsoft SQL Server 2016: Create a SQL Table
After watching this video, you will be able to demonstrate how to create a SQL Table.
-
Microsoft SQL Server 2016: Index Design Basics
After watching this video, you will be able to recognize the basic guidelines to follow when designing and implementing indexes.
-
Microsoft SQL Server 2016: Third Normal Form
After watching this video, you will be able to describe the third normal form level of normalization.
-
Microsoft SQL Server 2016: Database Denormalization
After watching this video, you will be able to demonstrate how to denormalize a database.
-
Microsoft SQL Server 2016: Creating Clustered Indexes
After watching this video, you will be able to create clustered indexes.
-
Microsoft SQL Server 2016: Tables Without Clustered Indexes
After watching this video, you will be able to describe when to use tables without clustered indexes.
-
Microsoft SQL Server 2016: Clustered vs. Nonclustered Indexes
After watching this video, you will be able to recognize the basic guidelines to follow when designing and implementing indexes.
-
Microsoft SQL Server 2016: First Normal Form
After watching this video, you will be able to describe the first normal form level of normalization.
-
Microsoft SQL Server 2016: Second Normal Form
After watching this video, you will be able to describe the second normal form level of normalization.
-
Microsoft SQL Server 2016: Normalization
After watching this video, you will be able to recognize the process of normalization in SQL Server 2016.
-
Microsoft SQL Server 2016: Altering Tables
After watching this video, you will be able to use the ALTER TABLE statement to modify a table.
-
Microsoft SQL Server 2016: Naming Conventions
After watching this video, you will be able to describe the best practices to follow when selecting a naming convention.
-
Microsoft SQL Server 2016: Numerics
After watching this video, you will be able to describe the numeric data type category in SQL Server 2016.
-
Microsoft SQL Server 2016: Renaming Tables
After watching this video, you will be able to rename a table.
-
Microsoft SQL Server 2016: Constraints
After watching this video, you will be able to use constraints to ensure integrity of data.
-
Microsoft SQL Server 2016: Binary Strings
After watching this video, you will be able to describe the binary strings data type category in SQL Server 2016.
-
Microsoft SQL Server 2016: Special Data Types
After watching this video, you will be able to describe the special data types category in SQL Server 2016.
-
Microsoft SQL Server 2016: Date and Time
After watching this video, you will be able to describe the date and time data type category in SQL Server 2016.
-
Microsoft SQL Server 2016: Character and Unicode
After watching this video, you will be able to describe the character and unicode data type category in SQL Server 2016.
-
Microsoft SQL Server 2016: Adding and Removing Columns
After watching this video, you will be able to add and removing columns from a table.
-
Microsoft SQL Server 2016: Duplicating Tables
After watching this video, you will be able to duplicate a table.
-
Transact-SQL: Querying with Right Outer Joins
After watching this video, you will be able to demonstrate the proper usages of outer joins in SQL Server 2016.
-
Transact-SQL: Querying Cross Joins and Self Joins
After watching this video, you will be able to demonstrate the proper usages of cross and self joins.
-
Transact-SQL: Multiple Join Operators
After watching this video, you will be able to demonstrate the use of multiple join operators.
-
Transact-SQL: Using Simple CASE Expressions
After watching this video, you will be able to demonstrate how to use simple CASE expressions.
-
Transact-SQL: Joins Overview
After watching this video, you will be able to recognize how and when to use joins in SQL Server 2016.
-
Transact-SQL: Querying with Inner Joins
After watching this video, you will be able to demonstrate the proper usage of inner joins in SQL Server 2016.
-
Transact-SQL: Querying with Left Outer Joins
After watching this video, you will be able to demonstrate the proper usages of outer joins in SQL Server 2016.
-
Transact-SQL: Referring to Columns Using Aliases
After watching this video, you will be able to describe how to refer to columns using aliases.
-
Transact-SQL: Referring to Tables Using Aliases
After watching this video, you will be able to specify how to refer to tables using aliases.
-
Transact-SQL: SQL Server 2016 CASE Expressions
After watching this video, you will be able to describe SQL Server 2016 CASE expressions.
-
Microsoft SQL Server 2016: Creating Tables
After watching this video, you will be able to create tables in SQL Server 2016.
-
Microsoft SQL Server 2016: Dropping Tables
After watching this video, you will be able to use the DROP TABLE statement to drop a table from a database.
-
Microsoft SQL Server 2016: PRIMARY KEY Constraints
After watching this video, you will be able to describe the use of the PRIMARY Key constraint.
-
Microsoft SQL Server 2016: Enforcing Data Integrity
After watching this video, you will be able to use the various mechanisms used to enforce data integrity.
-
Microsoft SQL Server 2016: Entity and Referential Integrity
After watching this video, you will be able to describe entity and referential integrity.
-
Microsoft SQL Server 2016: In-Memory Index Performance Considerations
After watching this video, you will be able to describe in-memory index performance considerations.
-
Microsoft SQL Server 2016: XML Indexes
After watching this video, you will be able to describe XML indexes.
-
Microsoft SQL Server 2016: Creating Tables with Nonclustered Hash Indexes
After watching this video, you will be able to create tables with nonclustered hash indexes.
-
Microsoft SQL Server 2016: Configure Columnstore Indexes
After watching this video, you will be able to implement and configure columnstore indexes.
-
Microsoft SQL Server 2016: Types of Data Integrity
After watching this video, you will be able to recognize the three basic forms of data integrity: domain, entity, referential.
-
Microsoft SQL Server 2016: Secondary XML Indexes
After watching this video, you will be able to describe secondary XML indexes.
-
Microsoft SQL Server 2016: XML Index Performance Considerations
After watching this video, you will be able to describe XML index performance considerations.
-
Microsoft SQL Server 2016: Changing Data in a Nonclustered Columnstore Index
After watching this video, you will be able to change data in a nonclustered columnstore index.
-
Microsoft SQL Server 2016: In-memory Nonclustered Hash Indexes
After watching this video, you will be able to describe in-memory nonclustered hash indexes.
-
Microsoft SQL Server 2016: Clustered vs. Nonclustered Columnstore Indexes
After watching this video, you will be able to differentiate between clustered and nonclustered columnstore indexes in SQL Server 2016.
-
Microsoft SQL Server 2016: Creating a Nonclustered Columnstore Index
After watching this video, you will be able to create a nonclustered columnstore index.
-
Microsoft SQL Server 2016: Columnstore Versioned Feature Summary
After watching this video, you will be able to describe columnstore versioned feature summary.
-
Microsoft SQL Server 2016: Columnstore Indexes Query Performance
After watching this video, you will be able to improve columnstore index query performance.
-
Microsoft SQL Server 2016: Columnstore Indexes Defragmentation
After watching this video, you will be able to implement columnstore index defragmentation.
-
Microsoft SQL Server 2016: Columnstore for Real-time Operational Analytics
After watching this video, you will be able to implement real-time operational analytics.
-
Microsoft SQL Server 2016: Columnstore Indexes for Data Warehousing
After watching this video, you will be able to describe columnstore index data warehousing.
-
Microsoft SQL Server 2016: When to Implement a Columnstore Index
After watching this video, you will be able to determine when to implement a columnstore index.
-
Microsoft SQL Server 2016: Creating a Clustered Columnstore Index
After watching this video, you will be able to create a clustered columnstore index.
-
Microsoft SQL Server 2016: Create Indexes with Included Columns
After watching this video, you will be able to create an index with included columns.
-
Microsoft SQL Server 2016: Columnstore Index Overview
After watching this video, you will be able to recognize when to use columnstore indexes.
-
Microsoft SQL Server 2016: Columnstore Indexes Data Loading
After watching this video, you will be able to describe columnstore index data loading.
-
Microsoft SQL Server 2016: Creating Indexed Views
After watching this video, you will be able to create an indexed view.
-
Microsoft SQL Server 2016: Using Partitioned Views
After watching this video, you will be able to create partitioned views.
-
Microsoft SQL Server 2016: Renaming and Deleting a View
After watching this video, you will be able to rename and delete a view.
-
Microsoft SQL Server 2016: Modifying Views
After watching this video, you will be able to modify views.
-
Microsoft SQL Server 2016: Modifying Data Using a View
After watching this video, you will be able to modify data using a view.
-
Microsoft SQL Server 2016: Views
After watching this video, you will be able to describe the use of views.
-
Microsoft SQL Server 2016: Designing a View Structure
After watching this video, you will be able to recognize how to design and implement views.
-
Microsoft SQL Server 2016: Deleting Indexes
After watching this video, you will be able to delete indexes.
-
Microsoft SQL Server 2016: Modifying Indexes
After watching this video, you will be able to modify indexes.
-
Microsoft SQL Server 2016: Types of Views
After watching this video, you will be able to describe the various types of views.
-
Microsoft SQL Server 2016: Creating Views
After watching this video, you will be able to create views.
-
Microsoft SQL Server 2016: Creating Filtered Indexes
After watching this video, you will be able to create filtered indexes.
-
Microsoft SQL Server 2016: Creating Indexes with Included Columns
After watching this video, you will be able to create indexes with included columns.
-
Microsoft SQL Server 2016: Creating Nonclustered Indexes
After watching this video, you will be able to create nonclustered indexes.
-
Microsoft SQL Server 2016: Creating Unique Indexes
After watching this video, you will be able to create unique indexes.
-
Microsoft SQL Server 2016: Connecting to an Azure SQL Database
After watching this video, you will be able to demonstrate how to connect to an Azure SQL Server 2016 database
-
Microsoft SQL Server 2016: Troubleshooting Storage, IO, and Cache Issues
After watching this video, you will be able to troubleshoot storage, IO, and cache issues
-
Microsoft SQL Server 2016: Monitor Azure SQL Databases
After watching this video, you will be able to demonstrate how to monitor Azure SQL Database query plans
-
Microsoft SQL Server 2016: Data Collector
After watching this video, you will be able to describe the data collector service for monitoring SQL Server 2016 databases
-
Microsoft SQL Server 2016: Scheduling and Wait Statistics
After watching this video, you will be able to monitor and diagnose scheduling and wait statistics using dynamic management objects
-
Microsoft SQL Server 2016: Elastic Database Pools
After watching this video, you will be able to describe elastic database pools.
-
Microsoft SQL Server 2016: Extended Events Tasks
After watching this video, you will be able to describe extended events tasks.
-
Microsoft SQL Server 2016: Packages, Targets, Actions, and Sessions
After watching this video, you will be able to differentiate between extended events packages, targets, and sessions.
-
Microsoft SQL Server 2016: System Stored Procedures
After watching this video, you will be able to use system stored procedures for monitoring tasks.
-
Microsoft SQL Server 2016: SQL Server Extended Events
After watching this video, you will be able to describe the benefits of using extended events.
-
Microsoft SQL Server 2016: SQL Trace Architecture
After watching this video, you will be able to describe the SQL trace architecture.
-
Microsoft SQL Server 2016: Create a Trace
After watching this video, you will be able to create a trace using transact-sql.
-
Microsoft SQL Server 2016: Extended Events Targets
After watching this video, you will be able to distinguish between extended events targets.
-
Microsoft SQL Server 2016: Monitor Performance Using Monitoring Tools
After watching this video, you will be able to use various tools to monitor performance.
-
Microsoft SQL Server 2016: Optimize SQL Trace
After watching this video, you will be able to optimize SQL trace to minimize performance costs.
-
Microsoft SQL Server 2016: Schedule Traces
After watching this video, you will be able to demonstrate how to schedule tracing in SQL Server.
-
Microsoft SQL Server 2016: Performance Baseline
After watching this video, you will be able to establish a server performance baseline.
-
Microsoft SQL Server 2016: Performance Monitor
After watching this video, you will be able to demonstrate how to use perfmon.
-
Microsoft SQL Server 2016: Monitor Databases Using SQL Server Monitor
After watching this video, you will be able to demonstrate how to use the SQL Server Monitor
-
Microsoft SQL Server 2016: Performance Metrics
After watching this video, you will be able to describe performance metrics.
-
Microsoft SQL Server 2016: Dynamic Management Objects
After watching this video, you will be able to demonstrate how to use dynamic management objects.
-
Microsoft SQL Server 2016: Troubleshooting Performance Issues
After watching this video, you will be able to compare baseline metrics to observed metrics in order to troubleshoot performance issues.
-
Microsoft SQL Server 2016: Azure SQL Database Performance
After watching this video, you will be able to monitor Azure SQL Database performance.
-
Microsoft SQL Server 2016: Task Manager
After watching this video, you will be able to demonstrate how to use the task manager windows monitoring tool.
-
Microsoft SQL Server 2016: DBCC Commands
After watching this video, you will be able to demonstrate how execute database consistency checker commands.
-
Microsoft SQL Server 2016: Live Query Statistics
After watching this video, you will be able to demonstrate how to enable and view live query statistics.
-
Microsoft SQL Server 2016: Activity Monitor
After watching this video, you will be able to use the activity monitor in SQL Server 2016.
-
Microsoft SQL Server 2016: Performing a Piecemeal Restore
After watching this video, you will be able to restore a database using a piecemeal restore.
-
Microsoft SQL Server 2016: Restoring a Database with the Full Model Part 2
After watching this video, you will be able to restore a database under the full recovery model.
-
Microsoft SQL Server 2016: Auditing with Temporal Tables Part 2
After watching this video, you will be able to use temporal tables for auditing.
-
Microsoft SQL Server 2016: Implementing Row-level Security Part 2
After watching this video, you will be able to implement row-level security using T-SQ: and predicates.
-
Microsoft SQL Server 2016: Configuring the Management Data Warehouse
After watching this video, you will be able to enable and configure a management data warehouse for the data collector service
-
Microsoft SQL Server 2016: Enabling a Data Collector
After watching this video, you will be able to configure a data collection