This course will be regularly updated.

Welcome to this SQL Server course. If you want to gain knowledge of Microsoft SQL Server to understand how it stores and retrieves huge amounts of data, this course is right for you. Microsoft SQL Server offers developers a unique opportunity to leverage the advanced features and build applications that are robust, scalable, and easy to administer. This course will help you learn about Microsoft SQL Server, including the features and functionalities that are needed to design and develop reliable database systems.

You will learn how to set up your SQL Server and configure new (and existing) environments for optimal use. This course starts with an introduction to SQL Server and databases and takes you through the installation of SQL Server Express. Once you are ready with the set-up, you will learn to connect to a database instance and create a database and tables inside the database. After covering the designing aspect, the course delves into performance-tuning aspects by teaching you how to effectively use indexes. The course will also teach you about certain choices that need to be made about backups and how to implement a rock-solid security policy and keep your environment healthy.

It prepares you for the more advanced topics by starting with a quick introduction to SQL Server’s new features and a recapitulation of the possibilities you may have already explored with previous versions of SQL Server. The next part introduces you to small delights in the Transact-SQL language and then switches to a completely new technology inside SQL Server - JSON support. We also take a look at the Stretch database, security enhancements, and temporal tables.

As you advance, you will learn to run queries against tables to manipulate tables and data and create relationships in the SQL Server with foreign keys and normalization. Finally, you will learn about the techniques you should use when things go wrong, and other important topics - such as migration, upgrading, and consolidation - are covered in detail. Integration with Azure is also covered in depth.

Whether you are an administrator or thinking about entering the field, this course will provide you with all the skills you need to successfully create, design, and deploy databases using Microsoft SQL Server.