CST-363 Week 2

 

  1. 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.
    1. You want a combination of ingredients to create a food item. Ex: SELECT f.name, i.amount, i.name FROM food f CROSS JOIN ingredient i;
  2. 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?
    1. I think SQL is not very difficult to learn. Some of the more challenging questions are ones that involve multiple JOIN statements, which may be a bit more difficult to think of an abstract solution.

Comments

Post a Comment

Popular posts from this blog

Week 4

Part 1 Educational Goals. My main educational goal is to achieve my bachelor's degree in computer science in 2 years. Another educational goal of mine is to do well in my upper division classes so I can be prepared for a career in software development. I would also like to strengthen my collaboration skills through the use of group projects.  Part 2 Career Goals. One of my main career goals is to become a professional software developer after graduation. I hope to leverage my current internship as an Android developer to find a new internship next summer, so I can explore different fields in software development. Part 3 Guess ETS percentile. If I had to guess, I think I would be in the 70th percentile. I feel pretty comfortable with programming, but I think I would struggle more with the theory-based questions and would have to review my notes from discrete/data structures beforehand.  Part 4 Learning Journal.  Writing material:  For my Ethics essay, I will need to c...
Read more

CST-363 Week 1

  Relational database tables and spreadsheets look similar with both having rows and columns.  What are some important differences between the two? One of the biggest differences is that relational databases can be restored on failures. Relational databases also use SQL to retrieve and insert data. 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?  Databases force data integrity and ensure it is consistent across programs. Databases can also restrict data to a program based on security rules. Databases can reduce redundancy and inconsistency.  What do you want to learn in this course that you think will be useful in your future career?  I think I would like to learn how to translate English into valid SQL queries/maybe accessing databases asynchronously as practically every company will have a...
Read more

Week 9

 Codingbat questions Did you plan it out or throw code at it?  I gave it a few seconds of thought before throwing code at it What worked? Java methods were pretty easy to understand coming from C++ and Kotlin. What DID NOT work? Some of the methods involving indexes through me off sometimes, as it is easier to visualize by writing down your steps to the solution than it is trying to do it in your head. (same with some of the problems involving edge cases) How many tries did it take?  Most only took 1-3 tries.
Read more