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