Microsoft SQL Server 2019 Database Administration Course Overview

To ensure that participants can successfully engage with the Microsoft SQL Server 2019 Database Administration course materials and derive the full benefit from the training, the following prerequisites are recommended:

• Basic understanding of database concepts, including relational databases.
• Familiarity with the Windows operating system and its core functionality.
• Experience with Transact-SQL (T-SQL), such as writing simple queries to retrieve data.
• Basic knowledge of core database administration tasks, such as creating databases and backing up data.
• An understanding of basic networking concepts, including TCP/IP and firewall configuration.

These prerequisites are intended to provide a foundation upon which the course will build. No previous experience with SQL Server is required, but familiarity with the concepts listed above will enable learners to grasp the course content more readily.

Target Audience for Microsoft SQL Server 2019 Database Administration

Learn to administer SQL Server 2019 databases, perfect for IT professionals seeking to enhance their database management skills.

• Database Administrators
• Systems Administrators managing SQL Server environments
• IT Professionals looking to upgrade their database skills to SQL Server 2019
• Data Analysts requiring knowledge of SQL Server infrastructure
• Technical Consultants implementing database solutions for clients
• SQL Server Developers seeking deeper understanding of the platform's administration
• IT Managers overseeing database operations teams
• Business Intelligence Professionals
• Data Architects designing and maintaining enterprise database systems
• Database Engineers looking to learn about new features in SQL Server 2019
• Professionals preparing for Microsoft certification exams in SQL Server

Learning Objectives - What you will Learn in this Microsoft SQL Server 2019 Database Administration?

Introduction to Learning Outcomes:

Gain expertise in SQL Server 2019 administration by mastering database infrastructure, ensuring security, performing maintenance, and optimizing performance through hands-on labs and expert instruction.

Learning Objectives and Outcomes:

• Understand SQL Server 2019 architecture, installation, and configuration to set up a robust database environment.
• Manage database storage effectively, including system and user databases, and implement buffer pool extensions.
• Perform database maintenance tasks ensuring database integrity and optimal performance.
• Implement and manage SQL Server security, including authentication, authorization, server roles, and user access controls.
• Design and execute a comprehensive backup strategy to safeguard data and ensure business continuity.
• Master the art of restoring SQL Server databases from backups, including point-in-time recovery and accelerated database recovery.
• Automate SQL Server management using SQL Server Agent for job scheduling and maintenance.
• Utilize Extended Events to monitor, troubleshoot, and optimize SQL Server performance.
• Improve database performance by analyzing query execution, using Query Store, and managing statistics.
• Transfer data efficiently using tools like the bulk copy program (bcp), BULK INSERT, and other data import/export techniques.