Python Database Course: SQLite, PostgreSQL, MySQL,SQLAlchemy

Name: Python Database Course: SQLite, PostgreSQL, MySQL,SQLAlchemy
Rating: 4.5 (78 reviews)

Master Databases in Python: In-Depth Training on SQLAlchemy, SQLite, PostgreSQL, and MySQL

Created byElshad Karimov

Last updated 1/2025

English

What you'll learn

Understand and Apply Fundamental Python Database Concepts
Implement and Manage SQLite Databases using Python
Develop Proficiency with PostgreSQL and MySQL using Python
Master SQLAlchemy for Database Operations
Adapt to Real-world Scenarios with Hands-On Projects

Course content

15 sections • 109 lectures • 13h 9m total length

Getting the Most Out of This Course4:27
How to use the Course1:38
Learn to navigate the Python database mastery course, starting with the Python starter kit and SQLite section to learn core SQL concepts, then progress to SQLAlchemy, PostgreSQL, and MySQL.

IDE - Code Editor for the Course8:08
Learn to use Replit as the Python editor, create repls, adjust settings, run code to see console output, and debug syntax errors with strings and quotes.
Values and Types10:45
Variables9:27
Operators15:08
Asking User for Input10:43
Explore how to gather user input in Python using the input function, with prompts, variable assignment, and simple string concatenation. Use backslash n to create a new line in prompts.
Python Comments4:44
Variable Naming5:36
Boolean Expressions7:00
Conditional Execution13:20
Nested Conditionals11:18
Chained Conditionals10:03
Multiple IF Statements10:43
Explore the difference between chained if-elif-else and multiple independent if statements in Python, and learn to apply checks to adjust a mortgage rate based on salary, credit score, and disability.
Logical Operators8:11
Try and Except14:29
Calling Builtin Functions7:02
Math Module12:06
Random Module10:52
Defining Function9:39
Indentation in Python9:12
Function with Inputs9:42
Positional and Keyword Arguments9:41
Function with Output15:16
Docstring4:11
List and Iterations13:44
For Loop9:33
Updating Variables4:51
Loop Over Custom Function3:09
Range Function with Loop5:23
While Loop4:12
Continue and Break7:37
Learn how continue and break statements control loops in Python. Use for and while loops with range to skip iterations or terminate the loop, with practical number examples.
What is a String?10:35
Explore how strings work in Python, from quoting to indexing and slicing. Learn to use length and negative indices to access characters and substrings.
String Operations8:56
String Methods10:20
Explore core Python string methods and how to invoke them on string objects. Learn to use type, dir, capitalize, upper, lower, find, and strip, and how to access help.
String Parsing7:59
Escape Sequence5:23
String Formatting12:42

What is SQL?4:08
What is SQLite?2:19
Connect SQLite with Python6:59
SQLite Browser5:06
Create Table in SQLite5:52
What is Cursor?2:39
Insert INTO - Adding Data to a Table in SQLite12:02
Insert data from CSV to SQLite7:40
SELECT - Retrieve Data from SQLIte6:35
WHERE - Filter Data in SQLite12:38
Master the where clause in SQLite to filter data, using operators such as =, >, and between, with and, or, in, like, not equal, and case sensitivity.
UPDATE - Change Data6:07
DELETE / DROP - Remove Data4:42
JOINS - Access Tables Together7:47
SQLite Quiz

Connecting Database and Create Table using SQLAlchemy ORM9:24
Insert Data to Database using SQLAlchemy ORM4:16
Retrieve Data From Database using SQLAlchemy ORM5:14
Filter Operations SQLAlchemy ORM5:06
Explore SQLAlchemy ORM filter operations, including equal, not equal, like, in, and, and/or, with examples filtering by id and names starting with e.
Update Data using SQLAlchemy ORM3:41
Delete Data From Database using SQLAlchemy ORM2:30
Building Relationship SQLAlchemy ORM9:46
Join Tables using SQLAlchemy ORM6:43
SQLAlchemy ORM

