Skip to content
UdemyWeb DevelopmentPaid courseAll LevelsCertificate

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

icon
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

icon
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.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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.


icon
More courses by Dr. Alexander Schlee

$11.99

$44.99

icon
More Web Development courses

$19.99

$89.99

$89.99

$79.99

$10.99

$84.99

icon
Reviews

4.6

117 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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!

Showing all 10 reviews on CourseDuck

Read all 117 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100