HTML CSS JavaScript PHP MySQL Bootstrap 5
MySQL Developer

Practice & Master Your Skills

10
Exercises
5
Challenges
0
Total Points
Fill in the Blank
Code Challenges
Certificate
Exercise 1
10 pts
Select all columns from the users table.
SELECT FROM users;
Wildcard character for all columns
Exercise 2
10 pts
Insert a new record.
users (name, age) ("John", 25);
Adds new rows to a table
Exercise 3
10 pts
Filter records based on a condition.
SELECT * FROM products price > 100;
Used to extract only those records that fulfill a specified condition
Exercise 4
10 pts
Update an existing record.
users age = 26 WHERE name = "John";
Modifies existing records in a table
Exercise 5
10 pts
Combine rows from two tables based on a related column.
SELECT * FROM orders users ON orders.user_id = users.id;
Selects records that have matching values in both tables
Exercise 6
10 pts
Sort the results in descending order.
SELECT * FROM users age ;
Used to sort the result-set
Exercise 7
10 pts
Count the number of users in each city.
SELECT city, (*) FROM users city;
Groups rows that have the same values into summary rows
Exercise 8
10 pts
Delete specific records.
users age < 18;
Removes existing records from a table
Exercise 9
10 pts
Create a new table.
users (id INT, name VARCHAR(50));
Used to create a new table in a database
Exercise 10
10 pts
Define a primary key that auto increments.
id INT
Uniquely identifies each record and generates sequential values

1. Select specific columns

SELECT, FROM

2. Join query

INNER JOIN, ON

3. Count group

COUNT, GROUP BY

4. Update query

UPDATE, SET, WHERE

5. Create Table

CREATE TABLE, PRIMAR

Certificate Locked

You must complete the exercises with a score of 70% or higher to unlock your certificate.

0% Current Score

Claim Your Certificate

Congratulations! You have passed the required exercises. Please provide your details exactly as you want them on your certificate.

Certificate of Completion

Proudly Presented To

Student Name
For successfully completing all exercises and challenges with an outstanding score in the MySQL course.
ProTechSolution Platform
Official Authorized Signature
Date
Issue Date
Verify ID: LH-XXXX-XXXXXX