From the course: Exploring Performance and Scale with Data Options in Azure
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
SQL Azure overview - Azure Tutorial
From the course: Exploring Performance and Scale with Data Options in Azure
SQL Azure overview
- [Instructor] The first thing we're going to talk about is working with relational data in the cloud. In Azure there's a number of different offerings, including the Azure SQL Database, SQL Server Managed Instances, as well as PostgreSQL, MariaDB, MySQL, as well as several third-party offerings. The key concept is that relational databases use the Structured Query Language, or SQL, some call it S-Q-L, that allows us to read, write, and update statements against the data in a consistent way. It also has the idea of transactional ACID, or the atomic, consistent, isolated, and durable transactions. We create the schema using a Data Definition Language, we got normalization, so we get to a single source of truth, but all of these have tables and defined relationships, and we design code using stored procedures and functions. And there's also the enforced data types, as well as referential integrity that the databases will…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.