28/16
Description
Students who have attended our previous courses know that we like to go deep into all the technologies we work on and so to fulfill this need we develop courses in large batches and this course chain helps students not only understand the technology itself but also confidently implement it in their company, prepare for and clear all the interviews and also update your skills.
This SQL series consists of 3 courses 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 Administration 2019.
Course overview:
Before checking the framework of the course, we would like to add a very important note, The network and infrastructure used in this course was created in our course 1: Setting up a Windows server 2019 network -Microsoft series, where we created a virtual environment for all the courses we have developed so far.
Why did we do it?
Simply because we don’t want to waste your time creating the original virtual machine, network adapters, router and other infrastructure over and over again. We want to provide you with REAL TIME industrial experience by integrating different technologies into one BIG NETWORK and this will enable students to apply computer and technology skills in learning and problem solving.
Let’s now consider the outline of the course in more detail.
This is a Basic SQL course for beginners consisting of theory 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 for installing SQL Server 2019 on an existing network that we created together in Course 1: Windows Server 2019 Network Setup – Microsoft Series
– Installation of the 1st instance of one SQL Server 2019, SQL Server Management studio 18
– Perform remote access and create snapshots.
Segment 2 : Sort out your basics for advanced topics
From Section 5 to Section 9, this segment will teach you about database basics. As an administrator, it is necessary to understand all terminology related to databases for better product administration. We will learn the basics of the following topics:
Module 1: ‘Introduction to Databases’ introduces key database concepts in the context of SQL Server 2019
Module 2: ‘Data Modelling’ describes a range of data modeling techniques.
Module 3: ‘Normalization’ introduces the concept of normalization and describes normalization and denormalization techniques.
Module 4: ‘Relationships’ describes the different types of relationships and their effects in database design.
Module 5: ‘Performance’ describes the effects of database design on performance.
Module 6: ‘Database Objects’ introduces a frequently used database object.
** Expect some theories that might be a bit boring
Segment 3: Let’s do Hands-on with a bunch of LABS
Section 10 is very interesting as we have prepared LABS (Project) for you to practice all the concepts we learned together in Segment 2.
Segment 4: SQL Server 2019 Fail over clustering
Starting with Section 11, we will perform the following LABS
A- Create domain service accounts
B- Install the 1st Fail over cluster instance of SQL Server 2019
C- Install the 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 to SQL server 2019 fail over cluster to achieve high availability.
By completing this course you will be prepared and ready for the next course 12: SQL Server 2019 on Linux & Azure.