Jump to content

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


omgRawr
 Share

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...