What is MySQL?4:14
Installing MySQL on Mac8:06
Installing MySQL Workbench on Mac3:07
Installing MySQL and MySQL Workbench on Windows0:24
Creating Database and Tables in MySQL15:25
Connecting MySQL using Python7:16
MySQL Database Operations using Python11:40
Pythonic Application SQLAlchemy ORM - MySQL11:04
Insert/Retrieve Data to MySQL using SQLAlchemy ORM9:03
MySQL Challenge10:37
Import Data from CSV to MySQL9:14
Import Data using Pandas to MySQL3:47
MySQL Quiz

Requirements

Basic Python Knowledge

Description

Welcome to the Python Database Course, a comprehensive journey through the world of database management and integration using Python. This course is meticulously designed to provide in-depth training on four major databases: SQLite, PostgreSQL, MySQL, and the SQLAlchemy ORM. Whether you're a beginner aspiring to delve into the realm of databases, or an experienced developer aiming to enhance your database skills in Python, this course is tailored just for you.

Course Highlights:

SQLite Mastery: Start your database journey with SQLite, the go-to choice for lightweight database needs. Learn to implement, query, and manage SQLite databases with Python, making it ideal for small-scale projects and standalone applications.
PostgreSQL Proficiency: Dive into the world of enterprise-level databases with PostgreSQL. Understand how to set up robust, efficient, and secure databases. Delve into advanced features like indexing, views, and stored procedures to manage complex data with ease.
MySQL Integration: Gain expertise in one of the most popular database systems, MySQL. Learn the nuances of using MySQL with Python to handle large-scale data operations. Master techniques to optimize, secure, and scale your MySQL databases.
SQLAlchemy Core: Unravel the power of SQLAlchemy as an ORM (Object Relational Mapper). Learn to bridge the gap between Python code and database engines, enabling seamless data manipulation and querying with high-level Pythonic constructs.

What You Will Learn:

Fundamentals of database theory and SQL.
Practical implementation of CRUD operations (Create, Read, Update, Delete).
Advanced database concepts such as transactions, indexing, and normalization.
Hands-on experience with real-world database applications.
Best practices for database design, security, and performance optimization.

Why Choose This Course?

Hands-On Approach: Engage in practical exercises, projects, and case studies to solidify your learning experience.
Industry-Relevant Skills: Equip yourself with the skills sought after in today’s tech-driven job market.
Expert Instruction: Learn from seasoned instructors with years of industry and teaching experience.
Community and Support: Join a community of like-minded learners and receive dedicated support throughout your learning journey.
Flexibility and Convenience: Enjoy the freedom of self-paced learning, tailored to fit your schedule.

Who Is This Course For?

Aspiring data scientists and database professionals.
Software developers and engineers looking to expand their database skills.
Python programmers who wish to integrate databases into their applications.
Anyone interested in mastering database management through Python.

Get ready to embark on a transformative learning experience that will elevate your Python and database skills. Enroll now and start your journey towards mastering SQLite, PostgreSQL, MySQL, and SQLAlchemy!

Who this course is for:

Anybody interested in learning databases using Python!
Self-taught programmers who have a basic knowledge in Python and want to be professional in Python Databases!
Students currently studying computer science and want supplementary material for databases in Python!
Professional programmers who want to sharpen their Python database skills.

Python Database Course: SQLite, PostgreSQL, MySQL,SQLAlchemy

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 6min

A Comprehensive Python Starter Kit36 lectures • 5hr 32min

Introduction to Databases in Python4 lectures • 18min

SQLite in Python13 lectures • 1hr 25min

Real Project - Password Manager using SQLite5 lectures • 43min

SQL Alchemy Core7 lectures • 38min

Password Manager Project using SQLAlchemy Core2 lectures • 12min

SQL Alchemy ORM8 lectures • 47min

Password Manager using SQLAlchemy ORM2 lectures • 13min

MySQL in Python12 lectures • 1hr 34min

Requirements

Description

Who this course is for: