Working with JSON/SQL | Day 16 | 100 Days of Machine Learning

JavaScript Object Notation (JSON) is a standard text-based format for representing structured data based on JavaScript object syntax. JSON is a lightweight data format used for data interchange between multiple different languages. It is easy to read for humans and easily parsed by machines. It's pretty common for websites to return JSON from API's so that the information is easy to parse by different programming languages.

SQL(Structured Query Language) is used to manage relational databases, and It is used to perform fetching rows, database creation, modifying databases, deleting databases, and also reading, writing data. It is extremely useful in managing structured data, i.e. data that is used to represent relations among entities and variables. SQL is predicated on relational algebra and tuple relational calculus. MS Access, MySQL is a standard database language.

Working with JSON/SQL involves handling structured data in JSON format or querying relational databases using SQL, essential skills for data manipulation and analysis.

============================
Do you want to learn from me?
============================

📱 Grow with us:

[adityamehra]

I have never commented on any YouTube video. This video, the whole playlist made me. Salute to your efforts I am forever in your debt

[joshivu]

Thanks!, this PlayList is super helpful. Keep up the good work, Nitish!

[anilbarmola]

Usually I do not prefer comments on YouTube but I respect your afferts. Thank for every thing

[JACKSPARROW-chjl]

You are the only youtuber, who is interpreting all the subparameters thanxxx

[sangamwathore]

its called real content... thank you sir ji

[bhabanisankarsahoo]

02:08 JSON and SQL are widely used data formats in programming

04:16 Learn how to work with JSON and SQL in Python

06:24 The tutorial explains how to read and convert JSON data into a pandas dataframe.

08:32 Converting a SQL file into a pandas dataframe

10:40 Start Apache and MySQL servers and import a dataset into a new database

12:48 Create a connection to a MySQL database in Python using MySQL.Connector

14:56 The function read_SQL_query in Pandas can create a dataframe by executing a SQL query with a connection object.

17:00 Life expectancy is greater than 60 in 167 countries.

[jayanthAILab]

Pretty much amazing playlist in entire youtude. I loved it

[hamdansiddiqui]

Informative I like your way of teaching

[tanishagrawal]

i wish i watched ur videos 2years ago 😄..Good Work bro..thanks

[raghavagrawal]

thank you sir for showing, how to extract data from the database. Sir pymysql library will also work instead of MySQL.connector

[dipanjanjayswal]

Do we need to keep our server running while making a connection to the mysql database

[replymeasapp]

If someone coding in google colab then how did you read SQL data? Like how did you create the database for it, please help

[KeyboardWarrior]

Can we do this using SSMS? will XAMPP be needed then?

[yathishb]

Very much helpful if video is in English (for non hindi)

[Awm_king-yi]

Hello sir this video very very important for beginers i want to you please make a project sql and jupter notebook using complete project

[sandalagrawal]

I got stuck while setting connection to the mysql database.

InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' (111 Connection refused)

can someone please help me?

[PiyushSingh-vnql]

@CampusX This playlist is ML playlist or Data science playlist. Because, till now the concepts covered seems to be of data science; but you have named this playlist as ML. And you have another playlist named Data Science.

[brijkishorvarshney]

What is need of xampp?
Anyone please

[tanmayshinde]

is there any need to learn c++ or java for data scientist role in big MNCs?

[lakshyajain]

2003: Can't connect to MySQL server on 'localhost:3306' (111 Connection refused) anyone pls help