About Course
Microsoft SQL Server 2019 Administration is a course that teaches you how to install, configure, manage, and maintain SQL Server 2019, the latest version of the popular relational database management system from Microsoft. SQL Server 2019 offers many new features and enhancements, such as improved performance, security, availability, scalability, and integration with big data and machine learning platforms. In this course, you will learn how to:
- Install and configure SQL Server 2019 on Windows or Linux
- Create and manage databases, tables, views, indexes, and other objects
- Use Transact-SQL (T-SQL) to query and manipulate data
- Implement backup and restore strategies to protect your data
- Monitor and troubleshoot SQL Server 2019 issues
- Secure and audit SQL Server 2019 access and data
- Perform database maintenance tasks such as checking integrity, rebuilding indexes, and updating statistics
- Automate SQL Server 2019 administration using alerts, notifications, and jobs
This course is designed for database administrators, developers, and anyone who wants to learn how to work with SQL Server 2019. It covers the essential skills and knowledge required for the Microsoft SQL Server certification exams.
Course Content
Microsoft SQL Server 2019 Administration
-
Introduction to SQL Server
32:42 -
Introduction to SQL Server Instances
09:41 -
Introduction to SQL Server Authentications
10:56 -
Designing and Installing SQL Server 2019 Instance
34:37 -
Securing and Configuring SQL Server Instance
16:03 -
Monitoring and Managing SQL Server
06:25 -
Disaster Recovery SQL Server Databases
21:27 -
Troubleshooting SQL Server Connectivity and Plan to Azure SQL Databases
14:45 -
Plan to SQL Server Failover Cluster Instance FCI
25:47 -
Implement SQL Server Failover Cluster Instance FCI
46:03 -
Add Second Node to SQL FCI
12:21 -
Testing SQL FCI Failover
15:04 -
Plan to SQL Server 2019 AlwaysOn Cluster
16:21 -
Implement SQL Server 2019 AlwaysOn Cluster
53:33 -
Implement SQL Multi High Availability Layers and Disaster Recovery Site
42:35 -
SQL Server 2019 Migrations
14:20 -
Azure SQL Databases
34:57 -
Azure Elastic SQL Database
12:26
Tags
No Review Yet