Python Database Mastery: Dive into SQLAlchemy & Alembic
Published 6/2023
Created by Kostiantyn Kriuchkov
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 24 Lectures ( 3h 46m ) | 3.63 GB
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
Requirements
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.
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
Requirements
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.
Bitte
Anmelden
oder
Registrieren
um Links zu sehen.
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!