Mammoth Club All levels 5 sections 41 lectures

Build multi table database app with Python

Build multi table database app with Python

01
Skill level
All levels
02
Sections
5
03
Lectures
41
04
Instructor
John Bura
What's inside

This course includes.

5
Sections
41
Lectures
41
Resources
Certificate of completion
Included
Mobile and desktop access
Included
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content

Curriculum & lectures.

5 sections · 41 lectures
+ Build Python Tkinter teacher database gui app 3 lectures
01 Build Python Tkinter Student Database Grid Locked
02 Build Input Fields In Python Desktop App Locked
Source files Locked
+ Build SQLite multi table database with Python 4 lectures
01 Connect To Database With Python Locked
02 Create Row In Database With Python Locked
03 Read One Value From All Rows In Database With Python Locked
16 Source files Locked
+ Connect SQLite backend with Python Tkinter frontend 3 lectures
01 Create Row In Database From Frontend Locked
02 Show Backend Db In Frontend Python Gui Locked
Source files Locked
+ Python Introduction 21 lectures
01. Introduction To Python Locked
02. Variables Locked
02b. Variables Examples Locked
03. Type Conversion Examples Locked
04. Operators Locked
05. Operators Examples Locked
06. Collections Locked
07. Lists Locked
08. Multidimensional List Examples Locked
09. Tuples Examples Locked
10. Dictionaries Examples Locked
11. Ranges Examples Locked
12. Conditionals Locked
13. If Statement Examples Locked
14. If Statement Variants Examples Locked
15. Loops Locked
16. While Loops Examples Locked
17. For Loops Examples Locked
18. Functions Locked
19. Functions Examples Locked
00. Intro Locked
+ (Prerequisite) Introduction to SQLite Python 10 lectures
01 Create A Database Locked
02 Build Database Tables Locked
03 Insert Records Locked
04 Select Records Locked
05 Connect To A Database Locked
06 Build A Row From User Input Locked
07 Check If Entry Already Exists Locked
08 Introduction To SQL Joins Locked
09 Build SQL Joins Locked
Source Files Locked
Description

About this course.

Welcome to the Build a Multi-Table Database App with Python course! In this program, you will learn how to create a database-driven application using Python and interact with multiple database tables.

Throughout the course, you will be guided step-by-step in building a robust application that can handle complex data structures. You will learn how to design a database schema with multiple tables and establish relationships between them.

Starting from scratch, you will explore various database concepts and techniques, including creating tables, defining primary and foreign keys, and establishing table relationships such as one-to-one, one-to-many, and many-to-many.

You will learn how to connect your Python application to the database and perform essential CRUD (Create, Read, Update, Delete) operations on multiple tables. You will discover how to retrieve data from multiple tables using SQL queries and leverage the power of Python to manipulate and present the data.

Throughout the course, you will also learn best practices for handling database transactions, managing data integrity, and ensuring efficient data retrieval and manipulation.

By the end of this course, you will have a solid understanding of building a multi-table database app with Python. You will be equipped with the skills to design and manage complex databases, establish table relationships, and perform advanced data manipulation.

Enroll now and embark on a journey to become a skilled database developer. Develop your proficiency in Python and database management, and unlock the ability to build powerful, multi-table database applications. Get ready to create dynamic and efficient applications that can handle large datasets and deliver exceptional user experiences.


Instructors

Taught by people who ship.

John Bura

John Bura

Founder and CEO of Mammoth Club and Course Pro, the #1 AI-powered Learning Management System for course and content development, training and evaluation.

Ready to start building?

Build multi table database app with Python

Buy lifetime access →