.jpg){kind=logo}
SQL-SVR-2019.AP1.E0T
SQL Server 2019 Course
Self-paced · 1 year access
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 +
- 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
03 Introducing database server components 7 topics +
- Memory
- Central Processing Unit
- Storing your data
- Connecting to SQL Server over the network
- High availability concepts
- Securing SQL Server
- Understanding virtualization and containers
04 Designing and implementing an on-premises database infrastructure 8 topics +
- 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
05 Installing and configuring SQL Server instances and features 4 topics +
- What to do before installing SQL Server
- Installing a new instance
- Post-installation server configuration
- Post-installation configuration of other features
06 Installing and configuring SQL Server on Linux 5 topics +
- 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
07 Provisioning and configuring SQL Server databases 2 topics +
- Adding databases to a SQL Server instance
- Moving and removing databases
08 Understanding table features 5 topics +
- Reviewing table design
- Special table types
- Storing BLOBs
- Table partitioning
- Capturing modifications to data
09 Maintaining and monitoring SQL Server 9 topics +
- 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
10 Automating SQL Server administration 5 topics +
- 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
11 Developing, deploying, and managing data recovery 6 topics +
- Preparing for data recovery
- Understanding different types of backups
- Understanding backup devices
- Creating and verifying backups
- Restoring a database
- Defining a recovery strategy
12 Implementing high availability and disaster recovery 5 topics +
- 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
13 Administering security and permissions 4 topics +
- Authentication modes
- Security principals
- Permissions
- Common security administration tasks
14 Protecting data through encryption, privacy and auditing 5 topics +
- 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
15 Performance tuning SQL Server 4 topics +
- Understanding isolation levels and concurrency
- Understanding durability settings for performance
- Understanding how SQL Server executes your query
- Understanding advanced engine features for tuning queries
16 Understanding and designing indexes 6 topics +
- Designing clustered indexes
- Designing rowstore nonclustered indexes
- Understanding columnstore indexes
- Understanding indexing in memory-optimized tables
- Understanding index statistics
- Understanding other types of indexes
17 Designing and implementing hybrid and Azure database infrastructure 4 topics +
- Cloud computing and Microsoft Azure
- Cloud models and SQL Server
- Cloud security
- Other data services in Azure
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
Keep going
You might also like
Prepare for SQL Server 2019 Course
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.