Introduction Session (2h)

Introduction to the Academy: Structure, processes, and procedures

Relational Database Analysis and Development (28h)

Introduction to Databases
Database Environments
Relational Database Terminology
Planning and Designing Databases
Introduction to SQL Server
Create Databases
Tables and Data Integrity
Transact SQL Fundamentals
Filter and sort data

Practical Project – 1 (4h)
First part of the hands-on project

DP-080: Querying Data with Microsoft Transact-SQL (14h)

Introduction to Transact-SQL
Sort and filter results in T-SQL
Combine multiple tables with JOINs in T-SQL
Write Subqueries in T-SQL
Use built-in functions and GROUP BY in Transact-SQL
Modify data with T-SQL

SQL Database: Advanced Querying (14h)

Using Set Operators
Using Table Expressions
Using Window Ranking, Offset, and Aggregate Functions
Pivoting and Grouping Sets
Error Handling
Transactions

Practical Project – 2 (4h)

Continuation of the previously initiated hands-on project

SQL Database: Development (28h)

Introduction to Database Development
Designing and Implementing Tables
Advanced Table Designs
Ensuring Data Integrity through Constraints
Introduction to Indexes
Designing Optimized Index Strategies
Columnstore Indexes
Designing and Implementing Views
Designing and Implementing Stored Procedures
Designing and Implementing User-Defined Functions
Responding to Data Manipulation via Triggers
Using In-Memory Tables

Practical Project – 3 (4h)

Continuation of the previously initiated hands-on project

SQL Database: Infrastructure Administration (21h)

Installing SQL Server
Authenticating and Authorizing Users
Assigning Server and Database Roles
Authorizing Users to Access Resources
SQL Server Recovery Models
Backup of SQL Server Databases
Restoring SQL Server Databases
Automating SQL Server Management
Configuring Security for SQL Server Agent
Monitoring and Troubleshooting SQL Server
Working with Databases

Practical Project – 4 (4h)

Completion of the hands-on project

Job Integration: Data Roles (1h)

In this module, participants will gain an understanding of the diverse profiles, roles, and responsibilities of a database professional, as well as the various specializations available in the professional market

Microsoft Azure Fundamentals (e-Learning)

Describe core Azure concepts
Describe core Azure services
Describe core solutions and management tools on Azure
Describe general security and network security features
Describe identity, governance, privacy, and compliance features
Describe Azure cost management and service level agreements

Q&A Session: Microsoft Azure Fundamentals (3h)

Guidance and doubt clarification

DP-900: Microsoft Azure Database Administrator (7h)

Explore core data concepts
Explore data roles and services
Explore fundamental relational data concepts
Explore relational database services in Azure
Explore Azure Storage for non-relational data
Explore fundamentals of Azure Cosmos DB
Explore fundamentals of large-scale analytics
Explore fundamentals of real-time analytics
Explore fundamentals of data visualization

DP-900 Exam Preparation (2h)

Exam preparation
Clarifying exam questions

DP-203: Data Engineering on Microsoft Azure