17/48
Description Students who have taken our previous courses know that we like to go deeper into all the technology we work with, so to meet this need we develop a large series of courses, and this series of courses helps students not only understand the technology itself, but also implement it with the confidence that it is in your company, you prepare and pass interviews and update your skills. This SQL series consists of 3 courses with over 30 hours of intensive training. These courses are as follows: Course 11: SQL Server 2019 Windows Server 2019 & Failed through cluster. Course 12: SQL Server 2019 Linux & Azure. Course 13: SQL Server Administration 2019 Course Overview: 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: Windows Server 2019 Network Setup – Microsoft Series where we created a virtual environment for all the courses we have created so far. Why did we do it? Simply because we don’t want to waste your time creating the original virtual machine, network adapters, router and other infrastructure over and over again. We want to give you REAL TIME industry experience by integrating different technologies into one BIG NETWORK and this will allow students to apply their computer and technology skills to learning and problem solving. Now let’s discuss the course plan in detail. This is a Basic SQL course for beginners consisting of theory and LABS. This course is divided into 4 segments: Segment 1: Prepare your network for installing SQL SERVER 2019 Windows Server 2019 Starting with sections 1 to 4, you will learn about: – New features in SQL Server 2019 – Prerequisites for installing SQL. server 2019 on the existing network we created together in Course 1: Windows Server 2019 Network Setup – Microsoft Series – 1. Installing a single instance of SQL Server 2019 SQL Server Management studio 18 – Performing remote access and creating snapshots. Segment 2: Sort the basics by subject. From Section 5 to Section 9, this segment will teach you the basics of a database. In order to better administer the product, as an administrator you need to understand all the concepts related to databases. We will learn the basics of the following topics: Module 1: Introduction to Databases introduces basic database concepts in the context of SQL Server 2019. Module 2: “Data Modeling” describes a range 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 relationships and their impact on database design. Module 5: Performance describes the impact of database design on performance. Module 6: “Database Objects” presents the most commonly used database objects. ** Expect some theories that might be a bit boring. Segment 3: Let us do a practical LABS loading and unloading. Chapter 10 is very interesting because we have prepared a LABS (project) for you to practice all our ideas. studied together in segment 2. Segment 4: SQL Server 2019 clustering. Starting with Section 11, we will perform the following LABS A – Create a Domain Service Account B – Deploy Cluster 1 SQL Server 2019 Instance Cluster C – Deploy Cluster 2 SQL Server 2019 Instance D – Verify SQL Server 2019 cluster reliability. E. Migrate the DB from a single SQL Server 2019 to a SQL Server 2019 cluster for high availability. After completing this course you will be prepared and ready to attend the next course 12: SQL Server 2019 on Linux & Azure. Who is this course for: The primary audience for this course is people transitioning into a database role or whose role has expanded to include database technology.