Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add SQL for Beginners: Learn through 10 examples, data provided! to your Wishlist.

Add to Wishlist

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.3 (10 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.
51 students enrolled
Last updated 3/2016
English
$10 $25 60% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Understand basics of SQL
Extract data from "database" using SQL
Understand basics of how SQL can be used to solve business problems
View Curriculum
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!
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

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 18 Lectures Collapse All 18 Lectures 01:19:31
+
Welcome!
2 Lectures 04:55

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

Preview 01:37

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

Preview 03:18
+
Basics of SQL
4 Lectures 12:58

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

Preview 01:52

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

Preview 01:32

Continuation of the basic SQL query framework.

Preview 02:53

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

Components of a query
06:41
+
Examples 1-8
9 Lectures 42:57

In this lecture, we go over a basic query.

Example 1 - Basic query 1.0
03:43

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

Example 2 - Basic query 2.0
01:59

Basic query using an aggregate function.

Example 3 - Basic query with aggregate function
02:26

Basic query using ORDER BY

Example 4 - Query using ORDER BY
03:54

Basic query using WHERE and HAVING clauses.

Example 5 - Query using WHERE and HAVING
03:25

Basic query using join.

Example 6 - Query using JOIN
11:21

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

Example 7 - Query using JOIN (a little more complicated) Part 1
05:16

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

Example 7 - Query using JOIN (a little more complicated) Part 2
07:03

Query using string operand LIKE.

Example 8 - Query using LIKE
03:50
+
Examples 9 & 10
2 Lectures 17:36

Business example, uses Google Sheets to create bar chart.

Example 9
11:08

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

Example 10
06:28
+
Wrapping up
1 Lecture 01:05

Further resources and my contact information!

Wrap up
01:05
About the Instructor
4.1 Average rating
140 Reviews
1,554 Students
5 Courses
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!

4.4 Average rating
14 Reviews
71 Students
2 Courses
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.


Report Abuse