Understanding the New SQL

Author: Jim Melton
Publisher: Morgan Kaufmann
ISBN: 9781558602458
Category : Computers
Languages : en
Pages : 564

Book Description
The only book you'll ever need on SQL. The authors detail the changes in the new standard and provide a thorough guide to programming with SQL 2 for both newcomers and experienced programmers. The book is one that novice programmers should read cover to cover and experienced DBMS professionals should have as a definitive reference book for the new SQL 2 standard.

SQL The Complete Reference, 3rd Edition

Author: James R. Groff
Publisher: McGraw Hill Professional
ISBN: 0071592563
Category : Computers
Languages : en
Pages : 911

Book Description
The Definitive Guide to SQL Get comprehensive coverage of every aspect of SQL from three leading industry experts. Revised with coverage of the latest RDBMS software versions, this one-stop guide explains how to build, populate, and administer high-performance databases and develop robust SQL-based applications. SQL: The Complete Reference, Third Edition shows you how to work with SQL commands and statements, set up relational databases, load and modify database objects, perform powerful queries, tune performance, and implement reliable security policies. Learn how to employ DDL statements and APIs, integrate XML and Java scripts, use SQL objects, build web servers, handle remote access, and perform distributed transactions. Techniques for managing in-memory, stream, and embedded databases that run on today's mobile, handheld, and wireless devices are included in this in-depth volume. Build SQL-based relational databases and applications Create, load, and modify database objects using SQL Construct and execute simple, multitable, and summary queries Implement security measures with authentication, privileges, roles, and views Handle database optimization, backup, recovery, and replication Work with stored procedures, functions, extensions, triggers, and objects Extend functionality using APIs, dynamic SQL, and embedded SQL Explore advanced topics such as DBMS transactions, locking mechanisms, materialized views, and two-phase commit protocol Understand the latest market trends and the future of SQL

SQL: The Complete Reference, Second Edition

Author: James Groff
Publisher: McGraw Hill Professional
ISBN: 0072228172
Category : Computers
Languages : en
Pages : 1082

Book Description
Learn all you need to know about SQL with this one-stop resource. Updated to include information on Web services and XML, this complete guide also comes with a Windows 2000- and XP- compatible CD containing 4 databases (SQL Server 2000, IBM DB2 Version 7.2, Sybase, and mySQL).

SQL Functions Programmer's Reference

Author: Arie Jones
Publisher: John Wiley & Sons
ISBN: 0764598074
Category : Computers
Languages : en
Pages : 795

Book Description
Gives programmers two-in-one coverage, with both a "how-to" on SQL functions and a complete SQL functions reference SQL is the standard language for database queries; this book's advanced coverage helps programmers write their own SQL functions Covers both the internationally standardized SQL 99 functions and the hundreds of additional functions introduced by vendors, including the subtle variations required to successfully migrate or interoperate between vendor products Covers the latest versions of the major relational database management system (RDMS) applications: Microsoft SQL Server, Oracle, IBM DB2, and MySQL

Oracle Database 10g The Complete Reference

Author: Kevin Loney
Publisher: McGraw Hill Professional
ISBN: 0071770496
Category : Computers
Languages : en
Pages : 1393

Book Description
Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.

SQL for MySQL Developers

Author: Rick F. van der Lans
Publisher: Pearson Education
ISBN: 0132715899
Category : Computers
Languages : en
Pages : 1117

Book Description
The Most Complete and Practical Guide to MySQL Version 5’s Powerful SQL Dialect MySQL version 5 offers a SQL dialect with immense power. In SQL for MySQL Developers, Rick F. van der Lans helps you master this version ofSQL and take advantage of its full potential. Using case study examplesand hands-on exercises, van der Lans illuminates every key concept,technique, and statement–including advanced features that make iteasier to create even the most complex statements and programs. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why MySQL’s dialect works as it does–and how to get the most out of it. You’ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether you’re a programmer, Web developer, analyst, DBA, or database user, this book can take you from “apprentice” to true SQL expert. If you’ve used SQL in older versions of MySQL, you’ll become dramatically more effective–and if you’re migrating from other database platforms, you’ll gain practical mastery fast.

A Guide to the SQL Standard

Author: C. J. Date
Publisher: Addison Wesley Publishing Company
ISBN:
Category : Computers
Languages : en
Pages : 440

Book Description
A guide for users and designers of database systems. Outlines the inherent problems in the study, design, and implementation, and examines the background issues of priorities, administrative prerequisites, design concepts, database management systems, protocols, security, communication processes, and interactivity. Gives advice on developing corporate databases and management sytems. Non- technical, user-oriented text. No bibliography. Date provides a comprehensive treatment of standard SQL, with many worked examples while discussing some of the implications of the standard. Annotation copyrighted by Book News, Inc., Portland, OR

Oracle7

Author: George Koch
Publisher: Osborne Publishing
ISBN:
Category : Computers
Languages : en
Pages : 1064

Book Description
A comprehensive one-stop resource to the newest version of Oracle in a conveniently organized format that's perfect for both users and application developers. This reference features an alphabetical listing of all Oracle commands with detailed explanations and cross-references, plus invaluable practical chapters with extensive examples on using, designing, and managing databases effectively.

Oracle Database 11g The Complete Reference

Author: Kevin Loney
Publisher: McGraw Hill Professional
ISBN: 0071598766
Category : Computers
Languages : en
Pages : 1369

Book Description
The Definitive Guide to Oracle Database 11g Get full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included. Install Oracle Database 11g or upgrade from an earlier version Create database tables, sequences, indexes, views, and user accounts Construct SQL statements, procedures, queries, and subqueries Optimize security using virtual private databases and transparent data encryption Import and export data using SQL*Loader and Oracle Data Pump Use SQL replay, change management, and result caching Avoid human errors using flashback and automatic undo management Build and tune PL/SQL triggers, functions, and packages Develop database applications using Java, JDBC, and XML Optimize availability and scalability with Oracle Real Application Clusters

SQL Cookbook

Author: Anthony Molinaro
Publisher: "O'Reilly Media, Inc."
ISBN: 0596009763
Category : Computers
Languages : en
Pages : 632

Book Description
A guide to SQL covers such topics as retrieving records, metadata queries, working with strings, data arithmetic, date manipulation, reporting and warehousing, and hierarchical queries.