Cover image for SQL from the ground up
Title:
SQL from the ground up
Author:
Pyefinch, Mary.
Personal Author:
Publication Information:
Berkeley : Osborne/McGraw-Hill, [1999]

©1999
Physical Description:
xviii, 510 pages : illustrations ; 24 cm
Language:
English
ISBN:
9780072119749
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.73.S67 P94 1999 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

SQL (structured query language) is flexible, cross-platform language used to identify trends and relationships in data. SQL relational database business and services is a multi-billion dollar industry. The perfect introduction to SQL in an accelerated tutorial fashion. Real-world examples of how to design a database and retrieve data using queries and reports.


Table of Contents

Acknowledgmentsp. xiii
Introductionp. xv
I SQL Basics--Easy as ABCp. 1
1 What Is SQL?p. 3
What Is SQL?p. 4
SQL-92: What Does It Have That the Others Didn't?p. 6
SQL Is Divided into Three Partsp. 12
2 The Database--A Place for Everything and Everything in Its Placep. 23
Types of Databasesp. 25
What Is in a Database?p. 25
The Relational Modelp. 33
Client/Server Architecturep. 45
Open Database Connectivity (ODBC)p. 46
3 Understanding the SQL Languagep. 49
The SELECT Statement and Its Clausesp. 50
Expressions, Conditions, and Operators, Oh My!p. 55
Functionsp. 71
What's Next?p. 86
4 Building Tables and Viewsp. 87
Overview of Oracle8p. 88
Building Tables with Oracle8p. 89
5 Transaction Managementp. 109
The Set Transaction Statementp. 110
The Four Transaction Problemsp. 113
Lockingp. 116
Transactions in Actionp. 119
What's Nextp. 122
6 Database Securityp. 123
What Does a DBA Do?p. 124
How SQL Handles Securityp. 125
How Much Security Is Too Much?p. 142
What's Next?p. 142
II Queries-The Heart and Soul of SQLp. 143
7 The Simple One-Table Queryp. 145
The SELECT Statementp. 146
The Single-Table Viewp. 163
What's Next?p. 167
8 Complex Multitable Queriesp. 169
The Ins and Outs of Joinsp. 170
Summary Queriesp. 181
Putting It All Together--The Whole Enchilada!p. 189
What's Next?p. 191
9 The Subqueryp. 193
The Subquery Revealedp. 194
Queries--A Reviewp. 211
What's Next?p. 213
10 Optimizing SQLp. 215
How the Database Engine Processes SQLp. 216
Tuning a Databasep. 227
What's Next?p. 231
III Putting It All Together--SQL in Actionp. 233
11 Creating a Databasep. 235
Business Needs Analysisp. 236
What's Next?p. 253
12 Designing the Database Front Endp. 255
Planning the User Interfacep. 256
Other Development Toolsp. 260
What's Next?p. 265
13 Designing Forms in Accessp. 267
Access Design Environmentp. 268
What's Next?p. 284
14 Querying the Databasep. 285
Access Queriesp. 286
Creating Hush Select Queriesp. 299
What's Next?p. 306
15 Reportingp. 307
Types of Reporting Toolsp. 308
How to Choose Your Reporting Toolp. 309
Report Developmentp. 311
What's Next?p. 320
IV SQL Today and Tomorrowp. 323
16 T-SQL and Stored Proceduresp. 325
Understanding Stored Procedures and Cursorsp. 326
What's Next?p. 354
17 Advanced T-SQL Topicsp. 355
Using Cursorsp. 356
System Stored Proceduresp. 367
T-SQL for Administratorsp. 368
Triggersp. 371
Jobsp. 373
What's Next?p. 378
18 SQL*Plusp. 379
Getting Around in SQL*Plusp. 380
Formatting Queriesp. 392
What's Next?p. 400
19 PL/SQL Basicsp. 401
Character Setp. 403
Identifiersp. 404
Reserved Wordsp. 405
Literalsp. 405
The Semicolon Delimiterp. 405
The Pragma Keywordp. 406
Block Structurep. 406
Data Typesp. 409
Procedures, Functions, IF Statements, and Loopsp. 410
What's Next?p. 430
20 Programming with SQLp. 431
How Applications Employing SQL Are Builtp. 433
How ODBC Drivers and Databases Process SQL Commandsp. 434
How to Set Up an ODBC Data Sourcep. 435
Programming SQL with Cp. 435
Programming Dynamic SQL with Visual Basicp. 445
Programming with SQL in Javap. 450
What's Next?p. 456
21 Everyone Makes Mistakesp. 457
Top Ten Common Mistakesp. 458
Something Doesn't Look Right!p. 462
Error Preventionp. 466
What's Next?p. 466
22 The Future--SQL3p. 467
SQL3p. 468
What's Next?p. 479
A Termsp. 481
B Read More About Itp. 491
Booksp. 492
Magazines, Journals, and Organizationsp. 493
Business Intelligence Vendorsp. 494
Database Vendorsp. 495
Sybase, Inc.p. 496
Indexp. 497

Google Preview