MySQL database step by step

Step-by-step tutorials about the MySQL database and the phpMyAdmin tool. Everything from installing the server, through queries, to optimizations.

Lessons

MySQL step by step: Introduction and installation

Lesson 1 - MySQL step by step: Introduction and installation

In this very first MySQL database tutorial, we'll introduce relational databases and install the necessary tools with phpMyAdmin.
FreeUnratedWritten by David Capka
MySQL step by step: Creating a Database And a Table

Lesson 2 - MySQL step by step: Creating a Database And a Table

In this MySQL tutorial, we'll CREATE a database and a table via both the phpMyAdmin environment and SQL code. Then, we'll remove these by DROP.
FreeUnratedWritten by David Capka
MySQL step by step: Inserting And Deleting Table Data

Lesson 3 - MySQL step by step: Inserting And Deleting Table Data

In this tutorial, we'll insert users into a MySQL database table and then delete some of them. We'll learn INSERT and DELETE, and about the SQL injection.
FreeUnratedWritten by David Capka
MySQL step by step: Selecting Data (Searching)

Lesson 4 - MySQL step by step: Selecting Data (Searching)

In this MySQL tutorial, we'll learn to select data (search) using SELECT. We'll go through the LIKE, BETWEEN, and IN operators.
FreeWritten by David Capka
MySQL step by step: Ordering, Limit, and Aggregation

Lesson 5 - MySQL step by step: Ordering, Limit, and Aggregation

In this MySQL tutorial, we'll sort results, limit them, group them, and apply aggregation functions such as COUNT, SUM, AVG (average), MIN, and MAX.
FreeUnratedWritten by David Capka
MySQL step by step: Data Types and NULL

Lesson 6 - MySQL step by step: Data Types and NULL

In this tutorial, we'll introduce a few charts of MySQL data types. We'll explain the meaning of the NULL value and describe the data types properly.
FreeUnratedWritten by David Capka
MySQL Step By Step: Queries Over Multipe Tables (JOIN)

Lesson 7 - MySQL Step By Step: Queries Over Multipe Tables (JOIN)

In this MySQL tutorial, we'll start working on a content management system and select data through multiple tables using JOIN, INNER, LEFT, and RIGHT.
FreeUnratedWritten by David Capka
MySQL Step By Step: More Queries And the M:N Relationship

Lesson 8 - MySQL Step By Step: More Queries And the M:N Relationship

In this tutorial, we'll continue to make queries through multiple MySQL tables and learn how to create the M:N relationship using an associative table.
PremiumUnratedWritten by David Capka
MySQL Step By Step: Exercises to practise

Lesson 9 - MySQL Step By Step: Exercises to practise

In this tutorial, we'll give you several exercises you can try to run on a MySQL database to practice and check the results with yours.
PremiumUnratedWritten by David Capka
MySQL Step By Step: Subqueries

Lesson 10 - MySQL Step By Step: Subqueries

In this tutorial, we'll learn to use subqueries, nested queries in MySQL database. We'll explain new operators: IN, ALL, ANY, and EXISTS.
PremiumUnratedWritten by David Capka
MySQL Step By Step: Structure Change, Transactions and Views

Lesson 11 - MySQL Step By Step: Structure Change, Transactions and Views

In this tutorial, we'll learn how to modify the MySQL database structure (mainly tables) using the ALTER statement, explain transactions, and create views.
PremiumUnratedWritten by David Capka
MySQL Step by Step: Database Performance Optimization

Lesson 12 - MySQL Step by Step: Database Performance Optimization

In this tutorial, we'll learn how to optimize/increase performance of the MySQL database by indexes/keys and talk about normalization and denormalization.
PremiumUnratedWritten by David Capka


 

Activities (1)