|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/powershell-scripting-and-automation-for-sql-server-dba/
课程评论：没有评论
课程名称：PowerShell 脚本与 SQL Server DBA 自动化 课程概述：本课程旨在深入讲解 PowerShell，帮助学员能够轻松编写 PowerShell 脚本。课程分为 20 个模块，包括 HTML 课程，此外还有其他附加课程，作为本课程的子类别。学员将获得超过 100 个脚本的资料，课程结束后可以下载并进行实践。教学过程中将频繁上传视频，并提供电子邮件支持，解答学员的疑问。本课程的设计使得具备基本 DBA 知识的学员也能够在结课后，使用 PowerShell 为 SQL DBA 开发脚本。 课程内容涵盖了基础至高级的 PowerShell 脚本编写，具体包括常见的 DBA 日常任务，如备份、恢复、脚本编写数据库对象、在单个或多个服务器上创建和调度 SQL 作业，运行多服务器脚本，BCP 数据导入导出，以及使用任务调度器或 SQL Agent 调度脚本等。此外，还将学习如何使用配置文件传递参数、自定义模块的创建，以及编写脚本的标准方法。 课程还将介绍日志文件生成、服务器 Ping、使用单一配置文件传递多个参数、在脚本中创建函数、以颜色展示结果、在日志文件中添加时间戳、设置变量及注册信息级别等内容。 在监控与报告生成部分，学员将学习 SQL Server 的监控及使用电子邮件发送警报/通知，包括模板生成的 HTML 报告。监控内容包括数据库数据文件和日志文件空间、磁盘空间使用情况、CPU 或内存使用情况、长期运行的作业、阻塞、死锁等，此外还会创建备份状态报告和作业失败状态报告，并在服务故障时发送警报。 HTML 部分将包括基础知识、静态与动态 HTML 报告的创建、HTML 报告的定制及添加评论，以及如何使用 PowerShell 以 HTML 格式发送电子邮件。 云部分（将很快上传）将涵盖 Azure 云的基础知识以及如何为 Azure 云开发 PowerShell 脚本。 课程适合希望提升 PowerShell 脚本技能和 SQL Server 数据库管理自动化能力的学员。
In this course you will get in depth knowledge of PowerShell after that you will be able to develop the script using PowerShell easily.Basically, this course has been divided in to 20 sessions/Module which include the HTML Session, Evendu you will find the others additional session in this course, which will be the subcategory of the main course. For Sub-category you have to go through each Module.I am going to provide and discussed total 100+ script, you can download and start doing the practice after each session. I will be frequently uploading the video. For doubt clarification I will provide my email so that you can send me mail for any doubt.This course has designed in such a way that anyone having the basic knowledge of DBA, they can easily learn and develop the script using PowerShell for SQL DBA at the end of this course.In this session will cover that how to start writing the PowerShell script from basic to advance level. It will be going to include Daily DBA Task like - Backup, Restore, how to script the Database objects, creating and scheduling SQL Job in Single or Multiple servers. Running the script in multiple servers, BCP IN and BCP out, how to schedule the script using task scheduler or SQL Agent and many more things. How to pass the parameter using config file, creating own module ETC.Standard way of writing the script.1. Generating log file for any script.2. Ping the server.3. Passing multiple parameters using single configuration file.4. Creating function in script5. Displaying the result in color6. Adding the time stamp in log file.7. Setting the variable8. Registry level of informationMonitoring / Generating ReportIn this session we are going to work on SQL Server Monitoring Part and Generating and sending the alert/Notification using email in HTML body or as attachments. As per below screen shotThis report has been generated for Database file usage as HTML body. We are going to learn that how to generate the Health check report and monitoring the many things.a. Monitoring like Database data files and log file space.b. Disk space monitoring for single of multiple of servers.c. CPU or Ram usage monitoring.d. Long running job, Blocking, Deadlock etce. Creating report for Backup status.f. Job Failed status report.g. Sending the alert/Notification if any services will be down.· HTMLa. Basic of HTMLb. Static and Dynamic HTML Reportc. How customize the HTML report and adding some comment.d. Sending email in the format of HTML body using PowerShell.· Cloud (Going to be Uploaded very Soon)a. Basic of Azure Cloudb. How to develop the PowerShell scripts for AZURE cloud.
