Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Databases are part of our everyday life, and being able to communicate with them is essential. This course will teach you the basics of SQL, a powerful query language that lets you work with many types of data.

The SQL Basics course starts with simple queries performed on a single table. These exercises will show you how to retrieve exactly what you need. Next, you’ll start working with multiple tables. You will find out about the subtle differences between various joining methods, including INNER JOIN, LEFT JOIN, RIGHT JOIN, and OUTER JOIN.

As you go deeper into the course, you’ll master using the GROUP BY function to create simple reports. You’ll also start investigating subqueries. Finally, you can test your knowledge (and earn your certificate!) in a comprehensive quiz.

Looking to get started in SQL? Give this course a try – the fascinating world of SQL queries is only a click away!

What Do You Need to Take This Course?

Just a web browser and an Internet connection

This Course Will Teach You How To:

  • Retrieve information from a database
  • Build basic reports from scratch
  • Write complex WHERE conditions, using logical operators like AND, OR, and NOT
  • Understand the LIKE, ILIKE, IN, and BETWEEN operators
  • Work with multiple tables
  • Use INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN
  • Create simple reports using GROUP BY and aggregate functions
  • Write subqueries and complex instructions
  • Understand SQL set operations: UNION, INTERSECT, and EXCEPT
 

Plus, you’ll get to practice your skills on over 129 interactive exercises.

Who Should Take This Course?

  • Anyone who wants to learn SQL
  • Analysts who use relational databases
  • Students taking courses in relational databases
  • Beginning programmers
  • Business database users who want to improve their skills
    Start for free
    Gift this course

    Bundle deals

    86%
    off

    Reg. price
    $1512

    One to Rule 'Em All

    Includes 41 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Introduction to R, Tidyverse, Data Visualization 101, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, Introduction to Python for Data Science, How to Read and Write CSV Files in Python, How to Read and Write JSON Files in Python, Lists and Functions in R, Data Manipulation in R, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS, How to Read and Write Excel Files in Python

    Bundle price $199

    37 hours left at this price!

    73%
    off

    Reg. price
    $359

    SQL Complete Track

    Includes 9 courses SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Window Functions, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, PostGIS

    Bundle price $95

    37 hours left at this price!

    68%
    off

    Reg. price
    $304

    Basic Data Analytics

    Includes 8 courses SQL Basics, SQL Practice Set, SQL JOINs, Introduction to R, Tidyverse, Data Visualization 101, Statistics 101, Introduction to Python for Data Science

    Bundle price $95

    37 hours left at this price!

    66%
    off

    Reg. price
    $193

    SQL First Aid

    Includes 5 courses SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Tables in SQL

    Bundle price $65

    37 hours left at this price!

    Table of contents

    Progress: 0% completed 0 of 129 exercises done

    1. A little bit on databases

    Find out what relational databases are and get to know SQL – a language to talk to databases.

    More details Less
    Start now

    0% completed 0 of 6 exercises done

    2. Selecting from one table

    Discover how to select data from a single table.

    More details Less
    Start now

    0% completed 0 of 22 exercises done

    3. Querying more than one table

    Learn how to select data from multiple tables.

    More details Less
    Start now

    0% completed 0 of 13 exercises done

    4. Aggregation and grouping

    Computations in SQL? Why not? You will learn how to group rows and compute statistics with aggregate functions.

    More details Less
    Start now

    0% completed 0 of 23 exercises done

    5. More on JOINs

    Learn about various kinds of JOINs to best suit your needs.

    More details Less
    Start now

    0% completed 0 of 22 exercises done

    6. Subqueries

    Queries within queries? That's right! Discover how to build and use subqueries.

    More details Less
    Start now

    0% completed 0 of 22 exercises done

    7. Set operations

    Combine query results using set operations like UNION, INTERSECT or MINUS.

    More details Less
    Start now

    0% completed 0 of 12 exercises done

    8. Quiz

    Check your SQL skills.

    More details Less
    Start now

    0% completed 0 of 9 exercises done

    Reviews

    Average rating

    4.7/594.19047619047619 (420)

    Details

    5 Stars 80%
    4 Stars 16%
    3 Stars 3%
    2 Stars 0%
    1 Stars 1%
      Load more reviews

      Comments

      0