SQL Server Developer : SELECT query foundations

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.