jadeeshah / learnsql

LearnSQL

Table of Content

Basic Theory

• Data Types
• CRUD
• Query
• Filtering
• Joins
• Sets
• Data Generation, Conversion
• Grouping and Aggregates
• Subquery
• Locking
• Storage Engine
• Transactions
• Indexes
• Constraints
• Views
• Metadata

Sample Code

Common Usage

Working With Pandas

Working With SQLAlchemy

SQLAlchemy (ORM)

SQLAlchemy

The SQLAlchemy Object Relational Mapper presents a method of associating user-defined Python classes with database tables, and instances of those classes (objects) with rows in their corresponding tables. It includes a system that transparently synchronizes all changes in state between objects and their related rows, called a unit of work, as well as a system for expressing database queries in terms of the user defined classes and their defined relationships between each other. -SQLAlchemy

Reference

• Learning SQL by Alan Beaulieu