SQL Quick Reference Guide

Introductory SQL Quick Reference Guide

  Introductory SQL Quick Reference Cards: Buy SQL Quick Reference Cards at TeachUcomp, Inc. A picture of the first page of the Introductory SQL Quick Reference Card.
Subject: SQL
Level: Introductory
Topics Covered: 45
Pages: 4
Dimensions: 11 x 17″ – Folded
Availability: Printed & Laminated or PDF Download
Price: $5.95     Quantity Discounts Available
ISBN: 978-1-941854-73-0

Product Description

Designed with the busy professional in mind, this 4-page quick reference guide provides step-by-step instructions in Introductory SQL. When you need an answer fast, you will find it right at your fingertips. Clear and easy-to-use, quick reference cards are perfect for individuals, businesses and as supplemental training materials. This guide refers to the core SQL within its examples and focuses on the statements within standard SQL, grouped into four categories: Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), and Transactional Control Language (TCL). 

Topics Covered:

About Databases and SQL
Understanding Database Objects
Database Normalization Guidelines
SQL Variations and Core SQL
Guide Conventions and Categories

Data Definition Language (DDL)
Creating a Database
Creating a Table
Creating an Index
Creating a User
Creating a Role
About SQL Constraints
Applying SQL Constraints
Deleting Database Objects
Modifying Table Structure
General SQL Data Types

Data Manipulation Language (DML)
Inserting Records
Updating Records
Deleting Records
Selecting Records
Selecting with the WHERE Clause
Sorting with the ORDER BY Clause
Grouping Records with the GROUP BY and Optional HAVING Clause
Selecting from Multiple Tables with the JOIN Clause
Combining Result Sets with UNION
Copying Records to a New Table
Appending Records from One Table Into Another Existing Table
Creating a Subquery
Common Comparison Operators Used in the WHERE Clause
Common Notations Used for Literal Values and Wildcard Characters

Data Control Language (DCL)
About Data Control Language
Granting User or Role Privileges
Revoking User or Role Privileges
About Privileges
Commonly Used Privileges
Altering Users
Altering Roles

Transaction Control Language (TCL)
About Transaction Control Language

SQL Functions and Aliases
About SQL Functions
Common Aggregate Functions
Calculated Fields and Column Aliases
Table Aliases

About Views
Creating a View
Altering a View
Removing a View