If you already know SQL and Python, learn the power of using these two languages together.
Overview
Syllabus
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
Taught by
Bill Weinman