Deploying Microsoft Azure Synapse Analytics and Azure SQL Database

Focused View

Robert Lindley

1:59:17

23 View

01 - Course Overview

01 - Course Overview.mp4

02:16

02 - Deploying the Modern Data Warehouse Environment#

02 - Introduction.mp4

01:11

03 - Why Is This Important.mp4

01:31

04 - Modern Data Warehouses.mp4

03:36

05 - Demo - Creating Azure SQL Database.mp4

03:48

06 - Demo - Creating Azure SQL Data Warehouse.mp4

03:31

07 - Demo - Creating an Azure Data Factory.mp4

02:06

08 - Demo - Loading Data into Azure SQL Database.mp4

11:42

09 - Summary.mp4

01:09

03 - Choosing a Code Branching Strategy

10 - Introduction.mp4

01:38

11 - Planning Azure DevOps Organizations.mp4

01:44

12 - Demo - Creating an Azure DevOps Organization.mp4

05:14

13 - Demo - Creating an Azure DevOps Project.mp4

04:49

14 - Demo - Creating an Azure DevOps Repository.mp4

02:59

15 - Choosing an Agile Branching Strategy.mp4

02:47

16 - Demo - Managing Azure DevOps Branch Policies.mp4

06:59

17 - Summary.mp4

00:44

04 - Implementing a Data Warehouse Build and Release Pipeline

18 - Introduction.mp4

00:38

19 - What Is Continuous Integration and Deployment.mp4

02:15

20 - Demo - Creating ARM and Database Templates.mp4

07:30

21 - Demo - Creating an Azure DevOps Pipeline.mp4

07:01

22 - Demo - Creating an Azure DevOps Release.mp4

11:27

23 - Demo - Creating an Azure DevOps PR Release.mp4

03:22

24 - Summary.mp4

01:07

05 - Managing Hybrid Azure SQL Data Warehouse Solutions

25 - Introduction.mp4

01:26

26 - Demo - Exploring the Azure Database Migration Guide.mp4

03:37

27 - Demo - Creating a New Azure Migrate Project.mp4

03:31

28 - Demo - Using the Azure Data Migration Assistant.mp4

07:35

29 - Demo - Setting up Azure SQL Data Sync.mp4

10:31

30 - Summary.mp4

01:33

Description

In an agile world, employing the same evolutionary approaches to databases as is applied to the application is more necessary than ever. This course brings an agile methodology to databases using Azure DevOps to create agile database deployments.

What You'll Learn?

Agile methodologies have radically changed application development. Databases now need to continually evolve along with our applications, especially with the focus on highly iterative, micro-service driven architectures. In this course, Deploying Microsoft Azure Synapse Analytics and Azure SQL Database, you will learn foundational knowledge to create and deploy databases as part of a CI/CD process. First, you'll learn to create new Azure SQL Databases, Azure Data Warehouses, and Azure Data Factory resources along with creating ARM templates for each resource. Next, you’ll learn how to set up build and release pipelines with Azure DevOps to automatically provision new resources using ARM templates and deploying data warehouse or SQL database using data-tier application packages (DACPAC). Finally, you'll explore how to migrate existing on-premises SQL Server Databases to Azure using Azure Migrate Service, or keeping your on-premises databases automatically synchronized with Azure SQL Databases using Azure Data Sync. When you’re finished with this course, you will have the skills and knowledge to use Azure DevOps to deploy both Azure SQL Data Warehouses and Azure SQL Databases as part of your Agile processes.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

Microsoft Azure

Robert Lindley

Instructor's Courses

I have been in love with technology and all of the possibilities that technology provides since the day I first sat in front of a Tandy. It's a relationship that has been going strong for more than 20 years. I can't imagine a better career than being a developer creating software and services that have the ability to impact the lives of millions of people at a time.

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.