SQL all-in-one / by Allen G. Taylor
Book | John Wiley & Sons, Inc. | 2019 | 3rd edition.
Available at Gateway-Racine Campus New Books Display (QA 76.73 S6.7 T3.88 2019)

Additional actions:

close
see all

Items

Location Call No. Status
Gateway-Racine Campus New Books Display QA 76.73 S6.7 T3.88 2019 Available
Show fewer items

More Details

Edition
3rd edition.
Description
xxii, 737 pages : illustrations ; 24 cm
Series
Note
Previous edition: 2011.
Includes index.
Contents
Introduction
Book 1: SQL Concepts
CHAPTER 1: Understanding Relational Databases
CHAPTER 2: Modeling a System
CHAPTER 3: Getting to Know SQL
CHAPTER 4: SQL and the Relational Model
CHAPTER 5: Knowing the Major Components of SQL
CHAPTER 6: Drilling Down to the SQL Nitty-Gritty
Book 2: 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 3: 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 Operatiors
CHAPTER 5: Cursors
Book 4: Data Security
CHAPTER 1: Protecting Against Hardware Failure and Extrenal Threats
CHAPTER 2: Protecting Against User Errors and Conflicts
CHAPTER 3: Assigning Access Privileges
CHAPTER 4: Error Handling
Book 5: 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 an Application
CHAPTER 6: Understanding SQL's Procedural Capabilities
CHAPTER 7: Connecting SQL to a Remote Database
Book 6: SQL, XML, and JSON
CHAPTER 1: Using XML with SQL
CHAPTER 2: Storing XML Data in SQL Tables
CHAPTER 3: Retrieving Data from XML Documents
CHAPTER 4: Using JSON and SQL
Book 7: Database Tuning Overview
CHAPTER 1: Tuning the Database
CHAPTER 2: Tuning the Environment
CHAPTER 3: Finding and Eliminating Bottlenecks
Book 8: Appendices
APPENDIX A: SQL: 2016 Reserved Words
APPENDIX B: Glossary
Summary
"SQL is the internationally recognized standard language for dealing with data in relational databases. Developed by IBM, SQL became an international standard in 1986. The standard was updated in 1989, 1992, 1999, 2003, 2008, 2011, and 2016. It continues to evolve and gain capability. Database vendors continually update their products to incorporate the new features of the ISO/IEC standard. (For the curious out there, ISO is the International Organization for Standardization, and IEC is the International Electrotechnical Commission.) SQL isn't a general-purpose language, such as C++ or Java. Instead, it's strictly designed to deal with data in relational databases." - Introduction, page 1
"This book isn't just about SQL; it's also about how SQL fits into the process of creating and maintaining databases and database applications. In this book, I cover how SQL fits into the larger world of application development and how it handles data coming in from other computers, which may be on the other side of the world or even interplanetary space." - About This Book, page 1
31.00 DPWEB (10-152-4) (10-156-3)
Subject
Added Title
SQL all-in-one desk reference for dummies
SQL all-in-one for dummies
Browse Results
Other Sources:
View in classic catalog View MARC display
Back to top