We provide course about SQL Server 2025: The 2-day Masterclass in english. SQL Server 2025 introduces some of the most significant advances in the platform´s history - from AI integration and vector search to enhanced performance, real-time streaming, and modern T-SQL.
Course description:
This 2-day, hands-on masterclass is built for professionals who want more than slides: every module pairs concept explanations with live demos and guided lab exercises so you leave with working knowledge, not just awareness. Across two intensive days, you will explore, experiment, and build - gaining the practical skills to make SQL Server 2025 work in your environment from day one.
Key takeaways:
• Hands-on experience running and testing new SQL Server 2025 features in a live lab environment
• Practical T-SQL patterns using new 2025 syntax - ready to use in production code
• Reusable lab scripts, demo queries, and reference guides to take back to your team
• Working knowledge of AI and vector search capabilities you can apply to your own data platform
• A clear upgrade and migration checklist tailored to your role and workload type
• Scenarios, decision frameworks, and guidelines to evaluate features for your specific context
Course outline:
Module 1 - Engine, Performance & Security:
• Optimized locking, ADR, IQP, Entra ID, encryption, distributed AGs, optimized failover, Azure Arc
Module 2 - T-SQL & Developer Features:
• JSON, regex, REST/HTTP integration, new T-SQL functions
Module 3 - AI & Vector Search:
• Built-in vector search, embeddings, semantic search, AI-driven app patterns
Module 4 - Data Engineering & Streaming:
• Change event streaming, real-time analytics, Microsoft Fabric integration, hybrid architectures
Module 5 - Migration & Roadmap:
• Upgrade paths, modernization strategies, best practices, aligning your roadmap
Instructor: Magi Naumova
Margarita Naumova is a very well-known SQL Expert. Magi holds the highest possible SQL Server Technical Certification in the field - Microsoft Certified Master, making her one of the best SQL Server Experts Worldwide. Magi is also a Microsoft Data Platform MVP (Most Valuable Professional). She has more than 20 years of SQL Server and BI technologies consulting and training experience and is a trusted advisor for many large companies in SQL Server Platform Area.
Currently she works as a Managing Partner and Chief SQL Architect of Inspir-it AS, her own newly established Consulting Company in Norway. Margarita is a regular speaker at the largest IT events, SQLBits, SQL Saturday in Europe.
Target audience:
Anyone who wants course about SQL Server 2025: The 2-day Masterclass
Prerequisites:
• Comfortable writing and reading T-SQL queries (SELECT, JOINs, aggregations, subqueries). Basic understanding of SQL Server objects: tables, indexes, stored procedures, views. Familiarity with SQL Server Management Studio (SSMS) or Azure Data Studio. Working knowledge of your primary role: developer, DBA, or data engineer.
Nice to have (not required):
• Experience with any version of SQL Server 2019 or 2022. Basic familiarity with Azure services or Microsoft Fabric. Exposure to JSON, REST APIs, or vector/embedding concepts.
Environment setup (provided pre-course):
• Lab environment access details will be distributed 5 business days before the course. Attendees will receive a pre-configured VM or container image with SQL Server 2025 Developer Edition. All lab scripts, datasets, and reference materials will be available in the course GitHub repository.
Language:
• English course material and english speaking instructor
Course material:
The course fee includes course documentation and labs. Lunch and refreshments for in class events only.