MySQL Handbook

SQL, joins, indexing, transactions, and query optimization.

school Practice quiz Quiz

Rated

0%

Got it

0

Practice

0

Saved

0

monitoring Progress · 0/2163

Topics

Pick a topic to browse questions and answers.

folder_open

Introduction

49 questions

arrow_forward
Your progress 0%
folder_open

Installing and Configuring

45 questions

arrow_forward
Your progress 0%
folder_open

Architecture

45 questions

arrow_forward
Your progress 0%
folder_open

Databases and Tables

44 questions

arrow_forward
Your progress 0%
folder_open

Data Types

44 questions

arrow_forward
Your progress 0%
folder_open

Constraints

44 questions

arrow_forward
Your progress 0%
folder_open

CRUD Operations

42 questions

arrow_forward
Your progress 0%
folder_open

Operators

44 questions

arrow_forward
Your progress 0%
folder_open

Functions

43 questions

arrow_forward
Your progress 0%
folder_open

String Functions

41 questions

arrow_forward
Your progress 0%
folder_open

Numeric Functions

41 questions

arrow_forward
Your progress 0%
folder_open

Date and Time Functions

43 questions

arrow_forward
Your progress 0%
folder_open

Aggregate Functions

40 questions

arrow_forward
Your progress 0%
folder_open

GROUP BY

40 questions

arrow_forward
Your progress 0%
folder_open

HAVING Clause

40 questions

arrow_forward
Your progress 0%
folder_open

ORDER BY

41 questions

arrow_forward
Your progress 0%
folder_open

LIMIT and OFFSET

39 questions

arrow_forward
Your progress 0%
folder_open

DISTINCT

39 questions

arrow_forward
Your progress 0%
folder_open

Aliases

40 questions

arrow_forward
Your progress 0%
folder_open

WHERE Clause

40 questions

arrow_forward
Your progress 0%
folder_open

Logical Operators

40 questions

arrow_forward
Your progress 0%
folder_open

Pattern Matching (LIKE, REGEXP)

39 questions

arrow_forward
Your progress 0%
folder_open

NULL Handling

40 questions

arrow_forward
Your progress 0%
folder_open

CASE Expression

40 questions

arrow_forward
Your progress 0%
folder_open

Joins

40 questions

arrow_forward
Your progress 0%
folder_open

Self Join

40 questions

arrow_forward
Your progress 0%
folder_open

Cross Join

40 questions

arrow_forward
Your progress 0%
folder_open

UNION, UNION ALL, INTERSECT, EXCEPT (and MySQL alternatives)

40 questions

arrow_forward
Your progress 0%
folder_open

Subqueries

40 questions

arrow_forward
Your progress 0%
folder_open

Correlated Subqueries

40 questions

arrow_forward
Your progress 0%
folder_open

Common Table Expressions (CTE)

40 questions

arrow_forward
Your progress 0%
folder_open

Recursive CTE

40 questions

arrow_forward
Your progress 0%
folder_open

Views

40 questions

arrow_forward
Your progress 0%
folder_open

Stored Procedures

40 questions

arrow_forward
Your progress 0%
folder_open

Stored Functions

40 questions

arrow_forward
Your progress 0%
folder_open

Triggers

40 questions

arrow_forward
Your progress 0%
folder_open

Events (Event Scheduler)

40 questions

arrow_forward
Your progress 0%
folder_open

Transactions

40 questions

arrow_forward
Your progress 0%
folder_open

ACID Properties

40 questions

arrow_forward
Your progress 0%
folder_open

Isolation Levels

40 questions

arrow_forward
Your progress 0%
folder_open

Locks and Locking Mechanisms

40 questions

arrow_forward
Your progress 0%
folder_open

Deadlocks

40 questions

arrow_forward
Your progress 0%
folder_open

Indexes

40 questions

arrow_forward
Your progress 0%
folder_open

Composite Indexes

40 questions

arrow_forward
Your progress 0%
folder_open

EXPLAIN and Query Execution Plans

40 questions

arrow_forward
Your progress 0%
folder_open

Query Optimization

40 questions

arrow_forward
Your progress 0%
folder_open

Partitioning

40 questions

arrow_forward
Your progress 0%
folder_open

Replication

40 questions

arrow_forward
Your progress 0%
folder_open

Backup and Restore

40 questions

arrow_forward
Your progress 0%
folder_open

Users, Roles and Privileges

40 questions

arrow_forward
Your progress 0%
folder_open

Window Functions

40 questions

arrow_forward
Your progress 0%
folder_open

JSON Data Type and Functions

40 questions

arrow_forward
Your progress 0%
folder_open

Performance Schema and Monitoring

40 questions

arrow_forward
Your progress 0%