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

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

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

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

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

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

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

• 1. What is SQL Server?
• 2. SQL Server Editions and Components
• 3. Installation of SQL Server and SSMS
• 4. SQL Server Architecture Overview
• 5. Connecting to SQL Server Instances
• 6. Introduction to Relational Databases
• 7. Tables, Columns, and Rows
• 8. SQL Server Data Types
• 9. Primary Keys and Unique Keys
• 10. Foreign Keys and Relationships
• 11. Creating and Managing Databases
• 12. Understanding Schemas
• 13. Creating Tables
• 14. Altering Table Structures
• 15. Dropping Tables
• 16. Identity Columns and Default Values
• 17. Inserting Data (INSERT Statement)
• 18. Updating Data (UPDATE Statement)
• 19. Deleting Data (DELETE Statement)
• 20. TRUNCATE TABLE vs. DELETE
• 21. Basic SELECT Statement
• 22. Filtering Data with WHERE Clause
• 23. Sorting Data with ORDER BY
• 24. Limiting Results (TOP, OFFSET/FETCH)
• 25. Using Aliases for Tables and Columns
• 26. INNER JOIN Explained
• 27. LEFT JOIN and RIGHT JOIN
• 28. FULL OUTER JOIN
• 29. CROSS JOIN and Self-Joins
• 30. Introduction to Subqueries
• 31. Correlated Subqueries
• 32. UNION, UNION ALL, INTERSECT, EXCEPT
• 33. Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
• 34. Grouping Data with GROUP BY
• 35. Filtering Groups with HAVING
• 36. NOT NULL Constraint
• 37. UNIQUE Constraint
• 38. CHECK Constraint
• 39. PRIMARY KEY Constraint Deep Dive
• 40. FOREIGN KEY Constraint Deep Dive
• 41. Variables and Parameters in T-SQL
• 42. Control Flow (IF, ELSE, BEGIN, END, WHILE)
• 43. Creating Stored Procedures
• 44. Executing Stored Procedures with Parameters
• 45. User-Defined Functions (Scalar and Table-Valued)
• 46. Creating and Modifying Views
• 47. Introduction to Triggers
• 48. AFTER and INSTEAD OF Triggers
• 49. Introduction to Indexes
• 50. Clustered Indexes
• 51. Non-Clustered Indexes
• 52. Index Architecture and B-Trees
• 53. Managing and Rebuilding Indexes
• 54. Index Fragmentation
• 55. Transactions and ACID Properties
• 56. BEGIN TRAN, COMMIT, ROLLBACK
• 57. Concurrency Control and Locking
• 58. Transaction Isolation Levels
• 59. Deadlocks and Resolution
• 60. SQL Server Logins and Authentication
• 61. Database Users and Schemas
• 62. Server Roles and Database Roles
• 63. Permissions Management (GRANT, DENY, REVOKE)
• 64. Data Encryption (TDE, Always Encrypted)
• 65. Recovery Models
• 66. Full Database Backups
• 67. Differential Backups
• 68. Transaction Log Backups
• 69. Database Restore Operations
• 70. Point-in-Time Recovery
• 71. Understanding Execution Plans
• 72. SQL Server Query Store
• 73. Dynamic Management Views (DMVs)
• 74. Extended Events for Monitoring
• 75. Monitoring CPU, Memory, I/O
• 76. Optimizing Queries
• 77. Database Engine Tuning Advisor
• 78. Introduction to High Availability and Disaster Recovery (HA/DR)
• 79. Log Shipping
• 80. AlwaysOn Failover Cluster Instances (FCI)
• 81. AlwaysOn Availability Groups: Basic Setup
• 82. AlwaysOn Availability Groups: Advanced Features
• 83. Failover and Disaster Recovery Planning
• 84. SQL Server Agent: Jobs and Schedules
• 85. SQL Server Agent: Alerts and Operators
• 86. Introduction to SQL Server Integration Services (SSIS)
• 87. Building Basic ETL with SSIS
• 88. Introduction to SQL Server Reporting Services (SSRS)
• 89. Creating Reports with SSRS
• 90. Common Table Expressions (CTEs)
• 91. Window Functions
• 92. Error Handling with TRY...CATCH
• 93. Dynamic SQL and SQL Injection Prevention
• 94. MERGE Statement
• 95. SQL Server on Azure: SQL Database and Managed Instance
• 96. Migrating and Managing Cloud Databases
• 97. SQL Server on Linux and Containers
• 98. DevOps Practices for SQL Server
• 99. Data Governance, Security, and Compliance
• 100. Performance Troubleshooting and Best Practices