SQL for Non-Programmers

SQL for Non-Programmers

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 30m | 275 MB

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.
+ Table of Contents

1 How can SQL answer your data questions
2 What is SQL Server
3 Understanding servers, databases, and tables
4 Relational database concepts
5 Surrogate, primary, and foreign keys
6 SQL data types and nullability
7 Reading from a single table in SQL
8 Filtering on a single condition in SQL
9 Filtering on multiple conditions in SQL
10 Inner joins
11 Multiple inner joins
12 Outer joins
13 Subqueries
14 Case statements
15 Built-in functions
16 Aggregates
17 Query processing order
18 Next steps