|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/course-11-sql-server-2019-on-windows-server-2019/
课程评论：没有评论
**课程名称：SQL Server 2019 on Windows Server 2019 系列课程（Course 11）** **课程概述：** 本系列课程旨在提供深入的技术培训，帮助学员掌握 SQL Server 2019 的企业级部署、应用和面试准备。本课程（Course 11）作为系列的第一部分，重点关注 SQL Server 2019 在 Windows Server 2019 环境下的安装、基础配置以及故障转移集群的实现。 **课程内容亮点：** * **实时企业级环境：** 课程基于之前《Set Windows server 2019 network - Microsoft series》课程中创建的虚拟网络环境，实现技术的整合，提供真实的行业实践经验。 * **SQL Server 2019 新特性：** 深入介绍 SQL Server 2019 的亮点和新增功能。 * **安装与基础配置：** 详细指导如何在现有网络环境中安装 SQL Server 2019 的第一个实例，以及 SQL Server Management Studio 18 的安装，并进行远程访问和快照创建。 * **数据库基础知识：** 涵盖数据库入门、数据建模、规范化、关系、性能以及数据库对象等核心概念，为后续高级主题打下坚实基础。 * **大量动手实验（LABS）：** 提供丰富的实验环节，让学员通过实践巩固所学知识。 * **故障转移集群（Failover Clustering）：** 重点讲解 SQL Server 2019 故障转移集群的搭建，包括创建域服务账户、安装第一个和第二个故障转移集群实例、测试集群可靠性，以及将数据库迁移到集群以实现高可用性。 **目标学员：** 希望深入学习 SQL Server 2019 在 Windows Server 环境下部署、管理和实现高可用性的初学者及有经验的 IT 专业人士。 **后续课程：** 完成本课程后，学员将为学习《Course 12: SQL Server 2019 on Linux & Azure》做好准备。
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 big 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.Course 13: SQL Server 2019 Administration.Course outline:Before checking the course outline we would like to add very important note, The Network and Infrastructure used in this course was created in our Course 1: Set Windows server 2019 network -Microsoft series, where we created the virtual environment for all the courses we have developed so far.Why we did that ?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 in 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 comprises of theories and LABS.This course is divided into 4 segments:Segment 1: Prepare your Network to install SQL SERVER 2019 on Windows server 2019Starting 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 existing network which we created together in course 1: Set Windows server 2019 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 advance topicsFrom Section 5 to Section 9, this segment will teach you about fundamentals of database. As an administrator it is required to understand all the terminologies related to databases for better administration of the product. We will learn the basics of following topics: Module 1: ‘Introduction to Databases' introduces key database concepts in the context of SQL Server 2019Module 2: ‘Data Modelling' describes a number of data modelling 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 in database design.Module 5: ‘Performance' describes the effects of database design on performance.Module 6: ‘Database Objects' introduces commonly used database object.** Expect to have some theories which might be a bit boring:(Segment 3: Let us perform Hands-on with loads and loads of LABSSection 10 is very interesting because we have prepared LABS(Project) for you to practice all the concepts that we learned together in Segment 2.Segment 4: SQL Server 2019 Fail over clustering Starting from Section 11 we will perform the following LABSA- Create domain service accountsB- Install 1st Fail over cluster instance of SQL server 2019C- Install 2nd Fail over cluster instance of SQL server 2019D- Test the reliability of SQL Server 2019 Fail over cluster.E- Move DB from single SQL server 2019 into SQL server 2019 fail over cluster to achieve High Availability.By finishing this course , you will be prepared and ready to take next Course 12: SQL Server 2019 on Linux & Azure.
