From zero · 13 core levels · 4 extras · 154 questions
SQL Essentials for Appian
From SELECT to stored procedures: the SQL an Appian developer actually uses. Each level is a short lesson with queries you can run, then questions until you get them right. All in your browser, nothing to install.
0 of 13 core levels mastered 0 XP
I’m Ace, your guide. Never written SQL? That’s fine: we start from zero and build up to stored procedures. Tap a question below, or press Start.
to earn 10 points per level and keep your daily streak.
Core path
Each level unlocks the next
Additional topics
Optional, in any order. Each one opens once you’ve mastered the core level it builds on.
Read the lessons
Each lesson is also a page you can read, with its examples and the answers to its practice questions.
- SQL SELECT and WHERE for Beginners: Free Interactive Lesson
- SQL CREATE TABLE and INSERT INTO Explained, with Practice
- SQL Primary Keys and Foreign Keys Explained for Beginners
- SQL UPDATE Statement for Beginners: Examples and Practice
- SQL ALTER TABLE: Add, Rename and Drop Columns
- SQL DELETE vs TRUNCATE vs DROP, Explained with Examples
- SQL ORDER BY, LIMIT and OFFSET for Beginners
- SQL GROUP BY and HAVING Explained: COUNT, SUM, AVG
- SQL JOINs Explained for Beginners: INNER, LEFT, RIGHT, FULL
- SQL Views Explained: CREATE VIEW with Examples
- SQL Indexes Explained for Beginners: CREATE INDEX and EXPLAIN
- SQL Stored Procedures for Beginners: MySQL Examples
- SQL Transactions and Error Handling: COMMIT, ROLLBACK
- SQL Date Functions: NOW, DATE_ADD, DATEDIFF Explained
- SQL String Functions: UPPER, SUBSTR, CONCAT, REPLACE
- SQL CASE WHEN, ROUND and COALESCE for Beginners
- SQL Subqueries Explained: IN (SELECT …) and NOT IN