Mysql Databases | Python Programming (Build App And Api)

Build Database Driven App | Build API with Python, Django ,MySQL , REST Framework

What you'll learn

Setting up MySQL Database Server

Creating Objects like Databases and Tables in MySQL

Setting up Python

Setting up a development environment for Django.

Implementing MySQL table joins

Mastering the basic syntax and constructs of Python.

Writing Python functions and classes using object-oriented programming (OOP).

Integrating MySQL with Django using Django's Object-Relational Mapping (ORM).

Building an API using Django and Django REST Framework.

Implementing Create, Retrieve, Update, Delete (CRUD) operations in the API.

Testing APIs using tools like Postman

Understanding API serialization and how to use it in Django REST Framework.

Building a desktop application with Python and MySQL

Requirements

Basic knowledge of Python advised but not mandatory

Basic knowledge of Database Concepts advised but not mandatory

Software required is covered in the course.

Description

In this comprehensive course, you will embark on a journey of learning and practical application that leverages MySQL databases and Python programming. By the end of this course, you'll have built a database-driven application and an API using Python, Django, MySQL, and the REST framework.MySQL, an open-source relational database management system (RDBMS), is renowned for its speed and reliability. Python, on the other hand, is a versatile and powerful high-level programming language, praised for its simplicity and readability. The combination of these two technologies provides a solid foundation for creating robust and scalable web applications.The first part of the course is dedicated to providing you with a thorough understanding of MySQL databases, where you will explore MySQL's capabilities, including data types, operators, SQL statements, and table joins. From creating databases and tables to writing complex queries, you'll gain hands-on experience and learn best practices for optimizing your database.Next, you'll immerse yourself in Python programming, where you will learn Python  fundamentals which includes, Expressions, Statements, Variables, Operators, conditional statements,loops and functions.We will explore how to build  a database driven application and API using Python,MySQL, Django and the REST Framework. Throughout the course, we'll be creating a fully functional web application and API from scratch, which will serve as a tangible testament to your newfound skills. This project-based learning approach ensures you understand the concepts and how they come together in real-world applications.Whether you're a beginner looking to jumpstart your career in web development, or an experienced programmer aiming to add new tools to your repertoire, this course will provide you with a thorough understanding and practical skills to build database-driven apps and APIs with Python, Django, MySQL, and the REST Framework.Join us in this exciting course, "MySQL Databases | Python Programming: Build Database Driven App and API", and take your web development skills to the next level.

Overview

Section 1: MySQL Database Server Setup

Lecture 1 Introduction

Lecture 2 What is MySQL

Lecture 3 MySQL Download and Installation on Windows

Lecture 4 MySQL Download and Installation on Mac

Lecture 5 What is MySQL Workbench

Lecture 6 Installing MySQL Workbench on a Mac

Lecture 7 Database Concepts

Lecture 8 What is a Schema

Lecture 9 Database Schema

Lecture 10 MySQL Data Types

Section 2: Introduction to Database Modeling

Lecture 11 Introduction to data modeling

Lecture 12 Creating a model - Part 1

Lecture 13 Creating a model - Part 2

Lecture 14 Basic Modeling

Section 3: Creating MySQL Objects

Lecture 15 MySQL Naming Convention

Lecture 16 Creating a new MySQL Database

Lecture 17 Using IF NOT EXIST DROP

Lecture 18 Creating a Table in MySQL

Lecture 19 Setting a default database in MySQL

Lecture 20 Using Comments

Lecture 21 Primary Keys

Lecture 22 Foreign Keys

Section 4: MySQL Statements

Lecture 23 Overview of some fundamental MySQL statements

Lecture 24 What is CRUD

Lecture 25 MySQL SELECT Statement

Lecture 26 MySQL INSERT Statement

Lecture 27 MySQL UPDATE Statement

Lecture 28 MySQL DELETE Statement

Section 5: Data Extraction from multiple tables in MySQL

Lecture 29 Introduction to MySQL Table Joins

Lecture 30 MySQL INNER Join

Lecture 31 MySQL LEFT Join

