CST 363 - Module 2

 Week 2!

Something we worked with this week was the ability to join tables on any column. Normally, the join would use equality between the primary key and the foreign key. However, there are times where joining something other than keys would be necessary. For example, I can say I want to select the column "title" from the table "video_games" and the column "name" from the table "company" by joining where the "video_game" column "developer_company" is equal to the "company" column "name". In SQL, it would look like "SELECT video_game.title, company.name FROM video_game, company where video_game.title = company.name;". This would return the values of each column from both tables into one where the column values match.

So far, SQL is taking a bit of effort to get comfortable with. However, once I understand it, it is easy to use. Most of the time, the translation between English and SQL is smooth. However, when working with more specific cases like using outer, inner, left, right and natural join, the translation tends to be more different. An example of this being the fact that inner join does not mean literally join table from within a table, it means to select only matching columns from both tables being joined. 

Comments

Post a Comment

Popular posts from this blog

CST 300 - Module 4

Part 1 - Educational Goals This week's lecture readings in class have to do with setting goals. There are a few different types of goals to consider such as career, financial, family, artistic, attitude, physical, and public service. However, for now let's go over my educational goals. Some things I would particularly like to learn more about are software design and software engineering. I want to be able to create more professional applications to be an important member of any team I may join in the work field. To be more general, I would like to pass all of my classes with a grade higher than a C as I think they all are useful to know, especially for some of the things I want to do in the far future. Part 2 - Career Goals Another type of goal I should talk about is my career goal. Overall, I would like to have enough experience in working with the game development industry. There are a few levels to this goal, one is I would like to work with a company that develops games suc
Read more

CST 300 - Module 2

Image
Part 1 - Review and Reflect Learning Strategy After reading a paper on effective study skills by Dr. Bob Kizlik, I have come to realize there are more aspects of studying than I realized, and I do follow a large amount of them. However, there are also some aspects in which I struggle with that I have noticed, especially recently when it comes to reading. Although, to save your time, I will talk about the top 3 aspects I believe I am good at, and the top 3 I am bad at. One thing I am good at is taking notes. Especially in the digital age we are in, there are many ways to take notes, for me I separate my notes by module and assignment using google docs. Another is getting the main idea in a reading, also allowing me to take notes to reflect on later, instead of re-reading an entire segment of an essay or book. Finally, I feel I am also adept at surveying, to get an idea of what I'm going to study, before I actually study. However, some things I need to work on is to actually read bec
Read more

CST 300 - Module 3

Hello Everyone, Part 1 Last week I mentioned the areas in studying I need to work on such as paying attention to what I am reading, and to stick to a schedule as I often lose focus and prolong assignments. So, after visiting AcademicTips.org, I took some notes on concentration. Some things I am trying to do differently is to further avoid any distractions and to keep focus on my studies by taking breaks less often but do something that needs to be done other than just daydreaming, such as using the time to eat. Part 2 This week’s class module covered quite a bit of material. The readings covered topics such as the Code of Integrity for CSUMB CS Online, going over the rules of what should and should not be done when submitting any work or assisting/receiving assistance. Code of Ethics, as one may expect, be honest, avoid harm, maintain high standards, be professional, and many more aspects of what it is to be ethical in one’s work. This module puts an emphasis on ethics as it is the ma
Read more