Lesson: Apply Python to Scrape Data in a Database using SQL

Lesson Outcomes

By the end of this practical lesson, the learner should be able to:

  • Apply data scraping on a database table in SQL using Python

  • Store, retrieve, manage, or manipulate data inside a SQL database table 

Applied Knowledge

The learner must understand:

  • The purpose and procedure of SQL 

Internal Assessment Criterion

  • The required database transaction is applied using an appropriate tool. 

Lesson Notes

This practical lesson is about connecting three things:

  1. Python for scraping or extracting data

  2. SQL for storing and managing that data

  3. A database table where the scraped information is inserted and worked with

In simple terms, the learner must show that they can collect data with Python and then place that data into a SQL table, where it can be queried, updated, or managed.

What the learner must practically do

The PM-06 document requires the learner to:

  • PA0101: Apply data scraping on a database table in SQL using Python

  • PA0102: Store, retrieve, manage or manipulate data inside a SQL database table 

That means the learner should be able to:

  • identify a data source

  • scrape or extract data using Python

  • clean or structure the data if needed

  • connect to a SQL database

  • insert the data into a table

  • run basic SQL operations to confirm the data is usable

PreviousNext