|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-administration-part-4-projects/
课程评论：没有评论
课程名称：SQL SERVER 管理第四部分：项目 概述：在本课程中，学生将通过实际项目深入学习和应用 SQL Server 管理的概念。这些项目将涵盖创建数据库、定义表和列、设置数据类型和长度，以及编写查询以有效地与数据库进行交互。学生将学习如何插入数据，使用 Excel 表格作为数据来源，并通过创建图表和图形为管理层准备数据，从而实现有效的数据可视化。课程中将使用 SQL 脚本来管理数据库、实施安全措施和优化性能。此外，学生还将有机会与同伴合作，分享见解和共同解决问题，这样的经验与实际的数据库管理场景相似。 课程的一个关键重点是性能优化技巧。学生将学习为什么不推荐压缩数据库，因为这会导致碎片化并对性能产生不利影响。他们将探讨有效管理索引和数据碎片化的策略，包括定期维护任务，如重建和重新组织索引，以确保查询性能的高效。为了在本课程中取得成功，学生需要对 T-SQL 具有扎实的理解，并完成 SQL 管理第一部分的学习，因为这些基础技能对于处理更高级的话题至关重要。
In the SQL Server Administration Part 4 Projects course, students will engage in hands-on projects that reinforce their learning and application of SQL Server management concepts. These projects will involve creating databases, defining tables and columns, defining datatypes and lengths and writing queries to interact with the database effectively. Students will learn to insert data, use Excel worksheets as data sources, and prepare data for upper management by creating graphs and charts for effective data visualization. SQL scripts will be employed to manage databases, implement security measures, and optimize performance. Moreover, students will have the opportunity to collaborate with their peers, sharing insights and troubleshooting challenges together, which mirrors real-world database administration scenarios.A key focus of the course will be on performance optimization techniques. Students will learn why shrinking a database is generally not recommended, as it can lead to fragmentation and adversely affect performance. They will explore effective strategies for managing fragmentation of indexes and data, including regular maintenance tasks like rebuilding and reorganizing indexes to ensure efficient query performance. To succeed in this course, a solid understanding of T-SQL and completion of SQL Administration Part 1 are essential, as these foundational skills are crucial for tackling more advanced topics.
