Week 6 - Weekly Reflection
Week 6 of CST363 offered many learning opportunities both in assigned reading and labs. While the reading gave the initial rundown on database connections, query execution, and the use of prepared statements through APIs like JDBC, the Java labs offered hands-on teaching moments that clarified how to use these concepts in practice. Working directly with JDBC to manage connections, execute SQL queries, and handle transactions worked wonders in solidifying the material. Experiencing Java interface with SQL through IntelliJ and MySQL Workbench additionally contextualized using Connections and using prepared statements to aid prevention of SQL injection attacks. The conceptual topics tackled in the reading are an aspect of computer science that I am always compelled to learn about--in this case it is the different programming paradigms when considering SQL in the context of application development. Qualifying the differences between imperative and declarative languages highlighted the challenges of bridging paradigm and syntax gaps between SQL and other more well-rounded programming languages. As with much of my database system learning so far, I require this two-pronged approach to fully grasp the mechanisms afoot. Reading provides the theoretical foundation and real comprehension arrives through applied work and debugging.
Comments
Post a Comment