Coursera Plus Annual is 40% Off — Ends July 13.

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

Write review

No Longer Offered

CodeSignal Ad

Learn Generative AI, Prompt Engineering, and LLMs for Free

Learn More → TrainSec Ad

Master Windows Internals - Kernel Programming, Debugging & Architecture

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
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

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.