Course 11: SQL Server 2019 on Windows Server 2019 Series

Deep Dive into SQL Server 2019: Master Database Administration & High Availability

This comprehensive SQL Server 2019 series is designed for professionals seeking in-depth knowledge and practical skills. Building upon our established courses, this series empowers you to not only understand SQL Server 2019 but confidently implement it within your enterprise, excel in job interviews, and stay current with the latest technologies. This intensive training comprises over 30 hours across three courses.

Course Series Overview:

• Course 1: SQL Server 2019 on Windows Server 2019 & Failover Cluster
• Course 2: SQL Server 2019 on Linux & Azure
• Course 3: SQL Server 2019 Administration

Real-World Learning Environment:

We provide a pre-configured virtual environment, built upon the foundational network setup from our "Set Windows Server 2019 Network - Microsoft" course. This eliminates setup time and delivers real-time industry experience by integrating various technologies into a single, comprehensive network. This allows you to immediately apply your skills to practical problem-solving.

Course Outline: SQL Server 2019 Fundamentals for Beginners

This course blends theory and hands-on labs to provide a solid foundation in SQL Server 2019.

• Segment 1: Network Preparation & SQL Server 2019 Installation

  • Explore new features of SQL Server 2019.
  • Understand prerequisites for installing SQL Server 2019 within our pre-configured network (established in Course 1).
  • Install SQL Server 2019 and SQL Server Management Studio (SSMS) 18.
  • Learn to perform remote access and create snapshots.

• Segment 2: Database Fundamentals

  • Introduction to Databases: Key concepts in SQL Server 2019.
  • Data Modeling: Various data modeling techniques.
  • Normalization: Understand normalization and denormalization.
  • Relationships: Different types of relationships in database design.
  • Performance: How database design impacts performance.
  • Database Objects: Common database objects.
  • (Note: This segment includes theoretical content that may require focused attention.)

• Segment 3: Hands-on Labs & Projects

  • Practical application of concepts learned in Segment 2 through comprehensive labs and projects.

• Segment 4: SQL Server 2019 Failover Clustering

  • Create domain service accounts.
  • Install the first SQL Server 2019 failover cluster instance.
  • Install the second SQL Server 2019 failover cluster instance.
  • Test the reliability of the SQL Server 2019 failover cluster.
  • Migrate a database from a single SQL Server 2019 instance to the failover cluster for achieving high availability.

By the end of this course, you will be prepared to seamlessly transition to Course 2: SQL Server 2019 on Linux & Azure.

Key Skills You'll Gain:

• SQL Server 2019 installation and configuration
• Database design and normalization
• Database performance optimization
• Database object management
• SQL Server 2019 Failover Clustering
• High Availability solutions
• Practical database administration skills