Python Database Mastery: Dive into SQLAlchemy & Alembic

Focused View

Kostiantyn Kriuchkov

3:46:55

409 View

1. Introduction and Setup

1. Introduction to the course.mp4

03:48

2. Introduction to SQLAlchemy and Alembic.html

3. Setting Up Virtual Environment and Required Libraries.mp4

05:55

4. Setting Up PostgreSQL with Docker.mp4

03:55

5. Establishing Database Connection.mp4

11:50

2. Working with Tables

1. Executing Your First Queries.mp4

11:29

2.1 How to Create SQLAlchemy table classes.pptx

2. Introduction to Creating Tables.mp4

14:02

3. Creating the User Table.mp4

12:35

4. Utilizing Mixins in SQLAlchemy.mp4

05:51

5. Annotated Column Creation and Additional Tables.mp4

13:59

3. Alembic for Database Management

1. Using SQLAlchemy to Create Tables in the Database.mp4

10:12

2. Getting Started with Alembic.mp4

13:47

3. Creating Your First Database Migrations.mp4

15:15

4. Modifying the Database Structure with Alembic.mp4

11:49

4. Querying with SQLAlchemy ORM

1. Insert Queries Using the ORM.mp4

11:17

2. Advanced Select Queries with SQLAlchemy ORM.mp4

12:28

3. Combining Insert, Select and Update in a Single Query.mp4

05:16

4. Seeding Initial Data to Database.mp4

11:03

5. Establishing Relationships in Tables.mp4

10:00

6. ORM JOIN Queries (INNER, OUTER).mp4

08:08

7. Advanced Select Queries with Joins with SQLAlchemy ORM.mp4

15:28

8. Aggregated Queries using SQLAlchemy.mp4

08:49

5. Modifying Data with ORM

1. Update Queries with ORM.mp4

02:19

2. Delete Queries with ORM.mp4

01:08

3. Bulk Insert Operations with ORM.mp4

06:32

Description

Master SQLAlchemy & Alembic: Easily Create/Manage Databases, Implement ORM, Use Migration Tool, Boost Query Performance

What You'll Learn?

Understand the fundamentals of SQLAlchemy and Object Relational Mapping (ORM) in Python
Create, define, and manage database tables using SQLAlchemy's ORM
Utilize Alembic, a database migration tool for SQLAlchemy, to create, manage, and track changes in their database schema
Apply best practices for using SQLAlchemy and Alembic in real-world projects

Who is this for?

SQL users wanting Python ORM skills

Developers seeking Pythonic DB management

Data engineers improving DB knowledge

SQLAlchemy newbies with SQL background

App developers needing DB integration

Python programmers with SQL experience

Transitioning SQL users to SQLAlchemy

What You Need to Know?

Basic Python programming knowledge: Understanding of Python data types, functions, classes, and syntax is essential for following the tutorial.

Familiarity with SQL: Learners should have a basic understanding of SQL concepts like tables, primary keys, foreign keys, and CRUD operations (Create, Read, Update, and Delete).

Object-Oriented Programming (OOP) understanding: Since the tutorial uses Object Relational Mapping (ORM) for creating tables, having some experience with OOP and Python classes would be beneficial.

Python environment: Learners should have a Python development environment set up on their machine (Python 3.x and pip) or have access to a Jupyter Notebook environment where they can install packages and run code snippets as demonstrated in the tutorial

Database access: Access to a PostgreSQL database server for hands-on practice is crucial. Familiarity with creating databases and user accounts would be useful but not required, as it can be learned along the way.

More details

Description
This comprehensive course is designed for users who have some knowledge of SQL, and it aims to teach you how to leverage the power of SQLAlchemy and Alembic to streamline your work with databases. By learning the techniques taught in this course, you will have a better understanding of Object Relational Mapping (ORM), how to create and manipulate database tables using Python, and how to manage and track changes using Alembic migrations.

Throughout the course, you will gain hands-on experience by working on various practical examples and exercises. The course will be easy to follow, with a focus on making complex tasks easier to understand and apply in your own projects.

Key topics include:

1. Introduction to SQLAlchemy and Alembic
Â Â - Overview of SQLAlchemy and its benefits
Â Â - Getting started with Alembic for database migrations

2. Creating tables with SQLAlchemy
Â Â - Declarative base and table class creation
Â Â - Working with different column types and constraints
Â Â - Using Mixin classes to reuse column and key definitions

3. Working with data using ORM
Â Â - Inserting, updating, and deleting rows
Â Â - Querying data and using filtering options
Â Â - Working with relationships and joins.

4. Handling schema changes and migrations with Alembic
Â Â - Setting up an Alembic environment and configuration
Â Â - Generating, reviewing, and customizing migration scripts
Â Â - Upgrading and downgrading database schemas

5. Advanced SQLAlchemy features
Â Â - Query optimizations
Â Â - Building complex queries
Â Â - Managing transactions and session handling

6. Best practices and real-world case examples
Â Â - Implementing reusable patterns
Â Â - Scaling and performance considerations
Â Â - Common SQLAlchemy pitfalls and solutions

Upon completion of this course, you will have a strong foundation in using SQLAlchemy and Alembic to manage your databases effectively. You will be equipped with the skills necessary to create and manipulate databases with ease, enabling you to bring value to your projects and organization.
Who this course is for:
SQL users wanting Python ORM skills
Developers seeking Pythonic DB management
Data engineers improving DB knowledge
SQLAlchemy newbies with SQL background
App developers needing DB integration
Python programmers with SQL experience
Transitioning SQL users to SQLAlchemy

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Database Management

Database Programming

Kostiantyn Kriuchkov

Instructor's Courses

Background & Education:I embarked on my academic journey, graduating from the Construction Academy with both a Bachelor's and a Master's degree. My quest for knowledge led me to the United Kingdom where I earned an MSc in Engineering Project Management from a prestigious institution in Leeds.Technology & Programming:A fervent enthusiast of technology, I graduated with honors from the renowned Computer Academy STEP (ШАГ). Parallel to my university studies, I pursued self-taught programming, specializing in Python since 2017.Experience & Achievements:Through my dedication and consistent learning, I've been able to transform my passion into a rewarding career. My development work has garnered me financial success.My Approach:Striking a balance between construction, project management, and software development, I bring a unique blend of skills to the table. I strive to deliver robust and effective solutions in an ever-evolving technological landscape, bridging the gap between diverse fields with my fresh and versatile problem-solving approach.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.