Skip to content

Learn Explore Roadmaps Paths Organizations Contact

Learn. Build. Grow.

Learn

Learn
Explore
Roadmaps
Paths
Methodology

For organizations

Schools & Business

Think Pixel

About
Contact
Privacy
Terms
Cookies

© 2026 Think Pixel

Learn

SQL

Learn SQL

Databases

Complete SQL tutorial and reference dataset.

beginner440 lessons~9.35 hours

Progress0/440 · 0%

What you'll learn

SQL Tutorial
SQL Database
SQL References
SQL Examples

Lessons

SQL Tutorial· 46 lessons

01SQL Tutorial1 min 02Introduction to SQL2 min 03SQL Syntax3 min 04SQL SELECT Statement2 min 05SQL SELECT DISTINCT Statement2 min 06SQL WHERE Clause2 min 07SQL ORDER BY Keyword2 min 08SQL AND Operator2 min 09SQL OR Operator2 min 10SQL NOT Operator3 min 11SQL INSERT INTO Statement3 min 12SQL NULL Values2 min 13SQL UPDATE Statement4 min 14SQL DELETE Statement2 min 15SQL SELECT TOP, LIMIT and FETCH FIRST3 min 16SQL Aggregate Functions1 min 17SQL MIN() Function2 min 18SQL MAX() Function2 min 19SQL COUNT() Function2 min 20SQL SUM() Function2 min 21SQL AVG() Function2 min 22SQL LIKE Operator3 min 23SQL Wildcards3 min 24SQL IN Operator2 min 25SQL BETWEEN Operator2 min 26SQL Aliases3 min 27SQL Joins2 min 28SQL INNER JOIN2 min 29SQL LEFT JOIN2 min 30SQL RIGHT JOIN2 min 31SQL FULL JOIN2 min 32SQL Self Join1 min 33SQL UNION Operator2 min 34SQL UNION ALL Operator2 min 35SQL GROUP BY Statement2 min 36SQL HAVING Clause2 min 37SQL EXISTS Operator2 min 38SQL ANY Operator2 min 39SQL ALL Operator1 min 40SQL SELECT INTO Statement1 min 41SQL INSERT INTO SELECT Statement2 min 42SQL CASE Expression1 min 43SQL NULL Functions2 min 44SQL Stored Procedures3 min 45SQL Comments1 min 46SQL Operators2 min

SQL Database· 20 lessons

47SQL CREATE DATABASE Statement1 min 48SQL DROP DATABASE Statement1 min 49SQL BACKUP DATABASE Statement1 min 50SQL CREATE TABLE Statement2 min 51SQL DROP TABLE Statement1 min 52SQL ALTER TABLE Statement4 min 53SQL Constraints1 min 54SQL NOT NULL Constraint1 min 55SQL UNIQUE Constraint1 min 56SQL PRIMARY KEY Constraint2 min 57SQL FOREIGN KEY Constraint2 min 58SQL CHECK Constraint1 min 59SQL DEFAULT Constraint1 min 60SQL CREATE INDEX Statement1 min 61SQL AUTO INCREMENT Field3 min 62SQL Working With Dates2 min 63SQL Views2 min 64SQL Injection2 min 65SQL Parameters1 min 66SQL Prepared Statements2 min

SQL References· 373 lessons

