DP-800 exam prep: Microsoft SQL Server AI Developer

Learn to install and use SQL Server Management Studio to connect to Azure SQL Database, configure authentication, browse databases and objects, and run queries in the DP 800 database.

Learn the select and from clauses in SQL, practice selecting all columns or specific ones from the saleslt.product table, and explore basic T-SQL syntax and comments.

Explore the where clause and the like operator to search strings by prefixes, suffixes, or patterns using wildcards %, _, and not like, while understanding case sensitivity and collate options.

Use the where clause to combine multiple conditions with and, or, in, and between, avoid duplicates, and apply brackets and not between for precise data filtering.

Explore aggregations and the group by clause to summarize data, compare count, sum, min, and max, and learn how non-aggregated columns must appear in group by.

Explore number data types for variables and tables in TSQL, including bit, tinyint, smallint, int, and bigint, their ranges, signedness, and basic operations like division and modulo.

Explore key string functions in SQL Server, including concatenation, case changes, substring, trim, and length. Learn casting, converting, and formatting between strings and numbers across currencies and cultures.

Explore SQL Server's other data types, such as binary and varbinary, JSON and XML, geography and geometry, plus row version and vector for AI applications.

Create a school schema and a scores table, define data types and constraints, and practice basic insert, update, delete operations.

Learn how the unique index constraint prevents duplicates and how to create, drop, and apply it as a standalone or table-level constraint. Understand clustered versus non-clustered indexes and null handling.

Design and implement database-wide sequences for auto numbering across tables. Use default constraints and next value for the sequence, with configurable data type, start, increment, min, max, cycle, and cache.

Learn to query multiple tables with a join, alias the tables, and define on relationships between school.scores and school.pupils to retrieve related pupil names.

Create, alter, and drop views to encapsulate a select statement, then query them in from clauses. Explore view restrictions, such as order by, and inspect definitions with sys views.