SQL (Structured Query Language) — pronounced “sequel” or “ess queue ell” — is a computer programming language tailored to interacting with data stored in relational databases. SQL provides all the necessary tools to create, read, update, and delete (CRUD) that data.
This SQL hub lists all the Udacity blog posts which cover SQL. Armed with this information you can craft “SQL queries” — tailored requests for information — from virtually any database (including MySQL, SQLite, Apache Presto, Firebird SQL, Google BigQuery, Oracle, Microsoft SQL Server, Sybase, SAP HANA, IBM DB2, and many others).
- An Introduction to Relational Database and SQL
- SQL — A Language Overview Tutorial
- SQL Join – Connecting Tables
- SQL Update – Amend Your Data
- SQL Insert — Adding To A Database
- SQL Case — Choosing What To Do
- SQL Group By — Refining Your Queries
- SQL Alter — Changing Your Mind
- SQL Order By — Sorting For Readability
- SQL Where — Getting At Your Dreams
- SQL Create Table — Storing All The Things
- SQL Distinct — Getting the Basics Down
- SQL Delete — All Good Things Must End
- SQL Coalesce — Weeding Through The NULLs
- SQL Injection — All Your Data Are Ours
- SQL Aggregate Functions — AVG, COUNT, DISTINCT, MAX, MIN, SUM
- SQL Like — Wildcards Empower Searching
- SQL Top Limit Fetch Rownum — Too Much Of A Good Thing
- SQL Between — Limiting Rows Returned
- SQL Inner Join — Together, Forever
- SQL Having — Finding, Grouping, and Filtering
- SQL Dates And Times — Opportunity Knocks
- SQL In — Picking Through Collections
- SQL Select — Just the Facts
- SQL Substring — The Lint From The Fluff
- SQL Booleans – The True Will Set You Free
- SQL Insert Into — Everything Has Its Place
- SQL Convert and SQL Cast — It’s All Back & Forth
- SQL Union — Collections of Collections
- SQL IFNULL — Hurdling Over Potholes
- SQL DATEDIFF — Now & Then
- SQL FOREIGN KEY — Unlock Table Relationships
To learn more about SQL, enroll in our SQL Nanodegree program, described in detail here.
