This course teaches students how to design and develop AI-enabled database solutions using Microsoft SQL technologies, including SQL Server, Azure SQL, and SQL databases in Microsoft Fabric. Students will learn how to build modern data solutions that work with both structured and semi-structured data, and how to add AI capabilities such as vector search, embeddings, and intelligent data retrieval to business applications.

The course is ideal for database professionals, data engineers, and application developers who want to create scalable, AI-powered solutions using SQL-based data services.

To get the most out of this course, you should have:

• Basic knowledge of SQL (queries, tables, joins)
• Understanding of databases
• Basic familiarity with cloud concepts (Azure preferred)
• Interest in Artificial Intelligence (no prior experience required)

By the end of this course, you will be able to:

• Design AI-enabled database solutions
• Work with Azure SQL, SQL Server, and Microsoft Fabric
• Implement vector search, embeddings, and semantic queries
• Build intelligent, AI-powered backend applications
• Create and manage data pipelines for AI workloads
• Optimize performance and ensure secure data solutions
• Apply real-world scenarios aligned with the DP-800 exam

Design and develop database solutions

• 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

Secure, optimise, and deploy database solutions

• Implement data security and compliance with SQL
• Optimise database performance
• Implement CI/CD by using SQL Database Projects
• Integrate SQL solutions with Azure services

Implement AI capabilities in database solutions

• Design and implement models and embeddings with SQL
• Design and implement intelligent search with SQL
• Design and implement RAG with SQL