Release Name : Linkedin.Learning.SQL.Non-Programmers-QUiD

Publisher    : Linkedin
Release Date : 2021-01-12
Size         : 19 x 15MB
Url          : https://www.lynda.com/SQL-tutorials/SQL-Non-Programmers/2864257-2.html

Release Info:
Do you want to learn about SQL but aren’t sure where to start? In this beginner-level
course, instructor Julianne Thouin covers basic concepts of relational database design
and explains how to write simple SELECT statements using joins and proper filtering.
Julianne explains what SQL Server is and what it is used for. Next, she shows how tables
in a relational database relate to one another through surrogate, primary, and foreign
keys. Julianne teaches you how to tackle the most basic query possible. She explains how
AND and OR logic applies to filtering queries on more than one data point, then discusses
INNER joins and OUTER joins. Julianne covers how to use subqueries for filtering your
results. She walks you through some commonly used examples of built-in functions. In
conclusion, Julianne shows you how aggregate functions work using the GROUP BY and HAVING
clauses.

- Unpack
- Open the tutorial
- Enjoy