CST363 Week 6

 What I have learned this week

This week I learned how database programming bridges SQL with traditional languages like Java. I learned that languages generally fall into two categories: imperative, which execute step by step, and declarative, like SQL, which is more focused on outcome than process. Being declarative makes SQL optimal for things like databases.

We also explored Java Database Connectivity which enables Java to interact with relational databases using the MySQL Connector. I also learned the differences between Statement, PreparedStatement, and CallableStatement. In this lab I was able to successfully connect Java to MySQL and run queries. This gave a clearer picture of how APIs can be used to allow for Javas object oriented programming code to work alongside SQL's declarative language for use in databases.

Comments

Post a Comment

Popular posts from this blog

CST300 Week 2: Drafts and Peer Reviews

Image
Part 1. Review and Reflect Learning Strategy      The top 3 effective study skills that I am strong in are Surveying, Making and revising a schedule, and Recite. Anytime I am presented with a new set of coursework I carefully overview the material and create a study plan allocating the time that will be required to cover and review it.      The 3 I am weakest in are Outlining textbooks, Where to study, and reciting. For one, I don't typically mark on textbooks, I also typically study at my computer which can often lead to distraction if I'm not careful, and lastly I can sometimes find myself reading through a section without fully grasping what I just covered.   Part 2: Preview Time Management Skills Part 3: Project Management Basics     The three video presentations, Introduction to Project Management, A WNS Masterclass, and Project Management in Under 5, were all incredible resources in learns key aspects about project management. The ...
Read more

Week 4

  Part One: Set Your Educational Goals     I have always told myself that I want to continuously develop my skills as a developer. There is always more to learn and new avenues to explore. As far as a set in stone goal to achieve, completing my Bachelor's is first and foremost. Once I achieve that I can start focusing on other certifications that may be beneficial to my career. Part Two: Set Your Career Goals      For my career goal, I hope to one day be in the position to design software systems. I enjoy writing code, but its always been building more than just producing that has fascinated me the most. My ideal role would be as a Software Architect. As an architect more of my responsibilities would revolve around developing the overall structure and project design rather than just working on coding tasks.     Even beyond that, it is a dream of mine to open a game development studio. Much of my spare time is spent working on small personal p...
Read more

Interview With an Industry Expert

Introduction      Today I interviewed Hirokazu Tei, a friend of mine who currently works as a Senior Software Engineer at Snowflake, an AI cloud platform in Seattle. I selected Kaz because he is a very bright, successful software engineer who I have known for many years. With an impressive track record, having worked at companies like Nextdoor and Twitter, I knew he would be a great source of knowledge and could provide me with tips for a successful career in the tech world. Summary      Kaz told me that to guarantee a job as soon as possible I should search for internship opportunities. He explained that working within a company will teach me things that can't be learned in an academic setting. He mentioned that in recent months recruiters have been reaching out over Linkedin meaning that many see the end of the hiring freezes that companies have been experiencing. Additionally, if I am struggling to find an internship I should use my available time to wor...
Read more