Please ensure Javascript is enabled for purposes of website accessibility

About This Course

In today’s hectic world, we are presented with tons of raw data that we need to process into meaningful information. What used to be the job of the IT Department is now delegated to the end user. Many databases use the SQL language to query the data so you can get the exact data that you need.

This course will show the important fundamentals that you need to start writing meaningful queries using the SQL language. It includes a file that will create the sample database in an SQL Server environment, and all of the scripts are included as well.

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

Our Promise to You

By the end of this course, you will have learned how to write SQL queries.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about SQL.

Course Curriculum

Section 1 - Writing Queries
Unzipping The Sample Files 00:00:00
Creating The Sample Database 00:00:00
Basic Select Statements 00:00:00
Sorting The Query With The Order By Statement 00:00:00
Using The Where Statement To Filter The Query 00:00:00
Creating Subtotals Using The Group By Statement 00:00:00
Introduction To Using The Join Statement To Create Queries From More Than One Table 00:00:00
top
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel