How to install Python and PIP in windows

To build the real-world applications, connecting with the databases is the necessity for the programming languages. However, python allows us to connect our application to the databases like SQLite, MySQL, Oracle, Sybase, PostgreSQL etc. Python also supports Data Definition Language (DDL), Data Manipulation Language (DML) and Data Query Statements. Data is stored in a collection of tables with each table consisting of a set of rows and columns. This is similar to how data is stored in SQLite. To interact with the data stored in tables we use a special-purpose programming language called SQL. MySQL is a Relational Database Management System (RDBMS) whereas the structured Query Language (SQL) is the language used for handling the RDBMS using commands i.e Creating, Inserting, Updating and Deleting the data from the databases. To connect Python with MySQL, follows the below steps

o Step-1: Install Python + PIP

o Step-2: Install MySQL

o Step-3: Integrate / Connect Python and MySQL using MySQL Connector

A] Install Python + PIP:

PIP is a package management system used to install and manage software packages/libraries written in Python. These files are stored in a large “on-line repository” termed as Python Package Index (PyPI).

1. Open Google Chrome Browser

2. Type https://www.python.org/downloads/

3. Download the latest version for windows

4. Now .exe file will be downloaded in your local system

5. Install by double clicking on it