SQL all-in-one desk reference for dummies / by Allen G. Taylor.
Material type:
TextPublication details: Hoboken, NJ : Wiley Pub., 2007.Description: xxxii, 684 p. : ill. ; 24 cmISBN: - 9780470119280
- QA76.73 . T387 2007.
| Item type | Current library | Call number | Copy number | Status | Barcode | |
|---|---|---|---|---|---|---|
| Books | Library First Floor | QA76.73 . T387 2007. (Browse shelf(Opens below)) | 1 | Available | 11344 |
Browsing Library shelves, Shelving location: First Floor Close shelf browser (Hides shelf browser)
| No cover image available | ||||||||
| QA76.73.S67 M428 2002 SQL:1999 : understanding relational language components / | QA76.73.S67 S87 2013 PHP, MySQL, JavaScript & HTML5 all-in-one for dummies / | QA76.73.S67 T39 2011 SQL all-in-one for dummies / | QA76.73 . T387 2007. SQL all-in-one desk reference for dummies / | QA76.754 .G653 2003 .Net System Management Services / | QA76.754 .S48 1996 Software Architecture : Perspectives on an Emerging Discipline / | QA76.754 .T397 2010 Software architecture : foundations, theory, and practice / |
Introduction. Book I: SQL Concepts. Chapter 1: Relational Database Basics. Chapter 2: Modeling a System. Chapter 3: SQL Overview. Chapter 4: SQL and the Relational Model. Chapter 5: The Major Components of SQL. Chapter 6: SQL Characteristics. Book II: Relational Database Development. Chapter 1: System Development Overview. Chapter 2: Building a Database Model. Chapter 3: Balancing Performance and Correctness. Chapter 4: Creating a Database with SQL. Book III: SQL Queries. Chapter 1: Values, Variables, Functions, and Expressions. Chapter 2: SELECT Statements and Modifying Clauses. Chapter 3: Querying Multiple Tables with Subqueries. Chapter 4: Querying Multiple Tables with Relational Operators. Book IV: Data Security. Chapter 1: Protecting Against Hardware Failure and External Threats. Chapter 2: Protecting Against User Errors and Conflicts. Chapter 3: Assigning Access Privileges. Chapter 4: Error Handling. Book V: SQL and Programming. Chapter 1: Database Development Environments. Chapter 2: Interfacing SQL to a Procedural Language. Chapter 3: Using SQL in an Application Program. Chapter 4: Designing a Sample Application. Chapter 5: Building a Sample Application. Chapter 6: SQL's Procedural Capabilities. Chapter 7: Connecting to a Remote Database. Book VI: SQL and XML. Chapter 1: XML/SQL Basics. Chapter 2: Storing XML Data in SQL Tables. Chapter 3: Retrieving Data from XML Documents. Book VII: Database Tuning Overview. Chapter 1: Tuning the Database. Chapter 2: Tuning the Environment. Chapter 3: Finding and Eliminating Bottlenecks. Book VIII: Appendixes. Appendix A: SQL:2003 Reserved Words. Appendix B: Glossary. Index.
SQL is the international standard language for creating and maintaining relational databases. This book is a compendium of information about SQL and relational database design, development, and maintenance. The nine mini books cover the full spectrum of issues that arise in building, using, and maintaining relational database systems. The book include - Book I: SQL Concepts, Book II: Relational Database Development, Book III: SQL Queries, Book IV: Data Security, Book V: SQL and Programming, Book VI: SQL and XML, Book VII: Database Tuning Overview, and, Book VIII: Appendixes.
There are no comments on this title.