System Configuration


Not CompletedIntroduction to SQL Databases

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.

Not CompletedDifferences Between Popular SQL Implementations

This guide examines the key differences between popular SQL implementations such as: Oracle's SQL, Microsoft SQL server, MySQL, Postgres, and MariaDB.

Not CompletedInstalling MySQL on a Mac

This guide walks through how to install MySQL on a Mac via the Homebrew package manager.

Not CompletedHow to Install MySQL Workbench on a Mac

This lesson examines the steps necessary to install MySQL Workbench on a Mac, including how to add a connection to the local MySQL database.

Not CompletedCreating a Database Schema in MySQL Workbench

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.

Not CompletedHow to Create a Table in MySQL

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.

Not CompletedHow to Create a Table with a Foreign Key in MySQL

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.

Not CompletedGuide to Changing Columns in MySQL Tables

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.

Not CompletedHow to Add New Columns to a Table in MySQL

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.

Not CompletedDeep Dive: SQL Data Types

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.

Quizzes


System Configuration
    Unsupported Browser

    devCamp does not support ancient browsers.
    Install a modern version for best experience.