SQL Fundamentals

String Functions & Operations: Next

Pattern Matching (LIKE, REGEX) Data Types & Type Conversion WHERE Clause & Filtering Build full name from first and last name Extract domain from email address

Pattern Matching (LIKE, REGEX)

Data Types & Type Conversion

WHERE Clause & Filtering

Build full name from first and last name

Extract domain from email address

Find customers with Gmail addresses

Normalize phone numbers to standard format

Explain portable string concatenation, NULL behavior, and functional-index trade-offs.

Pattern Matching (LIKE, REGEX)

MySQL String & Math Functions

Index Design & Selection