Programming 103: Saving and Structuring Data CO219 / A23
Summary
Discover how to save data to use it across multiple runs of your program
On this course, you will learn how to save text and binary files, and how to structure data so that programs can interpret it correctly.
You will explore various common types of structured files, including CSV and JSON, and also find out how to connect to a SQL database to use it in your Python programs.
This course is designed for those who have a little Python experience and are comfortable using functions with parameters–as covered in our Programming 102 course. Please note: screengrabs and recorded screencasts are key elements of this course.
Who is it for?
This course is aimed at classroom teachers teaching up to and including GCSE computer science.
What topics are covered?
You'll cover the following topics:
- Creating, reading from, and writing to files using Python
- The importance of data persistence
- Structuring data using CSV files, Python dictionaries, and JSON files
- How data structures aid compatibility between systems
- Interacting with databases using SQL and Python
How will you learn?
This online, self-paced course can be completed flexibly. You can join and start this course at any time after the advertised date, and keep access for a year after booking. You can learn independently or with colleagues to directly address your individual needs.
This course will be periodically facilitated by expert Professional Development Leaders.
Who is the course leader?
-
This is a self-paced Online Course
The course leader will be introduced in the course.
-
Outcomes
You will be able to:
- Demonstrate how to use Python to store and retrieve persistent data
- Explain the importance of data persistence and where it is used
- Compare different types of structured data
- Modify a program to store data in a JSON file
- Perform operations on a database using SQL statements
Sessions
| Date | Time | Location | |
|---|---|---|---|
| 1 Programming 103: Saving and Structuring Data | 01 September 2023 | 00:00-23:59 | Online course |
Actions
Fees & Subsidies
Additional information
If the course you would like to attend is fully booked, please contact enquiries@stem.org.uk to express your interest in being added to a waiting list. We will contact you when the course is due to run again.
Are you a state-funded Special School or PRU unit in England? You may be eligible for reduced course fees and even subsidies. Get in touch to check your eligibility and book your place directly. You can see our fees and subsidy information here.
Alternative dates
Interested in this course?
Sign up to receive our emails to hear about the latest CPD available