DP-800 Training Course: Designing and Developing AI-Enriched SQL Database Solutions
Key information
Upcoming sessions
Would you like to schedule this training on a specific date? Contact us by email or via the contact form.
Description of the training: DP-800 Training Course: Designing and Developing AI-Enriched SQL Database Solutions
The DP-800 training course prepares technical teams to design, develop and operate modern SQL databases, enriched by the latest advances in artificial intelligence. It covers the Microsoft SQL Server, Azure SQL Database and SQL in Microsoft Fabric platforms, with a focus on the new vector services, semantic search and the integration of AI assistants within data workflows.
Through guided workshops, participants learn to model a robust schema, optimise T-SQL queries, secure data access, and integrate AI features (embeddings, vector search, copiloting). The course is aimed at SQL developers, DBAs, data engineers and architects who want to professionalise their SQL databases and prepare for the official Microsoft DP-800 exam.
To go further on these topics, also discover our Artificial Intelligence training catalogue and our Databases & BI training courses.
Good to know
Our sessions are guaranteed from a single registrant, with no risk of postponement (except in cases of force majeure). A preliminary interview is held with the participant and/or a company representative. It helps to define the participant’s profile: level, needs, context and challenges.
Assessment: the trainer tracks progress through quizzes, practical scenarios and hands-on exercises. Participants receive a certificate of achievement at the end of the course.
This course is part of our Artificial Intelligence training catalogue — discover our other AI courses to fully harness the potential of machine learning, LLMs and generative AI. It is also part of our Databases & BI training courses, to model, exploit and add value to your business data.
Objectives of the training: DP-800 Training Course: Designing and Developing AI-Enriched SQL Database Solutions
- Identify the roles and use cases of SQL Server, Azure SQL Database and SQL in Microsoft Fabric.
- Design a high-performing, normalised and scalable SQL data model.
- Write, optimise and secure advanced T-SQL code.
- Integrate AI features (embeddings, vector search) into a SQL database.
- Implement a security, compliance and business-continuity strategy.
- Deploy and automate databases through CI/CD and DevOps tools.
- Monitor, diagnose and tune performance in production.
- Effectively prepare for the official Microsoft DP-800 exam.
Prerequisites of the training: DP-800 Training Course: Designing and Developing AI-Enriched SQL Database Solutions
- Hands-on experience with relational databases (SQL Server, MySQL, PostgreSQL or equivalent).
- Command of SQL fundamentals: SELECT, joins, aggregations, sub-queries.
- Basic knowledge of Microsoft platforms (SQL Server, Azure) and cloud concepts.
- General notions of data architectures (data warehouse, data lake) are welcome.
- No prior AI expertise is required: concepts are introduced progressively.
- Because every participant is unique, a personalised interview with our expert lets us design a training course aligned with their objectives, level and challenges.
Financing
This course is funded directly by the company (no CPF, no OPCO). See our funding terms.
Detailed programme of the training: DP-800 Training Course: Designing and Developing AI-Enriched SQL Database Solutions
Introduction to Microsoft SQL platforms and AI in databases
Designing and modelling a modern SQL database
Advanced T-SQL development: performance, security and quality
Integrating AI into your SQL databases: vectors, embeddings and semantic search
Deploying and automating with Azure SQL, SQL in Fabric and DevOps
Observability, governance and optimisation in production
The benefits of this training course
- A structured path that concretely prepares you for the Microsoft DP-800 certification.
- A focus on the latest advances in AI applied to SQL databases (embeddings, vector search, copiloting).
- Hands-on labs on SQL Server, Azure SQL Database and SQL in Microsoft Fabric.
- A course oriented towards practical business cases plus DevOps best practices.
- Expert SQL trainers with real-world field experience.
FAQ
What is the DP-800 certification?
The Microsoft DP-800 (Developing Azure SQL Database solutions) certification validates the skills of professionals who design and develop SQL database solutions on Microsoft platforms. The exam covers modelling, advanced T-SQL development, security, performance, deployment, as well as the new AI use cases associated with SQL databases (embeddings, vector search).
How is the DP-800 training course delivered?
The DP-800 training course is delivered as an interactive virtual classroom (remote) or at your premises on request. It alternates theory, demonstrations and hands-on workshops on SQL Server, Azure SQL Database and SQL in Microsoft Fabric environments. Each participant has access to a dedicated lab environment to work with the concepts covered and prepare effectively for the exam.
What are the prerequisites for the DP-800 course?
Participants should have some initial experience with relational databases and writing SQL queries. Basic knowledge of Microsoft platforms (SQL Server, Azure) and general notions of cloud services are recommended. No prior AI expertise is required: the AI topics (embeddings, vector search) are introduced progressively during the course.
How long does the DP-800 training course last?
The DP-800 training course at MFE-IT lasts 3 days, i.e. 18 hours, delivered remotely (synchronous sessions, workshops and practical cases) or at your premises. The course covers the entire official DP-800 programme: design, T-SQL development, security, performance, AI integration and deployment.
Is this DP-800 course eligible for CPF or OPCO funding?
No. MFE-IT does not directly manage CPF or OPCO files and our organisation is not Qualiopi-certified. This course is therefore aimed only at companies that fund it directly. This is a deliberate choice: we have prioritised pedagogical agility and investment in genuine quality over administrative compliance. In return, you benefit from a 100% tailor-made format: a preliminary interview, content adapted to your business context, sessions guaranteed from a single registrant (except in cases of force majeure), a maximum of 3 participants per session and 30 days of post-course support by email. For more information, see our FAQ and/or contact us via our contact form.