This course will teach you about basic architecture and concepts of MS SQL Server, comprehend the differences and similarities between Transact-SQL and other computer languages and how to maintain a MS SQL Server database. After completing this course, you will be able to explain core database administration tasks, restore databases from backups, carry out ongoing database maintenance and set up and configure SQL Server 2016.