Normal view MARC view ISBD view

SQL for dummies / by Allen G. Taylor

By: Taylor, Allen G.
Publisher: Hoboken, N.J. : Wiley ; 2010Edition: 7th ed.Description: xvi, 440 p. : ill. ; 24 cm.ISBN: 9780470557419; 0470557419 .Subject(s): Databases | Computer programming | Microsoft access | Information technologyOnline resources: Download as an eBook
Contents:
BASIC CONCEPTS : Relational database fundamentals -- SQL fundamentals -- The components of SQL. USING SQL TO BUILD DATABASES : Building and maintaining a simple database structure -- Building a multitable relational database. STORING AND RETRIEVING DATA : Manipulating database data -- Specifying values -- Using advanced SQL value expressions -- Zeroing in on the data you want -- Using relational operators -- Delving deep with nested queries -- Recursive queries. CONTROLLING OPERATIONS : Providing database security -- Protecting data -- Using SQL within applications. TAKING SQL TO THE REAL WORLD : Accessing data with ODBC and JDBC -- Operating on XML data with SQL. ADVANCED TOPICS : Stepping through a dataset with cursors -- Adding procedural capabilities with persistent stored modules -- Handling errors -- Triggers. THE PART OF TENS : Ten common mistakes -- Ten retrieval tips.
Summary: Provides a practical guide on SQL, the industry-standard database query language, so that you can develop and build relational databases. Covers topics such as: how a database management system is structured, building and protecting a database, and making use of database data. Includes tips on using XML data with SQL.
Item type Home library Call number Status Notes Date due Barcode Item reserves
EBook EBook International
ProQuest eBook (Browse shelf) eBook Available as an ebook here
Book Book New Zealand
276 SQL (Browse shelf) Not for loan CA005468
Total reserves: 1

BASIC CONCEPTS : Relational database fundamentals -- SQL fundamentals -- The components of SQL. USING SQL TO BUILD DATABASES : Building and maintaining a simple database structure -- Building a multitable relational database. STORING AND RETRIEVING DATA : Manipulating database data -- Specifying values -- Using advanced SQL value expressions -- Zeroing in on the data you want -- Using relational operators -- Delving deep with nested queries -- Recursive queries. CONTROLLING OPERATIONS : Providing database security -- Protecting data -- Using SQL within applications. TAKING SQL TO THE REAL WORLD : Accessing data with ODBC and JDBC -- Operating on XML data with SQL. ADVANCED TOPICS : Stepping through a dataset with cursors -- Adding procedural capabilities with persistent stored modules -- Handling errors -- Triggers. THE PART OF TENS : Ten common mistakes -- Ten retrieval tips.

Provides a practical guide on SQL, the industry-standard database query language, so that you can develop and build relational databases. Covers topics such as: how a database management system is structured, building and protecting a database, and making use of database data. Includes tips on using XML data with SQL.

© 2017 Chartered Accountants Australia and New Zealand ABN 50 084 642 571 (CA ANZ).
Formed in Australia. Members of CA ANZ are not liable for the debts and liabilities of CA ANZ

Powered by Koha

Powered by Koha