SQL & Databases: Download Practice Datasets - SuperDataScience - Big Data | Analytics Careers | Mentors | Success

SQL & Databases: Download Practice Datasets

Greetings

Welcome to the data repository for the SQL Databases course by Kirill Eremenko and Ilya Eremenko.

The datasets and other supplementary materials are below.

Enjoy!

 

Section 1. Introduction

No dataset required

Section 2. It's super easy to get Started

No dataset required

Section 3. Preparation

Section 3 – The Challenge

Section 3 – PostgreSQL Upload Code

Section 3 – MS SQL Upload Code

Consumer Complaints (csv file 14.7 MB)

Consumer Complaints (zip file 2.5 MB)

Data Source: http://www.consumerfinance.gov/data-research/consumer-complaints/

Section 4. Basics of SQL

Here we will continue working with the Dataset from the previous section.

Section 5. Working With Data

Section 5 The Challenge

Section 5 – PostgreSQL Upload Code

Section 5 – MS SQL Upload Code

Console Games Sales

Console Dates

Section 6. Fundamentals of Database Theory

Will be added soon.

Section 7. Joining tables in SQL

Section 7 – The Challenge

Section 7 – PostgreSQL Upload Code

Section 7 – MS SQL Upload Code

Pets

Owners

Procedures History (Updated)

Procedures Details

Section 8. Creating Tables in SQL

No dataset required

Section 9. Database Design

Section 9 – The Challenge

Section 9 – PostgreSQL Upload Code

Section 9 – MS SQL Upload Code

Online Store Sales (OLTP database example)

Kirill Eremenko
Kirill Eremenko

I’m a Data Scientist and Entrepreneur. I also teach Data Science Online and host the SDS podcast where I interview some of the most inspiring Data Scientists from all around the world. I am passionate about bringing Data Science and Analytics to the world!

What are you waiting for?

EMPOWER YOUR CAREER WITH SUPERDATASCIENCE

CLAIM YOUR TRIAL MEMBERSHIP NOW
as seen on: