SQL for Non-Technical Users

Focused View

Katie Kindred

35:54

28 View

01 introduction.mp4

02:45

02 best practices project.mp4

01:21

03 terms and syntax.mp4

03:14

04 the products table.mp4

01:32

05 importing data into sqlite online.mp4

01:56

06 price of a specific product.mp4

02:08

07 explaining unique ids.mp4

00:49

08 numerical modifiers.mp4

01:10

09 using order by.mp4

01:02

10 math using avg.mp4

03:04

11 math using profit.mp4

03:41

12 section 2 complete.mp4

00:19

13 the relational database.mp4

01:03

14 finding the order totals.mp4

02:56

15 finding item revenues.mp4

01:59

16 order profitability with group by.mp4

02:18

17 using like.mp4

01:35

18 using order dates.mp4

01:12

19 conclusion.mp4

01:50

SQL Class Student.zip

Description

Are you interested in databases but get overwhelmed by the technical language? Do you have a database that you constantly need your data team to help you get basic insights from? Are you a beginner looking for a simple way to dip your toes into SQL? Look no further, this is the class for you.

In this class, I will guide you through 3 sections:

Section 1: The What, Why, and How of SQL

Section 2: Using SQL with One Table

Section 3: Using SQL with a Relational Database

How is this class useful?

For small businesses: this will give you an introduction into how you can start leveraging your data to make impactful and informed business decisions.

For enterprise users: this can help you dive into the data your organization is already collecting and help support your IT staff. You can be empowered to pull data to create your own basic reports, and your IT team can keep focusing on higher value-added activities.

What You'll Learn?

Technology
Information Design
SQL
Analytics
SQLite
Data Science
Development Tools

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

SQL Server

Microsoft SQL

Katie Kindred

Instructor's Courses

I’m a creative.

I grew up doing Theatre and Choir. I love making things with my hands and performing for other people. I crave beautiful things that make me feel all of the emotions.

I’m a professional.

I grew up with a special place in my heart for Microsoft Office. I love getting into the nitty-gritty and practical side of things. I crave productivity tips that help me do things I care about.

I’m a creative professional.

I grew up anticipating school supply shopping season. I love using conditional formatting to make my spreadsheets colorful and functional. I crave new ways to better visualize and explain data.

I dream of a world where people feel wake up with stars in their eyes, spend their time doing things that matter, and go to sleep at night feeling safe and eager to do it all again the next morning.

This is why I created The Reverie Project, to inspire grateful hearts and authentic connections which will change the world.

So go– dream and do. They need each other, and we all do too.

SkillShare

View courses SkillShare

Skillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.