|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-the-job-of-dba-on-sql-server-2019/
课程评论：没有评论
课程名称：完整的 SQL Server 2019 数据库管理课程 课程概述：本课程旨在让你学习如何构建一个强大、安全且可靠的数据库服务器！SQL Server DBA 是当今一个全职的、稳定的工作，备受各界追捧。本课程分为多个章节，每个章节都有特定的主题和实践。 第一章：通过讨论索引及其实现来介绍性能问题（3小时课程）。 第二章：深入学习 SQL Server 的备份与恢复的细节（2小时30分钟课程）。 第三章：以更高级的方式讲解 TSQL，包括分区函数（如 ROW_NUMBER 等）。 第四章：学习如何以最小数据丢失轻松且自动地检测数据损坏（3小时课程）。 第五章：了解创建和配置数据库时需避免的细微差别和陷阱（3小时课程）。 第六章：讨论系统数据库的用途以及约束（主键、外键等）的创建和作用。 第七章：了解在数据库上设置的不同隔离模式（如读取提交、未提交、可序列化等）。 第八章：发现触发器、同义词、序列以及表中的 IDENTITY。 第九章：详聊 SQL Server 2016 的新特性，如 RLS、DDM 和时间数据。 第十章：讨论安全性和权限管理的重要性，学习如何建立一个稳健和安全的 SQL Server（2小时课程）。 此外，课程结束时将进行一次虚拟面试，帮助准备未来的 SQL 面试，涵盖常见的面试问题，如主键、索引的定义、OLAP 与 OLTP 的区别等。 重要信息： 本课程覆盖所有 SQL Server 版本，包括 SQL Server 2019。在线课程总时长为17小时30分钟的演示和30分钟理论，且理论内容包含在课堂中，课程视频均不超过10分钟。参加本课程将帮助你在技术上脱颖而出，无论是与同事的比较还是在求职面试中。此外，完成本课程将显著提高你通过 Microsoft 认证的能力。我的其他课程平均评分为 4.4/5，保证了课程的质量。
Learn in this course, how to build a robust, secure and reliable database server! DBA SQL server is nowadays a full time assured job, it is an extremely sought after job in the working world.************ This course is broken down into several chapters *****************1st chapter: Let's talk about performance by discussing indexing and its implementation. (3 hrs of class).2nd chapter: This 2:30 chapter will teach you all the intricacies of BACKUP and RESTORE on SQL Server. (3 hrs of class).3rd chapter: Let's approach TSQL at a slightly more advanced level, through partitioning functions (ROW_NUMBER etc...).4th chapter: Find out how to easily and automatically detect corruption ,with minimum data loss. (3 hr course).5th chapter: Discover all the subtleties and pitfalls to avoid, when creating and configuring a database. (3 h of class).6th chapter: We will discuss the utility of System DBs, as well as the creation and utility of constraints (PK,FK etc...).7th chapter: We will see the different modes of isolation (READ COMMITED, UNCOMMITED, SERIALIZABLE...) that can be set up on a BDD.8th chapter: Discover triggers, synonyms, the sequences and the IDENTITY on your tables.9th chapter: A big chapter on what's new in SQL Server 2016. Such as RLS, DDM, and temporal data.10th chapter: Administration rhymes with precaution, and therefore of course with security. We will discuss security and privilege management during 2 hours. We will learn how to set up a robust and secure SQL server.******* And at the end of the course take a virtual interview to prepare for your future interview on SQL *******Start out more confident by tackling all these theoretical questions, so that you can face an interview on SQL.You go to an interview, you don't really know what to review beforehand, this is a summary of the most frequently asked questions.For example: What is a primary key ? what is an index? What is the difference between OLAP and OLTP ? Do you know the COALLESCE function ? or how do you remove duplicates with your query ?Courses that will arrive during the year 202110th chapter: Let's go together on SQL Azure!!!11th chapter: How to improve your performance on your stored procedures.12th chapter: Come and find out how to set up security on a SQL Server. (2 hr course).Important points about this course:This course covers all SQL Server versions, even SQL Server 2019.This online course is 17 hours 30 minutes of demo and 30 minutes of theory. The theory is in the classes, not in this course:)I made sure that the videos, were not too sappy, and that they were no longer than 10 minutes.Taking this course, will help you to stand out technically from your colleagues, or during a job interview.Taking this course will, greatly enable you to pass your Microsoft certifications. Look at the average of my other courses (4.4/5), and you will see that my courses are quality courses:)
