|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-2019-administration-sql-server-part-1/
课程评论：没有评论
课程名称：《SQL Server 2019: 管理 SQL Server 第一部分》 课程概述： 本课程融合了我在Udemy平台上开设的两门课程，内容涵盖了SQL Server数据库的备份和恢复以及检测和修复数据库损坏的方法。课程分为两个部分。 第一部分主要讨论数据库的备份和恢复，包括如何简单地进行备份和恢复，备份日志和差异备份的重要性，并强调实施备份策略的必要性。学员将了解使用WITH INIT选项的备份技巧，以及如何使用WITH STOPAT选项进行时间点恢复。此外，还将介绍全恢复模式（FULL、SIMPLE和BULK LOGGED）在备份中的重要性。 第二部分内容较为深入，讨论了在多个文件上进行备份时的性能问题、使用CHECKSUM避免备份损坏的技巧、以及使用备份中的COPY ONLY选项来避免破坏备份链等内容。学员还将学习如何进行页面恢复或通过日志序列号（LSN）恢复，以减少服务器崩溃时的恢复时间。同时，课程会介绍尾日志备份（TAIL LOG BACKUP）来恢复未保存的日志、备份压缩以节约存储空间、以及使用WITH MIRROR选项进行备份的同时复制。 此外，课程还涵盖了如何恢复系统数据库（如Master、MSDB、model和TEMPDB）以及通过SNAPSHOT进行恢复的技巧和所需权限。 课程的第二章专注于SQL Server的损坏问题。数据库损坏在全球范围内是常见的，课程将帮助学员了解如何检测和修复大多数数据库损坏案例，包括如何配置SQL Server以自动检测输入/输出错误、执行一致性检查以及定期进行检查的DBCC命令。 本课程面向所有数据库管理员和开发人员，旨在提升他们应对数据库损坏的能力。学习SQL Server管理不仅能确保充足的就业机会，还能使学员在求职时脱颖而出，是值得投资的技能。
This course brings together two of my courses on the Udemy platform which are:SQL server: Detecting and repairing corruption on a databaseSQL server: The complete course about BACKUP and RESTORE. The first chapter will talk about BACKUP and RESTORE: How to make very simply a BACKUP and a RESTORE.Discuss the BACKUP LOGS and DIFFERENTIAL BACKUP, and why it is absolutely necessary to implement them in your BACKUP strategy.Understand the interest of the WITH INIT in a BACKUP, and learn how to make a restoration in time with the WITH STOPAT option.And finally, we will see the different full recovery model on a database(FULL,SIMPLE and BULKED LOGGUED), and why this is (very) important for our BACKUPs.The second part, which is longer, is the part of a more advanced level, we will discuss: The performance when doing a BACKUP on several files.Avoiding corruption on BACKUPs with the CHECKSUM, and understanding the importance of BACKUP WITH COPY ONLY, to avoid breaking the BACKUP chain during the day.To discover that you can make a RESTORE of a page, or from a LSN, to avoid losing hours of RESTORE, in case of server crash.Recover unsaved logs, in case of server crash, with the power of the TAIL LOG BACKUP.We will discuss the BACKUP WITH COMPRESSION, to save disk space, which can be significant, and the simultaneous copy of BACKUP with the WITH MIRROR option.We will also see how to restore system databases (Master, MSDB, model, TEMPDB).The RESTORE WITH STANDBY, which allows to examine the data between each RESTORE.And to finish, we will see how to make a RESTORE from a SNAPSHOT, see the necessary rights, to make BACKUP, how to consult BACKUP metadata.The second chapter will talk about corruption on SQL Server: Database corruption happens all the time, all over the world!! When it happens in your environment, do you know what to do? This 2-hour course will show you what you need to know to detect and repair most cases of database corruption. The course begins by explaining why early detection of corruption is so important, and then examines the different causes of database corruption. You will learn how to configure SQL Server to automatically detect when I/O errors occur.You'll learn how to configure SQL Server to automatically detect when I/O errors occur, what consistency checks are, the DBCC commands to use to perform consistency checks, and how to configure SQL Server to perform consistency checks regularly. This course is aimed at all database administrators and developers who will learn how to react to a case of corruption. Why start SQL administration? SQL Server is one of the skills very actively sought after on the job market.Administering an SQL server today is ensuring that you have a full-time job.Moreover, SQL Server, because of its simplicity, allows you to quickly become competent in very specific areas.Following this course will help you to stand out technically from your colleagues, or during a job interview, I guarantee it.
