×

Contact Us

Corporate Headquarters

TeachUcomp, Inc.
1140 Abbot Road
#64
East Lansing MI 48823
USA

Phone

Toll Free (U.S. and Canada): 877-925-8080
International:  +1-517-333-2560

Email

sales@teachucomp.com

Hours of Operation

Monday-Friday 9:00-5:00 Eastern.

Policies

Privacy Policy

Terms and Conditions

Introductory SQL Quick Reference Guide

$5.95

Available via Printed/Laminated (Shipped/Physical) or PDF (Download Only):

Quantity: Price:
1-49 $5.95
50-99 $4.85
100-499 $4.05
500-999 $3.50
1000+ $3.35

SKU: N/A Categories: , ,

Description

Subject: SQL
Level: Introductory
Topics Covered: 45
Pages: 4
Dimensions: 11 x 17″ – Folded
Availability: Printed & Laminated or PDF Download
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

You may also like…

  • One Year Subscription- Access to Entire Library

    $29.00 for 1 year
    Add to CartMORE INFO
TOP
SALE! $29 All-Access 15 Days 12 Hours 47 Minutes 45 Seconds      $199 $29 Entire Library!
See Deal