Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Professional Azure SQL Database Administration
Rating: 4.2 out of 5(545 ratings)
2,166 students

Professional Azure SQL Database Administration

Master your skills to efficiently manage and maintain data on the cloud
Created byPackt Publishing
Last updated 11/2018
English

What you'll learn

  • Build a new Azure SQL Database or migrate to it from an on-premise SQL Database
  • Backup, restore, secure, and scale an Azure SQL Database
  • Monitor and tune an Azure SQL Database
  • Implement the high availability and disaster recovery features
  • Automate common management tasks with PowerShell
  • Develop a scalable cloud solution with SQL Database

Course content

9 sections • 66 lectures • 4h 58m total length

  • Introduction3:19

    This video gives a brief introduction of what we will be covering in this course.   

  • Installation and Setup3:30

    This video shows you to install and setup the required software’s for this course.   

  • Course Overview1:13

    This video will show you the lessons that will be covered in this course.   

  • Microsoft Azure SQL Database Primer1:32

    This video gives an introduction and objectives for this lesson.   

  • Azure SQL Database Architecture5:34

    In this video, you will learn about the different layers in the database architecture.   

  • Database Request Flow and Provisioning2:00

    In this video, you will take a look at the SQL database request flow and provisioning an SQL database.   

  • Creating, Connecting and Querying the Database from the Azure Portal6:51

    This video shows you how to create, connect and query the database from the Azure portal.   

  • Deleting Resources5:46

    This video shows you how to delete Azure SQL Database, Azure SQL Server, and Azure Resource group.   

  • Differences between Azure SQL Database and SQL Server8:52

    This video shows you some of the important features which differs from on premises SQL Server.   

  • Unsupported Features5:18

    This video shows you some of the main features not supported by Azure SQL Database or Azure SQL Server.   

  • Summary0:54

    This video summarizes your learning of this lesson.   

  • Test Your Knowledge

Requirements

  • To gain maximum benefits from this course, you should have prior experience of working on an on-premises SQL Server and you know PowerShell and C#.

Description

Azure SQL Database is the  cloud version of SQL Server. It differs in terms of management,  maintenance and administration.  It’s important to know how to  administer SQL Database so that you can get the most out of the features  that it provides. You will learn different management aspects of an  Azure SQL Database, such as migration, backup and restoration, pricing,  security, scalability, monitoring and performance optimization, high  availability and disaster recovery. You’ll start by understanding the  architecture of the Azure SQL Database and its service tiers. Through a  narrative of a DBA, who is migrating from a traditional on-premises  system to Azure SQL Database, this course will explain the concepts by  using different scenarios you might come across while working with Azure  SQL Database. If you are interested in developing new or migrating  existing applications with Azure SQL Database, then this course is for  you.

About the Authors

Gethyn Ellis has over eighteen years of experience wit SQL Server and for past ten years he has been working on Azure. He is Microsoft certified trainer. He also trains and is a consultant for SQL Server. Prior to this he has worked with Packt and written books on "Getting Started SQL Server 2014 Administration" and, "Microsoft Azure laaS Essentials".

Ahmad Osama is an independent consultant for Microsoft data platform stack. He has provided consulting, training, content development and SQL support services to more than 120 SQL Server customers globally. An expert in SQL Server and related technologies, he frequently speaks at user group events and conferences. Over the last 9 years, he has worked on countless SQL Server projects, consulted, trained, and mentored more than 1000 IT professionals on SQL Server, delivered more than 50 workshops. Ahmad has been a Microsoft Most Valuable Professional (MVP) awardee for SQL Server from 2014 - 2016.

Currently, he works for Pitney Bowes Pvt. Ltd. as a database engineer and is a Microsoft Data Platform rMVP. In his day to day job at Pitney Bowes, he works on developing and maintaining high performance on-premise and cloud SQL Server OLTP environments, building CI/CD environments for databases and automation.

Other than his day to day work, Ahmad has written over 100 blogs, including SQL Server Administration/Development, Azure SQL Database, and Azure Data Factory. He regularly speaks at user group events and webinars conducted by the Dataplatformlabs community.

Who this course is for:

  • This course is designed for database administrators, database developers, and application developers, who want to develop applications with Azure SQL Database, or migrate from their old applications.

Report abuse