Skip to content
Write a review
UdemyPythonPaid courseBeginner levelCertificate

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

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

4.3
67 reviews

Created by: Code Pro

Last updated January 2018

icon
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

How it compares

Against the other 388 rated Udemy courses in Python on CourseDuck:

  • Rating4.3 out of 5higher than 25% of them
  • Reviews67#370 of 389 by number of reviews
  • Length2.4 hoursshorter than 89% of them
  • Last updatedJanuary 2018earlier than 89% of them

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 86 / 100

icon
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.
Read More Beginner Beginner Level product length iconTime: 2.4h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

placeholder

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.

Read More

icon
More Python courses

$22.99

$17.99

Free

Free

$19.99

Free

All Python courses

icon
Reviews

4.3

67 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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.

By Steven Weaver

I appreciate all the examples for connecting to each RDMS type. I only use MSSQL and Oracle. However, I may use the others at some point.

Showing 12 of 13 reviews

Python Pandas: connect & import directly any database
Visit course on Udemy Write a review
  • Video Duration: icon 2.4h
  • Price: $39.99
  • Provider: icon Udemy
  • Updated: icon January 2018
  • Level: Beginner Beginner
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com