Spring sales Swift week
Save up to 80 % on our Swift e-learning courses. Only this week!
Get up to 60 % extra points for free! More info

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.
Written by David Capka
FreeUnrated Show description
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.
Written by David Capka
FreeUnrated Show description
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.
Written by David Capka
FreeUnrated Show description
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.
Written by David Capka
Free Show description
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.
Written by David Capka
FreeUnrated Show description
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.
Written by David Capka
FreeUnrated Show description
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.
Written by David Capka
FreeUnrated Show description
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.
Written by David Capka
PremiumUnrated Show description
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.
Written by David Capka
PremiumUnrated Show description
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.
Written by David Capka
PremiumUnrated Show description
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.
Written by David Capka
PremiumUnrated Show description
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.
Written by David Capka
PremiumUnrated Show description


 

Activities (3)