• Data Types and New T-SQL Language Features
  • Single Table Queries
  • Joining Multiple Tables
  • Subqueries, Common Table Expressions and Ranking Functions
  • Indexing
  • Query Tuning
  • Data Modification, Transactions and Error Processing
  • Stored Procedures and Triggers
  • Introduction to database management systems and databases
  • What is database and a database management system (DBMS?)
  • Introduction to Microsoft SQL Server and its overall SQL Server Data Platform
  • Tasks of a Database Administrator
  • Microsoft SQL Server 2016 Installation
  • Microsoft SQL Server 2016 Security
  • Microsoft SQL Server 2016 database session administration
  • SQL Server 2016 Backup and Recovery – Part 1
  • Introduction to Backup and Recovery strategy for databases
  • Full Database backups using the SIMPLE Recovery Model