Using SQL with Python

Introduction

• Use SQL with Python
• Using the exercise files
• What do you need for this course?
• Installing the tools

• The Python DB-API
• Creating a connection
• Simple queries
• Prepared statements
• Hello, SQLite
• Hello, MySQL
• Challenge
• Solution

• The essential four
• SQL Wrapper
• Adding CRUD methods
• Using the module
• Challenge
• Solution

• Defining the project
• Testing a web application
• Code demonstration
• Touring the code
• Challenge
• Solution

• Thank you