sql final journal

Throughout this course, I’ve learned how powerful and structured SQL really is when it comes to managing and organizing data. The three most important things I learned are how to design databases properly, how to write and understand complex SQL queries, and how databases maintain data integrity and performance behind the scenes.

The first major thing I learned was database design. I now understand how to use CREATE TABLE statements, define primary and foreign keys, and build relationships like one-to-many or many-to-many. Learning about normalization and entity-relationship (E-R) diagrams showed me how to organize data efficiently, avoid redundancy, and make sure every table serves a clear purpose in the overall schema.

The second thing I found essential was writing advanced SQL queries. I learned how to use SELECT statements with joins, grouping, and functions like SUM, COUNT, AVG, and MAX. Understanding the difference between WHERE and HAVING clauses, as well as how to use subqueries, CTEs, and views, helped me see how SQL can handle everything from simple lookups to complex data analysis. Learning INSERT, UPDATE, and DELETE also gave me confidence in managing data effectively.

Finally, I learned how databases maintain integrity and performance. Concepts like transactions, ACID properties, isolation levels, deadlocks, and recovery logs helped me understand how databases keep data consistent and reliable, even when multiple users are working at once. I also learned how indexes and their structure (including fan-out and multi-level indexing) improve query speed and performance.

Overall, this class gave me a strong foundation in both the logic and structure behind databases. I not only learned how to write correct SQL code, but also why good database design and management matter so much in the real world.