SQL Fundamentals for Excel Users
4.6 (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.
81 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Fundamentals for Excel Users to your Wishlist.

Add to Wishlist

SQL Fundamentals for Excel Users

A Simple Step-By-Step Introduction to SQL using Excel
4.6 (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.
81 students enrolled
Created by Lukas Halim
Last updated 9/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 8 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand how functions tasks you're used to performing in Excel can be performed with SQL
  • Create queries using SELECT the statement
  • Aggregate data with SUM, AVG, MIN, MAX and the GROUP BY clause
  • Filter data with the WHERE clause
  • Find unique values using the DISTINCT keyword
  • Combine tables using the INNER JOIN and LEFT JOIN
  • Combine select statements using the UNION clause
View Curriculum
Requirements
  • You should be comfortable with Excel
  • You need to have Excel for Windows rather than Excel for Mac
Description

Companies in every industry are looking to make better use of their data. Much of the data analysis is done in spreadsheets, with Excel and similar applications, but spreadsheets don't work that well with larger and more complex data. In those cases, a SQL database (Oracle, MySQL, Microsoft SQL Server, Teradata, or PostgreSQL) is usually the best solution.

So if you'd like to expand your data analysis skill set and be able to work with larger more complex data you need to learn SQL.

Please note that the software will not work on macs, only on Windows.

Who is the target audience?
  • This course is for those who know how to analyze data using Excel, but have not yet learned SQL.
Compare to Other SQL Courses
Curriculum For This Course
30 Lectures
01:37:30
+
Start Here
6 Lectures 09:08


The Data
00:06


Hands-on Query Question
1 question

Hands-on Query Solution
00:30

QueryStorm Troubleshooting
00:11
+
High-Level Comparison of Excel and SQL
1 Lecture 07:01

Quiz on Comparison of Excel and SQL functions
3 questions
+
The SELECT Statement
4 Lectures 15:11
Select * From TableName
03:19

Hands-on Select * question
1 question

SELECT column_name,column_name FROM table_name
03:28

How many columns are returned by the following query:

SELECT Runner,[Race Id],*
FROM RaceTimes

Hands-on Select column_name,column_name question
1 question

Select Distinct
05:05

Hands-on Select Distinct question
1 question

Select count(*) from TableName
03:19

Select Review Quiz
3 questions
+
The WHERE Clause
8 Lectures 27:11
WHERE column_name = value
03:29

Hands-on where column_name = value question
1 question

Using AND in the where clause
03:29


Hands-on And question
1 question

Using OR in the where clause
03:42

OR question
1 question

WHERE column_name in (value, value)
02:20

Hands-on IN question
1 question

WHERE column_name like value
04:17

LIKE Quiz
1 question

WHERE column_name IS NULL
02:15

IS Null Quiz
1 question

Less Than and Greater Than
03:20

Greater Than or Less Than Quiz Question
1 question

Using Parentheses in the WHERE clause
04:19

WHERE Clause Review Quiz
3 questions
+
ORDER BY
1 Lecture 03:52
Order By
03:52
+
JOINS
3 Lectures 15:12
LEFT JOIN
06:18

Left Join Question
1 question

More LEFT JOIN
04:50

More Left Join Quiz
1 question

INNER JOIN
04:04

JOIN review quiz
3 questions
+
UNION
2 Lectures 08:30
UNION
05:15

UNION question
1 question

UNION and UNION ALL
03:15
+
AGGREGATION
2 Lectures 11:12
COUNT(*) with GROUP BY
04:50

Count(*) with Group By question
1 question

SUM and AVG with Group By
06:22

SUM and AVG questions
2 questions
+
Additional Practice Problems
0 Lectures 00:00
Review Problem Set 1
5 questions

Review Problem Set 2
5 questions
+
Conclusion
3 Lectures 00:18
Interview Questions
00:05

Conclusion
00:09

Bonus: Coupon for QueryStorm Professional
00:03
About the Instructor
Lukas Halim
4.5 Average rating
1,212 Reviews
5,584 Students
2 Courses
Analytics Professional

Let me tell you about myself, and why I became interested in Tableau.

I was the office Excel and SharePoint expert, creating macros and writing JavaScript to streamline workflows and create reports. I was a valued contributor to the team, but for a while I didn't seem to be learning new skills. A friend gave me a bit of advice - "don't confuse seven years of experience with one year of experience seven times." Friends were mentioning that there was a lot of buzz around Hadoop and Big Data, so I decided to go back to school.

I earned a Masters in Analytics from NC State in 2013 and now work as a data analyst in the health insurance industry. Using tools such as SAS, Tableau, and Teradata, I conduct analysis to help my company improve healthcare affordability and customer engagement.