Microsoft SQL Server 2019 Administration
- Caption
- Certificate
- Dedicated Tutors
- 41 Videos
- 6.24 Hours
- 75 Test Questions
Course Description
Microsoft SQL Server 2019 Administration
The Microsoft SQL Server 2019 Administration course is designed for IT professionals and database administrators who need to manage and maintain SQL Server 2019 environments. This course covers the essential aspects of SQL Server administration, including installation, configuration, security, performance tuning, and backup and recovery. Participants will gain hands-on experience with the tools and techniques required to ensure the smooth operation of SQL Server databases.Key Features:
- SQL Server Installation and Configuration: Learn how to install and configure SQL Server 2019, including setting up instances, configuring server and database settings, and optimizing initial setups for performance and security.
- Database Management: Explore methods for creating, managing, and maintaining databases, including database design principles, space management, and handling database growth.
- Security and Permissions: Understand SQL Server security features, including managing logins, roles, and permissions, as well as implementing encryption and auditing practices to protect data.
- Backup and Recovery: Gain skills in performing and managing backups and restores, including full, differential, and transaction log backups, as well as strategies for disaster recovery and data restoration.
- Performance Tuning: Discover techniques for monitoring and optimizing SQL Server performance, including indexing, query optimization, and resource management.
- High Availability and Disaster Recovery: Learn about high availability solutions such as Always On Availability Groups, failover clustering, and database mirroring to ensure business continuity and minimize downtime.
- Monitoring and Troubleshooting: Explore tools and methods for monitoring SQL Server health and performance, including using SQL Server Management Studio (SSMS) and dynamic management views (DMVs) for troubleshooting and resolving issues.
- Automation and Maintenance: Understand how to automate routine administrative tasks using SQL Server Agent, create maintenance plans, and schedule jobs for regular database upkeep.
- Integration and Data Migration: Learn about integrating SQL Server with other systems and performing data migrations, including using SQL Server Integration Services (SSIS) for ETL (Extract, Transform, Load) processes.
This course provides comprehensive training in SQL Server 2019 administration, equipping professionals with the knowledge and skills needed to effectively manage, secure, and optimize SQL Server environments.
Proudly Display Your Achievement
Upon completion of your training, you will receive a personalized certificate of completion to help validate your new skills.
Step-by-Step Courses List
Module 1: Installation
- SQL Admin Intro
- Installation
Module 2: Data Storage
- Introduction to Data Storage with SQL Server
- Managing Storage for System Databases
- Managing Storage for User Databases
- Moving Database Files
Module 3: Data Recover
- Intro to Data Recovery
- Understanding SQL Server Recovery Models
- Planning a Backup Strategy
- Backing up Databases and Transaction Logs
- Using SSMS For Backup
- Understanding the Restore Process
- How to Restore a Database
- Using SSMS For Restore
- T-SQL Backup and Restore
- Advanced Restore Scenarios
- Introduction to Transferring Data
- Importing and Exporting Table Data
- Copying or Moving a Database
Module 4: Monitoring
- Introduction to Monitoring SQL Server
- Dynamic Management Views and Functions
- Server Reports
- System Performance Monitor
- Tracing SQL Server Workload Activity
- Extended Events
- Database Tuning Advisor
Module 5: Security
- Introduction to SQL Server Security
- Managing Server-Level Security
- Managing Database-Level Security
- Row Level Security (RLS) Using Policies
- Database Security Tools
- Contained Database
- Auditing Data Access in SQL Server
- Implementing Transparent Data Encryption
Module 6: Maintenance
- Introduction to Maintenance
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
- Automating SQL Server Management
- Monitoring SQL Server Errors
- Configuring Database Mai
Reviews
You must be logged in to post a review.
What is Included
-
Professional Certification
Exam-focused prep and certification guidance aligned to your learning path.
-
ATS-Optimized Resume
Build a resume that highlights your new skills for recruiters and hiring systems.
-
Mock Interviews
Practice real interview scenarios with structured feedback from career coaches.
-
LinkedIn Optimization
Polish your profile so employers discover your credentials and achievements.
-
Job Placement Support
Career guidance and placement resources on eligible programs.
-
Practical Labs
Hands-on labs and exercises to reinforce concepts from your courses.
The course provided clear explanations and strong practical examples that helped me improve my Microsoft skills.
I liked the hands-on labs and real-world scenarios included in the lessons.
I liked the hands-on labs and real-world scenarios included in the lessons.
Excellent training with easy-to-follow modules and helpful demonstrations.
Great instructor-led content with practical exercises that made learning easier.
The course provided clear explanations and strong practical examples that helped me improve my Microsoft skills.
Very detailed and well-structured — perfect for certification preparation.
The course gave me hands-on skills in database design and analysis.
Detailed lessons and great support materials for exam preparation.
Excellent course with clear explanations and practical examples.
The course gave me hands-on skills in database design and analysis.
Detailed lessons and great support materials for exam preparation.