Extract Data - Output Data in Excel & PostgreSQL Database
InstructorDr. Alexander Schlee
Free
Free
Free
The teaching style is described as easy to follow, providing a clear alternative to more complex or messy code-heavy tutorials.
Instruction follows a multi-part project sequence that integrates Jupyter Notebook, Pandas, and SQLAlchemy for data handling.
Editorial course preview
These 3 complementary views highlight concrete, legible examples from the course presentation.
This screen capture displays the Realtor.ca interface during a web scraping demonstration, highlighting a custom search boundary drawn around Ottawa, Ontario.
The interface displays a detailed map of the Ottawa area populated with individual property markers, illustrating the granular data points available for extraction.
The Realtor.ca homepage interface displays a search input field with location suggestions for Ottawa and Ontario to demonstrate data retrieval.
The coverage of PostgreSQL and the construction of final databases is noted as being briefly addressed or only surveyed.
The curriculum provides basic knowledge of scraping tools without extensive coverage of cloud-based database options like BigQuery.
The curriculum aligns with the stated goal of teaching basic Python-based scraping to data enthusiasts.