Chod Matrix > Development > Database Design & Development > MySQL Databases | Python Programming (Build App and API)

4.7 out of 5

14 reviews on Udemy

MySQL Databases | Python Programming (Build App and API)

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

Instructor:

247 Learning

1,068 students enrolled

English [Auto]

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

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.

MySQL Database Server Setup

Introduction

What is MySQL

MySQL Download and Installation on Windows

MySQL Download and Installation on Mac

What is MySQL Workbench

Installing MySQL Workbench on a Mac

Database Concepts

What is a Schema

Database Schema

MySQL Data Types

Introduction to Database Modeling

Introduction to data modeling

Creating a model - Part 1

Creating a model - Part 2

Basic Modeling

Creating MySQL Objects

MySQL Naming Convention

Creating a new MySQL Database

Using IF NOT EXIST DROP

Creating a Table in MySQL

Setting a default database in MySQL

Using Comments

Primary Keys

Foreign Keys

MySQL Statements

Overview of some fundamental MySQL statements

What is CRUD

MySQL SELECT Statement

MySQL INSERT Statement

MySQL UPDATE Statement

MySQL DELETE Statement

Data Extraction from multiple tables in MySQL

Introduction to MySQL Table Joins

MySQL INNER Join

MySQL LEFT Join

MySQL RIGHT Join

MySQL SELF Join

MySQL Stored Procedures

What are Stored Procedures

Creating Stored Procedures

Modifying Stored Procedures

Creating an advanced Stored Procedure

Calling and deleting a Stored Procedure

MySQL Subqueries and Derived Tables

What is a Subquery

Nested Subqueries

Derived Tables

MySQL Aggregate Functions

Introduction to Aggregate Functions

AVG Aggregate Functions

COUNT Aggregate Functions

SUM Aggregate Functions

MIN Aggregate Functions

MAX Aggregate Functions

Python Setup

What is Python

What is Jupyter Notebook

Installing Jupyter Notebook Server

Running Jupyter Notebook Server

Jupyter Notebook Dashboard

Creating a new Notebook

Notebook Components

Python Programming Fundamentals

Python Expressions

Python Statements

Python Comments

Python Data Types

Casting Data Types

Variables

Python List

Python Dictionary

Python Operators

Python Conditional Statements

Python Loops

Python Functions

Build a Database driven app with Python and MySQL

What we will build

Install Python on Windows

Install Python on Mac

Application Design

Note on Text Editors

Install Visual Studio Code

Creating a project directory and Python file

Creating the application interface - Part 1

Creating the application interface - Part 2

Creating the application interface - Part 3

Creating the application interface - Part 4

Creating the application interface - Part 5

Create a database and table

Create and activate a virtual environment

Install MySQL Connector

Creating a configuration connection file

Create a class with methods

Creating Functions

Activating button widgets

Modifying python file for mysql interaction

Testing connection to database with Python

Interacting with MySQL from Python - Part 1

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!

4.7

4.7 out of 5

14 Ratings