Implementing a Relational Database in Microsoft Azure SQL Database

Focused View

Reza Salehi

2:50:13

65 View

00. Course Overview

00. Course Overview.mp4

01:08

01. Getting Started

00. Overview.mp4

01:45

01. IaaS vs. PasS Azure Database Offerings.mp4

03:36

02. Comparing IaaS and PasS Offerings.mp4

02:44

03. Azure SQL Database Deployment Options.mp4

02:02

04. Azure SQL Database Purchasing Models.mp4

03:00

05. Azure SQL Database Service Tiers.mp4

02:33

06. Demo - Provisioning an IaaS SQL Server Workload.mp4

07:09

07. Demo - Provisioning a PaaS Workload.mp4

03:31

08. Summary.mp4

02:15

02. Provisioning Azure SQL Database Single Database & Elastic Pool

00. Overview.mp4

01:29

01. Understanding Azure SQL Database Single Database.mp4

02:06

02. Provisioning Azure SQL Database Single Database.mp4

03:06

03. Understanding Azure SQL Database Elastic Pools.mp4

04:09

04. Securing Azure SQL Database.mp4

03:32

05. Demo - Provisioning Azure SQL Single Database.mp4

07:26

06. Demo - Configuring Azure SQL Security and Connectivity.mp4

05:39

07. Demo - Provisioning Azure SQL Elastic Pools.mp4

06:18

08. Scaling Azure SQL Databases.mp4

02:21

09. Summary.mp4

00:55

03. Provisioning Azure SQL Database Managed Instance

00. Overview.mp4

01:17

01. Introducing Azure SQL Database Managed Instance.mp4

04:23

02. Migration Options and Service Tiers for Managed Instances.mp4

02:57

03. Managed Instance Advanced Security.mp4

02:13

04. Demo - Provisioning Azure SQL Database Managed Instance.mp4

03:59

05. Demo - Connecting to Managed Instance Using a Jumpbox.mp4

07:25

06. Summary.mp4

01:33

04. Configuring Data Backup

00. Overview.mp4

01:06

01. Understanding Azure SQL Automated Backups.mp4

01:31

02. Point in Time and Long Term Retention Backups.mp4

03:20

03. Restoring Databases from Backups.mp4

01:44

04. Demo - Restoring a Corrupted or Deleted Database.mp4

05:28

05. Demo - Configuring Long Term Retention (LTR) Backups.mp4

02:16

06. Summary.mp4

01:35

05. Configuring Elastic Database Jobs

00. Overview.mp4

00:55

01. Scheduled Jobs in Azure.mp4

02:34

02. Understanding Elastic Database Jobs.mp4

02:51

03. Elastic Job Components and Configuration.mp4

03:05

04. Demo - Creating an Elastic Job Agent.mp4

05:00

05. Demo - Creating and Managing a Job Using T-SQL.mp4

07:48

06. Summary.mp4

00:55

06. Configuring SQL Agent Jobs

00. Overview.mp4

01:21

01. Understanding SQL Agent Jobs for Managed Instances.mp4

01:49

02. Understanding SQL Agent Job Step, Schedule and Notification.mp4

02:40

03. Demo - Creating a SQL Agent Job and Configuring SQL Job Email Notifications.mp4

08:41

04. Summary.mp4

02:07

07. Managing Data Synchronization between Azure and SQL Server On-premises

00. Overview.mp4

01:06

01. Azure SQL Data Sync Use Cases.mp4

01:55

02. Sync Group, Sync Group Properties, Hub, Member, and Sync Databases.mp4

03:31

03. Data Sync Considerations and Limitations.mp4

02:21

04. Demo - Creating the Hub and Member Databases.mp4

04:15

05. Demo - Setting up Data Sync.mp4

08:32

06. Summary.mp4

01:16

Description

This hands-on course explores Azure SQL Database. Security, data sync, automatic backups, scheduled jobs, and more are covered. Empower your modern applications by leveraging this high-performance, highly-available relational database in the cloud.

What You'll Learn?

Azure SQL Database is Microsoft's main relational database management system offering in the cloud. Getting the most out of this sophisticated service can be a challenge.

In this course, Implementing a Relational Database in Microsoft Azure SQL Database, you will gain the ability to quickly provision and configure your relational database in the cloud.

First, you will learn which deployment option best suits your project. Next, you will discover the automatic backup and data sync features. Finally, you will explore how to create database scheduled jobs to meet your data management and other needs.

When you are finished with this course, you will have the skills and knowledge of Azure SQL Database needed to deploy and run your relational databases in the cloud.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Microsoft SQL

Microsoft Azure

Reza Salehi

Instructor's Courses

Reza is a cloud consultant and a Microsoft Certified Trainer alumni. He started professional software development and training over two decades ago and is passionate about cloud technologies. Reza continues to help his clients moving to the cloud and loves to share his passion for the cloud with the developers and software architects through training.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.