Learning SQL

• Part 1: Understanding Tables
• Part 2: SELECT
• Part 3: INSERT
• Part 4: UPDATE
• Part 5: DELETE

Using SQL

• Part 1: CREATE TABLE
• Part 2: ALTER TABLE
• Part 3: DROP TABLE
• Part 4: Working with Databases

Mastering SQL

• Part 1: Primary and Foreign Keys
• Part 2: WHERE, BY, AND
• Part 3: OR, AS, LIMIT
• Part 4: LIKE, WITH

Structured Query Language (SQL) is a declarative programming language used for accessing data storied in relational databases. It appears in or is a core part of many common software packages like MySQL, PostgreSQL, Microsoft SQL Server, and Oracle Database.

---

To help retrieve, organize, and sort data, there are a large number of keywords connected to using SELECT statements. Many of these are also used with UPDATE and DELETE to help work on only those rows and columns needed.

LIKE

The LIKE keyword compares similar values. Instead of finding an exact value, the LIKE keyword is used to find values that might match the value submitted.

SELECT *

  FROM Books

 WHERE Author LIKE 'Jemisin'

Wildcards

To work with the LIKE keyword, there are some special characters used to find similar values.

• “%”: Representing one or more characters.
• “_”: Representing a single character

SELECT *
   FROM Books
  WHERE Author LIKE '%Jemisin'

WITH

The WITH keyword allows a query to have a sub-query. Often paired with the keyword AS, the results of a SELECT statement can be combined into a more complex statement where one query feeds into another.

WITH temporaryTable (ID, Name) 
AS (SELECT * FROM Orders) 
SELECT ID, Name
WHERE OrderNumber = '4567'