Three Most Important Things I Learned in CST363-30: Intro to Database Systems

In CST363-30: Intro to Database Systems, I learned many new concepts that changed the way I think about data and software development. The first important thing I learned was how relational databases like MySQL work. I now understand how to create tables, define primary and foreign keys, and use SQL commands such as SELECT, INSERT, UPDATE, and DELETE to manage data. Learning how to design databases using Entity-Relationship (ER) diagrams and normalization helped me see how organized structures reduce redundancy and improve data accuracy. This part of the course gave me a strong foundation for understanding how information is stored and related inside real business systems.

The second major thing I learned was how to connect databases with Java using JDBC. This skill showed me how programming languages interact with databases to build full applications. I practiced writing Java programs that could add, read, or update data in a MySQL database, and I learned how to handle transactions with commit and rollback. It made me realize the importance of managing errors and keeping data consistent. This connection between SQL and Java helped me understand how backend systems work in real projects, which is valuable for my goal of becoming a software engineer.

The third important lesson was learning about NoSQL databases like MongoDB. Unlike MySQL, MongoDB stores data as flexible JSON-like documents, which makes it easier to adapt when data changes. Through the labs, I saw how MongoDB is useful for modern applications such as e-commerce or social media platforms where data does not always fit into strict tables. Comparing MySQL and MongoDB helped me understand when to use each type—MySQL for structured, consistent data, and MongoDB for fast and flexible development.

Overall, this course gave me both technical skills and problem-solving experience. I learned not only how to store and retrieve data, but also how to design efficient systems that keep information reliable. These lessons connect directly to my future goals in software engineering and cybersecurity, where understanding how data is organized, secured, and accessed is essential. I feel more confident now in building applications that use databases effectively and in continuing to explore advanced topics like performance tuning, indexing, and large-scale data management.