Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 23 Minute(s)
Language
English
Taught by
Code Pro
Rating
Course Overview
ORACLE Database, IBM Db2, MS SQL Server, MySQL, Postgresql, SQLite
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.
Course Content
- 7 section(s)
- 32 lecture(s)
- Section 1 Introduction
- Section 2 SQLite
- Section 3 MS SQL SERVER
- Section 4 ORACLE
- Section 5 IBM
- Section 6 MySQL
- Section 7 PostgreSQL
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
Skills covered in this course
Reviews
-
MMariano Javier Lenkiewicz
It is concise and practical course with some important tips that should be taken in advantage!
-
YYedou Lare
It is ok but couse need to be update
-
TThomas Houze
Yes, I am very impressed so far by the clarity of the explainations while going through the exercises. It makes me feel as if I am sitting in the classroom with a truly excellent instructor.
-
SSteven 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.
