SQL for Non-Programmers

Focused View

Christina Stathopoulos, MSc

2:50:58

19 View

01 - Introduction

01 - Intro Why SQL and why nnow.mp4

00:51

02 - What you should know.mp4

04:48

03 - Set up with SQLite and SQLiteStudio.mp4

05:01

02 - 1. Getting Started with Relational Databases, SQL, and DQL

01 - Relational databases.mp4

02:48

02 - Database structuring through normalization.mp4

03:47

03 - The power of SQL.mp4

03:12

04 - DQL for all.mp4

03:01

03 - 2. Basic Commands

01 - Getting started with SQL.mp4

05:33

02 - Retrieving data with SELECT.mp4

07:19

03 - Formatting your query.mp4

05:40

04 - Putting order to your data with ORDER BY.mp4

06:52

05 - Filtering your data with WHERE.mp4

05:09

06 - Filtering your data with multiple conditions.mp4

08:05

07 - Challenge Practice with basic commands.mp4

01:40

08 - Solution Basic commands solved.mp4

04:09

04 - 3. Aggregate Functions

01 - Getting started with aggregate functions.mp4

06:59

02 - Making aggregate functions work for you.mp4

05:35

03 - Group data using GROUP BY.mp4

06:26

04 - Filter on groups of data with HAVING.mp4

04:36

05 - Challenge Practice with aggregate functions.mp4

01:38

06 - Solution Aggregate functions solved.mp4

05:06

05 - 4. Multiple Table Joins

01 - Combining tables with an Equijoin.mp4

06:58

02 - From Equijoins to Inner Joins.mp4

07:34

03 - Other types of SQL joins.mp4

03:51

04 - Challenge Practice with multiple table joins.mp4

00:56

05 - Solution Multiple table joins solved.mp4

05:35

06 - 5. Advanced Commands

01 - Categorize data with CASE.mp4

08:51

02 - Beyond basic CASE statements.mp4

07:09

03 - Creating Calculated Fields.mp4

07:33

04 - Matching data with wildcards.mp4

07:57

05 - Combining data with UNION.mp4

06:57

06 - Challenge Practice with advanced commands.mp4

02:01

07 - Solution Advanced commands solved.mp4

06:10

07 - 6. Conclusion

01 - Recommendations and next steps.mp4

01:11

Description

New technologies allow data to be shared, accessed, and analyzed more easily than ever before, even by non-data science professionals. Regardless of your industry, technical background, or current role, you can now leverage data to make better business decisions with the easy-to-use SQL Data Query Language. This course covers some of the most basic, fundamental SQL commands for non-programmers and non-data science professionals.

Join instructor Christina Stathopoulos as she demonstrates the skills required to independently and confidently access and analyze your data, utilizing key commands, functions, and joins such as SELECT, ORDER BY, WHERE, GROUP BY, HAVING, CASE, wildcards, UNION, and more. Along the way, test out your new skills in the exercise challenges at the end of each section.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Computer Network

Network Engineering

Christina Stathopoulos, MSc

Instructor's Courses

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.