43/47
Description
Students who have taken our previous courses know that we like to go deep with all the technologies we work on, and to meet this need we develop courses in large series and this series of courses helps students not only understand the technology itself, but also confidently. implement it in your business, prepare and crack the interview 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 2019 Administration.
Course outline:
Before reviewing the course outline, we would like to add a very important note, The network and infrastructure used in this course was created in our Course 1: Windows Server 2019 Network Setup – Microsoft Series, where we have 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 time creating a Source virtual machine, network adapters, router and other infrastructure over and over again. We want to provide you with REAL TIME industry experience by integrating various technologies into one BIG NETWORK and enable students to apply computer and technology skills to learning and problem solving.
Now let’s discuss the course outline in detail.
This is a SQL Basics course for beginners that consists of theories and LABS.
This course is divided into 4 parts:
Segment 1: Prepare your network to install SQL SERVER 2019 on Windows Server 2019
Starting with 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, which 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 take snapshots.
Segment 2 : Sort out the basics for advanced topics
From Section 5 to Section 9, this segment will teach you the basics of the database. As an administrator, it is necessary for him to understand all the terminologies related to databases for better administration of the product. 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 Modeling” describes a number 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 on database design.
Module 5: “Performance” describes the effects of database design on performance.
Module 6: “Database Objects” introduces a commonly used database object.
** Expect to have some theories that can be a bit boring
Segment 3: Let’s do some hands-on practice with lots and lots of LABS
Part 10 is very interesting because we have prepared a 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 1st fail over SQL Server 2019 cluster instance
C- Installation 2nd failure over SQL Server 2019 cluster instance
D- Test the reliability of SQL Server 2019 Fail over cluster.
E- Move DB from single SQL Server 2019 to SQL Server 2019 cluster for high availability.
After completing this course, you will be prepared and ready to take the next course 12: SQL Server 2019 on Linux & Azure.