Skip to main content
HomeSQL

Applying SQL to Real-World Problems

4.6+
16 reviews
Intermediate

Find tables, store and manage new tables and views, and write maintainable SQL code to answer business questions.

Start Course for Free
4 hours13 videos47 exercises27,669 learnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Course Description

Now that you’ve learned the basic tools of SQL you are ready to synthesize them into practical, real-world skills. In this course, you will work with a database of a fictional movie rental company. The size and complexity of this database will allow you to experience the challenges of working with databases firsthand. Throughout this course, you will use SQL to answer business-driven questions. You will learn new skills that will empower you to find the tables you need. You will then learn how to store and manage this data in tables and views that you create. Best of all you will also learn how to write code that not only clearly conveys your intent but is also legible.
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.
DataCamp for BusinessFor a bespoke solution book a demo.

In the following Tracks

SQL for Business Analysts

Go To Track
  1. 1

    Use Real-World SQL

    Free

    You will review some of the most commonly used SQL commands to ensure you are prepared to tackle both real-world problems as well as every exercise covered in this course.

    Play Chapter Now
    Essential SQL
    50 xp
    Review the essentials
    100 xp
    Practice the essentials
    100 xp
    Transforming your results
    50 xp
    Transform numeric & strings
    100 xp
    Extract what you need
    100 xp
    Working with aggregate functions
    50 xp
    Aggregating finances
    100 xp
    Aggregating strings
    100 xp
    Which tables?
    50 xp
  2. 2

    Find Your Data

    How do you find the data you need in your database in order to answer real-world business questions? Here you will learn how to use system tables to explore your database. You will use these tables to create a new tool that contains a list of all tables and columns in your database. Finally, you will create an Entity Relationship Diagram (ERD) which will help you connect multiple tables.

    Play Chapter Now
    Find the right table
    50 xp
    LIMITing your search
    100 xp
    Which table to use?
    50 xp
    What tables are in your database?
    100 xp
    Determine the monthly income
    100 xp
    Join the correct tables
    50 xp
    What columns are in your database?
    100 xp
    A VIEW of all your columns
    100 xp
    Testing out your new VIEW
    50 xp
    The average length of films by category
    100 xp
    Complex joins
    50 xp
    Build the entity relationship diagram
    100 xp
    Which films are most frequently rented?
    100 xp
  3. 3

    Manage Your Data

    Working with SQL to solve real-world problems will oftentimes require you to do more than retrieve the data you need, oftentimes you will need to manage the data in your database. This includes creating data, updating it and, when necessary, deleting it.

    Play Chapter Now
    Store your data
    50 xp
    Storing new data
    100 xp
    Using existing data
    100 xp
    TABLE vs VIEW
    50 xp
    Update your data
    50 xp
    What should you modify?
    50 xp
    Update the price of rentals
    100 xp
    Updated based on other tables
    100 xp
    Delete your data
    50 xp
    Deleting all table data
    50 xp
    Delete selected records
    100 xp
    A family friendly video store
    100 xp
  4. 4

    Best Practices for Writing SQL

    How do you ensure that the SQL scripts you write will be easy to understand for anyone who needs to read them? This chapter will cover approaches you can leverage to ensure that your code clearly conveys your intent, is readable by others and follows best practices.

    Play Chapter Now
    Convey your intent
    50 xp
    How to convey our intent
    50 xp
    Clarify the intent of this query
    50 xp
    Fix this query - intent
    100 xp
    Write readable code
    50 xp
    How to make code easier to read
    50 xp
    Make this query easier to read - Part I
    100 xp
    Make this query easier to read - Part II
    100 xp
    Avoid common mistakes
    50 xp
    What are the don'ts of writing SQL code?
    50 xp
    Apply best practices to your code
    100 xp
    Recap
    50 xp
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.

In the following Tracks

SQL for Business Analysts

Go To Track

datasets

DVD Rental Database

collaborators

Collaborator's avatar
Chester Ismay
Collaborator's avatar
Adrián Soto

prerequisites

Data Manipulation in SQL
Dmitriy Gorenshteyn HeadshotDmitriy Gorenshteyn

Lead Data Scientist at Memorial Sloan Kettering Cancer Center

See More

Don’t just take our word for it

*4.6
from 16 reviews
75%
13%
13%
0%
0%
Sort by
  • Rufus T.
    6 days

    Generally a good clear course.

  • mostafa g.
    7 days

    Thanks dat camp

  • Tommy A.
    3 months

    Very accessible and easy to understand.

  • Ruthu S.
    7 months

    Very good explanation

  • Emrah T.
    about 1 year

    More practice sections regarding Real-World Problems will be useful Thank you very much indeed

"Generally a good clear course."

Rufus T.

"Thanks dat camp"

mostafa g.

"Very accessible and easy to understand."

Tommy A.

Join over 15 million learners and start Applying SQL to Real-World Problems today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.