Backend Development with Python and MySQL

This course will teach you to develop a fully functional application using Python and MySQL backend. While front-end knowledge is not required, it is recommended.

This course consists of three parts.

Part 1: Relational Databases & MySQL

Part 2: Python Beginners to professional level

Part 3: Fully functional web application combining Python and MySQL. We will use the Django Framework while discussing more advanced Databases and Software Development topics.

In this course, we will learn the concept of Relational Databases from the basics to the developer/administrator level; we will learn how to create the backend of a project using Python and the Django framework. At the end of this course, you will develop a fully functional application ready for deployment.

Part 1 : MySQL Basics

Week 1: Introduction to Relational Database Management System, SQL Comments and Operators

Week 2: Querying Data, Sorting Data, Filtering Data, Joining Tables.

Week 3: Grouping Data, Sub-queries.

Week 4: Modifying Data and Transactions

Week 5: Databases, Tables, and Storage Engines

Week 6: More tables and database operations & Set operators

Week 7: Globalization, Import, and Export

Part 1 Quiz

Part 2: Python

Week 8: Introduction to Python,  syntax, comments, variables, and scope

Week 9: Datatypes, number and casting

Week 10: Strings, String formatting, Boolean and Operators

Week 11: Lists, Tuples, Set and Dictionaries

Week 12: Conditional Statements and Loops

Week 13: Functions, Lambda and Arrays

Week 14: Classes, Objects, and Inheritance

Week 15: Dates, Math and Regex

Week 16: Error and File Handling

Week 17: User input, Python Libraries and the flask framework

Week 18: Part 2 Quiz

Part 3 : Software Development Project: Infectious Disease Data Collection and Storage

Week 19: Setting up the development environment

Week 20: MySQL Administration

Week 21/22: MySQL Stored procedure

Week 23/24:MySQL Triggers

Week 25 : MySQL Views and Indexes

Week 26-28 : Class project: Fully Functional Software

Week 29/30 : Final Project (Topic of choice), Part 3 Quiz, Final Examination

13 Practical Assignments

3 MCQ Quizzes

I final Examination and Project

Education

BSc. Computer Science - Kogi State University

ALM. Software Engineering - Harvard University

Grad.Cert: Data Science - Harvard University

Profession

Senior Engineer: GroupSense, USA

Consultant case-based surveillance: Organisation of Eastern Caribbean States

Principal Engineer: Mildred Group

Talent & Engineering Consultant: Andela, Gun.io, Baires Dev.