Skip to content

Latest commit

 

History

History
87 lines (74 loc) · 5.64 KB

README.md

File metadata and controls

87 lines (74 loc) · 5.64 KB

SQL Server 2025 Course

Index

Database Basics

  1. Creating_Database.sql - Create a new SQL Server database.
  2. Backup_Database.sql - Backup and restore database operations.

Administration & Maintenance

  1. SQL_Server_Agent_Jobs.sql - Automate tasks with SQL Server Agent jobs.
  2. Update_Text.sql - Update and manage text data.
  3. Replication_Basics.sql - Set up and manage database replication.
  4. OpenRowSet.sql - Query external data sources using OPENROWSET.
  5. Bulk_Insert.sql - Perform efficient bulk data loading.
  6. CLR.sql - Integrate .NET code with SQL Server CLR.
  7. Localization.sql - Localization and globalization features in SQL Server 2022.

Schema & Objects

  1. Indices_Part_1.sql - Introduction to index creation and usage.
  2. Stored_Procedures.sql - Create and use stored procedures.
  3. Functions.sql - User-defined functions examples.
  4. Triggers.sql - Implement triggers for automation.
  5. Views.sql - Create and use database views.
  6. Index_Walkthrough_1.sql - Index walkthrough part 1.
  7. Index_Walkthrough_2.sql - Index walkthrough part 2.

Data Modeling & Advanced Data Types

  1. Hierarchy_Data.sql - Work with hierarchical data structures.
  2. XML.sql - Store and query XML data.
  3. JSON.sql - Store and query JSON data.
  4. Graph.sql - Model and query graph data.
  5. Spatial_Data.sql - Use spatial data types and queries.

Querying & Scripting

  1. Match.sql - Pattern matching and search operations.
  2. Statements.sql - Common SQL statements and usage.
  3. Windowing_Functions.sql - Use window functions for analytics.
  4. Rank_Functions.sql - Ranking and row numbering functions.
  5. Time_Series.sql - Analyze and manage time series data.
  6. Advanced_Queries.sql - Advanced query techniques.
  7. Data_Import_Export.sql - Import and export data.
  8. Dynamic_SQL.sql - Generate and execute dynamic SQL.
  9. Error_Handling.sql - Error handling strategies in SQL.
  10. Temp_Tables.sql - Use temporary tables for intermediate results.
  11. CTE.sql - Common Table Expressions (CTE) usage.
  12. Pivot_Unpivot.sql - Pivot and unpivot data for reporting.

Performance & Optimization

  1. RLS.sql - Implement row-level security.
  2. Approx_Functions.sql - Use approximate query processing functions.
  3. Predicts.sql - Predictive functions in SQL Server.
  4. Full_Text_Search.sql - Full-text search capabilities.
  5. Performance_Tuning.sql - Performance tuning examples.
  6. JSON_Advanced.sql - Advanced JSON data handling.
  7. Isolation_Levels.sql - Transaction isolation levels.
  8. Graph_Database.sql - Advanced graph database features.
  9. Temporal_Tables.sql - Temporal tables for historical data tracking.
  10. Partitioning.sql - Table and index partitioning strategies.
  11. Query_Store.sql - Monitor and analyze queries with Query Store.

Security

  1. Security_1.sql - Security best practices (part 1).
  2. Security_2.sql - Security best practices (part 2).
  3. Always_Encrypted.sql - Protect sensitive data with Always Encrypted.
  4. Ledger.sql - Immutable data storage using SQL Server Ledger.

Transactions & Concurrency

  1. Transactions.sql - Transaction management examples.
  2. Concurrency.sql - Concurrency control techniques.
  3. Extended_Events.sql - Monitor and troubleshoot with Extended Events.
  4. In_Memory_OLTP.sql - In-Memory OLTP for high-performance workloads.
  5. Memory_Optimized_Tables.sql - Use memory-optimized tables.

Reference & Utilities

  1. Partitioning.sql - Additional partitioning examples.
  2. SET.md - Reference for SQL Server SET options and statements.

SQL Server 2025 New Features

  1. JSON_Native_Type.sql - Native JSON data type with binary storage, modify() method, and JSON aggregate functions.
  2. Regular_Expressions.sql - Complete regex support: REGEXP_LIKE, REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_INSTR, REGEXP_COUNT, REGEXP_MATCHES, REGEXP_SPLIT_TO_TABLE.
  3. External_REST_Endpoints.sql - Call REST/GraphQL endpoints with sp_invoke_external_rest_endpoint for Azure Functions, Event Hubs, and OpenAI integration.
  4. Change_Event_Streaming.sql - Stream incremental DML changes to Azure Event Hubs in real-time with CloudEvents format.
  5. Fuzzy_String_Matching.sql - EDIT_DISTANCE and EDIT_DISTANCE_SIMILARITY functions for approximate string matching and data deduplication.

New samples and scripts will be added soon.