SQL Server Developer : SELECT query foundations

About this course

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 applicationsThis 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 reportsthe 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

Course objectives

• to teach the basics of querying data from SQL Server
• to provide practical skills in using SQL for database development