67SQL Data Types for MySQL, SQL Server, and MS AccessReference10 min 68SQL Keywords ReferenceReference5 min 69SQL ADD KeywordReference1 min 70SQL ADD CONSTRAINT KeywordReference1 min 71SQL ALL KeywordReference1 min 72SQL ALTER KeywordReference1 min 73SQL ALTER COLUMN KeywordReference1 min 74SQL ALTER TABLE KeywordReference1 min 75SQL ALTER VIEW KeywordReference1 min 76SQL AND KeywordReference1 min 77SQL ANY KeywordReference1 min 78SQL AS KeywordReference1 min 79SQL ASC KeywordReference1 min 80SQL BACKUP DATABASE KeywordReference1 min 81SQL BETWEEN KeywordReference1 min 82SQL CASE KeywordReference1 min 83SQL CHECK KeywordReference1 min 84SQL COLUMN KeywordReference1 min 85SQL CONSTRAINT KeywordReference1 min 86SQL CREATE KeywordReference2 min 87SQL CREATE DATABASE KeywordReference1 min 88SQL CREATE INDEX KeywordReference1 min 89SQL CREATE OR REPLACE VIEW KeywordReference1 min 90SQL CREATE TABLE KeywordReference1 min 91SQL CREATE PROCEDURE KeywordReference1 min 92SQL CREATE UNIQUE INDEX KeywordReference1 min 93SQL CREATE VIEW KeywordReference1 min 94SQL DATABASE KeywordReference1 min 95SQL DEFAULT KeywordReference1 min 96SQL DELETE KeywordReference1 min 97SQL DESC KeywordReference1 min 98SQL SELECT DISTINCT KeywordReference1 min 99SQL DROP KeywordReference2 min 100SQL DROP COLUMN KeywordReference1 min 101SQL DROP CONSTRAINT KeywordReference1 min 102SQL DROP DATABASE KeywordReference1 min 103SQL DROP DEFAULT KeywordReference1 min 104SQL DROP INDEX KeywordReference1 min 105SQL DROP TABLE and TRUNCATE TABLE KeywordsReference1 min 106SQL DROP VIEW KeywordReference1 min 107SQL EXEC KeywordReference1 min 108SQL EXISTS KeywordReference1 min 109SQL FOREIGN KEY KeywordReference1 min 110SQL FROM KeywordReference1 min 111SQL FULL OUTER JOIN KeywordReference1 min 112SQL GROUP BY KeywordReference1 min 113SQL HAVING KeywordReference1 min 114SQL IN KeywordReference1 min 115SQL INDEX KeywordReference1 min 116SQL INNER JOIN KeywordReference1 min 117SQL INSERT INTO KeywordReference1 min 118SQL INSERT INTO SELECT KeywordReference1 min 119SQL IS NULL KeywordReference1 min 120SQL IS NOT NULL KeywordReference1 min 121SQL JOIN KeywordReference2 min 122SQL LEFT JOIN KeywordReference1 min 123SQL LIKE KeywordReference1 min 124SQL SELECT TOP, LIMIT and ROWNUM KeywordsReference1 min 125SQL NOT KeywordReference1 min 126SQL NOT NULL KeywordReference1 min 127SQL OR KeywordReference1 min 128SQL ORDER BY KeywordReference1 min 129SQL FULL OUTER JOIN KeywordReference1 min 130SQL PRIMARY KEY KeywordReference2 min 131SQL CREATE PROCEDURE KeywordReference1 min 132SQL RIGHT JOIN KeywordReference1 min 133SQL SELECT TOP, LIMIT and ROWNUM KeywordsReference1 min 134SQL SELECT KeywordReference1 min 135SQL SELECT DISTINCT KeywordReference1 min 136SQL SELECT INTO KeywordReference1 min 137SQL SELECT TOP, LIMIT and ROWNUM KeywordsReference1 min 138SQL SET KeywordReference1 min 139SQL TABLE KeywordReference1 min 140SQL SELECT TOP, LIMIT and ROWNUM KeywordsReference1 min 141SQL DROP TABLE and TRUNCATE TABLE KeywordsReference1 min 142SQL UNION KeywordReference1 min 143SQL UNION ALL KeywordReference1 min 144SQL UNIQUE KeywordReference1 min 145SQL UPDATE KeywordReference1 min 146SQL VALUES KeywordReference1 min 147SQL VIEW KeywordReference1 min 148SQL WHERE KeywordReference1 min 149MySQL FunctionsReference9 min 150MySQL ASCII() FunctionReference1 min 151MySQL CHAR_LENGTH() FunctionReference1 min 152MySQL CHARACTER_LENGTH() FunctionReference1 min 153MySQL CONCAT() FunctionReference1 min 154MySQL CONCAT_WS() FunctionReference1 min 155MySQL FIELD() FunctionReference1 min 156MySQL FIND_IN_SET() FunctionReference1 min 157MySQL FORMAT() FunctionReference1 min 158MySQL INSERT() FunctionReference1 min 159MySQL INSTR() FunctionReference1 min 160MySQL LCASE() FunctionReference1 min 161MySQL LEFT() FunctionReference1 min 162MySQL LENGTH() FunctionReference1 min 163MySQL LOCATE() FunctionReference1 min 164MySQL LOWER() FunctionReference1 min 165MySQL LPAD() FunctionReference1 min 166MySQL LTRIM() FunctionReference1 min 167MySQL MID() FunctionReference2 min 168MySQL POSITION() FunctionReference1 min 169MySQL REPEAT() FunctionReference1 min 170MySQL REPLACE() FunctionReference1 min 171MySQL REVERSE() FunctionReference1 min 172MySQL RIGHT() FunctionReference1 min 173MySQL RPAD() FunctionReference1 min 174MySQL RTRIM() FunctionReference1 min 175MySQL SPACE() FunctionReference1 min 176MySQL STRCMP() FunctionReference1 min 177MySQL SUBSTR() FunctionReference2 min 178MySQL SUBSTRING() FunctionReference2 min 179MySQL SUBSTRING_INDEX() FunctionReference1 min 180MySQL TRIM() FunctionReference1 min 181MySQL UCASE() FunctionReference1 min 182MySQL UPPER() FunctionReference1 min 183MySQL ABS() FunctionReference1 min 184MySQL ACOS() FunctionReference1 min 185MySQL ASIN() FunctionReference1 min 186MySQL ATAN() FunctionReference1 min 187MySQL ATAN2() FunctionReference1 min 188MySQL AVG() FunctionReference1 min 189MySQL CEIL() FunctionReference1 min 190MySQL CEILING() FunctionReference1 min 191MySQL COS() FunctionReference1 min 192MySQL COT() FunctionReference1 min 193MySQL COUNT() FunctionReference1 min 194MySQL DEGREES() FunctionReference1 min 195MySQL DIV FunctionReference1 min 196MySQL EXP() FunctionReference1 min 197MySQL FLOOR() FunctionReference1 min 198MySQL GREATEST() FunctionReference1 min 199MySQL LEAST() FunctionReference1 min 200MySQL LN() FunctionReference1 min 201MySQL LOG() FunctionReference1 min 202MySQL LOG10() FunctionReference1 min 203MySQL LOG2() FunctionReference1 min 204MySQL MAX() FunctionReference1 min 205MySQL MIN() FunctionReference1 min 206MySQL MOD() FunctionReference1 min 207MySQL PI() FunctionReference1 min 208MySQL POW() FunctionReference1 min 209MySQL POWER() FunctionReference1 min 210MySQL RADIANS() FunctionReference1 min 211MySQL RAND() FunctionReference1 min 212MySQL ROUND() FunctionReference1 min 213MySQL SIGN() FunctionReference1 min 214MySQL SIN() FunctionReference1 min 215MySQL SQRT() FunctionReference1 min 216MySQL SUM() FunctionReference1 min 217MySQL TAN() FunctionReference1 min 218MySQL TRUNCATE() FunctionReference1 min 219MySQL ADDDATE() FunctionReference1 min 220MySQL ADDTIME() FunctionReference1 min 221MySQL CURDATE() FunctionReference1 min 222MySQL CURRENT_DATE() FunctionReference1 min 223MySQL CURRENT_TIME() FunctionReference1 min 224MySQL CURRENT_TIMESTAMP() FunctionReference1 min 225MySQL CURTIME() FunctionReference1 min 226MySQL DATE() FunctionReference1 min 227MySQL DATEDIFF() FunctionReference1 min 228MySQL DATE_ADD() FunctionReference1 min 229MySQL DATE_FORMAT() FunctionReference4 min 230MySQL DATE_SUB() FunctionReference1 min 231MySQL DAY() FunctionReference1 min 232MySQL DAYNAME() FunctionReference1 min 233MySQL DAYOFMONTH() FunctionReference1 min 234MySQL DAYOFWEEK() FunctionReference1 min 235MySQL DAYOFYEAR() FunctionReference1 min 236MySQL EXTRACT() FunctionReference1 min 237MySQL FROM_DAYS() FunctionReference1 min 238MySQL HOUR() FunctionReference1 min 239MySQL LAST_DAY() FunctionReference1 min 240MySQL LOCALTIME() FunctionReference1 min 241MySQL LOCALTIMESTAMP() FunctionReference1 min 242MySQL MAKEDATE() FunctionReference1 min 243MySQL MAKETIME() FunctionReference1 min 244MySQL MICROSECOND() FunctionReference1 min 245MySQL MINUTE() FunctionReference1 min 246MySQL MONTH() FunctionReference1 min 247MySQL MONTHNAME() FunctionReference1 min 248MySQL NOW() FunctionReference1 min 249MySQL PERIOD_ADD() FunctionReference1 min 250MySQL PERIOD_DIFF() FunctionReference1 min 251MySQL QUARTER() FunctionReference1 min 252MySQL SECOND() FunctionReference1 min 253MySQL SEC_TO_TIME() FunctionReference1 min 254MySQL STR_TO_DATE() FunctionReference4 min 255MySQL SUBDATE() FunctionReference1 min 256MySQL SUBTIME() FunctionReference1 min 257MySQL SYSDATE() FunctionReference1 min 258MySQL TIME() FunctionReference1 min 259MySQL TIME_FORMAT() FunctionReference2 min 260MySQL TIME_TO_SEC() FunctionReference1 min 261MySQL TIMEDIFF() FunctionReference1 min 262MySQL TIMESTAMP() FunctionReference1 min 263MySQL TO_DAYS() FunctionReference1 min 264MySQL WEEK() FunctionReference2 min 265MySQL WEEKDAY() FunctionReference1 min 266MySQL WEEKOFYEAR() FunctionReference1 min 267MySQL YEAR() FunctionReference1 min 268MySQL YEARWEEK() FunctionReference1 min 269MySQL BIN() FunctionReference1 min 270MySQL BINARY FunctionReference1 min 271MySQL CASE FunctionReference1 min 272MySQL CAST() FunctionReference2 min 273MySQL COALESCE() FunctionReference1 min 274MySQL CONNECTION_ID() FunctionReference1 min 275MySQL CONV() FunctionReference1 min 276MySQL CONVERT() FunctionReference2 min 277MySQL CURRENT_USER() FunctionReference1 min 278MySQL DATABASE() FunctionReference1 min 279MySQL IF() FunctionReference1 min 280MySQL IFNULL() FunctionReference1 min 281MySQL ISNULL() FunctionReference1 min 282MySQL LAST_INSERT_ID() FunctionReference1 min 283MySQL NULLIF() FunctionReference1 min 284MySQL SESSION_USER() FunctionReference1 min 285MySQL SYSTEM_USER() FunctionReference1 min 286MySQL USER() FunctionReference1 min 287MySQL VERSION() FunctionReference1 min 288SQL Server FunctionsReference6 min 289SQL Server ASCII() FunctionReference1 min 290SQL Server CHAR() FunctionReference1 min 291SQL Server CHARINDEX() FunctionReference1 min 292SQL Server CONCAT() FunctionReference1 min 293SQL Server Concat With +Reference1 min 294SQL Server CONCAT_WS() FunctionReference1 min 295SQL Server DATALENGTH() FunctionReference1 min 296SQL Server DIFFERENCE() FunctionReference1 min 297SQL Server FORMAT() FunctionReference1 min 298SQL Server LEFT() FunctionReference1 min 299SQL Server LEN() FunctionReference1 min 300SQL Server LOWER() FunctionReference1 min 301SQL Server LTRIM() FunctionReference1 min 302SQL Server NCHAR() FunctionReference1 min 303SQL Server PATINDEX() FunctionReference1 min 304SQL Server QUOTENAME() FunctionReference1 min 305SQL Server REPLACE() FunctionReference1 min 306SQL Server REPLICATE() FunctionReference1 min 307SQL Server REVERSE() FunctionReference1 min 308SQL Server RIGHT() FunctionReference1 min 309SQL Server RTRIM() FunctionReference1 min 310SQL Server SOUNDEX() FunctionReference1 min 311SQL Server SPACE() FunctionReference1 min 312SQL Server STR() FunctionReference1 min 313SQL Server STUFF() FunctionReference1 min 314SQL Server SUBSTRING() FunctionReference1 min 315SQL Server TRANSLATE() FunctionReference1 min 316SQL Server TRIM() FunctionReference1 min 317SQL Server UNICODE() FunctionReference1 min 318SQL Server UPPER() FunctionReference1 min 319SQL Server ABS() FunctionReference1 min 320SQL Server ACOS() FunctionReference1 min 321SQL Server ASIN() FunctionReference1 min 322SQL Server ATAN() FunctionReference1 min 323SQL Server ATN2() FunctionReference1 min 324SQL Server AVG() FunctionReference1 min 325SQL Server CEILING() FunctionReference1 min 326SQL Server COUNT() FunctionReference1 min 327SQL Server COS() FunctionReference1 min 328SQL Server COT() FunctionReference1 min 329SQL Server DEGREES() FunctionReference1 min 330SQL Server EXP() FunctionReference1 min 331SQL Server FLOOR() FunctionReference1 min 332SQL Server LOG() FunctionReference1 min 333SQL Server LOG10() FunctionReference1 min 334SQL Server MAX() FunctionReference1 min 335SQL Server MIN() FunctionReference1 min 336SQL Server PI() FunctionReference1 min 337SQL Server POWER() FunctionReference1 min 338SQL Server RADIANS() FunctionReference1 min 339SQL Server RAND() FunctionReference1 min 340SQL Server ROUND() FunctionReference1 min 341SQL Server SIGN() FunctionReference1 min 342SQL Server SIN() FunctionReference1 min 343SQL Server SQRT() FunctionReference1 min 344SQL Server SQUARE() FunctionReference1 min 345SQL Server SUM() FunctionReference1 min 346SQL Server TAN() FunctionReference1 min 347SQL Server CURRENT_TIMESTAMP FunctionReference1 min 348SQL Server DATEADD() FunctionReference2 min 349SQL Server DATEDIFF() FunctionReference1 min 350SQL Server DATEFROMPARTS() FunctionReference1 min 351SQL Server DATENAME() FunctionReference1 min 352SQL Server DATEPART() FunctionReference2 min 353SQL Server DAY() FunctionReference1 min 354SQL Server GETDATE() FunctionReference1 min 355SQL Server GETUTCDATE() FunctionReference1 min 356SQL Server ISDATE() FunctionReference1 min 357SQL Server MONTH() FunctionReference1 min 358SQL Server SYSDATETIME() FunctionReference1 min 359SQL Server YEAR() FunctionReference1 min 360SQL Server CAST() FunctionReference1 min 361SQL Server COALESCE() FunctionReference1 min 362SQL Server CONVERT() FunctionReference4 min 363SQL Server CURRENT_USER FunctionReference1 min 364SQL Server IIF() FunctionReference1 min 365SQL Server ISNULL() FunctionReference1 min 366SQL Server ISNUMERIC() FunctionReference1 min 367SQL Server NULLIF() FunctionReference1 min 368SQL Server SESSION_USER FunctionReference1 min 369SQL Server SESSIONPROPERTY() FunctionReference1 min 370SQL Server SYSTEM_USER FunctionReference1 min 371SQL Server USER_NAME() FunctionReference1 min 372MS Access FunctionsReference4 min 373MS Access Asc() FunctionReference1 min 374MS Access Chr() FunctionReference1 min 375MS Access Concat With &Reference1 min 376MS Access CurDir() FunctionReference1 min 377MS Access Format() FunctionReference3 min 378MS Access InStr() FunctionReference1 min 379MS Access InstrRev() FunctionReference1 min 380MS Access LCase() FunctionReference1 min 381MS Access Left() FunctionReference1 min 382MS Access Len() FunctionReference1 min 383MS Access LTrim() FunctionReference1 min 384MS Access Mid() FunctionReference1 min 385MS Access Replace() FunctionReference1 min 386MS Access Right() FunctionReference1 min 387MS Access RTrim() FunctionReference1 min 388MS Access Space() FunctionReference1 min 389MS Access Split() FunctionReference1 min 390MS Access Str() FunctionReference1 min 391MS Access StrComp() FunctionReference1 min 392MS Access StrConv() FunctionReference1 min 393MS Access StrReverse() FunctionReference1 min 394MS Access Trim() FunctionReference1 min 395MS Access UCase() FunctionReference1 min 396MS Access Abs() FunctionReference1 min 397MS Access Atn() FunctionReference1 min 398MS Access Avg() FunctionReference1 min 399MS Access Cos() FunctionReference1 min 400MS Access Count() FunctionReference1 min 401MS Access Exp() FunctionReference1 min 402MS Access Fix() FunctionReference1 min 403MS Access Format() FunctionReference2 min 404MS Access Int() FunctionReference1 min 405MS Access Max() FunctionReference1 min 406MS Access Min() FunctionReference1 min 407MS Access Randomize() FunctionReference1 min 408MS Access Rnd FunctionReference1 min 409MS Access Round() FunctionReference1 min 410MS Access Sgn() FunctionReference1 min 411MS Access Sqr() FunctionReference1 min 412MS Access Sum() FunctionReference1 min 413MS Access Val() FunctionReference1 min 414MS Access Date() FunctionReference1 min 415MS Access DateAdd() FunctionReference1 min 416MS Access DateDiff() FunctionReference2 min 417MS Access DatePart() FunctionReference2 min 418MS Access DateSerial() FunctionReference1 min 419MS Access DateValue() FunctionReference1 min 420MS Access Day() FunctionReference1 min 421MS Access Format() FunctionReference2 min 422MS Access Hour() FunctionReference1 min 423MS Access Minute() FunctionReference1 min 424MS Access Month() FunctionReference1 min 425MS Access MonthName() FunctionReference1 min 426MS Access Now() FunctionReference1 min 427MS Access Second() FunctionReference1 min 428MS Access Time() FunctionReference1 min 429MS Access TimeSerial() FunctionReference1 min 430MS Access TimeValue() FunctionReference1 min 431MS Access Weekday() FunctionReference1 min 432MS Access WeekdayName() FunctionReference1 min 433MS Access Year() FunctionReference1 min 434MS Access CurrentUser() FunctionReference1 min 435MS Access Environ() FunctionReference1 min 436MS Access IsDate() FunctionReference1 min 437MS Access IsNull() FunctionReference1 min 438MS Access IsNumeric() FunctionReference1 min 439SQL Quick ReferenceReference3 min

SQL Examples· 1 lessons

440SQL Examples2 min