fbpx

Microsoft SQL Server 2019 Administration

0.0
(0)
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

Requirements

  • MCSA Windows Server

Audience

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

Course Content

Microsoft SQL Server 2019 Administration

  • Introduction to SQL Server
    32:43
  • Introduction to SQL Server Instances
    09:40
  • Introduction to SQL Server Authentications
    10:56
  • Designing and Installing SQL Server 2019 Instance
    34:36
  • 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

Instructors

Moamen Hany

Moamen Hany

Business Development Manager / Senior Solutions Architect / Microsoft MVP / Microsoft MCT
0.0
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.

 
About

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?