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

LinkedIn Learning

Using SQL with Python

via LinkedIn Learning

Go to class Write review

This course may be unavailable.

Datacamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More → Coursera Ad

40% Off All Coursera Courses

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
If you already know SQL and Python, learn the power of using these two languages together.

Syllabus

Introduction
  • Use SQL with Python
  • Using the exercise files
  • What do you need for this course?
  • Installing the tools
1. Common Interface
  • The Python DB-API
  • Creating a connection
  • Simple queries
  • Prepared statements
  • Hello, SQLite
  • Hello, MySQL
  • Challenge
  • Solution
2. A CRUD Class
  • The essential four
  • SQL Wrapper
  • Adding CRUD methods
  • Using the module
  • Challenge
  • Solution
3. Final Project: URL Shortener
  • Defining the project
  • Testing a web application
  • Code demonstration
  • Touring the code
  • Challenge
  • Solution
Conclusion
  • Thank you

Taught by

Bill Weinman

Reviews

4.7 rating at LinkedIn Learning based on 448 ratings

Start your review of Using SQL with Python

Go to class

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.