Skip to content

Sams Teach Yourself SQL in 24 Hours

ISBN-10: 0672318997

ISBN-13: 9780672318993

Edition: 2nd 2000

Authors: Ryan K. Stephens, Ronald R. Plew

List price: $24.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

With this book, readers can learn the fundamentals of SQL quickly through the use of numerous examples depicting all the major components of SQL.
Customers also bought

Book details

List price: $24.99
Edition: 2nd
Copyright year: 2000
Publisher: Sams
Publication date: 3/28/2000
Binding: Paperback
Pages: 464
Size: 7.36" wide x 9.06" long x 1.02" tall
Weight: 1.650
Language: English

Introduction
A SQL Concepts Overview
Welcome to the World of SQL
SQL Definition and History
SQL Sessions
Disconnect
Types of SQL Commands
An Introduction to the Database Used in This Book
A SQL Concepts Overview
Defining Data Structures
What Is Data?
Basic Data Types
Managing Database Objects
What Are Database Objects?
What Is a Schema?
A Table: The Primary Storage for Data
Integrity Constraints
The Normalization Process
Normalizing a Database
Manipulating Data
Overview of Data Manipulation
Populating Tables with New Data
Updating Existing Data
Deleting Data from Tables
Managing Database Transactions
What Is a Transaction?
What Is Transactional Control?
Transactional Control and Database Performance
Getting Effective Results from Queries
Introduction to the Database Query
What Is a Query?
Introduction to the SELECT Statement
Examples of Simple Queries
Using Operators to Categorize Data
What Is an Operator in SQL?
Comparison Operators
Logical Operators
Conjunctive Operators
Negating Conditions with the NOT Operator
Arithmetic Operators
Summarizing Data Results from a Query
What Are Aggregate Functions?
Sorting and Grouping Data
Why Group Data?
The GROUP BY Clause
GROUP BY Versus ORDER BY
The HAVING Clause
Restructuring the Appearance of Data
The Concepts of ANSI Character Functions
Various Common Character Functions
Miscellaneous Character Functions
Mathematical Functions
Conversion Functions
The Concept of Combining Character Functions
Understanding Dates and Times
How Is a Date Stored?
Date Functions
Date Conversions
Building Sophisticated Database Queries
Joining Tables in Queries
Selecting Data from Multiple Tables
Types of Joins
Join Considerations
Using Subqueries to Define Unknown Data
What Is a Subquery?
Embedding a Subquery Within a Subquery
Combing Multiple Queries into One
Single Queries Versus Compound Queries
Why Would I Ever Want to Use a Compound Query?
Compound Query Operators
Using an ORDER BY with a Compound Query
Using a GROUP BY with a Compound Query
Retrieving Accurate Data
SQL Performance Tuning
Using Indexes to Improve Performance
What Is an Index?
How Do Indexes Work?
The GREATE INDEX Command
Types of Indexes
When Should Indexes Be Considered?
When Should Indexes Be Avoided?
Improving Database Performance
What Is SQL Statement Tuning?
Database Tuning Versus SQL Tuning
Formatting Your SQL Statement
Full Table Scans
Other Performance Considerations
Performance Tools
Using SQL to Manage Users and Security
Managing Database Users
Users Are the Reason
The Management Process
Tools Utilized by Database Users
Managing Database Security
What Is Database Security?
How Does Security Differ from User Management?
What Are Privileges?
Controlling User Access
Controlling Privileges Through Roles
Summarized Data Structures
Creating and Using Views and Synonyms
What Is a View?
Creating Views
Dropping a View
What Is a Synonym?
Working with the System Catalog
What Is the System Catalog?
How Is the System Catalog Created?
What Is Contained in the System Catalog?
Examples of System Catalog Tables by Implementation
Querying the System Catalog
Updating System Catalog Objects
Applying SQL Fundamentals in Today's World
Advanced SQL Topics
Advanced Topics
Cursors
Stored Procedures and Functions
Triggers
Dynamic SQL
Call-Level Interface
Using SQL to Generate SQL
Direct Versus Embedded SQL
Extending SQL to the Enterprise, the Internet, and the Intranet
SQL and the Enterprise
Accessing a Remote Database
Accessing a Remote Database Through a Web Interface
SQL and the Internet
SQL and the Intranet
Extensions to Standard SQL
Various Implementations
Examples of Extensions from Some Implementations
Interactive SQL Statements
Applying SQL Fundamentals in Today's World
Common SQL Commands
SQL Statements
SQL Clauses
ASCII Table
Answers to Quizzes and Exercises
Create Table Statements for Book Examples
Insert Statements for Data in Book Examples
Insert Statements
Glossary
Index