SQL 101 - Beginner to Expert Level Course

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 matrices 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 for managing 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 for from the raw data.

Topics Include:

• Select statements.
• Giving the output field a different name.
• Use Where statements to get the exact records you are looking for.
• Order By statements are used 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.