_{Jamie Balfour's}MySQL course

Course introduction

This course covers MySQL in detail and is designed to give a step by step insight into how MySQL works and how to use it.

The basics of an RDBMS

This article of the MySQL tutorial shows you how relational database management systems work.

Connecting to MySQL

This article of the MySQL tutorial shows you how to connect to a MySQL host.

MySQL types

This article of the MySQL tutorial describes the data types in MySQL.

Databases and tables

This article of the MySQL tutorial shows you how to create a database.

Inserting data into tables

This article of the MySQL tutorial shows you how to insert data into a database.

Retrieving data from tables

This article of the MySQL tutorial shows you how to retrieve data from a database.

Using conditions

This article of the MySQL tutorial shows you how to use conditions in MySQL.

Removing data from tables

This article of the MySQL tutorial shows you how to remove data from a database.

Modifying data in a table

This article of the MySQL tutorial shows you how to modify data in a database.

SQL dates

This article of the MySQL tutorial shows you how to use dates with SQL.

Basics of joins

This article of the MySQL tutorial teaches the basics of joins.

Inner joins

This article of the MySQL tutorial shows you how to use inner joins.

Left and right joins

This article of the MySQL tutorial shows you how to use left and right joins.

Functions in SQL

This article of the MySQL tutorial discusses the built in functions MySQL provides.

Ordering and grouping results in SQL

This article of the MySQL tutorial shows you how to organise data.

Views in SQL

This article of the MySQL tutorial shows you how to create views.

SQL injection

This article of the MySQL tutorial discusses SQL injection.

SQL transactions

This article of the MySQL tutorial describes transactions.

Granting privileges in MySQL

This article of the MySQL tutorial discusses granting access privileges to users.