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.
- 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.
|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|