CST363: Week 8

 Final learning journal post for 363 Intro to Databases


Briefly summarize the 3 most important things learned from this course

1. One of the most immediately impactful things I've learned from this course was the advanced uses of SQL clauses to help refine a queries results. While I was aware of how to use SQL in the simple SELECT FROM WHERE format, expanding on this with the inclusion of things such as JOIN tables creates a more robust method for data retrieval and organization.


2. While I had known of SQL and its basic uses coming into this course, I gained a deeper understanding of the inner workings and design of relational databases. Learning how Schemas, Tuples, and Indexing is designed has strengthened my ability to write more efficient and optimized SQL queries. Not only does this information help in actively using SQL, but it also gives me insight on how to organize a databases properties when designing one so that it is efficient.


3. Learning the differences and advantages found between flexible (MongoDB) and structured (MySQL) databases has helped me grasp what situation each of them excel in. This not only will help me in future projects to ensure that the design of database I go with is optimal in what I will be using for, but also has me looking back at previous projects and thinking about how I could have improved on their design had I known what I know now.

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