|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/10-things-every-production-sql-server-should-have/
课程评论：没有评论
课程名称：每个生产SQL Server应具备的10个要素 课程概述： 这门课程强调了每个在生产环境中使用的SQL Server所必需的10个要素，旨在帮助缺乏专业数据库管理员的组织建立基本的SQL Server环境。通过课程，学员可以学习数据库管理的关键方面，提升其在实际工作中的应用能力。 课程内容包括： 1. 开始时，我们将讨论每个SQL Server DBA工作中最重要的方面：备份。我们将介绍不同类型的备份以及最佳备份频率。 2. 演示还原过程，以帮助学员理解SQL Server如何备份数据库。 3. 强调完整备份的重要性及其在恢复过程中的意义。 4. 讨论一致性检查的必要性，以及它们应该被多频繁地执行。 5. 讲解统计信息和索引重建的过程及其重要性。 6. 最后，我们将介绍如何设置数据库邮件，以便在作业失败时接收警报。 这门入门级课程适合开发人员、网络管理员和数据库管理员，甚至对于管理DBA的人员也非常适用。课程采用现实世界的方法来建立生产环境中的SQL Server，且课程完全免费，鼓励大家立即注册。
Some recent reviews!!! "I can't thank Mike enough for providing such useful information without cost; the content in this course is invaluable." Ken"Thank you for the 10" David V"Great Course." David SThis course focuses on 10 things that every SQL Server in production should have.We will start with the single MOST important facet to every SQL Server DBAs job. Backups. We will cover the different kinds of backups and discuss how often we should be taking them. We will demo restores so WE understand the mechanics of how SQL Server backups up a database.We will talk about the importance of the FULL backup and what having it means to recovery.WE will cover consistency checks and talk about how often they should be run and why they should be run.WE will cover statistics and index REBUILDS and how and why we should use them.Lastly, WE will cover how to set up database MAIL so we can be alerted when OUR jobs fail.Many organizations don't have production DBAs so this course can assist them with setting up the very basic necessities for a production SQL Server.This is an entry level course and can be taken by developers, network administrators and database administrators. The course is even well suited for those who manage DBAs.The course is a real world approach to setting up your SQL Server in a production environment.The course if FREE so sign up now.
