Microsoft SQL Server 2019 Administration

28 Enrolled
7 hours

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.

What Will You Learn?

  • SQL Server installation and configuration on Windows or Linux
  • SQL Server service accounts and permissions
  • SQL Server database objects and data types
  • Transact-SQL (T-SQL) language and queries
  • SQL Server backup and restore strategies
  • SQL Server monitoring and troubleshooting tools
  • SQL Server security and auditing features
  • SQL Server database maintenance tasks and automation
  • SQL Server service principal names (SPNs) and clustering
  • SQL Server integration with big data and machine learning platforms


  • MCSA Windows Server


  • Security Analyst
  • Security Engineer
  • Security Consultant
  • Penetration Tester
  • Ethical Hacker
  • Cybersecurity Specialist

Course Content

Microsoft SQL Server 2019 Administration

  • Introduction to SQL Server
  • Introduction to SQL Server Instances
  • Introduction to SQL Server Authentications
  • Designing and Installing SQL Server 2019 Instance
  • Securing and Configuring SQL Server Instance
  • Monitoring and Managing SQL Server
  • Disaster Recovery SQL Server Databases
  • Troubleshooting SQL Server Connectivity and Plan to Azure SQL Databases
  • Plan to SQL Server Failover Cluster Instance FCI
  • Implement SQL Server Failover Cluster Instance FCI
  • Add Second Node to SQL FCI
  • Testing SQL FCI Failover
  • Plan to SQL Server 2019 AlwaysOn Cluster
  • Implement SQL Server 2019 AlwaysOn Cluster
  • Implement SQL Multi High Availability Layers and Disaster Recovery Site
  • SQL Server 2019 Migrations
  • Azure SQL Databases
  • Azure Elastic SQL Database


Moamen Hany

Moamen Hany

Business Development Manager / Senior Solutions Architect / Microsoft MVP / Microsoft MCT
230 Students
9 Courses

MBA, Microsoft MVP, Microsoft MCT, Digital Transformation Advisor, Business Development Manager, Senior Cloud Architect, Senior Infrastructure Consultant, Microsoft Partner, Author, Speaker, and Teacher.


With over +14 years of experience on Microsoft core infrastructure platforms and solutions, I am one of (the MVPs) in the Middle East & Africa in Azure Cloud, I have much better experience in Team leading and Training, and I have engaged in many large PostPre-Technical Microsoft & Cloud projects in Enterprises. Has several Information Technology Professional certifications from Microsoft, Redhat, ISACA, ITIL, EC-Council, and CompTIA. Has graduated from CairoNAWIA Information System and Management with a BS degree, Completed with Business education MBA in Project Management from, Asia University Malaysia (AEU) & International Business School of Scandinavia, has a lot of free learning tutorials in the Arabic Language since 2009 for the following vendors, Microsoft, REDHAT, ITIL, EC-Council. I currently act as Business Development Manager (Cloud & Infra) at Alnafitha IT

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?