SQL
About This Course
Structured Query Language (SQL) is the language we use to interact with databases that store data. This allows us to retrieve data with ease and simplicity.
This course will teach learners how to use the SQL language within Microsoft SQL Server, one of the most popular database engines in the world.
Learning Objectives
Complete literal SELECT statements.
Complete basic SELECT statements querying against a single table
Filter data using the WHERE clause
Sort data using the ORDER BY clause
Learn about database design and normalization
Using joins, return columns from multiple tables in the same query
Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
Complete SQL statements that use aggregate functions
Group data together using the GROUP BY clause
Filter groups of data using the HAVING clause
Target Audience
- Anyone who works with data, tables or databases.
Your Trainer
AD
