- Installation and configuration of SQL Server database engine
- Creating databases: files, file groups, basics: full-text search / FILESTREAM
- Introducing essential database objects: tables, views, indexes, server objects
- Backup and restore databases
- Moving and migrating databases
- Security: Authentication and authorization of users, standalone databases
- Provide defined reliability: data loss and data availability
- Automation of administrative tasks: creation of maintenance plans, deployment of SQL Server Agent
- AlwaysOn Failover Cluster Instances (FCI) and AlwaysOn Availability Groups (AG) (including Basic Availability Groups)
- Data sharing concepts: replication, data import/export, database dump, transaction log shipping
- Troubleshooting, Performance Tuning Basics, Monitoring
- Server and database level security concepts: transparent data encryption, backup encryption and connection encryption
- Basics of installing Reporting Service, Analysis Service, Integration Service