SQL for Non-Programmers

Focused View

Julianne Thouin

1:30:25

72 View

01 - Introduction

01 - How can SQL answer your data questions.mp4

00:55

02 - Introduction to SQL Server and Relational Database Concepts

01 - What is SQL Server.mp4

02:55

02 - Understanding servers, databases, and tables.mp4

04:30

03 - Relational database concepts.mp4

04:11

04 - Surrogate, primary, and foreign keys.mp4

02:33

03 - Single Table Select Statements

01 - SQL data types and nullability.mp4

02:55

02 - Reading from a single table in SQL.mp4

05:47

03 - Filtering on a single condition in SQL.mp4

10:11

04 - Filtering on multiple conditions in SQL.mp4

07:13

04 - Multiple Table Select Statements

01 - Inner joins.mp4

05:53

02 - Multiple inner joins.mp4

03:04

03 - Outer joins.mp4

05:10

04 - Subqueries.mp4

05:16

05 - Additional SQL Query Tools

01 - Case statements.mp4

09:09

02 - Built-in functions.mp4

11:17

03 - Aggregates.mp4

04:14

04 - Query processing order.mp4

04:24

06 - Conclusion

01 - Next steps.mp4

00:48

Exercise Files

Ex_Files_SQL_Non_Programmers.zip

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Julianne Thouin

Instructor's Courses

Experienced Database Engineer with a demonstrated history of working in the computer software industry. Skilled in Performance Tuning, Requirements Analysis, Stored Procedures, Engineering, and Programming. Strong information technology professional with a Master of Arts - MA focused in Children's and Adolescent Literature from Simmons University.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.