SQL or Structured Query Language is the standard language for interacting with relational databases. It is a declarative language used to retrieve and manipulate data stored in a relational database. To effectively query and modify a relational database, you need to understand and use the main SQL keywords and commands.
This SQL Keywords Reference PDF provides a quick overview of the main SQL keywords and concepts you need to know to start querying and modifying data in a relational database. The reference covers common keywords for creating tables and inserting data, selecting data, sorting and filtering data, updating data, deleting data, creating views, storing procedures, triggers, and more.
Related posts
Whether you are just getting started with SQL or need a quick refresher, this SQL Keywords Reference PDF aims to be a helpful desk companion with the main SQL concepts and keywords summarized in one place.
Overview SQL Keywords Reference
Three pages of SQL Keywords Reference in PDF format. Refer to this guide anytime you need to look up a SQL keyword, concept or command. Let’s start by reviewing some of the most fundamental SQL keywords for creating tables and adding data.
Reference Content
- ADD
- ADD CONSTRAINT
- ALL
- ALTER
- ALTER COLUMN
- ALTER TABLE
- AND
- ANY
- AS
- ASC
- BACKUP DATABASE
- BETWEEN
- CASE
- CHECK
- COLUMN
- CONSTRAINT
- CREATE
- CREATE DATABASE
- CREATE INDEX
- CREATE OR REPLACE VIEW
- CREATE TABLE
- CREATE PROCEDURE
- CREATE UNIQUE INDEX
- CREATE VIEW
- DATABASE
- DEFAULT
- DELETE
- DESC
- DISTINCT
- DROP
- DROP COLUMN
- DROP CONSTRAINT
- DROP DATABASE
- DROP DEFAULT
- DROP INDEX
- DROP TABLE
- DROP VIEW
- EXEC
- EXISTS
- FOREIGN KEY
- FROM
- FULL OUTER JOIN
- GROUP BY
- HAVING
- IN
- INDEX
- INNER JOIN
- INSERT INTO
- INSERT INTO SELECT
- IS NULL
- IS NOT NULL
- JOIN
- LEFT JOIN
- LIKE
- LIMIT
- NOT
- NOT NULL
- OR
- ORDER BY
- OUTER JOIN
- PRIMARY KEY
- PROCEDURE
- RIGHT JOIN
- ROWNUM
- SELECT
Reference Format
Nu Of Pages
3 Pages
