SQL & MySQL Tutorials: Queries, Functions, Joins and Examples

Use this learning hub to move from SQL fundamentals to practical MySQL queries. Start with database and table basics, then learn filtering, aggregation, joins and functions before working through exercises, sample datasets and application examples.

Tables & Keys

Build tables with suitable data types, primary keys and AUTO_INCREMENT IDs.

Primary Key tutorial

MySQL full-text search with MATCH AGAINST

Search Data

Move from WHERE and LIKE to regular expressions and full-text search.

MATCH ... AGAINST tutorial

Start Here

Topic	What you learn
Installation	Install and choose tools for working with MySQL.
SQL Introduction	SQL command categories and the basic query workflow.
Database	Create, select, inspect and remove databases.
Table & Records	Understand tables, rows, columns and relational structure.
Data Types	Choose suitable numeric, date, text and binary types.
CREATE TABLE	Create a table and define its columns.
PRIMARY KEY	Identify each row uniquely and design reliable keys.
SHOW TABLES	List databases, tables and metadata.
Sample Student Data	Copy the practice tables used throughout the tutorials.

Core Querying & Data Changes

Topic	What you learn
SELECT	Retrieve columns and rows from a table.
WHERE	Filter rows with conditions.
INSERT	Add single or multiple records.
UPDATE	Change existing data safely.
DELETE	Remove matching rows safely.
ORDER BY	Sort rows and add deterministic tie-breakers.
LIMIT	Return a limited range of ordered rows.
DISTINCT	Return unique result rows.
NULL	Work correctly with missing or unknown values.

Filtering, Conditions & Search

Aggregation & Window Functions

JOINs, Subqueries & Set Logic

Function Reference Pillars

Date & Time Functions	Dates, intervals, formatting, grouping and practical date queries.
Math Functions	Numeric, logarithmic, trigonometric, statistical and conversion functions.
String Functions	Length, extraction, trimming, search, conversion, comparison and formatting.

Popular standalone function examples: CHARACTER_LENGTH(), CONCAT(), REPLACE(), and RAND().

Schema & Data Management

Applications, Security & Practice

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

	17-06-2020
SELECT STUDENTID,CASE WHEN MARKS < 50 THEN 'FAIL' ELSE TO_CHAR(Marks) END AS STATUS FROM ASSESSMENT