This course is designed for those interested to learn the basics of the SQL language and the essential fundamentals of writing meaningful SQL queries to process raw data into meaningful information. Read more.
Tom Fragale is a computer professional w/over 30 years of experience. He is a Microsoft Certified Trainer. Available for webinars, Live Onsite Training and 1-on-1 training. He is also a published author with a book on Pivot Tables published by Wiley Publishing.
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout 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.
10 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 | ||
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.
10 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 | ||
Related Courses
Are you interested in higher education?
All Rights Reserved