DP-800: SQL AI Developer Associate Exam Prep

.

159

LESSONS

ALL

SKILL LEVEL

17:26 hr

DURATION

ENGLISH

AUDIO

ENG

SUBTITLES

OVERVIEW

This course is the foundation for learning T-SQL. It follows the Microsoft certificate DP-800 “SQL AI Developer Associate”.

You will be able to install for free the software used on this course – SQL Server Management Studio (SSMS).

There are regular quizzes to support your learning.

Once finished, you will be able to: manipulate numbers, strings and dates; create databases and tables; insert data and create analyses; and appreciate how they can all be used in T-SQL.

.

WHO IS THE COURSE FOR?

This course is for anybody new to SQL Server, or with limited experience, who wants to learn T-SQL. No prior knowledge is required.

It is also suitable as an SQL refresher course.

.

LEARNING PATH

THE SELECT STATEMENT

  • Install Azure SQL Database and SSMS.
  • Write queries to receive and summarise data using: SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
  • Number, string and data types and related functions.

CREATING TABLES

  • Creating and populating data, using INSERT, DELETE and UPDATE
  • Creating CONSTRAINTs
  • JOINing more than one table in an SELECT statement.
  • Creating node and edge graph tables
  • Creating indexes and partitioning
  • Creating specialized tables

CREATING OBJECTS

  • Create views to store SELECT queries.
  • Create triggers to automatically run code when INSERT, DELETE, or UPDATE is used.
  • Create stored procedures, scalar and table-valued functions.

FUNCTIONS

DESIGNING AND IMPLEMENT SQL SOLUTIONS BY USING AI-ASSISTED TOOLS

IMPLEMENT DATA SECURITY AND COMPLIANCE

  • Window functions
  • Common Table Expressions
  • JSON Functions
  • Regular expression functions
  • Fuzzy string matching functions
  • Enable Microsoft GitHub Copilot and Microsoft Copilot in Fabric.
  • Configure MCP tool options
  • Configure GitHub Copilot instruction files
  • Implement Data encryption and Dynamic Data Masking.
  • Implement Row-level Security and object-level permissions.
  • Implement secure database access and auditing.
  • Secure model, GraphQL, REST and MCP endpoints

OPTIMIZE DATABASE PERFORMANCE

  • Use transaction isolation levels and concurrency controls.
  • Evaluate query performance, including Query Execution plans, DMVs, Query Store, and Query Performance Insight

SQL DATABASE PROJECTS AND INTEGRATE WITH AZURE SERVICES

  • Use SQL Database projects.
  • Implement source control.
  • Develop a testing strategy
  • Use static data and secrets
  • Use deployment pipelines

IMPLEMENT AI CAPABILITIES IN DATABASE SOLUTIONS

  • Design and implement models and embeddings
  • Design and implement intelligent search
  • Design and implement retrieval-augmented generation (RAG)

REVIEWS

“Excellent Course! I’m enjoying it!” Jeff

“The style of delivery is unique and concept are explained in a more simplify manner.” Olufemi

.

READY TO START?