SQLite and SQLAlchemy in Python: Moving Your Data Beyond Flat Files

All programs process data in one form or another, and many need to be able to save and retrieve that data from one invocation to the next. Python, SQLite, and SQLAlchemy give your programs database functionality, allowing you to store data in a single file without the need for a database server.

You can achieve similar results using flat files in any number of formats, including CSV, JSON, XML, and even custom formats. Flat files are often human-readable text files—though they can also be binary data—with a structure that can be parsed by a computer program. You’ll explore using SQL databases and flat files for data storage and manipulation and learn how to decide which approach is right for your program.

In this video course, you’ll learn how to use:

• Flat files for data storage
• SQL to improve access to persistent data
• SQLite for data storage
• SQLAlchemy to work with data as Python objects

What’s Included:

• 8 Lessons
• Video Subtitles and Full Transcripts
• 2 Downloadable Resources
• Accompanying Text-Based Tutorial
• Q&A With Python Experts: Ask a Question
• Certificate of Completion

Downloadable Resources:

• Course Slides (.pdf)
• Sample Code (.zip)

Related Learning Paths:

• Data Collection & Storage