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

Overview

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 215 ratings

Start your review of Using SQL with Python

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.