Using SQL with Python

Go to class
Write Review

Free Online Course: Using SQL with Python provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Using SQL with Python is taught by Bill Weinman.

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