46/40

Course 13: SQL Server 2019 Administration

Description Students who have completed our previous courses know that we like to dive into all the technologies we work on, so to meet this need, we develop courses in large series, and this chain of courses helps students not only understand the technology itself but also confidently implement it in their enterprise, prepare for and pass job interviews, and update their skills. This SQL series consists of 3 courses containing over 30 hours of intensive training. These are the following courses: Course 11: SQL Server 2019 on Windows Server 2019 and Failover Clustering. Course 12: SQL Server 2019 on Linux and Azure.

Why did we do this?

Course Outline: Before checking 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: Setting Up Windows Server 2019 Networking - Microsoft series, where we created a virtual environment for all the courses we have developed so far. Simply because we don’t want to waste your time in constantly creating Source VM, NICs, router and other infrastructure. We want to provide you with REAL TIME industry experience by integrating different technologies in ONE BIG NETWORK which will allow students to apply computer and technology skills in learning and solving problems. Now let's discuss the course outline in detail.

This SQL Fundamentals course for beginners consists of theory and LABORATORY EXERCISES

The 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 – Understand the prerequisites to install SQL server 2019 on the existing network that we have created together in Course 1: Set Up Windows Server 2019 Network - Microsoft Series – Installing 1st Single Instance of SQL Server 2019, SQL Server Management Studio 18 – Perform Remote Access and Create Snapshots. Segment 2: Lay Out the Basics for Advanced Topics From section 5 to section 9, this segment will teach you the basics of databases. As an administrator, you need to understand all the terminology related to databases to administer the product better. You 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 5: “Performance” describes how database design affects performance

Module 3: “Normalization” introduces the concept of normalization and describes normalization and denormalization techniques. Module 4: “Relationships” describes the different types of relationships and how they affect database design. Module 6: “Database Objects” introduces commonly used database objects. ** Expect some theory which might be a bit boring Segment 3: Let's do some hands-on with lots of LAB Section 10 is very interesting as we have prepared a LAB (project) for you so that you can practice all the concepts that we have learned together in Segment 2.

E- Migrate the database from a single SQL Server 2019 to a SQL Server 2019 Failover Cluster to achieve high availability

Segment 4: SQL Server 2019 Failover Cluster Starting from Section 11 we will do the following LAB A- Create Domain Service Accounts B- Install SQL Server 2019 Failover Cluster Instance 1 C- Install ster SQL Failover Cluster 2019 2 D- Test the reliability of SQL Server 2019 Failover Cluster. After completing this course, you will be prepared and ready to attend the next course 12: SQL Server 2019 on Linux and Azure. Who this course is intended for: The primary audience for this course is people who intend to start working in the database area or whose scope of responsibilities has been expanded to include database technologies.