History, versions and licenses of SQL Server
Roles and stakeholders of a SQL Server database
Other concurrent systems
Tools associated with SQL Server
Installation process: planning, updating
Authentication modes
Installation verification
File type:. mdf, .ndf, .ldf
Administrative objects

Lab: Installing and configuring SQL Server – Getting to know the SQL Server Management Studio tool

General organization: tables, views, constraints, indexes, procedures, …
Specification and modeling methods
Types and particular specifications of tables and fields
Creation of data structures
Management of storage spaces: files, groups of files
Inserting and importing data

Workshop: Database creation and file management

SQL language; MS SQL standards and particularities
Data definition statements
Index types
Constraint management
Data manipulation: insertion, updates, restriction, projection, calculations
Advanced structures, multiple joins, views, stored procedures
Transact SQL programming: functions, procedures
Elements of temporal optimization of requests
Documentation available

Workshop: Creation and manipulation of database data

Users and security: authentication modes, accounts, roles, permissions
Logs, possible backups and tools
Work on history and cancellations
Monitoring by alerts and triggers
Various automation of administration tasks

Workshop: User management – Backups and restores

Details of the certification content
Taking and correcting a mock test
Corrected workshops
Questions / answers, time management when taking the exam