MySQL Certification Program

Learn to download and install the current MySQL version on Windows 11.

Learn how to create a new database in MySQL. Here, we will start the MySQL server and create a sample database.

Learn how to create a new table in MySQL. At first, we will create a new database and then a table in it.

Learn how to insert records in a table in MySQL. To insert records, you need to first create a table. For insertion, use the INSERT INTO statement in MySQL.

Learn how to select records from a column in MySQL. Use the SELECT statement to fetch records from any column.

Learn how to select distinct records from a column in MySQL. Use the SELECT DISTINCT statement to fetch records from any column.

Learn how to work with the WHERE clause in MySQL. It allows you to specify conditions and works like IF statement.

The NOT NULL Constraint in MySQL is a rule wherein a column cannot have a NULL value. We will see the usage of NOT NULL Constraint with a live example.

The PRIMARY KEY Constraint in MySQL is a combination of NOT NULL and UNIQUE constraints, that means a column set with PRIMARY KEY cannot have NULL values. It uniquely identifies each row

A FOREIGN KEY is a field in one table referring to the PRIMARY KEY in another table.

The UNIQUE Constraint in MySQL is a rule stating the all the values in a column are unique i.e. different. We will see the usage of UNIQUE Constraint with a live example.

The DEFAULT Constraint in MySQL sets a default value for a column wherein we missed to set a value. We will see the usage of DEFAULT Constraint with a live example.

Learn how to alter and add a new column to a table in MySQL. We will add a new column to an existing table using ALTER TABLE statement.

Learn how to alter and remove a new column to a table in MySQL. We will drop a column from the existing table using ALTER TABLE statement.

Learn how to alter and modify an existing column to a table in MySQL. We will modify a column using ALTER TABLE and MODIFY COLUMN statements.

Learn how to work with AND operator in MySQL. With AND, the records get displayed if all the conditions are TRUE. These conditions are separated by AND.

Learn how to work with OR operator in MySQL. With OR, the records get displayed if any of the conditions are TRUE. These conditions are separated by OR.

Learn how to work with NOT operator in MySQL. With NOT, the records get displayed if the conditions are not TRUE.

Learn how to specify multiple values while using WHERE clause with the IN operator in MySQL.

Learn how to use the LIKE operator in MySQL and fetch records from a specific column. With the LIKE, you can use wildcards in WHERE clause to fetch records.

Learn how to use the BETWEEN operator in MySQL and fetch records within a range. With that, we will also learn how to use the NOT BETWEEN operator.

Learn how to add comments in MySQL. It supports single line and multi-line comments. Add single line comments with hash and double dash.

Learn how to sum the values of a column in MySQL using the SUM() function.

Learn how to find the average of the column values in MySQL using the AVG() function.

Learn how to work with COUNT() function in MySQL and count the number of rows in a table. With this function, also calculate count of specific columns.

Learn how to update records in MySQL using the UPDATE statement. With this statement, you can also update multiple records in a single query.

Learn how to delete existing records in MySQL using the DELETE statement. With this statement, you can also delete all the records from the table. Deleting the table won't delete the structure of the table. It will only delete the records.