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

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

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

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

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

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

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

• 1. SQL Server The Student Toolkit for SQL Server Evolution: سرفصل‌ها
• 2. SQL Server Overview and Introduction
• 3. Understanding Relational Databases and SQL
• 4. Installing and Configuring SQL Server
• 5. SQL Server Management Studio (SSMS) Basics
• 6. Connecting to SQL Server and Exploring the Interface
• 7. Database Architecture and Components
• 8. Creating and Managing Databases
• 9. Understanding Data Types in SQL Server
• 10. Creating Tables and Defining Columns
• 11. Working with Primary and Foreign Keys
• 12. Data Integrity: Constraints and Rules
• 13. Insert, Update, and Delete Operations (CRUD)
• 14. Selecting Data with the SELECT Statement
• 15. Filtering Data with WHERE Clause
• 16. Sorting Results with ORDER BY Clause
• 17. Using Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
• 18. Grouping Data with GROUP BY Clause
• 19. Joining Tables: INNER, LEFT, RIGHT, FULL OUTER
• 20. Working with Subqueries
• 21. Using Common Table Expressions (CTEs)
• 22. Working with NULL Values
• 23. String Manipulation Functions
• 24. Date and Time Functions
• 25. Mathematical Functions
• 26. Conversion Functions
• 27. Advanced SELECT Statements: CASE, DISTINCT, TOP
• 28. Introduction to Stored Procedures
• 29. Creating and Managing Stored Procedures
• 30. Stored Procedure Parameters and Return Values
• 31. Working with Triggers
• 32. Creating and Managing Triggers
• 33. Understanding Transactions and ACID Properties
• 34. Implementing Transactions in SQL Server
• 35. Error Handling in SQL Server: TRY-CATCH Blocks
• 36. Introduction to Views
• 37. Creating and Managing Views
• 38. Indexing: Understanding Indexes and Their Importance
• 39. Creating and Managing Indexes
• 40. Performance Tuning Basics: Indexing and Query Optimization
• 41. Query Optimization Techniques
• 42. Understanding Execution Plans
• 43. Introduction to SQL Server Security
• 44. User Authentication and Authorization
• 45. Managing Server Roles and Database Roles
• 46. Granting and Revoking Permissions
• 47. Introduction to SQL Server Agent
• 48. Scheduling Tasks with SQL Server Agent
• 49. Database Backup and Restore
• 50. Understanding Different Backup Types
• 51. Implementing Backup Strategies
• 52. Restoring Databases from Backups
• 53. Introduction to Database Replication
• 54. Configuring Database Replication
• 55. Monitoring SQL Server Performance
• 56. Identifying Performance Bottlenecks
• 57. Using SQL Profiler and Extended Events
• 58. Introduction to Database Design and Normalization
• 59. Understanding Normalization Principles (1NF, 2NF, 3NF)
• 60. Designing Relational Databases
• 61. Introduction to XML in SQL Server
• 62. Working with XML Data in SQL Server
• 63. Introduction to JSON in SQL Server
• 64. Working with JSON Data in SQL Server
• 65. Introduction to CLR Integration
• 66. Implementing CLR Assemblies
• 67. Introduction to Full-Text Search
• 68. Configuring and Using Full-Text Search
• 69. Working with FileTables
• 70. Introduction to Columnstore Indexes
• 71. Creating and Managing Columnstore Indexes
• 72. Introduction to Temporal Tables
• 73. Creating and Managing Temporal Tables
• 74. Introduction to PolyBase
• 75. Querying External Data Sources with PolyBase
• 76. Introduction to SQL Server Integration Services (SSIS)
• 77. Creating SSIS Packages
• 78. SSIS Control Flow and Data Flow
• 79. Working with SSIS Tasks and Transformations
• 80. Deploying and Managing SSIS Packages
• 81. Introduction to SQL Server Reporting Services (SSRS)
• 82. Creating SSRS Reports
• 83. Designing Report Layouts and Data Visualization
• 84. Deploying and Managing SSRS Reports
• 85. Introduction to SQL Server Analysis Services (SSAS)
• 86. Creating Cubes and Dimensions in SSAS
• 87. Working with MDX Queries
• 88. Introduction to Database Mirroring
• 89. Configuring Database Mirroring
• 90. Introduction to AlwaysOn Availability Groups
• 91. Configuring AlwaysOn Availability Groups
• 92. Database Maintenance Tasks
• 93. Monitoring and Troubleshooting SQL Server
• 94. Performance Monitoring Tools and Techniques
• 95. Troubleshooting Common SQL Server Issues
• 96. Security Best Practices
• 97. Backup and Recovery Strategies
• 98. Disaster Recovery Planning
• 99. High Availability and Failover Solutions
• 100. Scalability and Performance Optimization