Week 25: CST 363 Week 8: Reflections on CST 363

    It has been a challenging yet rewarding course, where I’ve built a strong foundation in database theory, design, and practical implementation. Among the numerous concepts covered, three key takeaways stand out as the most significant learning experiences for me:

1. SQL and Complex Queries

    One of the most important things I learned in this course was the power of SQL. While I had some familiarity with basic SQL queries, CST 363 deepened my understanding by introducing advanced techniques. Working on the labs and assignments provided hands-on experience with real-world database scenarios, allowing me to write complex queries to retrieve and manipulate data efficiently. 

2. Database Design and Normalization

    Another critical takeaway was the importance of proper database design and normalization. Through chapters on database design and case studies, I learned how to create schemas that not only store data effectively but also prevent redundancy and ensure data integrity. 

3. Transaction Management and Data Integrity

    One of the most valuable concepts I learned in this course was the importance of transaction management and maintaining data integrity. Understanding how transactions work through concepts such as ACID (Atomicity, Consistency, Isolation, Durability) helped me appreciate how databases handle operations to ensure data reliability, even in the face of unexpected errors or system failures. 

    CST 363 has significantly improved my confidence in handling database systems, from designing efficient schemas to executing complex queries. The course also exposed me to the underlying concepts of transactions and data storage, giving me a solid grasp of how databases function at a deeper level.