List of lectures for the course SQL, 26 quest level on JavaRush

Modeling Relationships Between Tables for Normalization
SQL SELF
26 level,0 lecture
Learn how to properly model relationships between tables in relational databases to achieve normalization. We'll look at the main types of relationships (1:1, 1:N, M:N), examples of how to implement them using foreign keys, and some practical tips for designing your database structure.
Open
Creating an ERD (Entity-Relationship Diagram)
SQL SELF
26 level,1 lecture
Find out what an ERD (Entity-Relationship Diagram) is, why you need it, what elements it consists of, and how to build one for different systems—from a library to an online store. Practical tips and examples for both beginners and experienced devs.
Open
Analyzing Existing Databases for Normal Form Compliance
SQL SELF
26 level,2 lecture
A step-by-step guide to analyzing database structure for normal form compliance, with examples and practical tips. Learn how to spot normalization issues and optimize your table structure for better integrity and performance.
Open
Balancing Normalization and Performance
SQL SELF
26 level,3 lecture
Learn how to find the sweet spot between strict data normalization and high query performance in relational databases. We'll check out examples when denormalization makes sense, and how to dodge the most common mistakes.
Open
Pros and Cons of Normalization
SQL SELF
26 level,4 lecture
Find out why data normalization is needed in databases, what its pros and cons are, and how it affects structure, performance, and how easy it is to work with data in practice.
Open