Aspire Journeys
Working with Microsoft Azure SQL
- 5 Courses | 5h 40m 42s
- 1 Lab | 1h
Working with Microsoft Azure SQL is a comprehensive journey that teaches participants how to use Microsoft Azure's fully managed relational database service. Throughout the journey, participants will learn how to set up and manage an Azure SQL database, perform basic CRUD operations, and work with complex data types such as stored procedures and functions. They will also gain experience with advanced features such as transactions and security. In addition, participants will learn Monitoring data changes, tracking query performance, Optimizing query executions, and will be equipped with the skills necessary to build and deploy secure, scalable, and high-performing applications. Whether you're a developer, administrator, or architect, this journey will provide you with the hands-on experience and knowledge needed to effectively use Microsoft Azure SQL.
Track 1: Cloud Databases
In this track of the Working with Microsoft Azure SQL Aspire journey, the focus will be on cloud databases.
- 1 Course | 53m 28s
Track 2: Microsoft Azure SQL Database
In this track of the Working with Microsoft Azure SQLAspire journey, the focus will be on Microsoft Azure SQL. Learn how to set up and manage an Azure SQL database, perform basic CRUD operations, and work with complex data types such as stored procedures and functions. Explore advanced features such as transactions and security, and learn monitoring data changes, tracking query performance, and optimizing query executions.
- 4 Courses | 4h 47m 14s
- 1 Lab | 1h
COURSES INCLUDED
An Overview of Cloud Databases
Cloud databases are hosted on and often maintained by a cloud platform. The platform manages the hardware, networks, and OS, and users pay for the allocated or consumed resources. Through this course, learn what cloud-hosted databases have to offer, the factors that influence the adoption of a cloud database, and what to watch out for when using such systems. Explore the characteristics of cloud-hosted databases and the benefits and caveats of such services. Next, discover factors to consider when moving to the cloud. Finally, compare SQL and NoSQL systems and learn about some of the most powerful cloud-hosted database services. Upon completion, you'll be able to recognize the elements of different cloud databases and select the best option.
7 videos |
53m
Assessment
Badge
COURSES INCLUDED
Working with Microsoft Azure SQL: Getting Started with Azure SQL
Azure SQL is a family of offerings on Azure that use SQL Server as the database engine. Azure SQL Database is one of those offerings and is a fully managed database service with a serverless option. Through this course, learn how to get started with Azure SQL and set up an Azure SQL Database instance. Explore relational and NoSQL databases, what Azure SQL is, and the primary benefits of Azure SQL. Next, learn about Azure SQL Databases, how to configure a database to manage performance and costs, and its purchasing models and service tiers. Finally, discover how to create, configure, connect to, and query database instances. Upon completion, you'll be able to outline Azure SQL and Azure SQL Database.
14 videos |
1h 50m
Assessment
Badge
Working with Microsoft Azure SQL: Using Transact-SQL for Queries & Transactions
Transact-SQL (T-SQL) is a powerful query language that applies to all databases with a SQL engine. It can be used to run a variety of different operations against Azure SQL Database. Through this course, learn about the Transact-SQL language and how to query data, create table partitions, and launch transactions against Azure SQL Database. Discover how to load CSV file data into a new Azure SQL Database table and query and execute aggregations on that data. Next, learn how to implement and validate table partitioning, use Transact-SQL to define and execute transactions, and use rollbacks and savepoints. Finally, practice setting isolation levels for transactions. After course completion, you'll be able to use Transact-SQL to query data and launch transactions for Azure SQL Database.
11 videos |
1h 28m
Assessment
Badge
Working with Microsoft Azure SQL: Advanced Topics in Azure SQL Databases
Change data capture (CDC) is an Azure feature that records any modifications to the contents of a tracked table. Azure SQL Database integrates with change data capture, as well as many other Azure cloud services and features. Through this course, learn how Azure SQL Database integrates with change data capture, Azure Functions, and JSON data. Discover how to enable change data capture for a database and view the tracked changes. Next, practice using Azure Functions to respond to an HTTP request and set up a development environment with Visual Studio Code. Finally, learn how to create a table to store JSON data and query and modify that data. Upon completion, you'll be able to utilize some advanced features of Azure SQL Database.
10 videos |
1h 27m
Assessment
Badge
Final Exam: Working with Microsoft Azure SQL
Final Exam: Working with Microsoft Azure SQL will test your knowledge and application of the topics presented throughout the Working with Microsoft Azure SQL journey.
1 video |
32s
Badge
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE TRACKS
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
