فلش‌کارت‌های آموزشی SQL Server The Administrator's Toolkit for System Excellence

🎓 دوره آموزشی جامع

📚 اطلاعات دوره

عنوان دوره: دوره SQL Server The Administrator's Toolkit for System Excellence

موضوع کلی: برنامه نویسی

موضوع میانی: Microsoft SQL Server

📋 سرفصل‌های دوره

• 1. Introduction to SQL Server: What, Why, and Where
• 2. SQL Server Editions and Versions Overview
• 3. Planning a SQL Server Installation
• 4. Installing SQL Server: Step-by-Step Guide
• 5. Post-Installation Configuration and Best Practices
• 6. Navigating SQL Server Management Studio (SSMS)
• 7. Understanding SQL Server Services with Configuration Manager
• 8. Basic Server Properties and Instance Configuration
• 9. Relational Database Concepts Refresher for DBAs
• 10. System Databases: Master, Model, MSDB, TempDB, Resource
• 11. Creating and Managing User Databases
• 12. Files, Filegroups, and Transaction Logs Management
• 13. Understanding and Configuring Database Properties
• 14. Introduction to Tables, Views, and Stored Procedures (Admin View)
• 15. Managing Indexes: Creation, Rebuild, Reorganize (Admin View)
• 16. Understanding SQL Server Data Types
• 17. Schema Management and Ownership
• 18. Implementing Constraints: Primary Keys, Foreign Keys, Uniques
• 19. Advanced Database Options and Settings
• 20. Monitoring Database Growth and Disk Space Usage
• 21. The Dangers of Database Shrinking and Alternatives
• 22. Configuring and Using Database Mail
• 23. Introduction to SQL Server Agent and Automation
• 24. Creating and Managing SQL Server Agent Jobs
• 25. Scheduling Jobs and Understanding Job Steps
• 26. Implementing Alerts and Operators for Proactive Monitoring
• 27. Database Consistency Checks with DBCC CHECKDB
• 28. Managing tempdb: Configuration and Best Practices
• 29. Moving SQL Server Databases (Detach/Attach, Backup/Restore)
• 30. Understanding Database Snapshots
• 31. SQL Server Authentication Modes: Windows vs. SQL Server
• 32. Creating and Managing Logins and Users
• 33. Understanding Server Roles and Their Permissions
• 34. Managing Database Roles and Custom Roles
• 35. Granting, Denying, and Revoking Permissions on Securables
• 36. Principles of Least Privilege in SQL Server Security
• 37. Schema Ownership and Security Context
• 38. Introduction to Contained Databases
• 39. Implementing Transparent Data Encryption (TDE)
• 40. Column-Level Encryption for Sensitive Data
• 41. Configuring and Monitoring SQL Server Audit
• 42. Best Practices for SQL Server Security
• 43. Managing Certificates and Asymmetric Keys
• 44. Implementing Row-Level Security (RLS)
• 45. Using Dynamic Data Masking (DDM)
• 46. Understanding SQL Server Recovery Models (Full, Bulk-Logged, Simple)
• 47. Full Database Backups: Strategy and Execution
• 48. Differential Backups: Optimizing Backup Time
• 49. Transaction Log Backups: The Heart of Point-in-Time Recovery
• 50. Developing a Comprehensive Backup Strategy
• 51. Backup Compression and Encryption Options
• 52. Restoring a Full Database Backup
• 53. Point-in-Time Recovery Using Transaction Logs
• 54. Restoring Databases to a New Location or Instance
• 55. Tail-Log Backups: Preventing Data Loss During Failures
• 56. Partial Backups and Restores for Large Databases
• 57. Managing Backup Devices and Media Sets
• 58. Implementing a Robust Backup Testing Strategy
• 59. Automating Backups with SQL Server Agent
• 60. Monitoring and Alerting on Backup Status
• 61. Identifying Common Performance Bottlenecks
• 62. Using Activity Monitor for Real-time Performance Overview
• 63. Leveraging Performance Monitor (Perfmon) for SQL Server Metrics
• 64. Introduction to Dynamic Management Views (DMVs) and Functions (DMFs)
• 65. Mastering DMVs for Performance Analysis
• 66. Understanding and Using Query Store
• 67. Introduction to Extended Events for Advanced Monitoring
• 68. Configuring and Analyzing Extended Events Sessions
• 69. Basics of Reading SQL Server Execution Plans
• 70. Analyzing Wait Statistics for Performance Diagnosis
• 71. Optimizing CPU Usage and Memory Configuration
• 72. Disk I/O Performance and Storage Best Practices
• 73. Indexing Strategies for Performance Improvement
• 74. Managing and Maintaining Database Statistics
• 75. Troubleshooting Blocking and Deadlocks
• 76. Introduction to High Availability and Disaster Recovery Concepts
• 77. Implementing Log Shipping for DR
• 78. Understanding the Architecture of Always On Availability Groups (AGs)
• 79. Configuring an Always On Availability Group
• 80. Managing Availability Group Listeners
• 81. Performing Manual and Automatic Failovers in AGs
• 82. Understanding Always On Failover Cluster Instances (FCIs)
• 83. Setting Up an SQL Server Failover Cluster Instance
• 84. Introduction to SQL Server Replication (Snapshot, Transactional)
• 85. Developing a Comprehensive Disaster Recovery Plan
• 86. Defining Recovery Point Objective (RPO) and Recovery Time Objective (RTO)
• 87. Utilizing Azure SQL DB for Cloud-Based DR
• 88. Data Replication with Distributed Transaction Coordinator (MSDTC)
• 89. Cross-Region DR with Availability Groups
• 90. Best Practices for HA/DR Maintenance and Testing
• 91. Advanced SQL Server Agent Job Management
• 92. Custom Maintenance Scripts vs. Maintenance Plans
• 93. Automating Tasks with PowerShell for SQL Server
• 94. Using Central Management Servers for Multi-Instance Management
• 95. Setting up Database Health Check Automation
• 96. Troubleshooting Common SQL Server Issues
• 97. Upgrading and Patching SQL Server Instances
• 98. Strategies for Migrating SQL Server Databases
• 99. Introduction to Azure SQL Database and Managed Instance Administration
• 100. SQL Server on Linux: Key Differences for Administrators