SQL Bilbe 2nd edition

Name: SQL Bilbe 2nd edition
Author: Alex Kriegel

Specificaties

Paperback, 857 blz. | Engels

Wiley Computing | 2e druk, 2008

ISBN13: 9780470229064

Rubricering

Hoofdrubriek : Computer en informatica

Wiley Computing 2e druk, 2008 9780470229064

Onderdeel van serie Bible (Hungry Minds)

66,22

In winkelwagen

Verwachte levertijd ongeveer 9 werkdagen

Samenvatting

Harness SQL for Oracle(r) 11g, IBM DB2(r), and Microsoft(r) SQL Server(r) 2008

Combining theory with everyday practicality, this definitive volume is packed with up-to-date information, new features, and explanations you need to get the very most out of SQL and its latest standard. The book is unique in that every chapter highlights how the new SQL standard applies to the three major databases, Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008. The result is a comprehensive, useful, and real-world reference for all SQL users, from beginners to experienced developers.

- Learn the basics of SQL and relational databases
- Explore tables, views, sequences, and other database objects
- Examine transactions and locking in multiuser environments
- Review functions mandated by the SQL standard and the three major vendors
- Access metadata information and implement database security
- Go beyond SQL to XML integration, OLAP business intelligence, and more

Companion Web Site:
Find downloadable code examples, a full book description, and more at the publishers site.

Specificaties

ISBN13:9780470229064

Taal:Engels

Bindwijze:paperback

Aantal pagina's:857

Uitgever:Wiley Computing

Druk:2

Hoofdrubriek:IT-management / ICT

Serie:Bible (Hungry Minds)

Inhoudsopgave

U kunt van deze inhoudsopgave een PDF downloaden

Acknowledgements
Introduction

Part 1: SQL Basic concepts and principles
1. SQL and relational database management systems
2. Fundamentals SQL concepts and principles
3. SQL and Types

Part 2: Creating and modifying Database objects
4. Creating RDBMS objects
5. Altering and destroying RDBMS objects

Part 3: Data manipulation and transaction control
6. Data Manipulation Language (DML)
7. Sessions, transaction, and locks

Part 4: Retrieving and transferring data
8. Understanding the SELECT statement
9. Multitable Queries
10. SQL Functions
11. SQL Operators

Part 5: Implementing security using the System Catalog
12. SQL and RDBMS Security
13. The systems catalog and INFORMATION_SCHEMA

Part 6: Beyond SQL: Procedural Programming and Database Access Mechanisms
14. Stored Procedures, Triggers, abnd User-Defined Functions
15. SQL and XML
16. SQL and Procedural Programming
17. The Future of SQL

Appendix A: Accompanying Website
Appendix B: The ACME Sample Database
Appendix C: Basics of Relational Database Design
Appendix D: Installing RDBMS Software
Appendix E: Accessing RDBMS
Appendix F: Installing the ACME Database
Appendix G: SQL Functions
Appendix H: SQL Syntax Reference
Appendix I: SQL-Reserved Keywords
Appendix J: The Other RDBMSs
Appendix K: A Brief Introduction to Number Systems, Boolean Algebra,
And Set Theory

Index