Python Database Mastery: Dive into SQLAlchemy & Alembic

سرفصل های دوره

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

1. Introduction and Setup

1. Introduction to the course

2. Introduction to SQLAlchemy and Alembic.html

3. Setting Up Virtual Environment and Required Libraries

4. Setting Up PostgreSQL with Docker

5. Establishing Database Connection

2. Working with Tables

1. Executing Your First Queries

2.1 How to Create SQLAlchemy table classes.pptx

2. Introduction to Creating Tables

3. Creating the User Table

4. Utilizing Mixins in SQLAlchemy

5. Annotated Column Creation and Additional Tables

3. Alembic for Database Management

1. Using SQLAlchemy to Create Tables in the Database

2. Getting Started with Alembic

3. Creating Your First Database Migrations

4. Modifying the Database Structure with Alembic

4. Querying with SQLAlchemy ORM

1. Insert Queries Using the ORM

2. Advanced Select Queries with SQLAlchemy ORM

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

4. Seeding Initial Data to Database

5. Establishing Relationships in Tables

6. ORM JOIN Queries (INNER, OUTER)

7. Advanced Select Queries with Joins with SQLAlchemy ORM

8. Aggregated Queries using SQLAlchemy

5. Modifying Data with ORM

1. Update Queries with ORM

2. Delete Queries with ORM

3. Bulk Insert Operations with ORM

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training