SQL Server Developer : SELECT query foundations

Beginner querying and data analysis of Microsoft SQL server databases using the SELECT statement in T-SQL

What you’ll learn

  • Querying SQL server databases using the SELECT clause.
  • Joining multiple tables in different ways to combine information.
  • Filtering data to retrieve only the information you need.
  • Using aggregation functions and processes to find totals and averages for reports.

Course Content

  • Introduction –> 1 lecture • 3min.
  • Downloading and installing the required software and data –> 5 lectures • 20min.
  • SQL Server Management Studio Overview –> 2 lectures • 13min.
  • SQL Server SELECT query foundations –> 30 lectures • 2hr 18min.
  • Summary and final test –> 3 lectures • 25min.

Auto Draft

Requirements

  • Some knowledge of data reporting advantageous, but not necessary..

 

SQL Server SELECT query foundations aims to teach you the basics of retrieving data from the Microsoft SQL server database engine.

 

the course contains details on how to use the SELECT clause in the SQL server environment to query database tables and bring back data to present in reports or applications

 

This course is aimed at anyone looking to improve their understanding of database development, from data analysts looking to increase their skills on data querying, programmers looking to add database capabilities to their apps, or anyone who needs to get at the wealth of data contained in their companies’ database servers.

 

 

the course includes  lessons on :

 

  • Retrieving and combining columns from SQL server tables using the SELECT clause to define columns and functions to display to the end users.
  • Joining multiple tables in different ways to combine information. Using the FROM clause to specify which tables you want to connect to, and multiple JOIN clauses to connect tables to each other.
  • Filtering data to retrieve only the information you want. Using the WHERE clause to filter your data on one or multiple columns, and the ways to combine the WHERE clause with JOINs on your tables to efficiently retrieve information.
  • Using aggregate functions to GROUP BY information and find totals and averages of data to perform analysis and make reports

 

 

the course contains lessons on how to download and install all the tools you need to become proficient in coding SQL; I’ll take you through how you can download and install SQL server express edition, a free personal use version of SQL server, and the sample ‘AdventureWorks’ database so you can try out all the examples, and develop and test your own queries.

 

We’ll also download SQL Server Management Studio; your best interface into the database environment, and I’ll go through the basics of how to connect to Databases, and how to use the tool more efficiently.

 

I’ve included handouts with summaries and further information on some topics, as well as increasingly difficult review questions for you to try yourself. each set of questions is followed by a video analysis of the solutions and the different ways you could choose to solve them.

 

There’s also an end of course test that combines all the techniques you’ve learned into one final exam.