کتاب صوتی SQL Server The Strategic Toolkit for SQL Server Evolution

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

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

عنوان دوره: دوره SQL Server The Strategic Toolkit for SQL Server Evolution

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

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

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

• 1. Introduction to Databases and Relational Models
• 2. SQL Server Editions and Components
• 3. Installation and Configuration of SQL Server
• 4. SQL Server Management Studio (SSMS) Basics
• 5. Creating Databases and Filegroups
• 6. Understanding Data Types in SQL Server
• 7. Creating and Modifying Tables
• 8. Primary Keys, Foreign Keys, and Constraints
• 9. Basic INSERT Statements
• 10. Basic SELECT Statements
• 11. Filtering Data with WHERE Clause
• 12. Sorting Data with ORDER BY Clause
• 13. Updating Data with UPDATE Statements
• 14. Deleting Data with DELETE Statements
• 15. NULL Values and Three-Valued Logic
• 16. Joins: INNER JOIN
• 17. Joins: LEFT JOIN and RIGHT JOIN
• 18. Joins: FULL OUTER JOIN and CROSS JOIN
• 19. Subqueries: Scalar and Multi-Value
• 20. Correlated Subqueries
• 21. UNION, UNION ALL, INTERSECT, EXCEPT Operators
• 22. Grouping Data with GROUP BY
• 23. Filtering Groups with HAVING Clause
• 24. Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
• 25. Built-in String Functions
• 26. Built-in Numeric Functions
• 27. Built-in Date and Time Functions
• 28. CASE Expressions
• 29. COALESCE and NULLIF Functions
• 30. Common Table Expressions (CTEs)
• 31. Window Functions (RANK, ROW_NUMBER, NTILE, DENSE_RANK)
• 32. Window Functions (LAG, LEAD, FIRST_VALUE, LAST_VALUE)
• 33. PIVOT and UNPIVOT Operators
• 34. Stored Procedures: Basics and Creation
• 35. Stored Procedures: Input and Output Parameters
• 36. Stored Procedures: Error Handling (TRY...CATCH)
• 37. User-Defined Functions (UDFs): Scalar and Table-Valued
• 38. Triggers: DML Triggers (AFTER, INSTEAD OF)
• 39. Triggers: DDL Triggers
• 40. Views: Creating and Using
• 41. Indexed Views
• 42. Transactions and ACID Properties
• 43. Transaction Isolation Levels
• 44. Dynamic SQL
• 45. Cursors (and why to avoid them often)
• 46. Normalization Concepts (1NF, 2NF, 3NF, BCNF)
• 47. Denormalization Strategies
• 48. Understanding Indexes: Clustered vs. Non-Clustered
• 49. Creating and Managing Indexes
• 50. Included Columns in Non-Clustered Indexes
• 51. Filtered Indexes
• 52. Columnstore Indexes
• 53. Index Maintenance (Rebuild, Reorganize)
• 54. Statistics: Understanding and Managing
• 55. Data Compression
• 56. Execution Plans: Understanding and Interpreting
• 57. Identifying Performance Bottlenecks
• 58. SQL Server Profiler and Extended Events
• 59. Query Store for Performance Monitoring
• 60. Optimizing SELECT Statements
• 61. Optimizing INSERT, UPDATE, DELETE Statements
• 62. Analyzing Waits and Latches
• 63. Resource Governor
• 64. TempDB Optimization Strategies
• 65. Memory Management in SQL Server
• 66. SQL Server Security Model
• 67. Logins, Users, Roles, and Schemas
• 68. Granting and Revoking Permissions
• 69. Database Scopes and Server Scopes
• 70. Auditing in SQL Server
• 71. SQL Server Agent Jobs
• 72. Database Backups: Full, Differential, Transaction Log
• 73. Restoring Databases
• 74. Database Snapshots
• 75. Maintenance Plans
• 76. Data Definition Language (DDL) Commands
• 77. Data Control Language (DCL) Commands
• 78. Introduction to HA/DR Concepts
• 79. Log Shipping
• 80. Database Mirroring (Legacy, but good for understanding)
• 81. Always On Availability Groups: Concepts
• 82. Always On Availability Groups: Configuration
• 83. Failover Clustering Instances (FCI): Concepts
• 84. Replication: Snapshot, Transactional, Merge
• 85. Stretch Database
• 86. Data Masking and Always Encrypted
• 87. SQL Server Integration Services (SSIS) Introduction
• 88. SQL Server Analysis Services (SSAS) Introduction
• 89. SQL Server Reporting Services (SSRS) Introduction
• 90. Machine Learning Services with R and Python
• 91. Graph Databases in SQL Server
• 92. JSON Support in SQL Server
• 93. XML Support in SQL Server
• 94. Temporal Tables (System-Versioned Tables)
• 95. In-Memory OLTP (Hekaton)
• 96. Azure SQL Database: Concepts and Migration
• 97. Azure SQL Managed Instance: Concepts and Migration
• 98. PolyBase for Data Virtualization
• 99. DevOps for SQL Server Databases
• 100. Monitoring and Managing SQL Server Evolution