YoVDO

SQL Server vs Azure Cosmos DB: Choosing the Right Database for Cloud Projects

Offered By: SQLBits via YouTube

Tags

Azure Cosmos DB Courses NoSQL Databases Courses Data Modeling Courses Database Migration Courses Stored Procedures Courses Cloud Databases Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Explore the key differences between SQL Server and Azure Cosmos DB in this 49-minute conference talk from SQLBits. Learn about partitioning strategies, query plan engines, data models, indexing, and performance tuning for both database systems. Discover how to choose the right database for legacy application migration or new cloud projects. Gain insights from Microsoft Data Platform MVP Hasan Savran on topics including stored procedures, triggers, pricing, change feed, and data modeling. Compare null and undefined handling, and understand the unique features of each database to make informed decisions for your cloud-based applications.

Syllabus

SQL Server vs Cosmos DB
PARTITIONING IN SQL SERVER
COSMOS DB LOGICAL PARTITION
QUERY PLAN ENGINE
AVAILABLE DATA MODELS
INDEXES
CONNECTIONS
SPROCS
TRIGGERS
PRICING
CHANGE FEED
PERFORMANCE TUNING
NULL & UNDEFINED
DATA MODELLING
WHICH ONE SHOULD I USE?


Taught by

SQLBits

Related Courses

Introduction to Data Science
University of Washington via Coursera Web Engineering II: Developing Mobile HTML5 Apps
Technische Hochschule Mittelhessen via iversity Cloud Computing Concepts, Part 1
University of Illinois at Urbana-Champaign via Coursera Cloud Computing Concepts: Part 2
University of Illinois at Urbana-Champaign via Coursera Fundamentals of database systems
Indian Institute of Technology Kanpur via Swayam