Professional Azure SQL Database Administration
Professional Azure SQL Database Administration, available at $64.99, has an average rating of 3.95, with 66 lectures, 9 quizzes, based on 523 reviews, and has 2061 subscribers.
You will learn about 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 This course is ideal for individuals who are 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. It is particularly useful 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.
Enroll now: Professional Azure SQL Database Administration
Summary
Title: Professional Azure SQL Database Administration
Price: $64.99
Average Rating: 3.95
Number of Lectures: 66
Number of Quizzes: 9
Number of Published Lectures: 66
Number of Published Quizzes: 9
Number of Curriculum Items: 75
Number of Published Curriculum Objects: 75
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will 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
Who Should Attend
- 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.
Target Audiences
- 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.
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.
Course Curriculum
Chapter 1: Functional Programming and Lazy Operations
Lecture 1: Introduction
Lecture 2: Installation and Setup
Lecture 3: Course Overview
Lecture 4: Microsoft Azure SQL Database Primer
Lecture 5: Azure SQL Database Architecture
Lecture 6: Database Request Flow and Provisioning
Lecture 7: Creating, Connecting and Querying the Database from the Azure Portal
Lecture 8: Deleting Resources
Lecture 9: Differences between Azure SQL Database and SQL Server
Lecture 10: Unsupported Features
Lecture 11: Summary
Chapter 2: Migrating a SQL Server Database to an Azure SQL Database
Lecture 1: Lesson Overview
Lecture 2: Migration Methodology
Lecture 3: Azure SQL Database Service Tiers
Lecture 4: Determining an Appropriate Service Tier
Lecture 5: Determining Compatibility Issues
Lecture 6: Determining the Migration Method
Lecture 7: Summary
Chapter 3: Backing up the Azure SQL Database
Lecture 1: Lesson Overview
Lecture 2: Automatic Backups
Lecture 3: Manual Backups
Lecture 4: DACPAC and BACPAC
Lecture 5: Summary
Chapter 4: Restoring an Azure SQL Database
Lecture 1: Lesson Introduction
Lecture 2: Restore Types
Lecture 3: Restore Databases
Lecture 4: Summary
Chapter 5: Securing an Azure SQL Database
Lecture 1: Lesson Introduction
Lecture 2: Access Control
Lecture 3: Restore Databases
Lecture 4: SQL Authentication and Azure Active Directory
Lecture 5: Row Level Security
Lecture 6: Dynamic Data Masking
Lecture 7: Proactive Security
Lecture 8: Summary
Chapter 6: Scaling out Azure SQL Database
Lecture 1: Lesson Introduction
Lecture 2: Vertical Scaling
Lecture 3: Horizontal Scaling
Lecture 4: Data Dependent Routing
Lecture 5: Creating Shards part 1
Lecture 6: Creating Shards part 2
Lecture 7: Creating Shards part 3
Lecture 8: Summary
Chapter 7: Elastic Pools
Lecture 1: Lesson Introduction
Lecture 2: Elastic Pools
Lecture 3: Elastic Database Transaction Units
Lecture 4: Sizing Best Practices
Lecture 5: Elastic Jobs
Lecture 6: Elastic Job Workflow
Lecture 7: Summary
Chapter 8: High Availability and Disaster Recovery
Lecture 1: Lesson Introduction
Lecture 2: High Availability
Lecture 3: Disaster Recovery
Lecture 4: Auto Failover Groups
Lecture 5: Configuring Active Geo-Replication
Lecture 6: Configuring Auto Failover Group
Lecture 7: Summary
Chapter 9: Monitoring and Tuning Azure SQL Database
Lecture 1: Lesson Introduction
Lecture 2: Monitoring an Azure SQL Database Using the Azure Portal
Lecture 3: Database Size
Lecture 4: Using DMVs
Lecture 5: Monitoring Connections and Query Performance
Lecture 6: Monitoring Blocking
Lecture 7: Tuning an Azure SQL Database
Lecture 8: In-Memory Technologies
Lecture 9: Summary
Instructors
-
Packt Publishing
Tech Knowledge in Motion
Rating Distribution
- 1 stars: 27 votes
- 2 stars: 33 votes
- 3 stars: 113 votes
- 4 stars: 192 votes
- 5 stars: 158 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024