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

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

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

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

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

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

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

• 1. SQL Server The Foundation Toolkit for SQL Server Evolution: سرفصل‌ها
• 2. SQL Server Overview: Introduction and Architecture
• 3. SQL Server Installation and Configuration
• 4. SQL Server Management Studio (SSMS) Introduction
• 5. Connecting to SQL Server and Exploring the Interface
• 6. Databases and Their Components
• 7. Data Types in SQL Server
• 8. Creating and Managing Databases
• 9. Creating Tables: Defining Columns and Constraints
• 10. Understanding Primary Keys and Foreign Keys
• 11. Working with Identity Columns
• 12. Data Manipulation Language (DML): INSERT, UPDATE, DELETE
• 13. Data Query Language (DQL): SELECT Statements
• 14. Filtering Data with WHERE Clause
• 15. Sorting Data with ORDER BY Clause
• 16. Using Aggregate Functions: COUNT, SUM, AVG, MIN, MAX
• 17. Grouping Data with GROUP BY Clause
• 18. Joining Tables: INNER, LEFT, RIGHT, FULL OUTER
• 19. Working with NULL Values
• 20. Using Subqueries
• 21. Understanding Views
• 22. Creating and Managing Stored Procedures
• 23. Creating and Managing Functions (Scalar and Table-Valued)
• 24. Working with Triggers
• 25. Understanding Transactions and ACID Properties
• 26. Implementing Transaction Control: BEGIN TRANSACTION, COMMIT, ROLLBACK
• 27. Understanding Indexes: Clustered and Non-Clustered
• 28. Creating and Managing Indexes
• 29. Query Optimization and Execution Plans
• 30. Performance Tuning Basics
• 31. Security in SQL Server: Authentication and Authorization
• 32. Managing Users and Roles
• 33. Granting and Revoking Permissions
• 34. Backup and Restore Strategies
• 35. Understanding Backup Types: Full, Differential, Transaction Log
• 36. Performing Backup and Restore Operations
• 37. Database Maintenance Plans
• 38. Monitoring SQL Server Performance
• 39. Introduction to SQL Server Profiler
• 40. Introduction to SQL Server Extended Events
• 41. Introduction to SQL Server Agent
• 42. Creating and Scheduling Jobs
• 43. Introduction to Common Table Expressions (CTEs)
• 44. Working with Window Functions
• 45. Understanding Date and Time Functions
• 46. String Manipulation Functions
• 47. Mathematical Functions
• 48. Conversion Functions
• 49. Working with XML Data in SQL Server
• 50. Working with JSON Data in SQL Server
• 51. Understanding CLR Integration
• 52. Introduction to SQL Server Integration Services (SSIS)
• 53. Building Basic SSIS Packages
• 54. Working with Data Flow Tasks in SSIS
• 55. Working with Control Flow Tasks in SSIS
• 56. Deploying SSIS Packages
• 57. Introduction to SQL Server Reporting Services (SSRS)
• 58. Creating Basic Reports in SSRS
• 59. Working with Report Parameters
• 60. Report Design and Formatting
• 61. Understanding Parameterized Queries
• 62. Introduction to Database Design and Normalization
• 63. Understanding the Normal Forms (1NF, 2NF, 3NF, etc.)
• 64. Designing Efficient Database Schemas
• 65. Understanding Database Relationships
• 66. Working with Temporary Tables
• 67. Working with Table Variables
• 68. Understanding User-Defined Data Types
• 69. Introduction to Full-Text Search
• 70. Implementing Full-Text Search
• 71. Understanding SQL Server Replication
• 72. Configuring Transactional Replication
• 73. Configuring Snapshot Replication
• 74. Configuring Merge Replication
• 75. Introduction to Database Mirroring
• 76. Introduction to Always On Availability Groups
• 77. High Availability and Disaster Recovery Strategies
• 78. Working with Distributed Transactions
• 79. Introduction to Database Tuning Advisor
• 80. Analyzing Query Performance with Execution Plans
• 81. Identifying and Resolving Deadlocks
• 82. Optimizing Queries for Performance
• 83. Understanding Statistics in SQL Server
• 84. Creating and Updating Statistics
• 85. Introduction to the System Catalog Views
• 86. Querying System Catalog Views for Information
• 87. Monitoring Disk I/O Performance
• 88. Monitoring CPU Utilization
• 89. Monitoring Memory Usage
• 90. Introduction to Extended Events Profiling
• 91. Troubleshooting SQL Server Issues
• 92. Introduction to PowerShell for SQL Server
• 93. Automating Tasks with PowerShell
• 94. Understanding the SQL Server Service Broker
• 95. Working with Service Broker Queues and Dialogs
• 96. Performance Monitoring with Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs)
• 97. Introduction to Data Warehousing Concepts
• 98. Designing a Star Schema
• 99. Introduction to Columnstore Indexes
• 100. Implementing Columnstore Indexes