09. SQL, Part 2, Database Design (Java Enterprise - Complete Course)
All my courses: https://javaguru.by
Microservices and Employment: https://javaguru.by/developer
Analysis of tasks, tests, and interview questions: https://t.me/javaguru_by
We'll cover approaches to designing a data model for a PostgreSQL-based application and more complex SQL capabilities.
00:00 Database Normalization
05:32 OneToMany
07:10 OneToOne
07:31 ManyToMany
08:55 Practice. Preparing test data.
11:48 JOIN
14:00 INNER JOIN
18:15 CROSS JOIN
19:38 LEFT JOIN
22:07 Visual comparison of different JOINs
24:13 RIGHT JOIN
24:49 FULL JOIN
25:13 GROUP BY, HAVING
27:38 ALTER
30:11 What else can you learn?
33:00 Assignments