UNIT 7: Database Systems Fundamentals: Transactions, Concurrency Control, and Recovery Lesson 18: Database Transactions What I Learned About Transactions I learned that a transaction is a collec...

UNIT 6: Database Systems: Indexing, Query Processing, and Optimization Introduction In this blog post, I’ll share my understanding of three critical components that make databases efficient and p...

Unit 5: Normalization and Functional Dependencies Introduction to Good Relational Designs A good relational database design should have these key features: Relation for every entity ...

SQL Database Systems Fundamentals Introduction In this blog, I’ll be covering key concepts in SQL database systems, including joins, views, integrity constraints, data types, schemas, indexes, a...

Unit 3: SQL and Database Operations After completing Units 1 and 2, I now have a solid understanding of database concepts and the relational model. Unit 3 introduced SQL (Structured Query Languag...

Unit 2: Relational Model and Schema Design After finishing Unit 1, I felt I had a basic understanding of what databases are and why they are important. However, Unit 2 focused on the Relational M...