Understand the fundamental concepts of relational databases: tables, rows, columns, primary keys and relationships between entities.

Write queries with SQL and T-SQL: data selection, filters, sorts, joins, subqueries, variables and conditional statements.

Create and modify objects such as tables, views, stored procedures, functions, indexes and triggers in the context of SQL Server.

Control access to data with roles, permissions, authentication, auditing and data protection in SQL Server.

Perform full, differential and transactional backups; plan disaster recovery strategies and point-in-time recovery.

Monitor and optimize database performance: use of indexes, analysis of execution plans and resource management.

Practice Azure Data fundamentals: relational data, non-relational data, analytics, SQL, Azure Data services and core concepts for the DP-900 exam.

Practice administering Azure SQL solutions: provisioning, security, performance, backup, high availability, monitoring and optimization for the DP-300 exam.