Simple SQL Queries
Joins and Subqueries
Aggregation
Working with Timestamps
String Operations
Recursive Queries
Modifying Data
Data Mastery SQL Course
Simple SQL Queries
Joins and Subqueries
Aggregation
Working with Timestamps
String Operations
Recursive Queries
Modifying Data
Home
String Operations
String Operations
Begin!
Format the names of members
✓
Find facilities by a name prefix
✓
Perform a case-insensitive search
✓
Find telephone numbers with parentheses
✓
Pad zip codes with leading zeroes
✓
Count the number of members whose surname starts with each letter of the alphabet
✓
Clean up telephone numbers
✓