When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Development
SkillShare logo

SQL for Non-Technical Users

Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.

     0 |
  • Reviews ( 0 )
Free
SQL for Non-Technical Users

Related Courses

This Course Includes

  • iconskillshare
  • icon0 (0 reviews )
  • icon35 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconSkillShare

About SQL for Non-Technical Users

Introduction

Best Practices + Project

Terms and Syntax

The PRODUCTS Table

Importing Data into SQLite Online

Price of a Specific Product

Explaining Unique IDs

Numerical Modifiers

Using ORDER BY

Math: Using AVG

Math: Using Profit

Section 2 Complete!

The Relational Database

Finding the Order Totals

Finding Item Revenues

Order Profitability with GROUP BY

Using LIKE

Using Order Dates

Conclusion

What You Will Learn?

  • 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. .