SQL

  • Auteur: Chris Fehily
  • ISBN: 0132089475
  • Date de sortie: 2010-04-16
  • Collection: Peachpit Press
  • Total Download: 4631
  • Total Read: 6219

Télécharger Lire


SQL is a standard interactive and programming language for querying and modifying data and managing databases. This task-based tutorial and reference guide takes the mystery out learning and applying SQL. After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily immediately launches into the tasks that will get readers comfortable with SQL. In addition to covering all the SQL basics, this thoroughly updated reference contains a wealth of in-depth SQL knowledge and serves as an excellent reference for more experienced users.

Clarion Databases SQL

  • Auteur: David Gerhard Harms
  • ISBN: 9780968955338
  • Date de sortie: 2004
  • Collection: CoveComm Inc.
  • Total Download: 4905
  • Total Read: 9253

Télécharger Lire


SQL

  • Auteur: Robert Sheldon
  • ISBN: 9780072228854
  • Date de sortie: 2003
  • Collection: McGraw Hill Professional
  • Total Download: 2381
  • Total Read: 1952

Télécharger Lire


Explains how to program with SQL, covering topics including database objects, queries, modifications, embedded statements, and troubleshooting.

Oracle SQL Tuning with Oracle SQLTXPLAIN

  • Auteur: Stelios Charalambides
  • ISBN: 1430248106
  • Date de sortie: 2013-04-13
  • Collection: Apress
  • Total Download: 4708
  • Total Read: 4778

Télécharger Lire


Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to tune even the most complex SQL, and you'll learn to do it quickly, without the huge learning curve usually associated with tuning as a whole. Firmly based in real world problems, this book helps you reclaim system resources and avoid the most common bottleneck in overall performance, badly tuned SQL. You'll learn how the optimizer works, how to take advantage of its latest features, and when it's better to turn them off. Quickly tune any SQL statement no matter how complex. Build and tune test cases without affecting production. Use the latest tuning features with confidence.

SQL The Complete Reference 3rd Edition

  • Auteur: James Groff
  • ISBN: 0071592563
  • Date de sortie: 2008-10-01
  • Collection: McGraw Hill Professional
  • Total Download: 6570
  • Total Read: 1755

Télécharger Lire


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

  • Auteur: Michael J. Donahoo
  • ISBN: 0122205316
  • Date de sortie: 2005
  • Collection: Academic Press
  • Total Download: 7315
  • Total Read: 6054

Télécharger Lire


A solid guide and reference to the key elements of SQL and how to use it effectively. SQL 2003 compliant.

Beginning SQL

  • Auteur: Paul Wilton
  • ISBN: 0764577328
  • Date de sortie: 2005-03-04
  • Collection: John Wiley & Sons
  • Total Download: 3206
  • Total Read: 4030

Télécharger Lire


Describes the basics of SQL, database design, and how to create a database using the SQL language.
DMCA - Contact