Register your product to gain access to bonus material or receive a coupon.
In just 24 lessons of one hour or less, you will learn professional techniques to design and build efficient databases and query them to extract useful information. Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of ANSI SQL from the ground up.
Example code demonstrates the authors’ professional techniques, while exercises written for MySQL offer the reader hands-on learning with an open-source database. Included are advanced techniques for using views, managing transactions, database administration, and extending SQL.
Step-by-step instructions carefully walk you through the most common SQL tasks.
Q&As, Quizzes, and Exercises at the end of each chapter help you test your knowledge.
Notes and Tips point out shortcuts and solutions.
New terms are clearly defined and explained.
Learn how to…
For more than ten years the authors have studied, applied, and documented the SQL standard and its application to critical database systems.
Ryan Stephens and Ron Plew are entrepreneurs, speakers, and cofounders of Perpetual Technologies, Inc. (PTI), a fast-growing IT management and consulting firm which specializes in database technologies. They taught database courses for Indiana University–Purdue University in Indianapolis for five years and have authored more than a dozen books on Oracle, SQL, database design, and the high availability of critical systems.
Arie D. Jones is Senior SQL Server database administrator and analyst for PTI. He is a regular speaker at technical events and has authored several books and articles.
Category: Database
Covers: ANSI SQL
User Level: Beginning–Intermediate
Register your book at informit.com/title/9780672330186 for convenient access to updates and corrections
as they become available.
Download the CREATE TABLES statements and INSERT statements for the book examples
Managing Database Objects in SQL
Introduction 1
What This Book Intends to Accomplish......................... 1
What We Added to This Edition..................................... 1
What You Need............................................................ 2
Conventions Used in This Book..................................... 2
ANSI SQL and Vendor Implementations........................ 3
Understanding the Examples and Exercises................... 3
Part I: A SQL Concepts Overview
Hour 1: Welcome to the World of SQL 7
SQL Definition and History............................................ 7
SQL Sessions............................................................. 14
Types of SQL Commands........................................... 15
The Database Used in This Book................................. 17
Summary.................................................................. 22
Q&A.......................................................................... 23
Workshop................................................................. 24
Part II: Building Your Database
Hour 2: Defining Data Structures 27
What Is Data?............................................................ 27
Basic Data Types....................................................... 28
Summary.................................................................. 36
Q&A.......................................................................... 37
Workshop................................................................. 37
Hour 3: Managing Database Objects 41
What Are Database Objects?...................................... 41
What Is a Schema?.................................................... 42
A Table: The Primary Storage for Data........................ 44