1. What do you think is the most useful feature in SQL and why? Grouping, Joins, Sub-selects, something else?
I’ve only been introduced to this software within the past
few weeks so its hard to say. Joins are undoubtedly a fundamental aspect of working
with databases and it would be hard to imagine a functional and efficient
database software without some variant of the join operation.
2. What was the most difficult aspect of SQL language to learn? What makes it difficult?
Great question. So far, I have found that each individual function
in SQL is simple enough to learn. The tricky part seems to be pulling it all
together to form a complex select statement that solves the problem.
3. Can you think of a question you might want to ask of a database that would be difficult or impossible to do in SQL?
The views in SQL have limited functionality. It is generally
not possible to use the ‘order by’ clause in a view.
No comments:
Post a Comment