Lecture 32 MySQL RIGHT Join

Lecture 33 MySQL SELF Join

Section 6: MySQL Stored Procedures

Lecture 34 What are Stored Procedures

Lecture 35 Creating Stored Procedures

Lecture 36 Modifying Stored Procedures

Lecture 37 Creating an advanced Stored Procedure

Lecture 38 Calling and deleting a Stored Procedure

Section 7: MySQL Subqueries and Derived Tables

Lecture 39 What is a Subquery

Lecture 40 Nested Subqueries

Lecture 41 Derived Tables

Section 8: MySQL Aggregate Functions

Lecture 42 Introduction to Aggregate Functions

Lecture 43 AVG Aggregate Functions

Lecture 44 COUNT Aggregate Functions

Lecture 45 SUM Aggregate Functions

Lecture 46 MIN Aggregate Functions

Lecture 47 MAX Aggregate Functions

Section 9: Python Setup

Lecture 48 What is Python

Lecture 49 What is Jupyter Notebook

Lecture 50 Installing Jupyter Notebook Server

Lecture 51 Running Jupyter Notebook Server

Lecture 52 Jupyter Notebook Dashboard

Lecture 53 Jupyter Notebook Dashboard

Lecture 54 Creating a new Notebook

Lecture 55 Notebook Components

Section 10: Python Programming Fundamentals

Lecture 56 Python Expressions

Lecture 57 Python Statements

Lecture 58 Python Comments

Lecture 59 Python Data Types

Lecture 60 Casting Data Types

Lecture 61 Variables

Lecture 62 Python List

Lecture 63 Python Dictionary

Lecture 64 Python Operators

Lecture 65 Python Conditional Statements

Lecture 66 Python Loops

Lecture 67 Python Functions

Section 11: Build a Database driven app with Python and MySQL

Lecture 68 What we will build

Lecture 69 Install Python on Windows

Lecture 70 Install Python on Mac

Lecture 71 Application Design

Lecture 72 Note on Text Editors

Lecture 73 Install Visual Studio Code

Lecture 74 Creating a project directory and Python file

Lecture 75 Creating the application interface - Part 1

Lecture 76 Creating the application interface - Part 2

Lecture 77 Creating the application interface - Part 3

Lecture 78 Creating the application interface - Part 4

Lecture 79 Creating the application interface - Part 5

Lecture 80 Create a database and table

Lecture 81 Create and activate a virtual environment

Lecture 82 Install MySQL Connector

Lecture 83 Creating a configuration connection file

Lecture 84 Create a class with methods

Lecture 85 Creating Functions

Lecture 86 Activating button widgets

Lecture 87 Modifying python file for mysql interaction

Lecture 88 Testing connection to database with Python

Lecture 89 Interacting with MySQL from Python - Part 1

Lecture 90 Interacting with MySQL from Python - Part 2

Lecture 91 Project Code

Section 12: Build API with Python | Django | MySQL | REST Framework

Lecture 92 Introduction

Lecture 93 Create and activate a virtual environment

Lecture 94 What is Django

Lecture 95 Install Django

Lecture 96 Install REST Framework

Lecture 97 Install Corsheaders

Lecture 98 Create a Django Project

Lecture 99 Create a Django App

Lecture 100 Register Applications

Lecture 101 Django and MySQL Database Setup

Lecture 102 Applying Initial Migration

Lecture 103 Create a Django Model

Lecture 104 Create and apply a new migration

Lecture 105 Create a serializer class

Lecture 106 Starting and stopping Django Development Server

Lecture 107 Create a superuser account

Lecture 108 Creating Views - Part 1

Lecture 109 Creating Views - Part 2

Lecture 110 Mapping Views to URLS

Lecture 111 Register Model with Admin Site

Lecture 112 Create Model Objects

Lecture 113 Installing Postman

Lecture 114 Testing API with CRUD Operations

Lecture 115 Project Code

Beginner Python Developers,Beginner Database Administrators,Beginner Data Scientist,Beginner Data Analyst,Beginner Data Engineers