16/42

Course 13: SQL Server 2019 Administration

Description Students who have taken our previous courses know that we like to delve into all the technologies we work on and 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 implement it with confidence in their company, prepare and pass any interview and also update their 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 and Failover Cluster. Course 12: SQL Server 2019 on Linux and Azure.

Why did we do this?

Course Syllabus: Before checking the course syllabus 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 Network – Microsoft Series, where we created the virtual environment for all the courses we have developed so far. Simply because we don’t want you to waste your time by repeatedly creating the source VM, network adapters, router and other infrastructure. We want to give you a REAL TIME industry experience by integrating different technologies in a LARGE NETWORK and will enable students to apply computer science and technology skills to learning and solving problems. Now let’s discuss the course outline in detail.

This SQL Fundamentals for Beginners course includes 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: – New features of SQL Server 2019 – Understanding the prerequisites to install SQL Server 2019 on an existing network that we created together in Course 1: Set up Windows Server 2019 Network – Microsoft Series – Installing the first instance of a single SQL Server 2019, SQL Server Management Studio 18 – Perform remote login and create snapshots. Segment 2: Get the Foundation for Advanced Topics From Section 5 to Section 9, this segment will teach you the fundamentals of database. As an administrator, you need to understand all the database terminologies for better administration of the product. We will learn the basics of the following topics: Module 1: “Introduction to Databases” introduces the key database concepts in the context of SQL Server 2019 Module 2: “Data Modeling” describes a variety of data modeling techniques.

Module 6: “Database Objects” introduces commonly used database objects

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. ** Expect to have some theories which might be a bit boring Segment 3: Let’s practice with lots of LABS Section 10 is very interesting because we have prepared LABS (project) for you to practice all the concepts we have learned together in Segment 2.

E- Move DB from single SQL Server 2019 server to SQL Server 2019 Failover Cluster to achieve high availability

Segment 4: SQL Server 2019 Failover Clustering Starting from Section 11, which will perform the following LABS A- Create domain service accounts B- Install the first SQL Server 2019 Failover Cluster instance C- Install the second SQL Server 2019 Failover Cluster instance D- Test the reliability of SQL Server 2019 Failover Cluster. After completing this course, you will be prepared and ready to follow the next Course 12: SQL Server 2019 on Linux and Azure. Who should read this course: The primary audience for this course is people who are entering a role in the database industry or whose role has expanded to include database technologies.