MY CARTIntroductory SQL Quick Reference Guide 
| 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
The TRANSACTION Statement
SQL Functions and Aliases
About SQL Functions
Common Aggregate Functions
Calculated Fields and Column Aliases
Table Aliases
Views
About Views
Creating a View
Altering a View
Removing a View
