Welcome to SQL 3: Building Relations and Combining Data Sets This week we look at the fun side of SQL where we JOIN tables and create UNIONs.
Welcome to SQL 2: Selecting, Updating, and Deleting Data Explore the many flavors of SQL data manipulation in part 2 of our series.
Making API Requests with node-fetch Use Node's lightweight node-fetch library to make HTTP to REST API endpoints, or any URL.
Welcome to SQL: Modifying Databases and Tables Brush up on SQL fundamentals such as creating tables, schemas, and views.
S3 File Management With The Boto3 Python SDK Modify and manipulate thousands of files in your S3 (or DigitalOcean) Bucket.
Connect Flask to a Database with Flask-SQLAlchemy Interact with a database within Flask using Flask-SQLAlchemy. Create, fetch, and manage records via SQLAlchemy’s ORM.
Queries as Python Code with SQLAlchemy's Expression Language Work with your app's data entirely in Python by defining data models and using the session object from SQLAlchemy's ORM.
Implement ORM Data Models with SQLAlchemy Handle your application's data layer with SQLAlchemy's powerful ORM. Define data models, add/remove records, and execute queries purely in Python.
From CSVs to Tables: Infer Data Types From Raw Spreadsheets The quest to never explicitly set a table schema ever again.
