Sign in  |  Register
Advanced search
Publication Cover

CITATION

Oppel, Andrew. SQL Demystified. US: McGraw-Hill Osborne Media, 2005.

SQL Demystified

Authors: Andrew Oppel

Published:  October 2005

eISBN: 9780071486729 0071486720 | ISBN: 9780072262247
Open eBook
  • Contents
  • Acknowledgments
  • Introduction
  • Chapter 1 Relational Database Concepts
  • What Is a Database?
  • What Is a Database Management System (DBMS)?
  • What Is a Relational Database?
  • Relational Database Components
  • How Relational Databases Are Designed
  • The Need for Normalization
  • Applying the Normalization Process
  • Overview of the Video Store Sample Database
  • Downloading the SQL for the Sample Database
  • Quiz
  • Chapter 2 SQL Concepts
  • What Is SQL?
  • Connecting to the Database
  • A Brief History of SQL
  • SQL Syntax Conventions
  • SQL Statement Categories
  • Data Definition Language (DDL)
  • Data Query Language (DQL)
  • Data Manipulation Language (DML)
  • Data Control Language (DCL)
  • Transaction Control Commands
  • Quiz
  • Chapter 3 Defining Database Objects Using SQL
  • Syntax Conventions Used in This Chapter
  • Data Types
  • SQL:2003 Standard Data Types
  • Vendor Data Type Extensions and Differences
  • NULL Values and Three-Valued Logic
  • Data Definition Language (DDL) Statements
  • The CREATE DATABASE Statement
  • The CREATE TABLE Statement
  • The CREATE INDEX Statement
  • The CREATE VIEW Statement
  • The ALTER TABLE Statement
  • The DROP Statement
  • Quiz
  • Chapter 4 Retrieving Data Using Data Query Language (DQL)
  • The Basic SELECT Statement
  • Column Name Aliases
  • Sorting Results
  • Using the WHERE Clause to Filter Rows
  • Comparison Operators
  • Conjunctive Operators
  • Logical Operators
  • Arithmetic Operators
  • Basic SQL Functions
  • Character Functions
  • Mathematical Functions
  • Conversion Functions
  • Aggregate Functions and Grouping Rows
  • GROUP BY Clause
  • Compound Query Operators
  • UNION
  • UNION ALL
  • INTERSECT
  • EXCEPT
  • Quiz
  • Chapter 5 Combining Data from Multiple Tables
  • Joins
  • Equijoins
  • Natural Joins
  • Outer Joins
  • Self Joins
  • Other Joins
  • Cross Joins
  • Subselects
  • Noncorrelated Subselects
  • Correlated Subselects
  • Inline Views
  • Quiz
  • Chapter 6 Advanced Query Writing
  • Advanced SQL Functions
  • Character Functions
  • Mathematical Functions
  • Date and Time Functions
  • Taking Advantage of Views
  • Using SQL to Generate SQL
  • Generating SQL in Oracle
  • Generating SQL in Microsoft SQL Server
  • The CASE Expression
  • Simple CASE Expression
  • Searched CASE Expression
  • Quiz
  • Chapter 7 Maintaining Data Using DML
  • The INSERT Statement
  • Single Row Inserts Using the VALUES Clause
  • Bulk Inserts Using a Nested SELECT
  • The UPDATE Statement
  • The DELETE Statement
  • Quiz
  • Chapter 8 Applying Security Controls Using DCL
  • Why Is Security Necessary?
  • Database Security Architectures
  • Database Security in Microsoft SQL Server and Sybase Adaptive Server
  • Database Security in Oracle
  • Implementing Database Access Security
  • Database Privileges
  • SQL Statements Used for Security Administration
  • Schema Owner Accounts
  • Simplifying Administration Using Roles
  • Administering Roles in Microsoft SQL Server and Sybase Adaptive Server
  • Administering Roles in Oracle
  • Using Views to Implement Column and Row Level Security
  • Quiz
  • Chapter 9 Preserving Database Integrity Using Transactions
  • What Is a Database Transaction?
  • Transaction Support in Relational DBMSs
  • Transaction Support in Microsoft SQL Server
  • Transaction Support in Sybase Adaptive Server
  • Transaction Support in Oracle
  • Transaction Support in MySQL
  • Transaction Support in DB2 UDB
  • Locking and Transaction Deadlock
  • The Concurrent Update Problem
  • Locking Mechanisms
  • Deadlocks
  • Quiz
  • Chapter 10 Integrating SQL into Applications
  • Cursor Processing
  • The DECLARE CURSOR Statement
  • The OPEN CURSOR Statement
  • The FETCH Statement
  • Cursor UPDATE and DELETE Statements
  • The CLOSE Statement
  • Embedding SQL in Application Programs
  • ODBC Connections
  • Connecting Databases to Java Applications
  • The .NET Framework
  • Computationally Complete SQL
  • Transact-SQL (Microsoft SQL Server and Sybase Adaptive Server)
  • Oracle PL/SQL
  • Quiz
  • Chapter 11 SQL Performance and Tuning Considerations
  • General RDBMS Tuning Considerations
  • Minimize Disk Reads and Writes
  • Tune the Computer System and Environment
  • Design the Tables Efficiently
  • Tuning SQL Queries
  • General RDBMS Considerations
  • MySQL Considerations
  • Oracle Considerations
  • Microsoft SQL Server Considerations
  • DB2 UDB Considerations
  • Tuning DML Statements
  • Quiz
  • Final Exam
  • Answers to Quizzes and Final Exam
  • Chapter 1
  • Chapter 2
  • Chapter 3
  • Chapter 4
  • Chapter 5
  • Chapter 6
  • Chapter 7
  • Chapter 8
  • Chapter 9
  • Chapter 10
  • Chapter 11
  • Final Exam Answers
  • Index