From SQL to REST: Demystifying REST API

Does your large chunk of unorganized data terrify you?

Let's delve into the world of data retrieval, and learn how to transform intimidating numbers into meaningful information. We'll begin with a dataset pulled from a REST API and learn how to convert it into properly structured data using SQL to facilitate information flow, analysis, and decision-making. The examples will build upon one another to create a progressively complex query.

The objective is to demystify the process of SQL to REST by showcasing the relationship between query parameters in a REST API and their translation into SQL queries for retrieving data from a database.

Table of Contents:
0:00 – Introduction
1:36 – About the speaker
2:28 – Introduction to Data
3:00 – Origins of Data
3:37 – Laying Data into Tables
4:31 – Introduction to Database and SQL
6:27 – Main SQL Commands
11:46 – Introduction to REST API
14:26 – Query Parameters
15:01 – Query Parameters and SQL Filters
18:31 – Uses
21:34 – Why REST?
31:00 – Questions and Answers

--

--

Unleash your data science potential for FREE! Dive into our tutorials, events & courses today!

--

📱 Social media links

--

Also, join our communities:

_

#restapi #sql

[patrickwheeler]

When you said join, are you joining in the API itself using some library or are you pulling the API's into a platform or database and then joining the data together?

[sergeysperling]

The images in the beginning are very nice to look at ... where did you get them from? Are they AI generated? :D