32/26
Course 13: SQL Server 2019 Administration
Description The students who have taken our previous courses know that we like to go deep with all the technologies we work on and therefore to fulfill that need we develop courses in large series and this chain of courses help students to not only understand the technology itself but confidently implement it in their enterprise, prepare for and crack any interviews and also update their skills. This SQL series is comprising 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.
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: Set Windows Server 2019 network -Microsoft series courses we have developed so far. Simply because we don’t want to waste your time by creating the Source virtual machine, network adapters, router and other infrastructure again and again. We want to give you REAL-TIME Industry experience by integrating different technologies into one BIG NETWORK and it will allow students to apply computer and technology skills to learning and problem-solving. Now let us discuss the course outline in details.
This is SQL Fundamentals course for Beginners
This course is divided into 4 segments: Segment 1: Preparing 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 server 2019 on existing network which we created together in course 1: Set Windows Server Network -Microsoft Series – Installing 1st Instance of Single SQL Server 2019, SQL Server Management Studio 18 – Perform Remote Access and Create 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 required to understand all the terminologies related to databases for better administration of the product. 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 the commonly used database object
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 in 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 us perform Hands-on with loads and loads 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.
E- Move DB from single SQL Server 2019 into SQL Server 2019 file over cluster to achieve High Availability
Segment 4: SQL Server 2019 Failover Clustering Starting from Section 11 we will perform the following LABS A- Create domain service accounts B- Install 1st Failover Cluster Instance of SQL Server 2019 C- Install 2nd Failover Cluster Instance of SQL Server 2019 D- Test the reliability of SQL Server 2019 Failover Cluster. By finishing this course , you will be prepared and ready to take next Course 12: SQL Server 2019 on Linux & Azure. Who this course is for: The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.
