Advanced Python- Working with multiple databases

Advanced Python: Working with multiple databases, available at $49.99, has an average rating of 4.75, with 58 lectures, based on 2 reviews, and has 1019 subscribers.

You will learn about Establishing database connections in Python. Performing CRUD operations (Create, Read, Update, Delete) on database records. Executing SQL queries using Pythons 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 This course is ideal for individuals who are Beginner Python Developers or Beginner Data Analyst It is particularly useful for Beginner Python Developers or Beginner Data Analyst.

Enroll now: Advanced Python: Working with multiple databases

Summary

Title: Advanced Python: Working with multiple databases

Price: $49.99

Average Rating: 4.75

Number of Lectures: 58

Number of Published Lectures: 58

Number of Curriculum Items: 58

Number of Published Curriculum Objects: 58

Original Price: $59.99

Quality Status: approved

Status: Live

What You Will Learn

Establishing database connections in Python.

Performing CRUD operations (Create, Read, Update, Delete) on database records.

Executing SQL queries using Pythons 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

Who Should Attend

Beginner Python Developers

Beginner Data Analyst

Target Audiences

Beginner Python Developers

Beginner Data Analyst

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.

Course Curriculum

Chapter 1: Introduction and Python Setup

Lecture 1: Introduction

Lecture 2: What is a database

Lecture 3: Python Database API

Lecture 4: Install Python on Windows

Lecture 5: Install Python on Macs

Lecture 6: Note on text editors

Lecture 7: Installing Visual Studio Code

Lecture 8: Create project directory and Python file

Chapter 2: Build an application with Python

Lecture 1: What we will create

Lecture 2: The application design sketch

Lecture 3: Creating the application GUI – Part 1

Lecture 4: Creating the application GUI – Part 2

Lecture 5: Creating the application GUI – Part 3

Lecture 6: Creating the application GUI – Part 4

Lecture 7: Creating the application GUI – Part 5

Chapter 3: Python and Microsoft SQL Server Database Interaction

Lecture 1: Download SQL Server

Lecture 2: Install SQL Server

Lecture 3: Install SQL Server Management Studio – SSMS

Lecture 4: Connect SSMS to SQL Server

Lecture 5: Create a new database and table

Lecture 6: Create a database configuration file

Lecture 7: Install Python SQL Server Connector

Lecture 8: Connect Python file to SQL Server Database

Lecture 9: Create a cursor object

Lecture 10: Create a class and methods

Lecture 11: Add more methods

Lecture 12: Create a function for selected rows

Lecture 13: Create more functions

Lecture 14: Activate button widgets

Lecture 15: Python and SQL Server Database Interaction: Part 1

Lecture 16: Python and SQL Server Database Interaction: Part 2

Chapter 4: Python and MySQL Database Interaction

Lecture 1: Installing MySQL

Lecture 2: Install MySQL on Mac

Lecture 3: MySQL Workbench

Lecture 4: Create a database and table

Lecture 5: Create a database configuration file

Lecture 6: Install Python MySQL Connector

Lecture 7: Python MySQL Connection Configuration

Lecture 8: Testing Python and MySQL Database Connection

Lecture 9: Python and MySQL Database Interaction: Part 1

Lecture 10: Python and MySQL Database Interaction: Part 2

Chapter 5: Python and PostgreSQL Database Interaction

Lecture 1: Install PostgreSQL

Lecture 2: Connect to PostgreSQL with PgAdmin

Lecture 3: Create a database and table

Lecture 4: Create a sequence

Lecture 5: Database configuration file

Lecture 6: Install Python PostgreSQL Database Connector

Lecture 7: Modify app to connect to PostgreSQL

Lecture 8: Testing the connection to PostgreSQL

Lecture 9: Python and PostgreSQL Database Interaction – Part 1

Lecture 10: Python and PostgreSQL Database Interaction – Part 2

Chapter 6: Python and SQLite Database Interaction

Lecture 1: Installing SQLite

Lecture 2: Modify Python App to connect to SQLite

Lecture 3: Test connection to SQLite Database

Lecture 4: Python and SQLite Interaction

Lecture 5: SQLite Studio

Lecture 6: DB Browser for SQLite

Lecture 7: Viewing database records

Instructors

247 Learning
An investment in knowledge pays the best interest

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 0 votes

4 stars: 1 votes

5 stars: 1 votes

Frequently Asked Questions

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!