28/39
Course 13: SQL Server 2019 Administration
Description Students who have taken our previous courses know that we like to go deep into all the technologies we work on and so to meet that 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 company, prepare and pass any interviews and also update their skills. This SQL series is comprised of 3 courses containing over 30 hours of intensive training. These courses are as follows: 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 that?
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: Configure Windows Server 2019 Networking – Microsoft Series where we created the virtual environment for all the courses we have developed so far. Simply because we don’t want to waste your time in creating the source VM, network adapters, router and other infrastructure again and again. We want to give you REAL-TIME industry experience by integrating different technologies into a BIG NETWORK and it will enable students to apply computer and technology skills to learning and problem solving. Now let’s discuss the course outline in detail.
This is the SQL Fundamentals for Beginners course which consists 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 From Section 1 to Section 4, you will learn about: – New Features in SQL Server 2019 – Understanding the Prerequisites to Install SQL Server 2019 on the Existing Network that we created together in Course 1: Configure Windows Server 2019 Network – Microsoft Series – Installing First SQL Server 2019 Single Instance, SQL Server Management Studio 18 – Performing Remote Access and Creating Snapshots. Segment 2: Get Your Basics Sorted for Advanced Topics From Section 5 to Section 9, this segment will teach you about database fundamentals. As an administrator, it is necessary to understand all the database related terminology 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 6: ‘Database Objects’ introduces commonly used database objects
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 relationship and their effects on database design. Module 5: ‘Performance’ describes the effects of database design on performance.
Upon completion of this course, you will be prepared and ready to take the upcoming Course 12: SQL Server 2019 on Linux and Azure
** Expect some theories which might be a bit boring Segment 3: Let’s Do Some Practice with Lots and Lots of LABS Section 10 is very interesting because we have prepared LABS (Project) for you to practice all the concepts we learned together in Segment 2. Segment 4: SQL Server 2019 Failover Clustering Starting from Section 11, we will be doing the following LABS A- Create Domain Service Accounts B- Install First SQL Server 2019 Failover Cluster Instance C- Install Second SQL Server 2019 Failover Cluster Instance D- Test SQL Server 2019 Failover Cluster for Reliability E- Move Database from a Single SQL Server 2019 to SQL Server 2019 Failover Cluster for High Availability. Who is this course for: The primary audience for this course is individuals who are moving into a database role or whose role has expanded to include database technologies.
