In today's world, there's a ton of data that has to be reviewed and analyzed. Each individual transaction is meaningful unto itself, but the collection of data can show trends or metrix which may be very important to the decision making process needed for a successful business. The problem is that the end-user is in many cases responsible to manage their own data, because many IT depts don't have the manpower to do that task like they used. SQL, or structured query language has become an important tool in summarizing and analyzing data. The SQL language is used in many applications including: Access, SQL Server, Oracle , SAP , SAAS, and many others. It really has become critical for many people to learn this skill, so people can run their own queries, and get the information they are looking from the raw data.
Giving the output field a different name
Using Where statements to get the exact records you are looking for
Using Order By statements to sort the data
Creating Subtotals with the Group By statement
Introduction to joining tables together
The files mentioned in the video will be in the link that is included with the video.