Connect to a SQL Database using Python

Nowadays, Python is being common programming and there are a lot of companies using python to manipulate data. If your company requires you to use one of the database management systems such as MySQL or Oracle but you are not really good at this then you can connect Python and SQL databases.

Python is a very ‘easy to use’ programming language, so we can manipulate the data with Python by connecting SQL databases.

Example with Python

We can connect a database and create a cursor. The cursor is a Temporary Memory or Temporary Work Station. It is Allocated by Database Server at the Time of Performing DML operations on Table by User. Cursors are used to store Database Tables. The sqlite3 module is to connect objects that represent the database. So we can connect to our targeted database by the following code-

import sqlite3
conn = sqlite3.connect('emplyees.sqlite')
cur = conn.cursor()

Then we can execute queries by using fetchall —

cur.execute("""
SELECT * 
FROM emoloyees
LIMIT 3;
""")
cur.fetchall()
>>>
[('0001',
  'IT',
  'Marry',
  'Data Scientist',
  'marry@company.com',
  '1',
  ,
 ('0002',
  'HR',
  'Petter',
  'Senior Recuiter',
  'petter@company.com',
  '2'),
 ('1076',
  'Marketing',
  'Amy',
  'Operators',
  'amy@company.com',
  '3')]

If you do not want to use SQL syntax you can warp the results into Pandas data frames, then you are able to manipulate the data using Python.

import pandas as pd
cur.execute("""SELECT * FROM employees""")
df = pd.DataFrame(cur.fetchall())

The people who are more familiar with Python can use this to mine the data and use Matplotlib or Seaborn to find more actionable insights.

Conclusion

We can use a different method to manipulate the datasets. If your company allows you to use different tools to analyze the data, then this is a possible way to finish your task.