|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-2022-administration/
课程评论：没有评论
课程名称：SQL Server 2022 管理 课程概述：SQL Server 2022 管理课程旨在为IT专业人员、数据分析师或任何需要管理SQL Server的人士提供知识。该课程涵盖了适用于超过85% SQL Server安装的基本配置、方法和最佳实践。讲师Mike Bennyhoff是一位经验丰富的SQL Server管理专业人士，曾为包括HP和劳斯莱斯在内的超过75个客户提供服务。课程的目标是使SQL Server系统在最短时间内变得更加稳健和高效，而不需要深入的数据库理论。 课程内容包括： 1. **引言** - SQL Server简介：SQL Server是什么 2. **设置** - SQL Server安装及配置 - 使用VMware连接SQL Server - 样本数据库 3. **绝对基本要素** - 备份：不同类型的备份、SQL恢复模式以及检查备份一致性 - 索引：索引类型、维护及重组索引的计划设置 - 统计信息：统计信息的重要性及维护方法 - 内存：如何设置和检查SQL Server中的内存设置 4. **设置和用户管理** - 并行性：成本阈值和最大并行度设置 - 用户管理：创建SA和DBO用户、禁用用户和管理用户角色 5. **数据库邮件与SQL警报** - 数据库邮件：设置和配置数据库邮件 - 操作员：设置电子邮件通知的操作员 - 数据库警报：为特定错误号码创建警报并进行测试 6. **任务和活动监视器** - 工作：使用SQL Server代理工作自动化任务、调度和监控 - 活动监视器：利用活动监视器跟踪服务器性能、识别瓶颈及终止被阻塞的进程 7. **性能仪表板** - 如何打开和查看性能仪表板 - 当前等待情况、磁盘和CPU使用情况 8. **SQL Server基础设施** - VMware和AWS上的SQL Server - SQL Server许可：如何许可SQL Server及相关费用 本课程适合希望高效管理SQL Server实例的专业人士，提供了实践导向的学习经验。
SQL Server 2022 Management is designed for IT professionals, data analysts, or anyone needing to manage SQL Server Thos course covers essential configurations, methods and best practices that apply to over 85% of SQL Server installations.Mike Bennyhoff is an experienced SQL Server administration professional with a history of assisting over 75 clients including HP and Rolls-Royce. I aim to make SQL Server systems more resilient and efficient without extensive database theory in the shortest time possible. IntroductionIntro to SQL Server: What is SQL Server.Setting UpSetup SQL Server Setup VMware Connecting To SQL ServerSQL Server Connection ManagerSample DB'sThe Absolute EssentialsBackups: Different types of backups, SQL recovery modes, and checking backup consistency.Indexes: Types of indexes, maintaining them, and setting up plans to reorganize indexes.Stats: Importance of statistics and how to maintain them.RAM: How to set and check RAM settings in SQL Server.Settings and User AdministrationParallelism: Cost threshold and max degree of parallelism settings.User Administration Creating SA and DBO users, disabling users, and managing user roles.SQL Mail and SQL AlertsDatabase Mail: Setting up and configuring database mail.Operators: Setting up operators for email notifications.Database Alerts: Creating alerts for specific error numbers and testing them.Jobs and Activity MonitorJobs: Automating tasks with SQL Server Agent jobs, scheduling, and monitoring.Activity Monitor: Using Activity Monitor to track server performance, identify bottlenecks, and kill blocked processes.Performance Dashbard How to Open and ViewWhat are current waits, Disk and CPU SQL Server On...VMware AWS (Amazon Web Services) SQL Server LicensingHow To License SQL Server + Costs
