Working with Microsoft Azure SQL: Advanced Topics in Azure SQL Databases
Azure
| Intermediate
- 10 videos | 1h 27m 53s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this course
Enable change data capture (cdc) for a database and table using built-in procedures
View change data capture and disable the feature
Configure and deploy a simple azure function to respond to an http request
Set up the visual studio code ide to enable the development and deployment of an azure functions app -
Write a function that writes to azure sql database and invoke that function
Create a table that can store json data as a field
Run simple and complex queries on json data
Use the json_modify function to alter a json structure to write to an azure sql database table
Summarize the key concepts covered in this course
IN THIS COURSE
-
2m 32sIn this video, we will discover the key concepts covered in this course. FREE ACCESS
-
12m 21sFind out how to enable change data capture (CDC) for a database and table using built-in procedures. FREE ACCESS
-
3. Viewing Tracked Changes10m 16sDuring this video, discover how to view change data capture and disable the feature. FREE ACCESS
-
4. Creating and Invoking Azure Functions11m 15sIn this video, you will learn how to configure and deploy a simple Azure Function to respond to an HTTP request. FREE ACCESS
-
5. Setting Up an Environment for Azure Functions10m 7sLearn how to set up the Visual Studio Code IDE to enable the development and deployment of an Azure Functions app. FREE ACCESS
-
6. Deploying and Testing an Azure Function9mIn this video, discover how to write a function that writes to Azure SQL Database and invoke that function. FREE ACCESS
-
7. Adding JSON Data to a Table9m 53sAfter completing this video, you will be able to create a table that can store JSON data as a field. FREE ACCESS
-
8. Querying JSON Data8m 35sIn this video, learn how to run simple and complex queries on JSON data. FREE ACCESS
-
9. Transforming JSON Data11m 6sUpon completion of this video, you will be able to use the JSON_MODIFY function to alter a JSON structure to write to an Azure SQL Database table. FREE ACCESS
-
10. Course Summary2m 50sIn this video, we will summarize the key concepts covered in this course. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
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.
