CST363 Week 1


  • Relational database tables and spreadsheets look similar with both having rows and columns. What are some important differences between the two?
Relational databases use a schema which defines the structure for how the data is stored. Relational databases also use foreign and primary keys to help manage data. Relational databases also can query which allows a user to search for data on tables efficiently.
  • Installing and configuration a database and learning how to use it is more complicated that just reading and writing data to a file. What are some important reasons that makes a database a useful investment of time?
Relational databases can help with efficient searching by using the query system and indexing. They also provide more safety to guarantee data is not manipulated in error or stored incorrectly.
  • What do you want to learn in this course that you think will be useful in your future career?
Becoming proficient in database manipulation is infinitely useful for a career in development. Basic knowledge in SQL is required for just about every software development role. I am excited to be advance my skills 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