|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/azure-sql-dba-complete-crash-course-part1/
课程评论：没有评论
课程名称：AZURE SQL DBA 完全速成课程（第一部分） 课程概述：本课程专为 SQL Server 数据库管理员设计，旨在帮助他们熟练掌握 Microsoft Azure 的基础设施即服务（IaaS）和平台即服务（PaaS）技能。 课程内容（第一部分）： 1. 基础设施即服务模型概述 2. PaaS（平台即服务）模型简介 3. SaaS（软件即服务）模型解析 4. 单一数据库的定义 5. 数据库安全性（登录、用户和角色管理） 6. 备份保留策略 7. 从备份中恢复数据库 8. 从已删除数据库中恢复数据 9. 长期备份管理 10. 刷新非生产环境 11. DTU（数据库事务单位）使用情况的平均值、最小值和最大值 12. 弹性数据库简介 13. 弹性数据库中的成本节约 14. 外部表、弹性查询、跨查询与 Polybase 15. DTU 模型与 vCore 模型的比较 16. vCore 模型的种类 17. 无服务器数据库的概述 18. 高可用性与灾难恢复 - 可用性组 19. 高可用性与灾难恢复 - 地理复制 20. 高可用性与灾难恢复 - 数据同步 课程第二部分（将于近期发布，欢迎咨询更多信息）： 21. Azure 数据库的性能调优 22. Azure 成本计算器 23. Azure 混合福利 24. 预留资源选项 25. 读取扩展选项 26. DTU 计算器 27. 自动化方式（多种） 28. Windows 任务调度器 29. 本地 SQL Agent 30. 运行簿 31. 弹性作业 32. 基础设施与 PaaS 模型的区别 33. 单一数据库、弹性数据库与托管实例之间的区别 34. 管理实例 35. 存储账户创建 36. 存储密钥的重要性 37. Azure 存储资源管理器 38. 在线/URL 备份示例 39. 数据迁移方法 40. 数据迁移工具（主要用于评估） 41. 数据迁移服务（离线和在线） 42. Backpack 迁移 43. 事务复制 44. 手动迁移（架构脚本 + 导入和导出 / 关联服务器） 45. 向 Microsoft 提交问题单 46. Azure 中的死锁处理 47. 追踪标志 48. 数据范围设置（MAXDOP） 49. 锁管理 50. 报警设置 51. 恢复服务保险库 52. 成本分析 53. Azure 门户中的角色管理 54. 模拟面试 55. 简历准备 关于讲师：Rajasekhar Reddy Bolla，微软认证 SQL Server DBA/Azure DBA/架构师，拥有丰富的数据库工程师经验，擅长设计、开发、调优和维护企业数据库系统，热衷于学习和技术发展。 请联系讲师了解更多信息：Rajasekharreddyb.dba@gmail.com
This program has well designed and totally focused for SQL Server Database Administrators and to make them comfortably experts in Microsoft Azure (IaaS and PaaS)Part1: Below is the topic wise course content:1. What is Infrastructure as model?2. What is PASS model?3. What is SAAS model?4. What is single database?5. Security (logins& users& Roles)6. Backup retention?7. Restore DB's from backups8. Restore DB's from deleted databases9. Long term backups10. Refresh non- prod's11. AVG, MIN and MAX DTU usage?12. what is elastic databases?13. Cost saving in elastic databases?14. External Tables/ Elastic query/cross query/Polybase15. DTU vs vCore model16. vCore model types17. Server less Db's18. HA/DR - Availability Groups18. HA/DR - Geo-Replication19. HA/DR- Data syncPart2: (PART2 will publish Soon. Please reach me for more info)20. Performance Tuning in Azure DB's21. Azure Calculator22. Azure Hybrid Benefit23. Reservations24. Read-scale out option25. DTU Calculator26. Automation (how many ways)27. Windows Scheduler28. On premise SQL Agent29. Runbooks30. Elastic Jobs31. Difference between Infrastructure vs passmodel?32. Difference among single vs elastic vs managed instance?33. Infrastructure as a model34. Managed Instance35. Storage account creation36. Storage keys importance37. Azure Storage Explorer38. Online/URL backup example39. How many ways we can Migrate40. Data migration tool (Assessment mainly)41. Data Migration Service (Offline & Online)42. Backpack migration43. Transactional Replication44. Manual migration (schema script+ Import and export /Linked Server)45. Ticket raising with Microsoft46. Deadlocks in Azure47. Trace flags48. Data scoped settings (MAXDOP)49. Locks50. Alerts51. Recovery services vault52. Cost Analysis53. Roles in azure portal54. Mock Interview55. Resume PreparationThanks & RegardsRajasekhar Reddy BollaMicrosoft Certified SQL Server DBA/ Azure DBA/ Architect Thanks & RegardsRajasekhar Reddy BollaMicrosoft Certified SQL Server DBA/ Azure DBA/ Architect Rajasekharreddyb.dba@gmail.comAbout Myself:Started my career as a Database engineer and acquired skill over the technology well and could catch up a world class organization. I have very good track record in achieving and exceeding the targets and much interested in learning. Well experienced in designing, developing, tuning, and Maintaining Enterprise database systems for both OLTP and OLAP.. I independently handled activities in a immense environment by acting as a single point of contact for all concerns. Thus I believe so far my professional exp is a perfect blend to showcase my ability.
