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

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

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

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

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

📋 سرفصل‌های دوره (100 موضوع)

• 1. Introduction to Databases and SQL Server
• 2. Installing and Configuring SQL Server
• 3. SQL Server Management Studio (SSMS) Overview
• 4. Understanding Database Architecture
• 5. Creating Databases and Filegroups
• 6. SQL Server Data Types
• 7. Creating Tables and Defining Columns
• 8. Primary and Foreign Keys
• 9. Constraints: CHECK, UNIQUE, DEFAULT
• 10. Introduction to Indexes: Clustered vs. Non-Clustered
• 11. INSERT Statements for Data Entry
• 12. SELECT Statements: Basic Retrieval
• 13. WHERE Clause for Filtering Data
• 14. ORDER BY Clause for Sorting Results
• 15. NULL Values and Handling Them
• 16. UPDATE Statements for Data Modification
• 17. DELETE Statements for Removing Data
• 18. TRUNCATE TABLE vs. DELETE Statement
• 19. Understanding SQL Joins: INNER JOIN
• 20. LEFT JOIN and RIGHT JOIN
• 21. FULL OUTER JOIN and CROSS JOIN
• 22. Self-Joins and Complex Join Scenarios
• 23. UNION and UNION ALL Operators
• 24. Subqueries: Scalar and Multi-Row
• 25. Correlated Subqueries
• 26. Common Table Expressions (CTEs)
• 27. Derived Tables
• 28. EXISTS and NOT EXISTS Operators
• 29. GROUP BY Clause for Aggregation
• 30. HAVING Clause for Filtering Groups
• 31. Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
• 32. SQL Server Built-in Functions: String Manipulation
• 33. SQL Server Built-in Functions: Date and Time Handling
• 34. SQL Server Built-in Functions: Numeric and System Functions
• 35. CASE Expressions for Conditional Logic
• 36. PIVOT and UNPIVOT Operators
• 37. APPLY Operator: CROSS APPLY and OUTER APPLY
• 38. Views: Creating and Managing
• 39. Stored Procedures: Basic Creation and Execution
• 40. Stored Procedures: Parameters and Return Values
• 41. User-Defined Functions (UDFs): Scalar and Table-Valued
• 42. Triggers: DML Triggers for Automation
• 43. Transactions and Concurrency Control
• 44. Error Handling with TRY...CATCH
• 45. Dynamic SQL Best Practices and Security
• 46. Advanced Indexing Strategies
• 47. Index Maintenance: Rebuild vs. Reorganize
• 48. Statistics: Understanding and Management
• 49. Understanding Data Integrity and Consistency
• 50. Schemas and Database Security Basics
• 51. User and Role Management
• 52. Backup and Restore Strategies
• 53. SQL Server Agent Jobs for Automation
• 54. Data Import/Export Wizard
• 55. Bulk Insert and BCP Utility
• 56. Introduction to SQL Server Integration Services (SSIS)
• 57. SSIS: Data Flow Tasks for ETL
• 58. SSIS: Control Flow Tasks and Package Deployment
• 59. Introduction to Graph Databases in SQL Server
• 60. Introduction to Data Science Principles for SQL Professionals
• 61. Data Cleaning and Preprocessing Techniques in T-SQL
• 62. Feature Engineering using SQL Queries
• 63. Exploratory Data Analysis (EDA) with T-SQL
• 64. Descriptive Statistics Calculations in SQL Server
• 65. Basic Data Visualization Concepts for SQL Data
• 66. SQL Server Machine Learning Services: Overview
• 67. Installing and Configuring R and Python Services
• 68. Executing R Scripts in SQL Server (sp_execute_external_script)
• 69. Executing Python Scripts in SQL Server (sp_execute_external_script)
• 70. Data Exchange between SQL Server and External Languages
• 71. Training Machine Learning Models In-Database
• 72. Predicting/Scoring with ML Models in SQL Server
• 73. Deploying ML Models using Stored Procedures
• 74. PREDICT Function for Native Scoring
• 75. Introduction to PolyBase for External Data
• 76. Creating External Tables with PolyBase
• 77. Querying External Data Sources (Hadoop, Azure Blob Storage)
• 78. JSON Support: FOR JSON and OPENJSON
• 79. XML Data Type and Querying XML
• 80. Full-Text Search for Unstructured Data
• 81. Understanding Query Execution Plans
• 82. Analyzing Query Performance with SSMS
• 83. SQL Server Profiler and Extended Events
• 84. Index Tuning and Optimization Strategies
• 85. Database Engine Tuning Advisor
• 86. Optimizing JOINs and Subqueries
• 87. Performance Best Practices for Large Databases
• 88. Partitioning Tables and Indexes
• 89. Introduction to Columnstore Indexes
• 90. Clustered and Non-Clustered Columnstore Indexes
• 91. In-Memory OLTP (Hekaton): Concepts and Benefits
• 92. Creating Memory-Optimized Tables
• 93. Native Compiled Stored Procedures
• 94. Window Functions: ROW_NUMBER, RANK, DENSE_RANK, NTILE
• 95. Window Functions: LAG, LEAD, FIRST_VALUE, LAST_VALUE
• 96. Window Functions: Aggregate Functions with OVER
• 97. SQL Server in Azure: Azure SQL Database Overview
• 98. Azure Synapse Analytics: Data Warehousing for Data Science
• 99. Data Security and Compliance: Always Encrypted
• 100. Dynamic Data Masking and Row-Level Security