Course 11: SQL Server 2019 on Windows Server 2019 Series

SQL Server 2019 installation with fail over clustering on Windows server 2019, Entry point for Database Administration

Created by: Dante Leo
MCT, CEI, Senior system engineer

What Will I Learn?

• Install SQL Server 2019 & SSMS 15 on Windows server 2019
• SQL 2019 Fail over cluster
• Key database concepts in the context of SQL Server 2019
• Data modelling techniques
• Normalization and denormalization techniques
• Relationship types and effects in database design
• Effects of database design on performance
• Commonly used database objects

Requirements

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Students might have to attend Course 1: Set Windows Server 2019 Network - Microsoft series, if you want to create the network from scratch.
• No technical experience is required.

Target audience

• The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.
• Individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
• The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.