Python Pandas: connect & import directly any database

Python Pandas: connect & import directly any database
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 48000 Hz, 2ch | Size: 283 MB
Genre: eLearning Video | Duration: 32 lectures (2 hours, 23 mins) | Language: English

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

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

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.