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 Homepage: https://www.udemy.com/course/python-pandas-connect-import-directly-any-database/
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.
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.