Become more intimate with your data- use SQL's aggregate functions to explore the traits which make your data unique and beautiful.
This week we look at the fun side of SQL where we JOIN tables and create UNIONs.
Explore the many flavors of SQL data manipulation in part 2 of our series.
Brush up on SQL fundamentals such as creating tables, schemas, and views.
Create an AWS Lambda function to pull records from a database.
Connect and fetch records from a MySQL Database using Python's lightweight PyMySQL library.
Spinning up a managed MySQL database instance with Amazon RDS.
Configure a self-installation of MySQL on Ubuntu to allow access from external sources, such as SequelPro or other GUIs.
Setting up MySQL the old-fashioned way: on a Linux server.