Special Edition Using SQL,9780789719744

Special Edition Using SQL

by
Edition: 1st
ISBN13: 9780789719744
ISBN10: 0789719746
Format: Paperback
Pub. Date: 1999-10-27
Publisher(s): Que Publishing
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $41.99

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $20.43

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Special Edition Using SQL provides a comprehensive walk through of the SQL language. At the same time, this book is a useful reference to someone who is already an experienced database user and SQL programmer. It includes lots of information that will help you build, maintain, and manage a database. Topics covered include Database Design, Aggregating Query Results, Organizing Query Results, Real World Issues, Database Performance and Integrity, Database Security, Transactions, Stored Procedures, Database Management, Writing a Custom Loader in Perl, ODBC, DBI/DBD, JDBC, Web Publishing, and Tools for Web Publishing.

Author Biography

Rafe Colburn is a programmer working for Interpath Communications in the Professional Services department. He spends most of his time writing database-backed Web applications used on both public Web sites and Intranets. He has extensive experience designing both small and large scale databases using a number of popular relational database packages. He is also the author of Teach Yourself CGI Programming in a Week.

Table of Contents

Introduction 1(6)
Designing and Constructing a Database
The Structured Query Language
7(20)
Database Design
27(30)
Creatig Databases
57(22)
Creating, Changing, and Removing Records
79(20)
Retrieving Data from a Database
The SELECT Statement
99(28)
Using the WHERE Clause
127(22)
Aggregating Query Results
149(22)
Combining Tables Using Joins
171(30)
Subqueries
201(28)
Database Management
Using Views
229(26)
The SQL Security Model
255(24)
Real-World Issues
Handling Specific Types of Data
279(30)
Database Performance and Integrity
309(22)
Transactions and Cursors
331(26)
Stored Procedures
Writing Stored Procedures
357(28)
More On Transact-SQL Stored Procedures
385(18)
Writing Oracle PL/SQL Stored Procedures
403(28)
Specific Databases
Oracle
431(26)
Microsoft SQL Server and Sybase Adaptive Server
457(28)
Microsoft Access
485(24)
MSQL and MySQL
509(24)
Publishing Databases on the Web
Web Programming Fundamentals
533(20)
Web Application Servers
553(26)
A Sample Web Application
579(42)
Appendix
A System-Defined Exceptions in PL/SQ
619(2)
Index 621

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.