Using SQL with Python

If you already know SQL and Python, learn the power of using these two languages together.

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