30/47

Course 13: SQL Server 2019 Administration

Description Students who have taken our previous courses know that we like to go deep into every technology we work on and hence to cater to this need we have developed courses in large series and this chain of courses helps students not only understand the technology itself but also implement it confidently in their company, prepare for and pass interviews and also refresh their skills. This SQL series consists 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 this?

Course Outline: Before checking out the course outline we would like to add a very important note that the network and infrastructure used in this course was created in our Course 1: Define 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 creating the source virtual machine, network adapters, router and other infrastructure over and over again. We want to give you REAL TIME industry experience of integrating different technologies into a LARGE NETWORK and this will enable students to apply computer and technology skills to learning and problem solving. Now, let’s discuss the course outline in detail.

This SQL Fundamentals for Beginners course comprises of both 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 about: – New features of SQL Server 2019 – Understanding the prerequisites to install SQL Server 2019 on the existing network that we created together in Course 1: Set up Windows Server 2019 Network – Microsoft Series – Installing the 1st instance of SQL Server 2019 Single, SQL Server Management Studio 18 – Performing remote access and creating snapshots. Segment 2: Get your basics to advanced topics From Section 5 to Section 9, this segment will teach you about the fundamentals of the database. As an administrator, it is necessary to understand all the terminologies related to databases for better administration of the product. We will learn the basic concepts 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 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 some theories that can be a bit boring Segment 3: Let’s do Hands-on with lots and lots of LABS Section 10 is very interesting because we have prepared LABS (Project) for you to practice all the concepts that we learned together in Segment 2.

After completing this course, you will be prepared and ready to take the next Course 12: SQL Server 2019 on Linux and Azure

Segment 4: SQL Server 2019 Failover Clustering Starting from Section 11, we will do the following LABS A- Create Domain Service Accounts B- Install 1st SQL Server 2019 Failover Cluster Instance C- Install 2nd SQL Server 2019 Failover Cluster Instance D- Test SQL Server 2019 Failover Cluster Reliability E- Move Database from Single SQL Server 2019 to SQL Server 2019 Failover Cluster for High Availability. Who this course is 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.