Python Pandas: connect & import directly any database

Name: Python Pandas: connect & import directly any database
Rating: 4.3 (66 reviews)

ORACLE Database, IBM Db2, MS SQL Server, MySQL, Postgresql, SQLite

Created byCode Pro

Last updated 1/2018

English

What you'll learn

How to install major database software: Oracle Database, IBM Db2, MS SQL Server, MySQL, PostgreSQL, SQLite
How to install management tools for each database software: Oracle SQL Developer, IBM Data Studio, SSMS, MySQL Workbench, pgAdmin, DB Browser for SQLite
Where to find sample databases for each and how to import them
How to connect directly with Python to each database
How to import data directly to Pandas DataFrames

Course content

7 sections • 32 lectures • 2h 23m total length

Course structure & installation of Python, Pandas, and Jupyter Notebook5:30
This lecture provides the overall structure of the course as well as installation steps for Python, Pandas and Jupyter notebook (the browser based code editor you used throughout this course).

SQLite, DB Browser for SQLite and sample database5:17
In this lecture I walk you through the installation of SQLite, DB Browser for SQLite and a sample database.
THE CODE: How to import directly from SQLite7:23
Learn how to import data directly from SQLite database using Python and import it into a Pandas DataFrame.
Practice: What is missing in this code?0:07
This is a practice question.
Practice Answer0:08
This provides the answer to the practice question

MS SQL Server & SQL Server Management Studio (SSMS)3:41
In this lecture I take you through the installation of MS SQL Server and SSMS, SQL Server Management Studio.
Sample database for MS SQL Server9:58
In this lecture you will learn where to find sample databases for MS SQL Server, where to save them, and how to bring them in SSMS.
THE CODE: How to import directly from MS SQL Server10:51
In this lecture you will learn how to connect directly with Python to MS SQL Server, retrieve data and import it directly into a Pandas DataFrame.
Practice: What code would you write in this case?0:11
This is a practice question
Practice answer0:05
Answer to the practice question

Oracle Database & Oracle SQL Developer: Installation and configuration3:44
This lecture takes you through the installation of Oracle database and Oracle SQL Developer.
THE CODE: How to import directly from an ORACLE Database15:45
In this lecture you will learn how to connect directly with Python to an Oracle Database, retrieve data and import it directly into a Pandas DataFrame.
Practice: Where do you find the following 2 connection parameters?0:03
Practice question.
Practice answer0:28
Answer to practice question.

IBM Db2 and IBM Data Studio: Installation and configuration7:38
In this lecture I walk you through the installation and configuration of IBM Db2 and IBM Data Studio.
Create sample IBM database3:35
This lecture walks you through the creation of a sample IBM database that you will use to import data directly from IBM to a Pandas DataFrame.
Catalogued vs Uncatalogued database1:25
In this lecture I explain briefly the difference between a catalogued and an uncatalogued IBM database as these will be addressed differently in connection with Python Pandas.
THE CODE: import directly from an uncatalogued IBM database33:40
You will learn how to import data directly from an uncatalogued IBM database using Python into a Pandas DataFrame.
THE CODE: import directly from a catalogued IBM database4:14
In this lecture you will learn how to connect directly with Python to a catalogued IBM database, retrieve data and import it directly into a Pandas DataFrame.
Practice: What privileges are needed?0:05
Practice question.
Practice answer0:08
Answer to practice question.

MySQL & MySQL Workbench5:13
In this lecture I walk you through the installation and configuration of MySQL database Server and MySQL Workbench, the management tools for MySQL Database.
MySQL sample database5:06
You will learn how to import a sample database in MySQL Workbench.
THE CODE: How to import directly from MySQL5:20
In this lecture you will learn how to connect directly with Python to MySQL Database, retrieve data and import it directly into a Pandas DataFrame.
Practice: what code do you need?0:05
Practice question.
Practice Answer0:09
Answer for practice question.

PostgreSQL and pgAdmin3:00
In this lecture I walk you through the installation and configuration of PostgreSQL Database Server and pgAdmin4, the management tools for PostgreSQL database.
PostgreSQL sample database6:00
Here you will learn where to get a sample database for your PostgreSQL database Server and how to bring it in pgAdmin.
THE CODE: How to import directly from PostgreSQL4:15
In this lecture you will learn how to connect directly with Python to PostgreSQL Database, retrieve data and import it directly into a Pandas DataFrame.
Practice: What is the code?0:05
Practice question
Practice Answer0:07
Answer to practice question.
Closing lecture0:22
This lecture closes the course.

Requirements

Basics of Python and Pandas.

Description

Don't be the guy who can only import a csv file into Pandas, learn the techniques to connect directly with Python to a variety of database sources and import data directly into Pandas DataFrames.

At the end of this course you will be able to connect and import directly from ORACLE Database, IBM DB2, MS SQL Server, MySQL, Postgresql, and SQLite, and you will know how to deal with tricky connection parameter and where to find them.

This course is design for you to stand out from the crowd.

Who this course is for:

Anyone who wants to be able to retrieve data with Python directly from any database and import it into Pandas DataFrames.

Python Pandas: connect & import directly any database

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 6min

SQLite4 lectures • 13min

MS SQL SERVER5 lectures • 25min

ORACLE4 lectures • 20min

IBM7 lectures • 51min

MySQL5 lectures • 16min

PostgreSQL6 lectures • 14min

Requirements

Description

Who this course is for: