Using Databases with Python

Description

In this course, you will learn :

• To manage databases, use the Create, Read, Update, and Delete operations.
• Explain the fundamentals of Object-Oriented Python.
• Understand how data is stored in a database across multiple tables.
• To visualise data, use the Google Maps API.

Syllabus :

1. Object Oriented 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
• Object Oriented Definitions and Terminology
• Our First Class and Object
• Object Life Cycle
• Object Inheritance

 

2. Basic Structured Query Language

• Relational Databases
• Using Databases
• Single Table CRUD
• Worked Example: Counting Email in a Database

 

3. Data Models and Relational SQL

• Designing a Data Model
• Representing a Data Model in Tables
• Inserting Relational Data
• Reconstructing Data with JOIN

 

4. Many-to-Many Relationships in SQL

• Many-to-Many Relationships
• Worked Example: roster.py

 

5. Databases and Visualization

• Geocoding
• Geocoding Visualization

Show more