MySQL Online Test
For Jobseekers
Practice your skills and earn a certificate of achievement when you score in the top 25%.
Take a Practice TestFor Companies
Test candidates with real-world problems and interview the best ones.
Sign Up to Offer this TestAbout the test
The MySQL online test assesses knowledge of MySQL features and SQL skills using live coding tasks that require writing MySQL stored procedures, triggers, and SQL queries.
The assessment includes work-sample tasks such as:
- Using stored procedures and other MySQL features to optimize and refine queries.
- Writing queries and subqueries that join, group, filter, and aggregate data.
- Creating new database tables with proper table schema and constraints.
A good database admin, back-end developer, or data analyst working with MySQL needs to be able to take advantage of its functionality to interface with the database efficiently.
Sample public questions
App usage data are kept in the following table:
TABLE sessions id INTEGER PRIMARY KEY, userId INTEGER NOT NULL, duration DECIMAL NOT NULL
Write a query that selects userId and average session duration for each user who has more than one session.
See the example case for more details.
An application for testing programmers contains an initial question version and newer question versions, represented by the following schema:
TABLE questions id INTEGER NOT NULL PRIMARY KEY name VARCHAR(50) NOT NULL childId INTEGER FOREIGN KEY (childId) REFERENCES questions(id)
The latest question version has childId set to NULL, other question versions will have childId set to the next version. Each question version can be a child of only one other question version.
Finish the findLatestVersion stored procedure so that it returns the latest question version.
See the example case for more details.
For jobseekers: get certified
Earn a free certificate by achieving top 25% on the MySQL test with public questions.
Take a Certification TestSample silver certificate
Sunshine Caprio
Java and SQL TestDomeCertificate
For companies: premium questions
Buy TestDome to access premium questions that can't be practiced.
Get money back if you find any premium question answered online.
61 more premium MySQL questions
Dot Items, Cargo Concat, JSON Stock, Employee Sales, Index Performance, Movies, Matching Clothes, Bill Discount, Cultivated Fields, Reservations Report, Accounts Trigger, River Discharge, Customer Paging, Employee Tree, Student Max Score, Manager Sales, Manager Sales, Root Menu, Agents, New Wages, Research Funding, Guest List, Student Management, Product Data, Projects, Developers, Authors, Autocomplete, Bank Branches, Cheapest Product, Countries, Hospital Patients, Menu Items, Rectangles, Restaurant Menu, Poll, Sales, Employee Manager, Auto Show, Welfare Organization, Tasks, Student Rankings, Student Activities, Youngest Child, Movies Live, Average Salary, Movie Genres, ATM Locations, Transactions, Merge Stock Index, Ban Users, Delete Orders, Department Report, SMS Messages, Ingredients, Roads, Karting Leaderboard, Player Division, Popular Category, Retirees, Users and Accounts.
Skills and topics tested
- MySQL
- String Functions
- Aggregation
- JSON
- Window Functions
- SQL
- Indexes
- Performance Tuning
- Select
- Subqueries
- Conditions
- Joins
- Cursors
- Stored Procedure
- Date Functions
- Triggers
- Database Normalization
- Database Schema
- Bug Fixing
- Pagination
- CTE
- Recursion
- Left Join
- Right Join
- Update
- SQL CASE
- Constraints
- Alter Table
- Create Index
- Create Table
- Ordering
- Group by
- Union
- Delete
- Insert
- Views
For job roles
- Data Analyst
- Database Administrator
- MySQL Database Administrator
- MySQL Developer
- SQL Developer
Sample candidate report
What others say
Simple, straight-forward technical testing
TestDome is simple, provides a reasonable (though not extensive) battery of tests to choose from, and doesn't take the candidate an inordinate amount of time. It also simulates working pressure with the time limits.
Jan Opperman, Grindrod Bank
Product reviews
Used by
Solve all your skill testing needs
150+ Pre-made tests
From web development and database administration to project management and customer support. See all pre-made tests.
90+ skills
From JavaScript and SQL to English and customer support. See all questions to filter by skill.
Multi-skills Test
Mix questions for different skills or even custom questions in one test. See an example.
How TestDome works
Choose a pre-made test
or create a custom test
Invite candidates via
email, URL, or your ATS
Candidates take
a test remotely
Sort candidates and
get individual reports