What is denormalization and when to use it
· SQL & Databases
Learn when to intentionally introduce redundancy to improve read performance in relational databases.
Category: SQL & Databases
60 questions in SQL & Databases.
What is database normalization
· SQL & Databases
Eliminate redundancy and improve data integrity with the normal forms of database design.
How to choose data types for columns
· SQL & Databases
Select efficient and appropriate data types for columns based on domain, size, precision, and performance.
What are database relationships
· SQL & Databases
Understand the three fundamental database relationships and how they shape schema design.
How to model many to many relationships
· SQL & Databases
Implement many-to-many relationships in relational databases using junction tables and composite keys.
What is the difference between primary key and foreign key
· SQL & Databases
Compare primary keys and foreign keys and understand their roles in uniquely identifying rows and linking tables.
What are database constraints
· SQL & Databases
Enforce rules at the database level using constraints to maintain valid and consistent data.
How to design ER diagrams
· SQL & Databases
Model entities, attributes, and relationships visually using Entity-Relationship diagrams before building schemas.
What is database normalization
· SQL & Databases
Understand normalization forms and how they reduce redundancy and improve data integrity in relational databases.
What is query optimization in SQL
· SQL & Databases
Improve SQL query performance using execution plans, indexing strategies, and query rewriting techniques.