Jump to content

There's So Many Features In Sql, But I'm Rarely Using Them


omgRawr

Recommended Posts

After creating dynamic web-based applications for a while, I've realized that I rarely use the more advanced SQL features. Most of my SQL code only involves inserting, retrieving, updating and deleting rows from a database, so other features such as GROUP BY, LEFT/RIGHT/INNER JOIN, CREATE INDEX are rarely used. Does anyone feel the same away? I really do want to learn more about SQL, but the problem is that I'm assuming that I'll never use these features unless I get a job that involves interacting with databases.

Link to comment
Share on other sites

Don't worry, there are tons of features that are hardly used - when you need them you'll know.

Link to comment
Share on other sites

For web applications, most of the things like joins and grouping are used for reports. Nearly every "normal" page will either write data to the database, or read data from it. The reports that aggregate everything are where you would use the more advanced statements to look at all of the data in various ways. Reports usually show the big picture instead of discrete pieces of data.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...