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.