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
No Reviews found for this course.






Up Academy Web Development Team