CST363 Week 2



  • SQL has the flexibility to join tables on any column(s) using any predicate (=, >, < ). Most of the time the join will use equality between a primary and foreign key. Think of example where joining on something other than keys would be needed. Write the query both as an English sentence and in SQL. If you can't think of your own example, search the textbook or internet for an example.
An example of joining tables could be finding and listing games on a specific console that are developed by a specific studio (Rare). With one table for developers and another for all games on a specific console (GameCube).

select gc.game_title as GameCubeRareGame
from Games_GameCube gc 
join Developers d on gc.developer_id = d.developer_id 
where d.developer_name = 'Rare';
  • What is your opinion of SQL as a language? Do you think it is easy to learn and use? When translating from an English question to SQL, what kinds of questions do you find most challenging?
I am very happy with SQL. It feels like a language that is very easy to pick up and learn the basics of while having a great deal of flexibility that makes it useful for more advanced needs. Learning how to join tables and use sub queries as really opened my eyes to how flexible SQL can really be. I haven't had much issue with translation from English into SQL, its very intuitive.

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