SQL Server Developer : SELECT query foundations

Learn how to use SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER in SQL Server to retrieve and analyse data

Ratings 4.51 / 5.00

SQL Server Developer : SELECT query foundations

What You Will 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

Description

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.