No products in the cart.
Overview
About this Course
This intensive 3-day course provides students with the knowledge and skills to design and develop AI enabled database solutions across Microsoft SQL platforms, including SQL Server, Azure SQL, and SQL databases in Microsoft Fabric. It is intended for professionals who build modern data solutions that integrate structured and semi structured data and incorporate AI features into scalable enterprise applications. It will also be valuable for individuals who develop applications that rely on SQL based data services enhanced with vector search, embeddings, and other AI driven capabilities.
Outline
Learning Path: Design and develop database solutions
Build database solutions across SQL Server, Azure SQL, and Microsoft Fabric. You learn to create well-structured database objects and indexes. You encapsulate business logic with stored procedures and functions. You write advanced T-SQL using techniques such as Common Table Expressions (CTE), window functions, and error handling. You also accelerate your development workflow with AI-assisted tools including GitHub Copilot and Fabric Copilot.
Lessons:
- Design and implement database objects with SQL
- Implement programmability objects with SQL
- Write advanced T-SQL code
- Implement SQL solutions by using AI-assisted tools
Exercises:
- Create and maintain database objects
- Implement programmability objects in SQL Server
- Work with JSON functions
- Configure AI-assisted tools for database development
Learning Path: Secure, optimize, and deploy database solutions
Take your database solutions from development to production. You learn to protect sensitive data with encryption, masking, and row-level security. You tune query performance using execution plans, Query Store, and dynamic management views. You automate deployments with CI/CD pipelines using SQL Database Projects. Finally, you expose your databases through REST and GraphQL APIs with Data API Builder.
Lessons:
- Implement data security and compliance with SQL
- Optimize database performance
- Implement CI/CD by using SQL Database Projects
- Integrate SQL solutions with Azure services
Exercises:
- Implement security features
- Optimize query performance
- Implement CI/CD by using SQL Database Projects
- Configure Data API Builder for a product catalog
Learning Path: Implement AI capabilities in database solutions
This learning path explores how to implement AI capabilities directly in Azure SQL Database. You learn to design intelligent search using full-text and vector search, integrate AI models and embeddings, and build Retrieval Augmented Generation (RAG) solutions entirely in T-SQL.
Lessons:
- Design and implement models and embeddings with SQL
- Design and implement intelligent search with SQL
- Design and implement RAG with SQL
Exercises:
- Generate and update embeddings in Azure SQL Database
- Implement intelligent search with full-text, vector, and hybrid queries
- Implement a RAG solution
Prerequisites
Before attending this course, students must have:
• Experience writing T-SQL code and developing databases in Microsoft SQL platforms.
• Plus, you need to be familiar with continuous integration and continuous deployment (CI/CD) practices in GitHub, AI-assisted development tools, and AI concepts, such as embeddings, vectors, and models
FAQ
What if I have to reschedule my class due to conflict?
Ten (10) business days’ notice is required to reschedule a class with no additional fees. Notify TOPTALENT LEARNING as soon as possible at 469-721-6100 or by written notification to info@toptalentlearning.com to avoid rescheduling penalties.
How do I enroll for this class?
Please contact our team at 469-721-6100; we will gladly guide you through the online purchasing process.
What happens once I purchase a class?
You will receive a receipt and an enrollment confirmation sent to the email you submitted at purchase. Your enrollment email will have instructions on how to access the class. Any additional questions our team is here to support you. Please call us at 469-721-6100.
What is your late policy?
If a student is 15 minutes late, they risk losing their seat to a standby student. If a student is 30 minutes late or more, they will need to reschedule. A no-show fee will apply. Retakes are enrolled on a stand-by basis. The student must supply previously issued courseware. Additional fees may apply.
What happens when I finish my class?
You will receive a ‘Certificate of Completion’ once you complete the class. If you purchased an exam voucher for the class, a team member from TOPTALENT LEARNING will reach out to discuss your readiness for the voucher and make arrangements to send it.