Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn SQL with ease
Rating: 4.4 out of 5(191 ratings)
508 students

Learn SQL with ease

An easy, step by step guide to learning and SQL with many hands on practice examples
Created byMarco Eder
Last updated 3/2016
English

What you'll 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

Course content

6 sections • 45 lectures • 2h 11m total length

  • Writing your first SQL query2:29

    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.

  • Selecting columns1:53

    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.

  • 1st practice session - phone list0:09

    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 - solution1:55

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

  • Filtering with WHERE2:06

    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.

  • Using AND and OR operators2:38

    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.

  • 2nd practice - filtering0:18

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

  • 2nd practice - solution3:38

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

  • 3rd practice - advanced filtering0:21

    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 - solution3:26

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

  • IN and NOT IN4:26

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

  • Greater than and less than4:19

    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.

  • Quiz 1 - Practice filtering
  • Finding unique values3:25

    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.

  • Counting entries and values7:02

    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.

  • Grouping results6:22

    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.

  • Quiz 2 - DISTINCT, COUNT and GROUP BY
  • 4th practice - DISTINCT, COUNT and GROUP BY0:27

    Practice counting and grouping with three quick practice tasks.

  • 4th practice - solution9:42

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

  • Sorting4:34

    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.

  • Some finer points2:54

    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.

  • What you learned so far2:27

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

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 this course is for:

  • This course is created for beginners with little or no knowledge of SQL and those who want to freshen up their skills.

Report abuse