Day 16 of #100DayswithMachineLearning

Topic - Working with JSON & SQL

🧵

1⃣)
🔸JSON or JavaScript Object Notation is a lightweight text-based open standard designed for human-readable data interchange

🔸Web services and APIs use JSON format to provide public data

🔸JSON is language independent.

🔸JSON syntax is basically considered as a subset of JavaScript syntax

🔸Data is represented in name/value pairs.

🔸Curly braces hold objects and each name is followed by ':'(colon), the name/value pairs are separated by , (comma).

🔸JSON supports the following two data structures −

1⃣ Collection of name/value pairs − This Data Structure is supported by different programming languages.

2⃣ Ordered list of values − It includes array, list, vector or sequence etc.

🔸JSON Schema is a specification for JSON based format for defining the structure of JSON data

Blog Link -

www.tutorialspoint.com/json/index.htm

2⃣ Connect Python with SQL Database

🔸The connect() method of mysql.connector module is used. We pass the database details like HostName, username, and the password in the method call, and then the method returns the connection object.

🔸cursor() is used to execute the SQL statements in Python.

🔸execute() method is used to compile a SQL statement.

Blog Link - www.geeksforgeeks.org/how-to-connect-python-with-sql-database/

✅If this thread was helpful to you:

1. Follow me
@Sachintukumar
for daily content like this

2. Connect with me on Linkedin : linkedin.com/in/sachintukumar/

3. RT the tweet below to share it with your friends 👇