SQL for Beginners: Learn through 10 examples, data provided!

For non-technical students to learn how to write SQL, all class content provided so you can follow along!
4.4 (11 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
48 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 18
  • Length 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2016 English

Course Description

Interested in learning SQL? Not sure where to start? You've come to the right place! We are both analysts using SQL on a regular basis to extract and organize business-critical information. In this course, we'll cover what we consider to be core SQL knowledge to operate in a day-to-day business environment. After this course, you'll be able to extract and organize data (think joins, ordering, filtering) to gain meaningful insights, setting you up to become your company's in-house SQL wizard.

In this course, we will teach you the following:

  • Brief overview of key terms and concepts to get started with SQL
  • Basic-intermediate SQL syntax, through increasingly difficult examples
  • Plenty of further resources/references to become a true SQL ninja

*This course is an excellent resource for beginners to hit the ground running. Intermediate to advanced users should check other Udemy options, or return back when we release a more advanced option

What are the requirements?

  • You won't need any materials besides a computer and an internet connection. Everything can be downloaded from the course and I'll provide the free web link so you can follow along with me and practice your new skills later!

What am I going to get from this course?

  • Understand basics of SQL
  • Extract data from "database" using SQL
  • Understand basics of how SQL can be used to solve business problems

What is the target audience?

  • SQL course is designed for students with little to no experience working with data and using SQL to extract data.
  • Non-technical students
  • Aspiring data analysts
  • Recent college grads with no SQL experience
  • Job-seekers

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Welcome!
01:37

My background, high-level course offerings, and target audience.

03:18

In this lecture, we'll be going over how I will go through examples and which tools we'll be using.

Content for class can be access here:

https://drive.google.com/folderview?id=0B5ZGz-kmqkcQQ1FMTGxPRm9SLVE&usp=sharing

Section 2: Basics of SQL
01:52

In this lecture, we go over some common SQL use cases.

01:32

In this lecture, we go over the basic SQL query framework.

02:53

Continuation of the basic SQL query framework.

06:41

Here we're going to go over the components of SQL queries. 

Section 3: Examples 1-8
03:43

In this lecture, we go over a basic query.

01:59

This lecture goes over a basic query with multiple selected items.

02:26

Basic query using an aggregate function.

03:54

Basic query using ORDER BY

03:25

Basic query using WHERE and HAVING clauses.

11:21

Basic query using join.

05:16

Query using join, a little more complicated than Example 6.

07:03

Second part of a query using join that is a little more complicated than Example 6.

03:50

Query using string operand LIKE.

Section 4: Examples 9 & 10
11:08

Business example, uses Google Sheets to create bar chart.

06:28

Business example using functions not previously mentioned to format end result.

Section 5: Wrapping up
01:05

Further resources and my contact information!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Erik Rood, Analyst at Google

Hi! My name is Erik. I currently work as an analyst at Google. I have a strong interest in data visualization and analysis, so the content I publish here will be more or less related to that.

Feel free to reach out via email with any questions, hope you find the courses useful!

Instructor Biography

Crystal Wesnoski, Analyst at Pebble Tech

I'm a 2014 graduate of the University of Michigan, with my BS in Industrial and Operations Engineering. Upon graduation, I spent about 8 months at The Dow Chemical Company where I optimized chemical production on reactor assets. I am Pebble Tech as a Product Analyst. I also have created & manage a data-centric blog in efforts to learn some new tools for analysis and further refine my skills.


Ready to start learning?
Take This Course