Advanced Microsoft SQL Server (2016/Azure): Become a Master!

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

Requirements
A PC
Internet Access

Description
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.

Who this course is for
Web Developers
Software Developers
Programmers
Anyone interested in MS SQL Server