Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Master Using SQL with Python - Create a Data Warehouse with SQLite

Bryan Cafferky via YouTube

Start learning Write review
CodeSignal Ad

Learn the Skills Netflix, Meta, and Capital One Actually Hire For

Learn More → Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This lesson shows how to extract and transform data from SQL Server and PostgreSQL, load it into a local SQLite data warehouse, and use Python, SQL, and pandas to support analysis.

Syllabus

Introduction
Databricks Book
Proposal
Data Analysis
Power of SQLite
SQLite Features
Scenario
Creating a Class
SQLite Notebook
Importing SQLite
Importing SQLDB
Aggregating Data
Importing pandas
Running the query
Creating a consolidated view
Loading a CSV file
Loading data from PostgreSQL
Executing commands against SQLite
Closing connections

Taught by

Bryan Cafferky

Reviews

Start your review of Master Using SQL with Python - Create a Data Warehouse with SQLite

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.