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

Created by: Ben Osborn
Database administration and development

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

Requirements

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

Target audience

• Data Science beginners
• Someone curious to extend their data skills, perhaps used to working with Excel
• Programmers looking to add database capabilities to their applications
• Someone looking to enter the world of data analysis and machine learning