Back to Web Development

Databases

Learn how to store and manage application data using both relational (SQL) and non-relational (NoSQL) databases.

3 weeks

Topics in this Chapter

1

Relational: MySQL/PostgreSQL

Understand the principles of relational databases and learn basic SQL queries with systems like MySQL or PostgreSQL.

2

NoSQL: MongoDB

Explore the world of NoSQL with MongoDB, a document-oriented database that stores data in flexible, JSON-like documents.

3

Schema Design

Learn the fundamentals of designing database schemas for both relational (normalization) and NoSQL (embedding vs referencing) databases.

4

Queries

Practice writing queries to create, read, update, and delete (CRUD) data in both SQL and MongoDB.

5

Indexing

Learn how database indexes work and how to use them to dramatically improve the performance of your queries.

GeekDost - Roadmaps & Snippets for Developers