CST363 - Week 19

Most Useful SQL Feature

What do you think is the most useful feature in SQL and why?  Grouping, Joins, Sub-selects, something else? 

I think that grouping is the most useful feature in SQL. This function allows you to easily display columns for each category or object, which is a useful action that is frequently needed from a database. Using the grouping clause allows you to display meaningful output.

Most Difficult Aspect of SQL

What was the most difficult aspect of SQL language to learn? What makes it difficult?

The most difficult aspect of SQL is trying to translate what you want your script to do into the SQL language. You have to break it down in terms of each clause you want to incorporate. It's also tricky to decide how to formulate your statement by determining subqueries and keeping track of all the data. I think it's best to work part by part and build up the query while keeping in mind all of the relationships between all the tables of data.

Difficult SQL Question

Can you think of a question you might want to ask of a database that would be difficult or impossible to do in SQL? 

I'm not sure what would be difficult or impossible to do, but I would venture to guess that it would be hard to obtain and manipulate data from tables that either contain data that is unordered and unorganized or from tables that do not properly and meaningfully relate to each other.