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

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

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

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

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

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

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

• 1. SQL Server Ecosystem and Editions
• 2. Installation and Configuration Essentials
• 3. Introduction to SQL Server Management Studio (SSMS)
• 4. Understanding Relational Database Concepts
• 5. First Steps with T-SQL: SELECT Statement Basics
• 6. Filtering Data with WHERE Clause
• 7. Sorting Results with ORDER BY
• 8. Grouping Data with GROUP BY and HAVING
• 9. Using Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
• 10. Working with Joins: INNER JOIN
• 11. LEFT and RIGHT OUTER JOINs
• 12. FULL OUTER JOIN and CROSS JOIN
• 13. Introduction to Subqueries
• 14. Correlated Subqueries
• 15. Common Table Expressions (CTEs) Basics
• 16. SET Operators: UNION, UNION ALL, INTERSECT, EXCEPT
• 17. Built-in String Functions
• 18. Built-in Date and Time Functions
• 19. Built-in Numeric Functions
• 20. Conditional Logic with CASE Expressions
• 21. INSERT Statements
• 22. UPDATE Statements
• 23. DELETE Statements
• 24. TRUNCATE TABLE vs. DELETE
• 25. MERGE Statement for Upserts
• 26. Introduction to Transactions
• 27. Transaction Isolation Levels
• 28. Error Handling with TRY...CATCH
• 29. Using @@IDENTITY, SCOPE_IDENTITY(), IDENT_CURRENT()
• 30. Output Clause for DML Statements
• 31. Creating and Managing Databases
• 32. Understanding Data Types and Their Best Use
• 33. Table Creation and Column Properties
• 34. Primary Keys and Unique Constraints
• 35. Foreign Keys and Referential Integrity
• 36. CHECK and DEFAULT Constraints
• 37. Creating and Managing Indexes: Clustered vs. Non-Clustered
• 38. Understanding Index Architecture and B-Trees
• 39. Views: Simple and Complex
• 40. Stored Procedures: Creation and Execution
• 41. User-Defined Functions (UDFs): Scalar and Table-Valued
• 42. Triggers: DML Triggers (AFTER, INSTEAD OF)
• 43. Schemas for Object Organization
• 44. Filegroups and Database Storage Optimization
• 45. Understanding Normalization Forms (1NF, 2NF, 3NF, BCNF)
• 46. Window Functions: ROW_NUMBER, RANK, DENSE_RANK, NTILE
• 47. Window Functions: LAG, LEAD, FIRST_VALUE, LAST_VALUE
• 48. PIVOT and UNPIVOT Operators
• 49. Dynamic SQL: Building Flexible Queries
• 50. Recursive CTEs for Hierarchical Data
• 51. Table Variables vs. Temporary Tables vs. #Temp Tables
• 52. Cursors: When and Why (and mostly when not to)
• 53. Working with XML Data: Basics
• 54. Working with JSON Data: Functions and Best Practices
• 55. Spatial Data Types and Functions
• 56. Understanding Execution Plans: Graphical and XML
• 57. Key Performance Indicators (KPIs) for SQL Server
• 58. Analyzing Wait Statistics (sys.dm_os_wait_stats)
• 59. Identifying and Resolving Blocking and Deadlocks
• 60. Index Tuning Strategies and Best Practices
• 61. Working with Statistics: Creation, Update, and Impact
• 62. Parameter Sniffing and Resolution Techniques
• 63. Covering Indexes and SARGability
• 64. Using DMVs for Performance Analysis (sys.dm_exec_query_stats, etc.)
• 65. Extended Events: Capturing and Analyzing Performance Data
• 66. SQL Server Profiler and Its Modern Alternatives
• 67. Monitoring I/O, CPU, and Memory Usage
• 68. TempDB Contention and Optimization
• 69. Query Hints: When to Use (and mostly when not to)
• 70. Database Scoping and Configuration for Performance
• 71. Database Backup Strategies: Full, Differential, Transaction Log
• 72. Restoring Databases: Point-in-Time Recovery
• 73. Recovery Models: Simple, Full, Bulk-Logged
• 74. Automating Tasks with SQL Server Agent Jobs
• 75. Database Maintenance Plans: Rebuild/Reorganize Indexes, Update Statistics
• 76. SQL Server Security Model: Principals, Securables, Permissions
• 77. Logins and Users: Windows Authentication vs. SQL Server Authentication
• 78. Server Roles and Database Roles (Fixed and Custom)
• 79. Granting, Denying, and Revoking Permissions
• 80. Row-Level Security (RLS)
• 81. Always Encrypted and Data Masking
• 82. SQL Server Audit for Compliance
• 83. Managing Database Mail for Notifications
• 84. Resource Governor: Managing Workloads
• 85. Monitoring SQL Server Health (Activity Monitor, Performance Monitor)
• 86. Understanding RTO and RPO
• 87. Log Shipping for Disaster Recovery
• 88. Database Mirroring (Legacy, but good to know)
• 89. Failover Cluster Instances (FCIs) Introduction
• 90. Always On Availability Groups (AGs): Architecture
• 91. Configuring and Managing Always On Availability Groups
• 92. Readable Secondaries and Offloading Workloads
• 93. Backup and Restore in an AG Environment
• 94. Disaster Recovery Planning and Testing
• 95. SQL Server on Azure VMs: High Availability Options
• 96. In-Memory OLTP (Hekaton) Tables and Stored Procedures
• 97. Columnstore Indexes for Analytics Workloads
• 98. Temporal Tables for Data Versioning
• 99. Graph Database Capabilities in SQL Server
• 100. PolyBase and External Tables for Data Virtualization