Explore

Using Databases with Python

Approx. 15 hours to complete

Save Course

Go to Course

Course Summary

Learn how to use Python to work with databases in this course. From basic SQL to using APIs, this course covers a range of topics to help you become proficient in database management with Python.

Key Learning Points

Learn how to use Python to interact with SQL databases
Understand how to use APIs to access data in various formats
Build proficiency in database management with Python

Job Positions & Salaries of people who have taken this course might have

- USA: $72,000 - $120,000
- India: ₹350,000 - ₹1,800,000
- Spain: €25,000 - €50,000
- USA: $72,000 - $120,000
- India: ₹350,000 - ₹1,800,000
- Spain: €25,000 - €50,000
- USA: $90,000 - $140,000
- India: ₹450,000 - ₹2,500,000
- Spain: €30,000 - €60,000
- USA: $72,000 - $120,000
- India: ₹350,000 - ₹1,800,000
- Spain: €25,000 - €50,000
- USA: $90,000 - $140,000
- India: ₹450,000 - ₹2,500,000
- Spain: €30,000 - €60,000
- USA: $80,000 - $140,000
- India: ₹400,000 - ₹2,000,000
- Spain: €25,000 - €50,000

Learning Outcomes

Understand how to interact with SQL databases using Python
Learn how to use APIs to access data in various formats
Gain proficiency in database management with Python

Prerequisites or good to have knowledge before taking this course

Basic knowledge of Python
Familiarity with databases and SQL

Course Difficulty Level

Intermediate

Course Format

Online
Self-paced

Similar Courses

Python Data Structures
Python for Everybody
Data Management and Visualization

Related Education Paths

Related Books

Description

This course will introduce students to the basics of the Structured Query Language (SQL) as well as basic database design for storing data as part of a multi-step data gathering, analysis, and processing effort. The course will use SQLite3 as its database. We will also build web crawlers and multi-step data gathering and visualization processes. We will use the D3.js library to do basic data visualization. This course will cover Chapters 14-15 of the book “Python for Everybody”. To succeed in this course, you should be familiar with the material covered in Chapters 1-13 of the textbook and the first three courses in this specialization. This course covers Python 3.

Knowledge

Use the Create, Read, Update, and Delete operations to manage databases
Explain the basics of Object Oriented Python
Understand how data is stored across multiple tables in a database
Utilize the Google Maps API to visualize data

Outline

Object Oriented Python
Welcome to Using Databases with Python
Unicode Characters and Strings
Windows 10: Installing Python and Writing A Program
Windows: Taking Screen Shots
Macintosh: Using Python and Writing A Program
Macintosh: Taking Screen Shots
14.1 - Object Oriented Definitions and Terminology
14.2 - Our First Class and Object
14.3 - Object Life Cycle
14.4 - Object Inheritance
Bonus: Interview - Software Engineering - Bertrand Meyer
Bonus: Office Hours - London
Help us learn more about you!
Python Textbook
Coming from Python 2 - Encoding Data in Python 3
Notice for Auditing Learners: Assignment Submission
Using Encoded Data in Python 3
Object Oriented Programming

Basic Structured Query Language
15.1 Relational Databases
15.2 - Using Databases
15.3 - Single Table CRUD
Worked Example: Counting Email in a Database
Bonus: Office Hours Zagreb, Croatia
Interview: Elizabeth Fong - The Early Years of SQL
Worked Example: Twspider.py (Chapter 15)
Single-Table SQL

Data Models and Relational SQL
15.4 - Designing a Data Model
15.5 - Representing a Data Model in Tables
15.6 - Inserting Relational Data
15.7 - Reconstructing Data with JOIN
Worked Example: Tracks.py (Chapter 15)
Bonus: Office Hours Perth, Australia
Bonus Interview: Niklaus Wirth
Bonus: Office Hours Barcelona
Multi-Table Relational SQL

Many-to-Many Relationships in SQL
15.8 - Many-to-Many Relationships
Worked Example: roster.py (Chapter 15)
Bonus: Office Hours Mexico, City
Bonus Interview: Andrew Tannenbaum - Minix
Worked Example: Twfriends.py (Chapter 15)
Many-to-Many Relationships and Python

Databases and Visualization
16.1 - Geocoding
16.2 - Geocoding Visualization
Worked Example: Geodata (Chapter 16)
Bonus: Office Hours - Amsterdam
Bonus Interview: Richard Stallman - Free Software Foundation
Bonus Interview: Brian Behlendorf - Apache Foundation
Peer Graded Assignment - Instructor Input
Please Rate this Course on Class-Central
Post-Course Survey
Keep Learning with Michigan Online

Summary of User Reviews

Discover the world of Python Databases with this course on Coursera. Students rave about the comprehensive learning experience and helpful instructors. One key aspect that many users thought was good is the practical exercises that give students hands-on experience with Python Databases.

Pros from User Reviews

Great instructors who are always available to help
Comprehensive learning experience covering a wide range of topics
Practical exercises give students hands-on experience with Python Databases
Flexible schedule allows students to learn at their own pace
Engaging and interactive course content keeps students interested

Cons from User Reviews

Some students found the course material to be too challenging
Lack of one-on-one interaction with instructors
Limited opportunities for interaction with other students
Not ideal for beginners with no prior programming experience
Course can be time-consuming and requires a significant time commitment

Recommended for you

Learn Ultimate Python-3 GUI Course With Tkinter,Qt and PyGTK

Build Python GUI Applications. All you need to know about Tkinter PYQT PYGTK & QT in Python & Create real world projects!...

Save Course

Microsoft Excel for Business Professionals

Tips, Tricks, and Best Practices Straight from Corporate America In today's day and age, Microsoft Excel is fully integrated in all businesses....

Save Course

Python for Unreal Engine Editor Tools Scripting

Step by step into the new editor Python API of the Unreal Engine towards a new world of productivity tools development...

Save Course

Microsoft Access VBA for Non Programmers - YOU Can Do This!

Microsoft Access VBA can be learned quickly even if you've never done programming! Make complex jobs easy with VBA! I am further confident in reading and writing code....

Save Course