UsefulLinks
Computer Science
Web Development
Python Web Development
1. Fundamentals of Web Development
2. Python Environment Setup
3. Core Python for Web Development
4. Web Framework Fundamentals
5. Flask Web Development
6. Django Web Development
7. API Development
8. Database Integration
9. Testing Web Applications
10. Security in Web Applications
11. Performance and Optimization
12. Deployment and Production
13. Advanced Topics
8.
Database Integration
8.1.
Database Fundamentals
8.1.1.
Relational Databases
8.1.2.
SQL Basics
8.1.3.
Database Design Principles
8.1.4.
Normalization
8.2.
SQLAlchemy Core
8.2.1.
Engine and Connection
8.2.2.
Metadata and Tables
8.2.3.
SQL Expression Language
8.2.4.
Raw SQL Execution
8.3.
SQLAlchemy ORM
8.3.1.
Declarative Base
8.3.2.
Model Definition
8.3.3.
Relationships
8.3.3.1.
One-to-One
8.3.3.2.
One-to-Many
8.3.3.3.
Many-to-Many
8.3.3.4.
Self-Referential
8.3.4.
Querying
8.3.4.1.
Basic Queries
8.3.4.2.
Filtering
8.3.4.3.
Joins
8.3.4.4.
Aggregation
8.3.4.5.
Subqueries
8.3.5.
Sessions and Transactions
8.3.6.
Lazy Loading vs Eager Loading
8.4.
Database Migrations
8.4.1.
Alembic
8.4.1.1.
Migration Environment
8.4.1.2.
Auto-generation
8.4.1.3.
Manual Migrations
8.4.1.4.
Branching and Merging
8.5.
NoSQL Databases
8.5.1.
MongoDB with PyMongo
8.5.2.
Redis Integration
8.5.3.
Document-Based Models
8.6.
Database Performance
8.6.1.
Query Optimization
8.6.2.
Indexing Strategies
8.6.3.
Connection Pooling
8.6.4.
Caching Strategies
Previous
7. API Development
Go to top
Next
9. Testing Web Applications