Learn SQL with ease
4.7 (21 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.
135 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SQL with ease to your Wishlist.

Add to Wishlist

Learn SQL with ease

An easy, step by step guide to learning and SQL with many hands on practice examples
4.7 (21 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.
135 students enrolled
Created by Marco Eder
Last updated 3/2016
English
Current price: $10 Original price: $40 Discount: 75% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 13 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use SQL to pull and manipulate data from relational databases
  • Select columns, filter for results and sort values
  • Aggregate and group data
  • Calculate with data and manipulate text
  • Join multiple tables
View Curriculum
Requirements
  • This course uses an online practice database. All you need is a modern web browser to write your own queries and perform the practice tasks.
Description

No matter if you work in marketing, sales or finance, a solid understanding of data and the ability to query databases is a huge plus for your career. The first step to pulling your own data is an understand of SQL, the language used to query most data bases.

It doesn't matter if your company uses MySQL, TeraData, Microsoft SQL Server, Oracle oder MS Access. SQL is a standardized language, can be used to get data out of almost all relational databases.

What will you learn in this course?

This course is a quick and easy step by step guide to writing SQL queries to pull your own data. You learn all key functions of SQL and get a basic understanding of how relational databases work. Plenty of practice sessions will allow you to write your own queries and learn hands on. This way you will feel comfortable in applying the learned material to your day to day problems at work.

Is this course right for you?

If you want to learn solid skills that will improve your career prospects, then this is probably the course for you. Individuals that know their way around data bases, can query their own data sets and analyze them are in high demand in. If your current or your dream employer collects data of any kind? Then you should learn how to use this data.

If you run your own business, it is even more critical to get to your data and make sense of it. Even the databases of websites, online shops and payment systems can be queried with SQL. Get this data, format it and analyze to take the right decisions for your business success.

Course structure

The course is structured in easy steps that allow you to learn one step at a time. Practice sessions and quick quizzes will allow you to write your own queries in an easy to use online tool. No installation or setup required. In fact, you will write your first SQL query in the very first lesson. With each lesson the queries get more complicated and built on the learnings of the prior lessons.


Begin today, learn how to write your first query and start your journey to becoming a data expert!

Who is the target audience?
  • This course is created for beginners with little or no knowledge of SQL and those who want to freshen up their skills.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
45 Lectures
02:11:14
+
Simple data query of one table
20 Lectures 01:04:40

Let's start off on the right foot and begin with writing your very first SQL query. With it you learn the first keywords of a SQL query

If you want to get some background details on databases and SQL in general first, have a look at the resources in this section. There you will also find some more details on the practice tool we'll use in this course to write and execute queries.

Preview 02:29

With SQL you can select data from tables in relational databases. Most of these tables include multiple columns. Some of them are of interest to you, others likely aren't. In this lesson you learn how to selectively pick only those columns you are interested in.

Selecting columns
01:53

At its core SQL is quite easy, it requires a bit of practice though. Just like learning any other "language". In this practice session you will learn how to create a phone list of all customers in the data base.

1st practice session - phone list
00:08

In this lesson we walk through the practice task and discuss a possible solution. Please comment with any questions you may have!

Preview 01:55

Aside from picking columns, filtering the rows according to your needs is the next big step. In this lesson you learn about the filtering function and how to use it.

Filtering with WHERE
02:06

Often you need to filter for multiple conditions. In this lesson you will learn how to do that and how to combine different conditions in meaningful ways.

Preview 02:38

In this session you will create two lists using different filters.

2nd practice - filtering
00:18

In this lesson we walk through the practice task and discuss a possible solution. Please comment with any questions you may have!

2nd practice - solution
03:38

If the prior tasks where too easy for you, try these. Feel free to test as many queries as needed. The database is small and should return your results very quickly. The tool will also provide you with error messages, in case your query needs some adjustments.

Start developing some healthy skepticism towards your results though. Do they appear reasonable? Or could there be a mistake in the query logic?

3rd practice - advanced filtering
00:21

In this lesson we walk through the practice task and discuss a possible solution. Please comment with any questions you may have!

3rd practice - solution
03:26

The operators IN and NOT IN can be very useful to shorten some queries and eliminate typical typing mistakes in SQL queries.

IN and NOT IN
04:26

If you want to limit your results based on whether certain values are smaller or greater than a set number, you can use the commands for greater than and less than.

Greater than and less than
04:19

Practice filtering with the Products table.

Quiz 1 - Practice filtering
4 questions

In this lesson you learn how to quickly get a list of all unique values in a column and how to get a list of all unique combinations of two or more columns.

Finding unique values
03:25

In this lesson you will learn how to count the number of entries or records in a table, the number of values in a column and also how to find out how many unique values are in a column.

Preview 07:02

One of the most powerful functions of SQL is the grouping of results. In this lesson you learn why and how you can take advantage of this.

Grouping results
06:22

Quiz 2 - DISTINCT, COUNT and GROUP BY
3 questions

Practice counting and grouping with three quick practice tasks.

4th practice - DISTINCT, COUNT and GROUP BY
00:27

In this lesson we walk through the practice task and discuss a possible solution. Please comment with any questions you may have!

4th practice - solution
09:42

You results can be sorted both numerically and alphabetically. In this lesson you learn how to order them according to different columns in an ascending and descending order.

Preview 04:34

SQL is pretty straight forward and easy to learn. Even if the syntax appears to be rigid, you do have some flexibility in how you write your queries. In this lesson you learn some of the finer points in writing good SQL queries.

Some finer points
02:54

A quick summary of all you have learned so far, you can use it as a reference sheet for the up coming lessons.

What you learned so far
02:34
+
Joining tables
11 Lectures 38:16

SQL is the preferred query language for relational databases. But what are these databases anyways? In this lesson you will learn a bit about the theory of relational data bases to prepare for joining different tables in your upcoming queries.

Background to relational data bases and joins
02:20

Often tables are combined with an INNER JOIN. In this lesson you will learn how to perform an INNER JOIN and what it takes to adjust your prior queries for this.

Inner Joins
04:32

In this task, you will be asked to combine two tables via an inner join to pull data from both of them simultaneously.

5th practice - INNER JOIN
00:03

In this lesson we walk through the practice task and discuss a possible solution. Please comment with any questions you may have!

5th practice - solution
03:54

You can join more than one table in the same query. In this lesson I will show you how this works.

Joining multiple tables
02:59

Two tasks to practice joining multiple tables.

6th practice - INNER JOIN on multiple tables
00:13

In this lesson we walk through the practice task and discuss a possible solution. Please comment with any questions you may have!

6th practice - solution
04:15

In this lesson you learn

  1. what happens when you join two tables
  2. what does the ON condition mean
  3. what are outer joins and how do they work?
Joining tables - inner and outer joins
11:26

Here you have two tasks to practice outer joins. If you are not sure when to use an outer and when an inner join, try performing both queries in separate browser tabs and compare the results!

7th practice - OUTER JOIN
00:28

In this lesson we walk through the practice task and discuss a possible solution. Please comment with any questions you may have!

7th practice - solution
07:21

A brief summary of all you have learned in this section.

What you learned so far
00:44
+
Aggregate functions
5 Lectures 09:42

When you aggregate data in your tables, it often makes sense to sum metrics. In this lesson you learn how to do this and what you have to look out for.

Summing
02:57

Practice the summing of data.

8th practice - summing
00:05

In this lesson we walk through the practice task and discuss a possible solution. Please comment with any questions you may have!

8th practice - solution
03:25

Aside from counting and summing, there are three more useful aggregate functions that work similarly and can be used in combination with grouping. In this lesson you will learn how to calculate the average and how to find the lowest and highest values in individual columns.

Average, minimum and maximum
02:45

Quiz 3 - aggregate functions
5 questions

A summary of all SQL learnings in this section.

What you learned so far
00:29
+
More functions
3 Lectures 08:43

Oftentimes you find data points like revenue, cost, order numbers and more in your data base. It is rather easy to calculate things like order volumes and profit. In this lesson you will learn how to calculate across columns and tables and what you should keep in mind when doing so.

Calculating
04:56

Filtering for aggregates is a bit trickier than to filter on values in the source tables. For this you have to use the command HAVING. This lesson will cover how to do so.

Filtering with HAVING
01:39

Changing values
02:08
+
Tips and Tricks for writing SQL
5 Lectures 09:03

Congratulations. You learned most of the basics of SQL and I hope you have enjoyed the journey so far. If you are still uncertain, it is just a matter of practice. Feel free to use the tool as much as you want. If you want more practice tasks, just leave a comment.

To finish this course off, I included a few sessions with tips on optimizing your SQL queries. It will make writing and working with them a bit easier.

Alias
04:02

Column numbers
01:58

Using commas
01:56

Semicolon
00:53

Summary of optimization tips
00:14
+
Bonus
1 Lecture 00:59
Bonus and thank you
00:59
About the Instructor
Marco Eder
4.6 Average rating
70 Reviews
449 Students
2 Courses
Entrepreneur, Coach, Data Analyst

Hallo,

ursprünglich komme ich aus Brandenburg, aber meine Wanderlust hat mich in viele verschiedene Länder gezogen. Zwei meiner Lieblingsstationen waren Dublin und San Francisco, wo ich insgesamt sechs Jahre für Google gearbeitet habe. Als Analyst im Finance und Business Intelligence Team habe ich unendlich viele Zeilen an SQL-Abfragen geschrieben.

Meine Begeisterung und Leidenschaft für Daten, Datenbanken und die Abfrage mit SQL möchte ich mit dir auf Udemy teilen!