Advanced Microsoft SQL Server: Become a Master!

This course is designed for DBAs to implement, monitor, and maintain enterprise database solutions.

Microsoft SQL Server comes equipped with industry-leading features and the best online transaction processing capabilities. It is one of the most popular relational database management systems developed by Microsoft. If you are looking to work with data processing and management, getting up to speed with Microsoft SQL Server is key. This course will not only teach you how to administer an enterprise database, but also help you become proficient at managing and keeping the database available, secure, and stable.

What you’ll learn

  • Learn How to Configure data access and auditing.
  • Learn How to Manage backup and restore of databases.
  • Learn How to Manage and monitor SQL Server instances.
  • Learn How to Manage high availability and disaster recovery.
  • Learn How to Implement SQL in Azure.
  • Learn How to Manage databases and instances.
  • Learn How to Manage Storage.

Course Content

  • Welcome –> 1 lecture • 9min.
  • Part 1: Administering a SQL Database Infrastructure –> 2 lectures • 11min.
  • Learn About Microsoft SQL Server Basics –> 5 lectures • 36min.
  • Learn About Microsoft SQL Server 2016 –> 5 lectures • 36min.
  • Understanding Microsoft SQL Server Security –> 11 lectures • 1hr 20min.
  • Learn and Understand SQL Server Roles –> 6 lectures • 36min.
  • SQL Server – Understanding SQL Server Encryption –> 11 lectures • 1hr 23min.
  • SQL Server – Understanding Index Management –> 6 lectures • 44min.
  • SQL Server Backup & Restore –> 14 lectures • 1hr 49min.
  • Learn How to Monitor SQL Server –> 12 lectures • 1hr 34min.
  • Part 1 Summary – Administering a SQL Database Infrastructure –> 2 lectures • 1min.
  • Part 2: Provisioning SQL Databases –> 1 lecture • 8min.
  • Learn and Understand Cloud Computing –> 12 lectures • 1hr 27min.
  • Learn About Microsoft Azure –> 5 lectures • 32min.
  • Learn About Microsoft Azure SQL Database –> 7 lectures • 41min.
  • Learn About Microsoft SQL Server Virtualization –> 16 lectures • 1hr 44min.
  • Learn and Understand Microsoft Azure Security –> 7 lectures • 44min.
  • Learn and Understand Migration & Performance –> 7 lectures • 1hr 4min.
  • Part 2 Summary – Provisioning SQL Databases –> 2 lectures • 3min.

Advanced Microsoft SQL Server: Become a Master!

Requirements

  • A PC.
  • Internet Access.

Microsoft SQL Server comes equipped with industry-leading features and the best online transaction processing capabilities. It is one of the most popular relational database management systems developed by Microsoft. If you are looking to work with data processing and management, getting up to speed with Microsoft SQL Server is key. This course will not only teach you how to administer an enterprise database, but also help you become proficient at managing and keeping the database available, secure, and stable.

This course takes you through the latest features in SQL Server and their importance. You’ll start by learning how to set up your SQL Server and configure new and existing environments for optimal use. You will also learn to unlock faster querying speeds and understand how to leverage the new and improved security features to build robust data management solutions. This course then takes you through designing aspects and delves into performance tuning by showing you how to use indexes effectively. Further lectures will assist you with integrating, managing, and analyzing all data, including relational, NoSQL, and unstructured big data using SQL Server. You’ll understand certain choices that need to be made about backups, implement security policy, and discover how to keep your environment healthy. Tools available for monitoring and managing a SQL Server database, including automating health reviews, performance checks, and much more, will also be discussed in detail. As you advance, the course covers essential topics such as migration, upgrading, and consolidation, along with the techniques that will help you when things go wrong. Dedicated sections in the course will also demonstrate how you can use SQL Server to leverage data processing platforms, such as Apache Hadoop and Spark, and containerization technologies like Docker and Kubernetes to control your data and efficiently monitor it. Once you’ve got to grips with integration with Azure and streamlining big data pipelines, you’ll learn best practices from industry experts for maintaining a highly reliable database solution.

Whether you are an administrator or are looking to get started with database administration, this course will help you develop the skills you need to successfully build robust data management solutions.

 

Get Tutorial