MySQL

Database configuration, building queries, and cloud hosting options for MySQL.

Welcome to SQL 4: Aggregate Functions

Welcome to SQL 4: Aggregate Functions

Become more intimate with your data- use SQL's aggregate functions to explore the traits which make your data unique and beautiful.

Todd Birchard
Todd Birchard
SQL
Welcome to SQL 3: Building Relations and Combining Data Sets

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.

Todd Birchard
Todd Birchard
SQL
Welcome to SQL 2: Selecting, Updating, and Deleting Data

Welcome to SQL 2: Selecting, Updating, and Deleting Data

Explore the many flavors of SQL data manipulation in part 2 of our series.

Todd Birchard
Todd Birchard
SQL
Welcome to SQL: Modifying Databases and Tables

Welcome to SQL: Modifying Databases and Tables

Brush up on SQL fundamentals such as creating tables, schemas, and views.

Todd Birchard
Todd Birchard
SQL
Create a REST API Endpoint Using AWS Lambda

Create a REST API Endpoint Using AWS Lambda

Create an AWS Lambda function to pull records from a database.

Todd Birchard
Todd Birchard
AWS
MySQL, Google Cloud, and a REST API that Generates Itself

MySQL, Google Cloud, and a REST API that Generates Itself

Deploy a MySQL database that auto-creates endpoints for itself.

Todd Birchard
Todd Birchard
MySQL
Using PyMySQL: Python's MySQL Library

Using PyMySQL: Python's MySQL Library

Connect and fetch records from a MySQL Database using Python's lightweight PyMySQL library.

Todd Birchard
Todd Birchard
MySQL
MySQL on the Cloud with AWS RDS

MySQL on the Cloud with AWS RDS

Spinning up a managed MySQL database instance with Amazon RDS.

Todd Birchard
Todd Birchard
MySQL