This SQL Server 2019 course containing more than 30 Hours of intensive training. These courses are as follows:

Course 11: SQL Server 2019 on Windows Server 2019 & Fail over cluster.

Course 12: SQL Server 2019 on Linux & Azure.

Course 13: SQL Server 2019 Administration.

Now let us discuss the course outline in details.

This is SQL Server 2019 Fundamentals course for Beginners comprises of theories and LABS.

This course is divided into 4 segments:

Segment 1: Prepare your Network to install SQL SERVER 2019 on Windows server 2019

Starting from Section 1 to Section 4, you will learn about,

– New features of SQL server 2019

– Understanding the prerequisites to install SQL server 2019 on existing network which we created together in course 1: Set Windows server 2019 network -Microsoft series

– Installing 1st instance of single SQL server 2019, SQL Server Management studio 18

– Perform remote access and create snapshots.

Segment 2 : Get your basics sorted for advance topics

From Section 5 to Section 9, this segment will teach you about fundamentals of database. As an administrator it is required to understand all the terminologies related to databases
for better administration of the product. We will learn the basics of following topics:

Module 1: ‘Introduction to Databases’ introduces key database concepts in the context of SQL Server 2019

Module 2: ‘Data Modelling’ describes a number of data modelling techniques.

Module 3: ‘Normalization’ introduces the concept of normalization and describes normalization and denormalization techniques.

Module 4: ‘Relationships’ describes the different types of relationship and their effects in database design.

Module 5: ‘Performance’ describes the effects of database design on performance.

Module 6: ‘Database Objects’ introduces commonly used database object.

** Expect to have some theories which might be a bit boring

Segment 3: Let us perform Hands-on with loads and loads of LABS

Section 10 is very interesting because we have prepared LABS(Project) for you to practice all the concepts that we learned together in Segment 2.

Segment 4: SQL Server 2019 Fail over clustering

Starting from Section 11 we will perform the following LABS

A- Create domain service accounts

B- Install 1st Fail over cluster instance of SQL server 2019

C- Install 2nd Fail over cluster instance of SQL server 2019

D- Test the reliability of SQL Server 2019 Fail over cluster.

E- Move DB from single SQL server 2019 into SQL server 2019 fail over cluster to achieve High Availability.


Who this course is for:

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.

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.


======================================================
For Other free IT Tutorial Videos Visit youtube channel

https://www.youtube.com/@iteducationnetwork?sub_confirmation=1
======================================================

======================================================
For more information please visit our website

https://bluebytetechnologysolutions.com/
======================================================