|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/70-462-sql-server-database-administration-dba/
课程评论：没有评论
**Coursera 课程总结：70-462 SQL Server 数据库管理 (DBA)** **课程概述：** 本课程旨在提供 SQL Server 数据库管理的实用技能，帮助学习者增强简历、提升职业竞争力，并为微软官方认证做准备。尽管 70-462 考试已被微软撤销，但课程内容对 DBA 仍具高度相关性。 **核心内容：** 1. **SQL Server 免费下载与安装：** 学习者将免费获取功能强大的 SQL Server Developer 版本，该版本拥有企业版的全部功能（但不适用于商业目的）。 2. **数据库备份与恢复：** 掌握数据库的备份与还原操作，理解不同恢复模式的重要性，实现“时间点恢复”(Point in Time recovery)。 3. **用户与权限管理：** 管理登录名和服务器角色，精确控制数据访问权限。 4. **索引维护：** 理解并实施索引，以优化查询速度。 5. **数据导入导出：** 学习高效地导入和导出数据。 6. **SQL Server Agent 应用：** 学习如何自动化日常任务，并配置警报以应对潜在问题。 7. **数据库管理与配置：** 深入了解数据库的配置和管理，包括数据压缩技术，以优化大型数据库的性能。 8. **实践操作：** 课程强调动手实践，从手动备份到利用 SQL Server Agent 自动化备份，所有活动均可在单台计算机上完成，无需多服务器或虚拟化。 9. **循序渐进的学习：** 课程难度逐步提升，内容讲解细致，允许学习者在自己的电脑上同步操作。 10. **无 T-SQL 要求：** 课程主要通过图形用户界面 (GUI) 进行演示，无需 T-SQL 基础。但若目标是微软官方认证，则需要 T-SQL 知识。 11. **兼容性：** 课程录制于 SQL Server 2017，但对 2022、2019、2016、2014、2012 版本兼容性良好，对 2008R2 和 2008 版本也有较大程度的适用性。 **学习成果：** 完成课程后，学习者将获得成就证书，并具备扎实的数据库管理技能。课程时长约为 10 小时。
Please note: Microsoft has withdrawn the 70-462 exam. However, the information in this course is still relevant to DBA.Do you want to gain practical experience in Database Administration in SQL Server? Welcome.In this course, learn some of the skills that Microsoft want you to know, and add another tool to your CV or resume, and even go for the official Microsoft certification.Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.SQL Server is one of the main database tools that is requested in the job market, and the ability to being able to do DBA for SQL Server could be very useful for your current work, and your next job hunt.We'll download and install for free SQL Server Developer, which gives you all of the capabilities of the full-cost Enterprise edition (though without being able to use it for commercial purposes). We'll start by downloading a demonstration database, and learning how to backup and restore this database, and what recovery models are appropriate for other databases, to enable you to offer Point in Time recovery.We'll manage logins and server roles, so you can control who gets access to what data, implement and maintain indexes, so you can speed up searches, and import and export data. We'll look at managing SQL Server Agent, so you can automate routine tasks, and also be alerted to problems, we'll manage and configure databases, and look at compression, both of which aids with administrating big databases. And much more.The course will take around 10 hours to complete, but completing this will enable you to versed in Database Administration tasks, giving you hands-on experience.The course increases in difficulty slowly, so you'll manually backup a database, but then later we'll use SQL Server Agent to automate this. In this course, we will only do activities that require one computer, instead of multiple servers or virtualization.The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual DBA will be at a basic level, and I'll introduce every component as we go on.No knowledge of T-SQL is required, as I'll demonstrate everything I can through the GUI (Graphical User Interface) as well as T-SQL. However, if you are going to go for the official Microsoft exam, the equivalent knowledge as per my first two courses in 70-461 T-SQL is essential. At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and continue your preparations for the official Microsoft certifications.The course is recorded on SQL Server 2017, but will also work fully in 2022, 2019, 2016, 2014 and 2012, and mostly in 2008R2 and 2008.
