Cache Practice

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. Test Cache

Section 2: It’s Super Easy to Get Started

• No dataset required

Section 3: Preparation

• Section 3 – The Challenge
• Section 3 – PostgreSQL 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
• 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
• Pets
• Owners
• Procedures History
• Procedures Details

Section 8: Creating Tables in SQL

• No dataset required

Section 9: Database Design

• Section 9 – The Challenge
• Section 9 – PostgreSQL Upload Code
• Online Store Sales (OLTP database example)