دوره SQL Server The Professional's Toolkit for SQL Server Evolution همراه با فلش‌کارت آموزشی — ارائه روی فلش مموری

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

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

عنوان دوره: دوره SQL Server The Professional's Toolkit for SQL Server Evolution

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

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

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

• 1. Course Introduction & SQL Server Ecosystem Overview
• 2. SQL Server Editions, Components & Installation
• 3. Working with SQL Server Management Studio (SSMS)
• 4. Introducing Azure Data Studio
• 5. Database Architectures: OLTP vs. OLAP
• 6. Database Objects: Schemas, Tables, Data Types
• 7. Creating & Modifying Database Objects (DDL)
• 8. Inserting, Updating, Deleting Data (DML)
• 9. Basic SELECT Statements & Filtering (WHERE)
• 10. Sorting and Limiting Results (ORDER BY, OFFSET-FETCH)
• 11. Aggregate Functions & Grouping (GROUP BY, HAVING)
• 12. Joins: INNER, LEFT, RIGHT, FULL OUTER
• 13. Subqueries & Derived Tables
• 14. Common Table Expressions (CTEs)
• 15. Views for Data Abstraction
• 16. Stored Procedures: Basics & Parameters
• 17. Stored Procedures: Output Parameters & Return Values
• 18. User-Defined Functions (UDFs): Scalar & Table-Valued
• 19. Control-of-Flow Statements (IF, WHILE, CASE)
• 20. Transactions, ACID Properties & Isolation Levels
• 21. Error Handling with TRY...CATCH
• 22. Dynamic SQL Techniques & Security Considerations
• 23. Triggers: Design & Implementation
• 24. Identity, Sequences & Global Unique Identifiers (GUIDs)
• 25. Constraints: Primary Key, Foreign Key, Unique, Check, Default
• 26. Window Functions (Ranking, Analytic)
• 27. Pivoting & Unpivoting Data
• 28. Working with XML Data
• 29. Working with JSON Data
• 30. Spatial Data & GIS Functions
• 31. Full-Text Search Implementation
• 32. Temporal Tables for Historical Data
• 33. Memory-Optimized Tables (In-Memory OLTP)
• 34. Graph Database Features in SQL Server
• 35. Change Data Capture (CDC) & Change Tracking (CT)
• 36. Relational Database Design Principles & Normalization
• 37. Denormalization Strategies
• 38. Understanding Index Architecture & Concepts
• 39. Clustered & Non-Clustered Indexes
• 40. Creating & Managing Indexes
• 41. Index Design Best Practices & Pitfalls
• 42. Covering Indexes & Included Columns
• 43. Filtered Indexes & Columnstore Indexes
• 44. Statistics: Understanding & Management
• 45. Index Maintenance: Rebuild vs. Reorganize
• 46. Query Optimization Basics & Bottleneck Identification
• 47. Interpreting Execution Plans
• 48. Analyzing Index Usage & Missing Indexes
• 49. Query Hints & Their Impact
• 50. Understanding Wait Statistics
• 51. Using Dynamic Management Views (DMVs) for Performance
• 52. Extended Events: Capturing Performance Data
• 53. SQL Server Profiler & Trace Replay
• 54. Resource Governor for Workload Management
• 55. Data Compression Strategies
• 56. Table & Index Partitioning
• 57. Optimizing Stored Procedures & Functions
• 58. Database Scoped Configurations
• 59. Best Practices for Ad-Hoc Query Performance
• 60. Query Store for Performance Monitoring
• 61. Database Recovery Models: FULL, BULK-LOGGED, SIMPLE
• 62. Backup Strategies: Full, Differential, Log Backups
• 63. Performing Backups & Restores
• 64. Point-in-Time Recovery
• 65. Database Integrity Checks (DBCC CHECKDB)
• 66. SQL Server Agent: Jobs, Schedules, Steps
• 67. Alerts, Operators & Notifications
• 68. Automating Routine Maintenance Tasks
• 69. Database Mail Configuration
• 70. Migrating & Upgrading SQL Server Instances
• 71. Authentication Modes: Windows & SQL Server
• 72. Logins, Users & Mappings
• 73. Server Roles & Database Roles
• 74. Permissions Management: GRANT, DENY, REVOKE
• 75. Best Practices for SQL Server Security
• 76. Row-Level Security (RLS)
• 77. Dynamic Data Masking (DDM)
• 78. Transparent Data Encryption (TDE)
• 79. Always Encrypted
• 80. Auditing SQL Server Activities
• 81. HA/DR Concepts & Business Requirements
• 82. Log Shipping for Disaster Recovery
• 83. Database Mirroring (Overview of Legacy Tech)
• 84. Failover Clustering Instances (FCI)
• 85. AlwaysOn Availability Groups (AGs) Architecture
• 86. Configuring & Managing AlwaysOn AGs
• 87. Read-Only Routing & Secondary Replicas Usage
• 88. Replication: Snapshot, Transactional, Merge (Overview)
• 89. Implementing Transactional Replication
• 90. Disaster Recovery Planning & Testing
• 91. SQL Server on Linux & Containerization (Docker)
• 92. Introduction to Azure SQL Database
• 93. Azure SQL Managed Instance
• 94. Azure SQL Database Elastic Pools
• 95. Data Warehousing & ETL Concepts
• 96. PolyBase for Data Virtualization
• 97. Machine Learning Services with R & Python
• 98. DevOps for SQL Server: CI/CD Principles
• 99. Leveraging PowerShell for SQL Server Automation
• 100. Continuous Learning & Future Trends in SQL Server