Python Pandas: connect & import directly any database (Udemy.com)

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

( 13 Reviews )

Created by: Code Pro

Produced in 2017

What you will 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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 96 / 100

Course 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.

Time: 2.5h

Instructor Details

Code Pro

4.8 Rating
13 Reviews

I have 15 years' experience providing professional services to major companies such as ExxonMobil, Shell, British Petroleum, Unilever, PriceWaterHouseCoopers, KPMG, Unilever, PwC, KPMG, Avery Dennison, DuPont, Medtronic, Imperial Tobacco, Fiat...
I have worked on high profile projects including the bribery investigation that led the US Department of Justice to impose criminal and civil penalties for bribery on Oil companies. This involved of the use of advance data analysis to acquire evidence.
Specialised in Python, Pandas (Data Analysis), SQL, Django, Bokeh (Data Visualisation), DataShader and Kivy.
I was part of building the biggest commercial data Mart, processing some 350 million transactions per query.

I enjoy sharing knowledge, and I hope you will enjoy and benefit from my courses.

Rock the JVM! Akka Persistence with Scala

Rock the JVM! Akka Persistence with Scala (2021)
4.9 (22 Reviews)

- Provider: Udemy
- Time: 7h

$11.99

SQL and PostgreSQL: The Complete Developer's Guide

SQL and PostgreSQL: The Complete Developer's Guide (2021)
4.8 (60 Reviews)

- Provider: Udemy
- Time: 22h

$11.99

Practical SQL Bootcamp for Data Analysts and Data Scientists

Practical SQL Bootcamp for Data Analysts and Data Scientists (2021)
4.8 (50 Reviews)

- Provider: Udemy
- Time: 3.5h

$11.99

Python 3 Complete Masterclass - Make Your Job Tasks Easier!

Python 3 Complete Masterclass - Make Your Job Tasks Easier! (2021)
4.7 (414 Reviews)

- Provider: Udemy
- Time: 15.5h

$11.99

REST APIs with Flask and Python (2021)
4.7 (374 Reviews)

- Provider: Udemy
- Time: 17h

$11.99

Python Django Dev To Deployment (2018)
4.7 (361 Reviews)

- Provider: Udemy
- Time: 11h

$11.99

All postgresql courses

Reviews

4.8

13 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Piotr Kowalski

Amaaaaaaaaaazing!

Clear and concise, and the code works like a charm.

Great to see that level of professionalism.

Thanks for sharing code and tricks on getting data out of Enterprise level Databases Oracle, IBM, MS SQL Server... Internet is full of stuff about SQLite, but seriously which company is using SQLite.

Thanks again. Looking forward to get more of your stuff.

By Squirrelpatrick

it worked

By Mike Norris

excellent

By 江欣瑋

understandable~Nice~

By Nadeem Shahzad

Very professional,highly recommend.

By Michael Pomeroy

Very clear and thorough.

By Christopher DeBracy

I would have liked to see some additional content around manipulation of data, i.e. loading files into the database from the file system, converting csv or pipe-delimited data into usable content.

What is covered around connecting to the database is well done.

By Francky Noyez

Very well explained. Thoroughly. Practical. Super!

By Mxch5

Excellent course, quick survey of several databases in a way that allows you to get up to speed quickly.

By Dipanjan Saha

Was looking for more examples of the problem. However to understand the connection with different database it is good.

By Pavani Pallavi

I just brought the course of "Python Pandas: connect & import directly any database", which I feel is totally incomplete. Friends suggested me to do online courses for Python in Udemy than a any other website, because of experienced Instructors.

The description stated "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."

What is point of just importing data without real examples?

How to analyse the data after importing?

Deeply disappointed.