Creating a Multi-Table Database App with Python Tkinter
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.
Your Instructor
Alexandra Kropf is Mammoth Interactive's CLO and a software developer with extensive experience in full-stack web development, app development and game development. She has helped produce courses for Mammoth Interactive since 2016, including the Coding Interview series in Java, JavaScript, C++, C#, Python and Swift.
Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more.
Over 12 years, Mammoth Interactive has built a global student community with 4 million courses sold. Mammoth Interactive has released over 350 courses and 3,500 hours of video content.
Founder and CEO John Bura has been programming since 1997 and teaching
since 2002. John has created top-selling applications for iOS, Xbox and
more. John also runs SaaS company Devonian Apps, building
efficiency-minded software for technology workers like you.
Course Curriculum
-
Start01. Introduction (4:42)
-
Start02. Variables (19:17)
-
Start03. Type Conversion Examples (10:04)
-
Start04. Operators (7:04)
-
Start05. Operators Examples (21:52)
-
Start06. Collections (8:23)
-
Start07. Lists (11:38)
-
Start08. Multidimensional List Examples (8:05)
-
Start09. Tuples Examples (8:34)
-
Start10. Dictionaries Examples (14:24)
-
Start11. Ranges Examples (8:30)
-
Start12. Conditionals (6:41)
-
Start13. If Statement Examples (10:16)
-
Start14. If Statement Variants Examples (11:18)
-
Start15. Loops (7:00)
-
Start16. While Loops Examples (11:30)
-
Start17. For Loops Examples (11:18)
-
Start18. Functions (7:47)
-
Start19. Functions Examples (9:16)
-
Start20. Parameters And Return Values Examples (13:46)
-
Start21. Classes And Objects (11:13)
-
Start22. Classes Example (13:11)
-
Start23. Objects Examples (9:54)
-
Start24. Inheritance Examples (17:26)
-
Start25. Static Members Example (11:03)
-
Start26. Summary And Outro (4:06)
-
StartSource code
-
Start01. Create A Database (4:00)
-
Start02. Build Database Tables (5:25)
-
Start03. Insert Records (9:18)
-
Start04. Select Records (5:48)
-
Start05. Connect To A Database (3:19)
-
Start06. Build A Row From User Input (10:27)
-
Start07. Check If Entry Already Exists (5:39)
-
Start08. Introduction To SQL Joins (3:53)
-
Start09. Build SQL Joins (11:32)
-
StartSource Files