Microsoft Azure Developer: Managing Azure SQL Database from Pluralsight

Managing a hosted Azure SQL Database involves many aspects. In this course, you will learn foundational knowledge of the tools available to create, update, and manage an Azure SQL Database.

Data persistence is at the core of any line of business application. While some companies may have a dedicated database administrator, in many smaller companies the developer wears many hats including database administrator. In this course, Microsoft Azure Developer: Managing Azure SQL Database, you will learn foundational knowledge of the tools available to create, update, and manage an Azure SQL Database. First, you will learn how to migrate the database schema as your application iterates through versions. Next, you will discover several of the layers available to secure access to your database and the information that it contains. Finally, you will explore how to manage the performance of your database to meet ever growing demands. When you’re finished with this course, you will have the skills and knowledge of Azure SQL Database necessary to support your database needs.

What's inside

Syllabus

Course Overview

Setting the Stage

Migrating Schema

Securing Data

Managing Performance

Wrapping Up

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Explores Azure SQL Database, which is an industry-standard cloud-based relational database management system

Teaches foundational knowledge of tools available to manage an Azure SQL Database

Develops skills and knowledge necessary to support database needs through the use of Azure SQL Database

Taught by Jeff Hopper, who is recognized for their work in database management

Examines securing data, which is highly relevant to database management

Provides a strong foundation for beginners in database management, especially those who are interested in using Azure SQL Database

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Microsoft Azure Developer: Managing Azure SQL Database with these activities:

Compile a list of resources on Azure SQL Database

Show steps

Provides a valuable reference for future learning.

Browse courses on Azure SQL Database

Show steps

Search for resources on Azure SQL Database
Evaluate the resources
Organize the resources into a list

Follow a tutorial to set up and configure an Azure SQL Database

Show steps

Provides hands-on experience with setting up an Azure SQL Database.

Browse courses on Azure SQL Database

Show steps

Find a tutorial on setting up an Azure SQL Database
Follow the steps in the tutorial
Test the database

Create and perform a simple SQL query using an Azure SQL Database

Show steps

Brings foundational skills for interacting with a SQL database to working memory.

Browse courses on Azure SQL Database

Show steps

Open an Azure SQL Database
Create a new query
Type a simple SQL query
Execute the query

Five other activities

Expand to see all activities and additional details

Show all eight activities

Practice using SQL commands to create, update, and delete data

Show steps

Provides repeated practice with important SQL commands.

Browse courses on SQL

Show steps

Create a new database
Create a new table
Insert data into the table
Update data in the table
Delete data from the table

Participate in a workshop on Azure SQL Database

Show steps

Provides intensive training on Azure SQL Database.

Browse courses on Azure SQL Database

Show steps

Find a workshop on Azure SQL Database
Register for the workshop
Attend the workshop
Complete the exercises

Design a database schema for a simple application

Show steps

Lets students practice applying conceptual knowledge to a practical task.

Show steps

Identify the entities and relationships in the application
Create a logical data model
Translate the logical model into a physical schema
Create the database and tables
Test the schema

Attend a meetup or conference on Azure SQL Database

Show steps

Provides opportunities to connect with other professionals in the field.

Browse courses on Azure SQL Database

Show steps

Find a meetup or conference on Azure SQL Database
Register for the event
Attend the event
Network with other attendees

Volunteer to help with a project that uses Azure SQL Database

Show steps

Provides practical experience and opportunities to contribute to the community.

Browse courses on Azure SQL Database

Show steps

Find a project that uses Azure SQL Database
Contact the project leader
Volunteer your services
Participate in the project

Career center

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

Database Administrator

A Database Administrator is responsible for the day-to-day operation and maintenance of database systems. This course can help you build a foundation in managing Azure SQL Database, which is a popular cloud-based database service. The skills you learn in this course will be valuable for anyone who wants to pursue a career as a Database Administrator.

See salaries and explore the career path for Database Administrator

Data Analyst

A Data Analyst is responsible for collecting, cleaning, and analyzing data. This course can help you build a foundation in managing Azure SQL Database, which is a popular cloud-based database service. The skills you learn in this course will be valuable for anyone who wants to pursue a career as a Data Analyst.

