English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 58 lectures (5h 32m) | 1.60 GB
Build and connect Python Application to multiple databases
In today’s data-driven world, businesses rely on multiple relational databases to store and manage their valuable information. Python, being a powerful and versatile programming language, offers a wide range of tools and libraries that enable seamless integration and interaction with these databases. In this advanced Python course, you will explore the intricacies of working with multiple relational databases and learn how to harness Python’s capabilities to manipulate, query, and manage data effectively across different database systems.
When creating Python programs, you’ll likely want to populate data in an application automatically, or save data between user sessions. Databases help you to do this. They provide an organized structure so you can easily access, store, and manage large amounts of data. In this course, we’ll look at how to use databases in Python 3, we’ll create databases in SQLite, MySQL, SQL Server, Postgres. Then we’ll experiment with those databases using special Python modules that implement the Python database API.
By the end of this course, you will have gained the expertise to confidently work with multiple relational databases using Python, enabling you to seamlessly integrate, manage, and manipulate data across different database systems. Whether you are a data engineer, database administrator, or Python developer, this advanced course will equip you with the skills and knowledge to tackle complex database challenges and drive impactful solutions in your organization. Join us on this exciting journey to master the art of advanced Python – working with multiple relational databases.
What you’ll learn
- Establishing database connections in Python.
- Performing CRUD operations (Create, Read, Update, Delete) on database records.
- Executing SQL queries using Python’s database APIs.
- Working with different database management systems such as MySQL, PostgreSQL, SQLite, SQL Server
- Building a Python Application
- Connecting Python Application to multiple databases
- Creating databases and tables
Table of Contents
Introduction and Python Setup
1 Introduction
2 What is a database
3 Python Database API
4 Install Python on Windows
5 Install Python on Macs
6 Note on text editors
7 Installing Visual Studio Code
8 Create project directory and Python file
Build an application with Python
9 What we will create
10 The application design sketch
11 Creating the application GUI – Part 1
12 Creating the application GUI – Part 2
13 Creating the application GUI – Part 3
14 Creating the application GUI – Part 4
15 Creating the application GUI – Part 5
Python and Microsoft SQL Server Database Interaction
16 Download SQL Server
17 Install SQL Server
18 Install SQL Server Management Studio – SSMS
19 Connect SSMS to SQL Server
20 Create a new database and table
21 Create a database configuration file
22 Install Python SQL Server Connector
23 Connect Python file to SQL Server Database
24 Create a cursor object
25 Create a class and methods
26 Add more methods
27 Create a function for selected rows
28 Create more functions
29 Activate button widgets
30 Python and SQL Server Database Interaction Part 1
31 Python and SQL Server Database Interaction Part 2
Python and MySQL Database Interaction
32 Installing MySQL
33 Install MySQL on Mac
34 MySQL Workbench
35 Create a database and table
36 Create a database configuration file
37 Install Python MySQL Connector
38 Python MySQL Connection Configuration
39 Testing Python and MySQL Database Connection
40 Python and MySQL Database Interaction Part 1
41 Python and MySQL Database Interaction Part 2
Python and PostgreSQL Database Interaction
42 Install PostgreSQL
43 Connect to PostgreSQL with PgAdmin
44 Create a database and table
45 Create a sequence
46 Database configuration file
47 Install Python PostgreSQL Database Connector
48 Modify app to connect to PostgreSQL
49 Testing the connection to PostgreSQL
50 Python and PostgreSQL Database Interaction – Part 1
51 Python and PostgreSQL Database Interaction – Part 2
Python and SQLite Database Interaction
52 Installing SQLite
53 Modify Python App to connect to SQLite
54 Test connection to SQLite Database
55 Python and SQLite Interaction
56 SQLite Studio
57 DB Browser for SQLite
58 Viewing database records
Resolve the captcha to access the links!