In this introductory lesson we'll walk through: what databases are, how they're used in real world applications, and how databases have evolved over time.
This guide examines the key differences between popular SQL implementations such as: Oracle's SQL, Microsoft SQL server, MySQL, Postgres, and MariaDB.
This guide walks through how to install MySQL on a Mac via the Homebrew package manager.
This lesson examines the steps necessary to install MySQL Workbench on a Mac, including how to add a connection to the local MySQL database.
This guide teaches you how to create a database schema in MySQL Workbench. A schema is a tool we can use to wrap all of our database tables inside.
This guide gives a step by step set of instructions for how to create a table in MySQL Workbench. Additionally, we'll examine the various data types that can be used when configuring columns.
In this guide you'll examine how to create another table in MySQL. And for this table you'll learn how to create a foreign key relationship that connects the new table to the previously created users table.
This lesson walks through how to change a column in a MySQL table. Specifically, we'll examine how to ensure that a foreign key is required for every new record.
In this guide we'll create a new table that contains a relation to the users table. Additionally, we'll go through the steps needed to add a new column to an existing table.
In this deep dive we'll analyze the key SQL data types, including how you can use them to configure each of the columns in your database.
devCamp does not support ancient browsers.
Install a modern version for best experience.