.jpg){kind=logo}
SQL-SVR-2019.AP1.0L0
SQL Server 2019 Lab
Self-paced · 1 year access
21 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
21 Interactive Lessons · 114 topics01 Introduction 1 topics +
- Acknowledgments
02 Getting started with SQL Server tools 8 topics · 1 LiveLab +
- SQL Server setup
- Tools and services installed with the SQL Server Database Engine
- Performance and reliability monitoring tools
- SQL Server Reporting Services
- SQL Server Management Studio (SSMS)
- Azure Data Studio
- SQL Server Data Tools
- A note on discontinued and deprecated features
1 LiveLab in this lesson — see the labs panel →
03 Introducing database server components 7 topics · 1 LiveLab +
- Memory
- Central Processing Unit
- Storing your data
- Connecting to SQL Server over the network
- High availability concepts
- Securing SQL Server
- Understanding virtualization and containers
1 LiveLab in this lesson — see the labs panel →
04 Designing and implementing an on-premises database infrastructure 8 topics · 1 LiveLab +
- Introduction to SQL Server database architecture
- Data files and filegroups
- Recording changes in the transaction log
- Table partitioning
- Compressing data
- Managing the temporary database
- Configuration settings
- Container orchestration with Kubernetes
1 LiveLab in this lesson — see the labs panel →
05 Installing and configuring SQL Server instances and features 4 topics · 2 LiveLab +
- What to do before installing SQL Server
- Installing a new instance
- Post-installation server configuration
- Post-installation configuration of other features
2 LiveLab in this lesson — see the labs panel →
06 Installing and configuring SQL Server on Linux 5 topics · 1 LiveLab +
- What is Linux?
- Considerations for installing SQL Server on Linux
- Installing SQL Server on Linux
- Configuring SQL Server for Linux
- Caveats of SQL Server on Linux
1 LiveLab in this lesson — see the labs panel →
07 Provisioning and configuring SQL Server databases 2 topics · 2 LiveLab +
- Adding databases to a SQL Server instance
- Moving and removing databases
2 LiveLab in this lesson — see the labs panel →
08 Understanding table features 5 topics · 1 LiveLab +
- Reviewing table design
- Special table types
- Storing BLOBs
- Table partitioning
- Capturing modifications to data
1 LiveLab in this lesson — see the labs panel →
09 Maintaining and monitoring SQL Server 9 topics · 2 LiveLab +
- Detecting, preventing, and responding to database corruption
- Maintaining indexes and statistics
- Managing database file sizes
- Monitoring activity by using DMOs
- Monitoring with the SQL Assessment API
- Utilizing extended events
- Capturing performance metrics with DMOs and Data Collectors
- Protecting important workloads by using Resource Governor
- Understanding the new servicing model
2 LiveLab in this lesson — see the labs panel →
10 Automating SQL Server administration 5 topics · 1 LiveLab +
- Components of SQL Server automated administration
- Maintaining SQL Server
- Using SQL Server Maintenance Plans
- Strategies for administering multiple SQL Servers
- Using PowerShell to automate SQL Server administration
1 LiveLab in this lesson — see the labs panel →
11 Developing, deploying, and managing data recovery 6 topics · 2 LiveLab +
- Preparing for data recovery
- Understanding different types of backups
- Understanding backup devices
- Creating and verifying backups
- Restoring a database
- Defining a recovery strategy
2 LiveLab in this lesson — see the labs panel →
12 Implementing high availability and disaster recovery 5 topics · 1 LiveLab +
- Overview of high availability and disaster recovery technologies in SQL Server
- Configuring failover cluster instances
- Designing availability groups solutions
- Configuring availability groups in SQL Server on Linux
- Administering availability groups
1 LiveLab in this lesson — see the labs panel →
13 Administering security and permissions 4 topics · 1 LiveLab +
- Authentication modes
- Security principals
- Permissions
- Common security administration tasks
1 LiveLab in this lesson — see the labs panel →
14 Protecting data through encryption, privacy and auditing 5 topics · 1 LiveLab +
- Privacy in the modern era
- Introducing security principles and protocols
- Protecting the data platform
- Auditing with SQL Server and Azure SQL Database
- Securing Azure infrastructure as a service
1 LiveLab in this lesson — see the labs panel →
15 Performance tuning SQL Server 4 topics · 1 LiveLab +
- Understanding isolation levels and concurrency
- Understanding durability settings for performance
- Understanding how SQL Server executes your query
- Understanding advanced engine features for tuning queries
1 LiveLab in this lesson — see the labs panel →
16 Understanding and designing indexes 6 topics · 3 LiveLab +
- Designing clustered indexes
- Designing rowstore nonclustered indexes
- Understanding columnstore indexes
- Understanding indexing in memory-optimized tables
- Understanding index statistics
- Understanding other types of indexes
3 LiveLab in this lesson — see the labs panel →
17 Designing and implementing hybrid and Azure database infrastructure 4 topics · 1 LiveLab +
- Cloud computing and Microsoft Azure
- Cloud models and SQL Server
- Cloud security
- Other data services in Azure
1 LiveLab in this lesson — see the labs panel →
18 Provisioning Azure SQL Database 6 topics +
- Provisioning a logical SQL server
- Provisioning a database in Azure SQL Database
- Provisioning an elastic pool
- Managing database space
- Security in Azure SQL Database
- Preparing Azure SQL Database for disaster recovery
19 Provisioning Azure SQL Database managed instance 10 topics +
- What is a Managed Instance?
- Creating a managed instance
- Establishing a connection
- Migrating data to managed instance
- Deleting a managed instance
- Network requirements for managed instances
- Managed Instance administration features
- Azure SQL Analytics
- Security of Managed Instance
- Data protection features
20 Migrating to SQL Server solutions in Azure 4 topics +
- Migration Services Options
- Common causes for migration failures
- Integration Runtime options for Migration Services
- Best Practices for security and resiliency during migration
21 Leveraging big data and machine learning 6 topics +
- A big data primer
- Introducing Big Data Clusters
- Deploying Big Data Clusters
- Benefits of PolyBase
- Operationalizing analytics with Machine Learning Server
- Launchpad service
Hands-On Labs Our edge
21 LiveLabs- Exporting Data with the Import/Export Wizard
- Installing the Failover Cluster Feature
- Designing Multiple Filegroups
- Installing SQL Server Analysis Services
- Installing SQL Server Integration Services
- Configuring SQL Server
- Creating a SQL Login
- Using the ALTER Command with the ROLLBACK IMMEDIATE Command
- Creating a Table
- Using CHECKDB
- Managing Resource Utilization Using Resource Governor
- Configuring Database Mail
- Creating a Differential Backup
- Creating a Full Database Backup
- Granting Permissions to Create Tables
- Creating a New Server Audit and Configuring a Server Audit Specification
- Optimizing Queries
- Creating a Non-Clustered Index
- Creating a Columnstore Index
- Configuring Full-Text Indexing
- Creating a Virtual Machine in Azure
Labs run in your browser — nothing to install.
Keep going
You might also like
Prepare for SQL Server 2019 Lab
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 21 LiveLab included
- Certificate of completion
No credit card required