See salaries and explore the career path for Data Analyst

Data Scientist

A Data Scientist is responsible for developing and applying statistical models to data. This course can help you build a foundation in managing Azure SQL Database, which is a popular cloud-based database service. The skills you learn in this course will be valuable for anyone who wants to pursue a career as a Data Scientist.

See salaries and explore the career path for Data Scientist

Software Engineer

A Software Engineer is responsible for designing, developing, and maintaining software applications. This course can help you build a foundation in managing Azure SQL Database, which is a popular cloud-based database service. The skills you learn in this course will be valuable for anyone who wants to pursue a career as a Software Engineer.

See salaries and explore the career path for Software Engineer

Cloud Engineer

A Cloud Engineer is responsible for designing, deploying, and managing cloud-based infrastructure. This course can help you build a foundation in managing Azure SQL Database, which is a popular cloud-based database service. The skills you learn in this course will be valuable for anyone who wants to pursue a career as a Cloud Engineer.

See salaries and explore the career path for Cloud Engineer

Business Intelligence Analyst

A Business Intelligence Analyst is responsible for collecting, analyzing, and interpreting data to help businesses make better decisions. This course can help you build a foundation in managing Azure SQL Database, which is a popular cloud-based database service. The skills you learn in this course will be valuable for anyone who wants to pursue a career as a Business Intelligence Analyst.

See salaries and explore the career path for Business Intelligence Analyst

Database Developer

A Database Developer is responsible for designing, developing, and maintaining databases. This course can help you build a foundation in managing Azure SQL Database, which is a popular cloud-based database service. The skills you learn in this course will be valuable for anyone who wants to pursue a career as a Database Developer.

See salaries and explore the career path for Database Developer

Data Architect

A Data Architect is responsible for designing and managing the overall architecture of data systems. This course can help you build a foundation in managing Azure SQL Database, which is a popular cloud-based database service. The skills you learn in this course will be valuable for anyone who wants to pursue a career as a Data Architect.

See salaries and explore the career path for Data Architect

Information Security Analyst

An Information Security Analyst is responsible for protecting an organization's data and systems from security threats. This course can help you build a foundation in managing Azure SQL Database, which is a popular cloud-based database service. The skills you learn in this course will be valuable for anyone who wants to pursue a career as an Information Security Analyst.

See salaries and explore the career path for Information Security Analyst

IT Manager

An IT Manager is responsible for managing an organization's IT infrastructure and systems. This course can help you build a foundation in managing Azure SQL Database, which is a popular cloud-based database service. The skills you learn in this course will be valuable for anyone who wants to pursue a career as an IT Manager.

See salaries and explore the career path for IT Manager

Systems Administrator

A Systems Administrator is responsible for managing and maintaining computer systems. This course can help you build a foundation in managing Azure SQL Database, which is a popular cloud-based database service. The skills you learn in this course will be valuable for anyone who wants to pursue a career as a Systems Administrator.

See salaries and explore the career path for Systems Administrator

Network Administrator

A Network Administrator is responsible for managing and maintaining computer networks. This course may be useful for anyone who wants to pursue a career as a Network Administrator, as it provides a foundation in managing Azure SQL Database, which is a popular cloud-based database service.

See salaries and explore the career path for Network Administrator

Web Developer

A Web Developer is responsible for designing and developing websites. This course may be useful for anyone who wants to pursue a career as a Web Developer, as it provides a foundation in managing Azure SQL Database, which can be used to store website data.

See salaries and explore the career path for Web Developer

Mobile Developer

A Mobile Developer is responsible for designing and developing mobile applications. This course may be useful for anyone who wants to pursue a career as a Mobile Developer, as it provides a foundation in managing Azure SQL Database, which can be used to store mobile application data.

See salaries and explore the career path for Mobile Developer

Game Developer

A Game Developer is responsible for designing and developing video games. This course may be useful for anyone who wants to pursue a career as a Game Developer, as it provides a foundation in managing Azure SQL Database, which can be used to store game data.

See salaries and explore the career path for Game Developer