Programming 103: Saving and Structuring Data
CO219 Online course
Learn how to save and structure data in external files, and import files back into your Python programs. Supported by Google.
Skip to course bookingDiscover 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.
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
This course is part of the Subject knowledge certificate
Subject knowledge certificate
Our professional development programme, Computer Science Accelerator, is designed to help you develop or refresh your subject knowledge and leads to a nationally recognised certificate.
Join this course
You need to be logged in to start the course.
Not got a STEM Learning account?
Create an account
Adapted teaching and effective learning interventions in secondary computing
Develop an evidence-informed approach to education recovery over a sustained period, securing the computing education of young people following a period of great disruption.
An Introduction to algorithms, programming and data in computer science - remote
Create some simple block-based computer programs and discover how to implement them in the text based language Python.
An introduction to algorithms, programming and data in GCSE computer science - face to face
Create some simple block-based computer programs and discover how to implement them in the text based language Python.