Web Scraping APIs for Data Science 2021 | PostgreSQL+Excel (Udemy.com)
From Beginner to Advanced | 4 Hands-On Projects
Created by: Dr. Alexander Schlee
Last updated February 2023
What you will learn
- web scraping
- data extraction
- data mining
- create your own dataset
- output data in Excel
- output your dataframe in PostgreSQL
- run SQL commands on your dataframe
How it compares
Against the other 815 rated Udemy courses in Web Development on CourseDuck:
- Rating4.6 out of 5higher than 70% of them
- Reviews117#618 of 816 by number of reviews
- Length4.4 hoursshorter than 67% of them
- Last updatedFebruary 2023earlier than 70% of them
Course Description
In this course the students will get to know how to scrape data from the API of a website (if available). We start with the fundamentals and the beginner level project. After that, two different projects will be covered, followed by the advanced project. After scraping data of wach project, the results will be stored inside an Excel file. Within the advanced level project we will create two dofferent datasets with 5000 results each. The goal is to merge both dataframes (total: 10000 results), save it in Excel and output the data in the PostgreSQL database and run SQL commands on our own data.
The requirement for this course is basic knowledge of Python Programming. Since we will not cover very difficult Python topics you do not have to be a professional. The most important characteristic is that you are curious about Web Scraping and Data Mining. You should be ready to invest time in gaining the knowledge which is taught in this course.
After this course you will have the knowledge and the experience to scrape your own data and create your own dataset. With the help of the course resources you will always have documents you can refer to. If you have a question or if a concept just does not make sense to you, you can ask your questions anytime inside the Q&A - Forum. Either the instructor or other students will answer your question. Thanks to the community you will never have the feeling to learn alone by yourself.
Disclaimer : I teach web scraping as a tutor for educational purposes. That's it.
The first rule of scraping the web is: do not harm a certain website. The second rule of web crawling is: do NOT harm a certain website.
Instructor Details
- 4.6 Rating
117 Reviews
Dr. Alexander Schlee
Step into the exciting field of Python programming and Artificial Intelligence (AI).
I am an AI Program Manager, AI Reasearcher and I show my students how to not get overwhelmed but also not to lose track in the Era of Artifical Intelligence. This channel is for you, when you want to get a solid understanding of the evolving topics in the programming industry.
More courses by Dr. Alexander Schlee
Web Scraping for Data Science - Python & Selenium - Basics (2021)
4.6 (274 Reviews)
Provider: Udemy
Time: 3.4h
$11.99
API Scraping - Web Scraping Real Estate Data + PostgreSQL (2021)
4.7 (157 Reviews)
Provider: Udemy
Time: 1.2h
$44.99
More Web Development courses
Python Fullstack Mastery: Build Modern Web Apps with Django (2025)
5.0 (165 Reviews)
Provider: Udemy
Time: 35h
$19.99
NgRx Signal store for Angular - The missing guide (2026)
4.9 (436 Reviews)
Provider: Udemy
Time: 11.3h
$89.99
Vue 3: Create a Mobile & Desktop App (with Quasar 2 & Pinia) (2024)
4.9 (177 Reviews)
Provider: Udemy
Time: 7.6h
$79.99
Build a URL Shortener App with ASP.NET: Step by Step (2026)
4.9 (100 Reviews)
Provider: Udemy
Time: 9.6h
$10.99
The Complete Elixir and Phoenix Bootcamp (2021)
4.8 (7,773 Reviews)
Provider: Udemy
Time: 17.4h
$84.99
Reviews
By Matheus Brito de Oliveira on 1/22/2025
O curso é simples usa a mesma abordagem de scraping em todos os módulos. A didática é boa, mas o curso poderia abordar mais técnicas de scraping. Até mais
By Carlos Giraldo on 4/29/2023
I enjoyed and learned from this course. The instructor delivers good teaching and you can tell that the lessons are well prepared so that they don't drag on unnecessarily. The course is somewhat basic, but it is enjoyable and you learn the basics so you can learn more on your own.
By Sagar D on 5/4/2022
This was such an extraordinary course. Straight to the point. Full hands-on. I mainly took the course to learn about Network traffic of a website i.e. getting the endpoints to scrape the data from. The course fully satisfied my expectations. I was even able to apply the knowledge gained from this course at work. I fully recommend this course to anyone who wants to learn scraping data from APIs.
By Marta García on 8/30/2021
Fue una buena elección, en el aspecto de la obtención de información de APIs utilizando requests, json, diccionarios etc muy bien... Me hubiese gustado más variedad entre los ejemplos de webs, y un poco más de explicación en el funcionamiento interno de herramientas como engine (sqlalchemy)
By Constantina Dretakis on 8/13/2021
Excellent course and a This teacher puts in effort to prepare his lecture slides (they are pretty well prepared and comprehensive). His lectures are fairly interesting and engaging
By Mohamed Mamdouh on 8/11/2021
I think the instructor is well experienced in web Scraping. I hope he will make more detailed and advanced courses to master this interesting skill " Web Scraping ".
By James Wales on 8/11/2021
better than expected. as a data scientist i found it hard to find good and well strctured web scraping courses, especially when it comes to scrape the websites hidden api. alex (instructor) is just brilliant for this job! thanks!
By Nahil Nuhat on 8/9/2021
This course is had the answers to my questions. I knew API Scraping is very powerful and an alternative to Selenium and BS4 Scraping. Nice strctured, the instructor knows what he is saying!
By Dennis on 8/7/2021
The course is really well structured and well built. Contents are accordingly easy for me to understand. He is a great tutor. Thanks Alexander, you helped me a lot!!
By Aleksander Lening on 8/6/2021
As expected, the course was once again professional, understandably well structured. I could easily follow the topics covered. The knowledge was imparted at a reasonable pace. 5/5 Stars!
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 92 / 100








