فلش‌کارت‌های آموزشی SQL Server The Advanced Toolkit for SQL Server Evolution

📚 کتاب آموزشی جامع

📚 اطلاعات کتاب

عنوان کتاب: کتاب SQL Server The Advanced Toolkit for SQL Server Evolution

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

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

📋 سرفصل‌های کتاب (100 موضوع)

• 1. SQL Server Architecture: Deeper Dive into Components
• 2. Advanced Data Types and Storage Considerations
• 3. Advanced Constraints and Data Integrity Enforcement
• 4. Mastering Complex JOIN Operations
• 5. Subqueries and Correlated Subqueries: Performance Impact
• 6. Common Table Expressions (CTEs): Advanced Patterns and Recursion
• 7. Window Functions: Analytics, Ranking, and Aggregation
• 8. Pivoting and Unpivoting Data with T-SQL Techniques
• 9. Dynamic SQL: Secure and Efficient Implementation
• 10. Robust Error Handling with TRY...CATCH and THROW
• 11. Transaction Management and Isolation Levels Deep Dive
• 12. MERGE Statement: Advanced Use Cases and Pitfalls
• 13. Temporal Tables: System-Versioned Data Management
• 14. JSON Support: Storing, Querying, and Manipulating JSON Data
• 15. XML Functionality: Advanced Querying and Transformation
• 16. Graph Database Capabilities: Nodes, Edges, and Patterns
• 17. User-Defined Functions (UDFs): Performance and Best Practices
• 18. Stored Procedures: Advanced Design, Parameters, and Output
• 19. Triggers: INSTEAD OF and AFTER Triggers for Complex Scenarios
• 20. CLR Integration: Extending SQL Server Functionality
• 21. Understanding SQL Server's Storage Engine: Pages, Extents, Allocation
• 22. Indexing Strategies: Clustered, Non-Clustered, and Advanced Index Types
• 23. Filtered Indexes and Index Views for Specific Workloads
• 24. Columnstore Indexes: Rowstore vs. Columnstore for Analytics
• 25. In-Memory OLTP (Hekaton): Memory-Optimized Tables and Stored Procedures
• 26. Deep Dive into Query Execution Plans: Operators and Costs
• 27. Identifying and Resolving Query Performance Bottlenecks
• 28. Missing Index DMVs: Practical Application and Analysis
• 29. Statistics Management: Auto-Creation, Update, and Troubleshooting
• 30. Parameter Sniffing: Causes, Detection, and Mitigation Techniques
• 31. Deadlock Detection, Analysis, and Prevention Strategies
• 32. Blocking Scenarios: Identification and Resolution Methods
• 33. Concurrency Control Mechanisms: Locks, Latches, and Spinlocks
• 34. Wait Statistics: Diagnosing System-Wide Performance Issues
• 35. Resource Governor: Workload Management and Throttling
• 36. Data Compression: Row, Page, and Columnstore Compression
• 37. Table and Index Partitioning: Scalability and Management
• 38. Optimizing Large Data Loads and ETL Operations
• 39. TempDB Configuration and Performance Optimization
• 40. Filegroups and Data File Management Best Practices
• 41. I/O Subsystem Optimization for SQL Server Workloads
• 42. CPU and Memory Configuration for Optimal Performance
• 43. Database Scoped Configurations: Impact and Usage
• 44. Query Store: Performance Monitoring and Forced Plans
• 45. Automatic Tuning in Azure SQL Database (Conceptual Overview)
• 46. High Availability and Disaster Recovery (HADR) Concepts
• 47. Log Shipping: Implementation, Monitoring, and Failover Drills
• 48. Database Mirroring (Overview and Migration Path to Always On)
• 49. Always On Availability Groups: Architecture and Components
• 50. Configuring and Managing Always On Availability Groups
• 51. Availability Group Listeners: Client Connectivity and Failover
• 52. Readable Secondary Replicas for Offloading Read Workloads
• 53. Distributed Availability Groups: Multi-Data Center HADR
• 54. Troubleshooting Always On Availability Groups Issues
• 55. Disaster Recovery Planning: RPO, RTO, and Recovery Strategies
• 56. Advanced Backup and Restore: Partial, Filegroup, Page Restore
• 57. Point-in-Time Recovery and Transaction Log Backups
• 58. Database Snapshots for Reporting, Testing, and Rollback
• 59. Virtualization Best Practices for SQL Server Deployments
• 60. Hybrid HADR Solutions with Azure SQL Managed Instance/Database
• 61. Failover Cluster Instances (FCI): Shared Storage HADR
• 62. Choosing the Right HADR Solution for Business Needs
• 63. Authentication Mechanisms: Windows, SQL, Azure AD Integration
• 64. Authorization: Server Roles, Database Roles, Object Permissions
• 65. Schema Ownership and Principals for Granular Control
• 66. Row-Level Security (RLS): Implementing Data Access Policies
• 67. Dynamic Data Masking (DDM): Protecting Sensitive Data Display
• 68. Always Encrypted: Data at Rest, In Transit, and In Use Encryption
• 69. Transparent Data Encryption (TDE): Encrypting Database Files
• 70. SQL Server Auditing: Server and Database Level Audits
• 71. Vulnerability Assessment and Advanced Threat Protection
• 72. Certificates and Cryptography for Secure Communications
• 73. Endpoint Security and Network Configuration Best Practices
• 74. Best Practices for Securing a SQL Server Instance
• 75. SQL Server Agent: Advanced Job Scheduling and Management
• 76. Automating Routine Administrative Tasks with Agent Jobs
• 77. PowerShell for SQL Server Administration: dbatools Module
• 78. SQL Server Management Objects (SMO): Programmatic Administration
• 79. Performance Monitor (PerfMon) Counters for SQL Server Health
• 80. Extended Events: Deep Dive into Event Session Creation and Analysis
• 81. SQL Server Profiler vs. Extended Events: When to Use Which
• 82. Data Collector and Management Data Warehouse (MDW)
• 83. Policy-Based Management: Enforcing Configuration Standards
• 84. Central Management Servers: Managing Multiple Instances
• 85. Database Mail: Configuring and Using for Notifications
• 86. Monitoring Tools and Dashboards: Custom and Third-Party Solutions
• 87. SQL Server Integration Services (SSIS): Advanced ETL Patterns
• 88. Data Quality Services (DQS) and Master Data Services (MDS) Overview
• 89. Introduction to Azure SQL Database and Managed Instance Architectures
• 90. Strategies for Migrating On-Premises SQL to Azure SQL
• 91. Hybrid Cloud Scenarios: Extending On-Premises to Azure
• 92. PolyBase: Querying External Data Sources (Hadoop, Azure Blob, S3)
• 93. Machine Learning Services: R and Python Integration in SQL Server
• 94. SQL Server Big Data Clusters (Conceptual Overview for Data Lakes)
• 95. SQL Server Development Best Practices: Source Control Integration
• 96. Database DevOps: Continuous Integration and Continuous Delivery
• 97. Upgrading and Migrating SQL Server Versions: Planning and Execution
• 98. Advanced Troubleshooting Methodologies for SQL Server
• 99. The Evolving Landscape of SQL Server and Data Platform Technologies
• 100. Future Trends and Advanced Professional Development in SQL Server