The Basic, Standard, and Premium service tiers fulfill a lot of customers’ needs.

For some customers, though, the General Purpose, Business Critical, and Hyperscale service tiers offer additional performance and ability that is required for certain workloads.

Even if you don’t require those abilities, the technology and infrastructure behind these are worth learning.

In this episode with Matt Gordon, we’ll discuss those service tiers as well as discussing the differences between Provisioned and Serverless deployments on the General Purpose tier. Come learn how to ramp up your Azure SQL Database experience!

Resources:

This database design course by Caleb Curry will help you understand database concepts and give you a deeper grasp of database design.

Contents / Time stamps:

⌨️ (0:00:00) Introduction
⌨️ (0:03:12) What is a Database?
⌨️ (0:11:04) What is a Relational Database?
⌨️ (0:23:42) RDBMS
⌨️ (0:37:32) Introduction to SQL
⌨️ (0:44:01) Naming Conventions
⌨️ (0:47:16) What is Database Design?
⌨️ (1:00:26) Data Integrity
⌨️ (1:13:28) Database Terms
⌨️ (1:28:28) More Database Terms
⌨️ (1:38:46) Atomic Values
⌨️ (1:44:25) Relationships
⌨️ (1:50:35) One-to-One Relationships
⌨️ (1:53:45) One-to-Many Relationships
⌨️ (1:57:50) Many-to-Many Relationships
⌨️ (2:02:24) Designing One-to-One Relationships
⌨️ (2:13:40) Designing One-to-Many Relationships
⌨️ (2:23:50) Parent Tables and Child Tables
⌨️ (2:30:42) Designing Many-to-Many Relationships
⌨️ (2:46:23) Summary of Relationships
⌨️ (2:54:42) Introduction to Keys
⌨️ (3:07:24) Primary Key Index
⌨️ (3:13:42) Look up Table
⌨️ (3:30:19) Superkey and Candidate Key
⌨️ (3:48:59) Primary Key and Alternate Key
⌨️ (3:56:34) Surrogate Key and Natural Key
⌨️ (4:03:43) Should I use Surrogate Keys or Natural Keys?
⌨️ (4:13:07) Foreign Key
⌨️ (4:25:15) NOT NULL Foreign Key
⌨️ (4:38:17) Foreign Key Constraints
⌨️ (4:49:50) Simple Key, Composite Key, Compound Key
⌨️ (5:01:54) Review and Key Points….HA GET IT? KEY points!
⌨️ (5:10:28) Introduction to Entity Relationship Modeling
⌨️ (5:17:34) Cardinality
⌨️ (5:24:41) Modality
⌨️ (5:35:14) Introduction to Database Normalization
⌨️ (5:39:48) 1NF (First Normal Form of Database Normalization)
⌨️ (5:46:34) 2NF (Second Normal Form of Database Normalization)
⌨️ (5:55:00) 3NF (Third Normal Form of Database Normalization)
⌨️ (6:01:12) Indexes (Clustered, Nonclustered, Composite Index)
⌨️ (6:14:36) Data Types
⌨️ (6:25:55) Introduction to Joins
⌨️ (6:39:23) Inner Join
⌨️ (6:54:48) Inner Join on 3 Tables
⌨️ (7:07:41) Inner Join on 3 Tables (Example)
⌨️ (7:23:53) Introduction to Outer Joins
⌨️ (7:29:46) Right Outer Join
⌨️ (7:35:33) JOIN with NOT NULL Columns
⌨️ (7:42:40) Outer Join Across 3 Tables
⌨️ (7:48:24) Alias
⌨️ (7:52:13) Self Join

Learn about seven different database paradigms and what they do best.

Contents:

  • 00:00 Intro
  • 00:45 Key-value
  • 01:48 Wide Column
  • 02:47 Document
  • 04:05 Relational
  • 06:21 Graph
  • 07:22 Search Engine
  • 08:27 Multi-model

Data modeling is the process of establishing patterns and rules for how data is stored in database documents and containers and how it is accessed.

You can significantly improve speed and performance of Azure Cosmos DB – especially for your most frequent queries – by choosing the data model that best fits the needs of your application.

In less than two minutes, learn about the key considerations for choosing the right data model, the differences between embedding and referencing data, and how the Azure Cosmos DB change feed can eliminate data duplication.

For more on data modeling, visit:

Gaurav Sen explains NoSQL databases in this introductory video.

NoSQL is a popular database storage method. It keeps data as key value pairs. The advantages and disadvantages of NoSQL compared with RDBMS (which uses SQL) are discussed here, using the Cassandra architecture as an example.

Video index:

  • 1:08 NoSQL explanation and comparison
  • 10:27 Cassandra Architecture
  • 18:00 Quorum
  • 21:30 Compaction of SST tables

Discover ways to troubleshoot and optimize queries in Azure Cosmos DB using the Core (SQL) API. Program Manager Tim Sander demonstrates.

Content Index

  • 0:30 Request Units (database throughput capacity)
  • 3:30 Including necessary paths
  • 8:30 Optimizing ORDER BY queries
  • 11:30 Optimizing JOINs
  • 13:15 Avoiding cross-partition queries

Get started:

In this video, discover the unique capabilities and features of Azure Cosmos DB, a fully managed #NoSQL database system for scalable and real-time applications.

Product Manager Andrew Liu leads a demo of the key features and then shares common use cases and app scenarios. This includes, real-time IoT telemetry, personalized recommendations, how customers use Azure Cosmos DB most often, the top four things you should know before you start, and resources to help you.

Databricks recently streamed this tech chat on SCD, or Slowly Changing Dimensions.

We will discuss a popular online analytics processing (OLAP) fundamental – slowly changing dimensions (SCD) – specifically Type-2.

As we have discussed in various other Delta Lake tech talks, the reliability brought to data lakes by Delta Lake has brought a resurgence of many of the data warehousing fundamentals such as Change Data Capture in data lakes.

Type 2 SCD within data warehousing allows you to keep track of both the history and current data over time. We will discuss how to apply these concepts to your data lake within the context of the market segmentation of a climbing eCommerce site.