Tutorialspoint

SQL 101

Learn how to create queries in SQL

Course Description

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.

Topics Include:

  • Select statements
  • 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.

Goals

  • Learn SQL
Show More

Curriculum

Feedbacks
  • No Feedbacks Posted Yet..!
SQL 101
This Course Includes
  • 1 hours
  • 2 Lectures
  • 1 Resources
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate