omgRawr Posted June 21, 2009 Share Posted June 21, 2009 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 More sharing options...
Synook Posted June 21, 2009 Share Posted June 21, 2009 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 More sharing options...
justsomeguy Posted June 22, 2009 Share Posted June 22, 2009 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.