Deploying Microsoft Azure Synapse Analytics and Azure SQL Database from Pluralsight

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.

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.

What's inside

Syllabus

Course Overview

Deploying the Modern Data Warehouse Environment

Choosing a Code Branching Strategy

Implementing a Data Warehouse Build and Release Pipeline

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Introduces Azure DevOps for agile database deployments, which is highly relevant in both industry and academia

Shows learners how to set up build and release pipelines with Azure DevOps to provision new resources and deploy databases using data-tier application packages (DACPAC)

Prepares learners to migrate existing on-premises SQL Server Databases to Azure or keep them synchronized with Azure SQL Databases using Azure Data Sync

Taught by Robert Lindley, an expert in agile database deployments

Utilizes a mix of videos, readings, and discussions for a multi-modal learning experience

Assumes learners have a basic understanding of databases and Azure services

Career center

Learners who complete Deploying Microsoft Azure Synapse Analytics and Azure SQL Database will develop knowledge and skills that may be useful to these careers:

Cloud Data Engineer

Cloud Data Engineers design, build, and maintain data systems in the cloud. They work with a variety of cloud data services and tools to build scalable, reliable, and secure data solutions. This course will help build a foundation for a career in cloud data engineering, specifically in the Azure cloud.

See salaries and explore the career path for Cloud Data Engineer

Business Intelligence Analyst

Business Intelligence Analysts help businesses make better decisions by analyzing data and identifying trends. They use a variety of data analysis tools and techniques to extract insights from data. This course may assist in building a foundation for a career in business intelligence analysis by providing knowledge of Azure data services and data warehousing.

See salaries and explore the career path for Business Intelligence Analyst

Database Developer

Database Developers design, build, and maintain databases. They work with a variety of database technologies, such as Microsoft SQL Server and Oracle. This course will help build a foundation for a career in database development, specifically in the cloud environment.

See salaries and explore the career path for Database Developer

ETL Developer

ETL Developers design, build, and maintain ETL (extract, transform, and load) processes. They work with a variety of data integration tools and techniques to move data between different systems. This course may assist in building a foundation for a career in ETL development by providing knowledge of Azure data services, data warehousing, and data pipelines.

See salaries and explore the career path for ETL Developer

Data Architect

Data Architects design, build, and maintain data architectures. They work with a variety of data technologies and tools to ensure that data is stored, managed, and used effectively. This course will help build a foundation for a career in data architecture, specifically in the cloud environment.

See salaries and explore the career path for Data Architect

Database Administrator

Database Administrators ensure that data is stored, organized, and secured appropriately and efficiently. They guarantee the smooth operation and maintenance of databases, perform routine backups, and implement security measures to provide controlled access to sensitive data. This course will help build a foundation for a career in database administration, specifically in the cloud environment.

See salaries and explore the career path for Database Administrator

Data Engineer

Data Engineers design, build, and maintain data pipelines that collect, transform, and deliver data to meet the needs of an organization. This course may assist in building a foundation for a career in data engineering by providing knowledge of Azure data services, data warehousing, and data pipelines.

See salaries and explore the career path for Data Engineer

DevOps Engineer

DevOps Engineers are responsible for bridging the gap between development and operations teams. They help automate and integrate processes to improve the efficiency and quality of software delivery. This course may assist in building a foundation for a career in DevOps engineering by providing knowledge of Azure DevOps and CI/CD pipelines.

See salaries and explore the career path for DevOps Engineer

Big Data Engineer

Big Data Engineers design, build, and maintain systems for storing and processing large amounts of data. They work with a variety of big data technologies, such as Hadoop, Spark, and NoSQL databases. This course may assist in building a foundation for a career in big data engineering by providing knowledge of Azure data services and data warehousing.

See salaries and explore the career path for Big Data Engineer

Data Warehouse Architect

Data Warehouse Architects design, build, and maintain data warehouses. They work with a variety of data warehouse technologies, such as Azure SQL Data Warehouse and Snowflake. This course may assist in building a foundation for a career in data warehouse architecture by providing knowledge of Azure data services and data warehousing.

See salaries and explore the career path for Data Warehouse Architect

Data Warehouse Engineer

Data Warehouse Engineers build and maintain data warehouses. They work with a variety of data warehouse technologies, such as Azure SQL Data Warehouse and Snowflake. This course may assist in building a foundation for a career in data warehouse engineering by providing knowledge of Azure data services and data warehousing.

See salaries and explore the career path for Data Warehouse Engineer

Cloud Architect

Cloud Architects design, deploy, and manage cloud computing systems and services. They have a deep understanding of cloud technologies and can make informed decisions about the best way to use them to meet the needs of an organization. This course may assist in building a foundation for a career in cloud architecture by providing knowledge of Azure services and cloud deployment strategies.

See salaries and explore the career path for Cloud Architect

Software Engineer

Software Engineers work with diverse stakeholders across organizations to understand, analyze, and solve complex problems. They write, test, and maintain code, and they also design, build, and deploy software systems. This course will help build a foundation for a career in software engineering, especially in the cloud environment.

See salaries and explore the career path for Software Engineer

Data Scientist

Data Scientists are on the cutting edge of leveraging data to solve complex problems that persist in businesses today. These experts are well-versed in advanced statistical techniques, machine learning algorithms, and data modeling. With the insights gleaned from their data analysis, Data Scientists create predictive and prescriptive models that lead to better and informed decision-making.

See salaries and explore the career path for Data Scientist

Data Analyst

Data Analysts are pioneers in discovering data-driven solutions. They use data to influence business decisions in many different industries. Data Analysts translate the raw data into easily digestible visuals, reports, and presentations that can be understood and used by stakeholders at all levels of an organization. By analyzing and interpreting data, stakeholders can gain insights that drive product development and solutions.

See salaries and explore the career path for Data Analyst

Reading list

We haven't picked any books for this reading list yet.

Deploying Microsoft Azure Synapse Analytics and Azure SQL Database

What's inside

Syllabus

Traffic lights

Save this course

Activities

Career center

Reading list

Share

Similar courses