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

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

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

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

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

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

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

• 1. Introduction to Relational Databases and SQL Server
• 2. Installing SQL Server and SQL Server Management Studio (SSMS)
• 3. Connecting to SQL Server and Exploring the Environment
• 4. Understanding Database Architecture and Components
• 5. Creating Your First Database and Tables
• 6. Fundamental SQL Server Data Types
• 7. Primary Keys, Foreign Keys, and Data Integrity
• 8. The SELECT Statement: Basic Data Retrieval
• 9. Filtering Data with the WHERE Clause
• 10. Sorting Results with ORDER BY
• 11. Limiting Result Sets: TOP, OFFSET-FETCH
• 12. Understanding NULL Values and IS NULL
• 13. Using Logical and Comparison Operators
• 14. Basic Aggregate Functions: COUNT, SUM, AVG, MIN, MAX
• 15. Grouping Data with GROUP BY
• 16. Filtering Grouped Data with HAVING
• 17. INNER JOIN: Combining Data from Multiple Tables
• 18. LEFT, RIGHT, and FULL OUTER JOINs
• 19. Self-Joins and Cross Joins
• 20. Understanding UNION, UNION ALL, INTERSECT, EXCEPT
• 21. Subqueries: Nested Query Techniques
• 22. Common Table Expressions (CTEs) for Readability
• 23. Inserting New Records into Tables
• 24. Updating Existing Data
• 25. Deleting Records from Tables
• 26. TRUNCATE TABLE vs. DELETE: Performance and Logging
• 27. The MERGE Statement: Upsert Operations
• 28. Using the OUTPUT Clause with DML Statements
• 29. Principles of Database Design and Normalization
• 30. Creating and Altering Tables (DDL)
• 31. Implementing CHECK and DEFAULT Constraints
• 32. UNIQUE Constraints and Unique Indexes
• 33. Identity Columns and Sequences for Auto-Incrementing Values
• 34. Schema Evolution: Managing Database Changes
• 35. Dropping Database Objects Safely
• 36. Window Functions: ROW_NUMBER, RANK, NTILE
• 37. Advanced Window Functions: LEAD, LAG, FIRST_VALUE, LAST_VALUE
• 38. Pivoting and Unpivoting Data for Analysis
• 39. Working with Dates and Times: Functions and Formatting
• 40. String Manipulation Functions
• 41. Numeric and Mathematical Functions
• 42. Data Conversion Functions: CAST and CONVERT
• 43. Conditional Logic with the CASE Expression
• 44. Dynamic SQL: When and How to Use It
• 45. Creating and Using Views to Simplify Queries
• 46. Stored Procedures: Encapsulating Business Logic
• 47. Parameters in Stored Procedures
• 48. User-Defined Functions (UDFs): Scalar and Table-Valued
• 49. Triggers: Automating Actions on Data Events
• 50. Error Handling with TRY...CATCH Blocks
• 51. SQL Server Agent: Scheduling and Automating Tasks
• 52. Understanding Cursors (and Alternatives)
• 53. Introduction to Indexes: Clustered vs. Non-Clustered
• 54. Designing Effective Indexes for Business Workloads
• 55. Understanding and Interpreting Execution Plans
• 56. Analyzing Query Performance with DMVs and DMFs
• 57. Statistics: Their Role in Query Optimization
• 58. Optimizing Complex JOINs and Subqueries
• 59. Best Practices for Writing High-Performance T-SQL
• 60. Monitoring Index Usage and Fragmentation
• 61. Using the Database Engine Tuning Advisor
• 62. Optimizing TempDB Usage
• 63. Transactions: ACID Properties and Control
• 64. Transaction Isolation Levels
• 65. Locking and Blocking: Concurrency Management
• 66. Deadlocks: Detection and Resolution Strategies
• 67. SQL Server Security Model: Authentication and Authorization
• 68. Creating and Managing Logins, Users, and Roles
• 69. Assigning Permissions to Database Objects
• 70. Auditing SQL Server Activity for Compliance
• 71. Introduction to High Availability and Disaster Recovery Concepts
• 72. Backup Strategies: Full, Differential, Transaction Log
• 73. Performing Database Backups and Restores
• 74. Point-in-Time Recovery and Data Loss Prevention
• 75. Log Shipping for Disaster Recovery
• 76. Always On Availability Groups: Advanced HA/DR
• 77. Introduction to ETL Concepts and Data Warehousing
• 78. Using SQL Server Integration Services (SSIS) for Basic ETL
• 79. Import/Export Data Wizard and BCP Utility
• 80. Linked Servers: Querying Data Across Instances
• 81. Change Data Capture (CDC) and Change Tracking
• 82. Introduction to Azure SQL Database and Managed Instance
• 83. Migrating On-Premises Databases to Azure SQL
• 84. Choosing the Right Azure SQL Deployment Option
• 85. Monitoring and Tuning Azure SQL Performance
• 86. Azure Synapse Analytics for Cloud Data Warehousing
• 87. Hybrid Cloud Solutions: On-Premises to Azure Connectivity
• 88. Azure Data Factory for Cloud-Scale ETL
• 89. In-Memory OLTP (Hekaton) for Performance Critical Workloads
• 90. Columnstore Indexes for Analytics and Data Warehousing
• 91. Working with JSON Data in SQL Server
• 92. Temporal Tables: Managing Data History Automatically
• 93. Graph Database Capabilities in SQL Server
• 94. SQL Server Machine Learning Services (R/Python Integration)
• 95. Resource Governance and Workload Management
• 96. Database DevOps: Principles and Practices
• 97. Source Control for Database Schemas
• 98. Automated Database Deployments and CI/CD
• 99. Performance Monitoring with Extended Events and Dashboards
• 100. Strategic Evolution of Your SQL Server Environment: A Business Perspective