Master normalization to improve relational database design by eliminating repeating groups and data duplication. Decompose tables through first to third normal forms and BCNF to enhance data integrity.

Learn how to insert data into a table and retrieve it with select statements, using insert into with column lists or without, and understand column order and primary key uniqueness.

Explore how int and decimal define column values, how precision and scale work, and how char and varchar handle text, quotes, and storage in relational databases.

Explore single table select statements, using aliases for computations, apply where filtering, distinct values, and order by sorting, with practical examples in Oracle Live SQL.

Explore the where clause in select, delete, and update statements, applying filtering conditions with comparison and logical operators. Learn between...and, inclusive bounds, and common pitfalls with examples.

Learn how to use where with in and subqueries, properly quote each value with single quotes, and apply all and any with aggregates to compare against subquery results.

Learn how to apply where and having filters in a group by, distinguish original table vs aggregated data, and follow the execution order with sum aggregations.