0% completed

All LessonsFree Lessons (3)

Introduction to Databases

About This Course What Is a Database?Evolution of Database Systems Types of Databases

Database Models and Architecture

Data Models Overview Schema and Instance Three-Level Architecture Components of a DBMS Practice Exercises on Database Architecture

Relational Model

Fundamentals of Relations Keys in Relational Schema Integrity Constraints Codd’s 12 Rules Practice Exercises on the Relational Model

Entity-Relationship Modeling

ER Modeling Basics ER Diagram Creation Relationships and Cardinality Advanced ER Concepts Practice Exercises on ER Modeling

SQL Fundamentals

Introduction to SQL Data Definition Language ER to Relational Mapping Data Manipulation Language (DML)SELECT Queries Basics Working with NULLs and Expressions Set Operations Practice Exercises on SQL

Relational Algebra and Relational Calculus

Introduction to Relational Algebra Join Operations Tuple Relational Calculus Domain Relational Calculus Practice Exercises on Relational Algebra and TRC

Advanced Database Concepts

Joining Tables Aggregate Functions and Grouping Subqueries and Nested SELECTs Window Functions Conditional Logic in SQL Practice Exercises on Advanced SQL

Schema Design and Normalization

The Database Design Process Functional Dependencies Normal Forms BCNF and Beyond Denormalization and Performance Practice Exercises on Normalization

Transactions and Concurrency Control

Transactions and ACID Transaction Control in SQL Isolation Levels Locking Mechanisms Deadlocks and Concurrency Strategies Practice Exercises on ACID

Indexing and Query Optimization

Indexing Fundamentals Using EXPLAIN Plans Query Optimization Techniques Materialized Views and Caching Partitioning and Sharding Practice Exercises on Indexing and Query Optimization

NoSQL Databases Overview

Relational vs. NoSQL: Why NoSQL?

Modeling NoSQL Data

Querying in NoSQL Systems

Practice Exercises on NoSQL

Conclusion

Conclusion and Recap

Introduction to Modern Databases/

...

/

Practice Exercises on NoSQL

Practice Exercises on NoSQL

Test your understanding of this module with a few practice exercises.

We'll cover the following...

Problem 1

Insert a document for a customer named “Alice Johnson” with an email “alicej@example.com” and a customerTier of “New”.

MongoDB

// Write your code here

Problem 2

Write a query to find all customers whose CustomerTier is ...