• LOGIN
  • No products in the cart.

Design and query the databases behind every app: relational design and SQL with PostgreSQL and MySQL, then MongoDB and Mongoose, plus ORMs, indexing and choosing the right database.

Course Curriculum

1. Relational Databases
1.1 Tables, rows, keys and relationships 00:10:00
1.2 Database design and normalization 00:14:00
1.3 ER diagrams 00:09:00
2. SQL
2.1 SELECT, WHERE, ORDER BY 00:12:00
2.2 INSERT, UPDATE, DELETE 00:09:00
2.3 JOINs 00:14:00
2.4 GROUP BY and aggregate functions 00:12:00
2.5 Subqueries, views and transactions 00:12:00
2.6 Indexes and query performance 00:09:00
3. Databases in Node.js
3.1 PostgreSQL with Prisma ORM 00:14:00
3.2 Migrations and seeding 00:09:00
4. MongoDB
4.1 Documents, collections and when to use NoSQL 00:09:00
4.2 CRUD in MongoDB 00:10:00
4.3 Mongoose schemas, models and relations 00:14:00
4.4 Aggregation pipeline 00:12:00
4.5 Final project: database for an online store in SQL and MongoDB 00:22:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.