The Resource SQL for dummies, by Allen G. Taylor
SQL for dummies, by Allen G. Taylor
Resource Information
The item SQL for dummies, by Allen G. Taylor represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Evansville Vanderburgh Public Library.This item is available to borrow from all library branches.
Resource Information
The item SQL for dummies, by Allen G. Taylor represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Evansville Vanderburgh Public Library.
This item is available to borrow from all library branches.
- Summary
- Uncover the secrets of SQL and start building better relational databases today!This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it. Includes new enhancements of SQL:2011, including temporal data functionality which a
- Language
- eng
- Edition
- Eighth edition.
- Extent
- 1 online resource
- Note
-
- Includes index
- ODBC and the Internet
- Contents
-
- Table of Contents; Introduction; About This Book; Who Should Read This Book?; Icons Used in This Book; Where to Go from Here; Part I: Getting Started with SQL; Chapter 1: Relational Database Fundamentals; Keeping Track of Things; What Is a Database?; Database Size and Complexity; What Is a Database Management System?; Flat Files; Database Models; Database Design Considerations; Chapter 2: SQL Fundamentals; What SQL Is and Isn't; A (Very) Little History; SQL Statements; Reserved Words; Data Types; Null Values; Constraints; Using SQL in a Client/Server System
- Using SQL on the Internet or an IntranetChapter 3: The Components of SQL; Data Definition Language; Data Manipulation Language; Data Control Language; Part II: Using SQL to Build Databases; Chapter 4: Building and Maintaining a Simple Database Structure; Using a RAD Tool to Build a Simple Database; Building POWER with SQL's DDL; Portability Considerations; Chapter 5: Building a Multitable Relational Database; Designing a Database; Working with Indexes; Maintaining Data Integrity; Normalizing the Database; Part III: Storing and Retrieving Data; Chapter 6: Manipulating Database Data
- Retrieving DataCreating Views; Updating Views; Adding New Data; Updating Existing Data; Transferring Data; Deleting Obsolete Data; Chapter 7: Handling Temporal Data; Understanding Times and Periods in SQL: 2011; Working with Application-Time Period Tables; Working with System-Versioned Tables; Tracking Even More Time Data with Bitemporal Tables; Chapter 8: Specifying Values; Values; Value Expressions; Functions; Chapter 9: Using Advanced SQL Value Expressions; CASE Conditional Expressions; CAST Data-Type Conversions; Row Value Expressions; Chapter 10: Zeroing In on the Data You Want
- Modifying ClausesFROM Clauses; WHERE Clauses; Logical Connectives; GROUP BY Clauses; HAVING Clauses; ORDER BY Clauses; Limited FETCH; Peering through a Window to Create a Result Set; Chapter 11: Using Relational Operators; UNION; INTERSECT; EXCEPT; Join Operators; ON versus WHERE; Chapter 12: Delving Deep with Nested Queries; What Subqueries Do; Chapter 13: Recursive Queries; What Is Recursion?; What Is a Recursive Query?; Where Might You Use a Recursive Query?; Where Else Might You Use a Recursive Query?; Part IV: Controlling Operations; Chapter 14: Providing Database Security
- The SQL Data Control LanguageUser Access Levels; Granting Privileges to Users; Granting Privileges across Levels; Granting the Power to Grant Privileges; Taking Privileges Away; Using GRANT and REVOKE Together to Save Time and Effort; Chapter 15: Protecting Data; Threats to Data Integrity; Reducing Vulnerability to Data Corruption; Constraints Within Transactions; Chapter 16: Using SQL within Applications; SQL in an Application; Hooking SQL into Procedural Languages; Part V: Taking SQL to the Real World; Chapter 17: Accessing Data with ODBC and JDBC; ODBC; ODBC in a Client/Server Environment
- Isbn
- 9781118657188
- Label
- SQL for dummies
- Title
- SQL for dummies
- Statement of responsibility
- by Allen G. Taylor
- Language
- eng
- Summary
- Uncover the secrets of SQL and start building better relational databases today!This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it. Includes new enhancements of SQL:2011, including temporal data functionality which a
- Cataloging source
- EBLCP
- http://library.link/vocab/creatorName
- Taylor, Allen G
- Dewey number
-
- 005.75/85
- 005.7585
- Illustrations
- illustrations
- Index
- index present
- LC call number
- QA76.73.S67
- Literary form
- non fiction
- Nature of contents
- dictionaries
- Series statement
- For dummies
- http://library.link/vocab/subjectName
-
- Computer programming
- Database management
- Relational databases
- SQL (Computer program language)
- SQL (Computer program language)
- Database management
- Computer programming
- Label
- SQL for dummies, by Allen G. Taylor
- Note
-
- Includes index
- ODBC and the Internet
- Carrier category
- online resource
- Carrier category code
-
- cr
- Carrier MARC source
- rdacarrier.
- Content category
- text
- Content type code
-
- txt
- Content type MARC source
- rdacontent.
- Contents
-
- Table of Contents; Introduction; About This Book; Who Should Read This Book?; Icons Used in This Book; Where to Go from Here; Part I: Getting Started with SQL; Chapter 1: Relational Database Fundamentals; Keeping Track of Things; What Is a Database?; Database Size and Complexity; What Is a Database Management System?; Flat Files; Database Models; Database Design Considerations; Chapter 2: SQL Fundamentals; What SQL Is and Isn't; A (Very) Little History; SQL Statements; Reserved Words; Data Types; Null Values; Constraints; Using SQL in a Client/Server System
- Using SQL on the Internet or an IntranetChapter 3: The Components of SQL; Data Definition Language; Data Manipulation Language; Data Control Language; Part II: Using SQL to Build Databases; Chapter 4: Building and Maintaining a Simple Database Structure; Using a RAD Tool to Build a Simple Database; Building POWER with SQL's DDL; Portability Considerations; Chapter 5: Building a Multitable Relational Database; Designing a Database; Working with Indexes; Maintaining Data Integrity; Normalizing the Database; Part III: Storing and Retrieving Data; Chapter 6: Manipulating Database Data
- Retrieving DataCreating Views; Updating Views; Adding New Data; Updating Existing Data; Transferring Data; Deleting Obsolete Data; Chapter 7: Handling Temporal Data; Understanding Times and Periods in SQL: 2011; Working with Application-Time Period Tables; Working with System-Versioned Tables; Tracking Even More Time Data with Bitemporal Tables; Chapter 8: Specifying Values; Values; Value Expressions; Functions; Chapter 9: Using Advanced SQL Value Expressions; CASE Conditional Expressions; CAST Data-Type Conversions; Row Value Expressions; Chapter 10: Zeroing In on the Data You Want
- Modifying ClausesFROM Clauses; WHERE Clauses; Logical Connectives; GROUP BY Clauses; HAVING Clauses; ORDER BY Clauses; Limited FETCH; Peering through a Window to Create a Result Set; Chapter 11: Using Relational Operators; UNION; INTERSECT; EXCEPT; Join Operators; ON versus WHERE; Chapter 12: Delving Deep with Nested Queries; What Subqueries Do; Chapter 13: Recursive Queries; What Is Recursion?; What Is a Recursive Query?; Where Might You Use a Recursive Query?; Where Else Might You Use a Recursive Query?; Part IV: Controlling Operations; Chapter 14: Providing Database Security
- The SQL Data Control LanguageUser Access Levels; Granting Privileges to Users; Granting Privileges across Levels; Granting the Power to Grant Privileges; Taking Privileges Away; Using GRANT and REVOKE Together to Save Time and Effort; Chapter 15: Protecting Data; Threats to Data Integrity; Reducing Vulnerability to Data Corruption; Constraints Within Transactions; Chapter 16: Using SQL within Applications; SQL in an Application; Hooking SQL into Procedural Languages; Part V: Taking SQL to the Real World; Chapter 17: Accessing Data with ODBC and JDBC; ODBC; ODBC in a Client/Server Environment
- Control code
- ocn855504594
- Dimensions
- unknown
- Edition
- Eighth edition.
- Extent
- 1 online resource
- Form of item
- online
- Isbn
- 9781118657188
- Isbn Type
- (electronic bk.)
- Media category
- computer
- Media MARC source
- rdamedia.
- Media type code
-
- c
- Other physical details
- illustrations.
- Specific material designation
- remote
- Stock number
- B4625823-D3C1-46D9-8691-CD34FD55DBC2
- Label
- SQL for dummies, by Allen G. Taylor
- Note
-
- Includes index
- ODBC and the Internet
- Carrier category
- online resource
- Carrier category code
-
- cr
- Carrier MARC source
- rdacarrier.
- Content category
- text
- Content type code
-
- txt
- Content type MARC source
- rdacontent.
- Contents
-
- Table of Contents; Introduction; About This Book; Who Should Read This Book?; Icons Used in This Book; Where to Go from Here; Part I: Getting Started with SQL; Chapter 1: Relational Database Fundamentals; Keeping Track of Things; What Is a Database?; Database Size and Complexity; What Is a Database Management System?; Flat Files; Database Models; Database Design Considerations; Chapter 2: SQL Fundamentals; What SQL Is and Isn't; A (Very) Little History; SQL Statements; Reserved Words; Data Types; Null Values; Constraints; Using SQL in a Client/Server System
- Using SQL on the Internet or an IntranetChapter 3: The Components of SQL; Data Definition Language; Data Manipulation Language; Data Control Language; Part II: Using SQL to Build Databases; Chapter 4: Building and Maintaining a Simple Database Structure; Using a RAD Tool to Build a Simple Database; Building POWER with SQL's DDL; Portability Considerations; Chapter 5: Building a Multitable Relational Database; Designing a Database; Working with Indexes; Maintaining Data Integrity; Normalizing the Database; Part III: Storing and Retrieving Data; Chapter 6: Manipulating Database Data
- Retrieving DataCreating Views; Updating Views; Adding New Data; Updating Existing Data; Transferring Data; Deleting Obsolete Data; Chapter 7: Handling Temporal Data; Understanding Times and Periods in SQL: 2011; Working with Application-Time Period Tables; Working with System-Versioned Tables; Tracking Even More Time Data with Bitemporal Tables; Chapter 8: Specifying Values; Values; Value Expressions; Functions; Chapter 9: Using Advanced SQL Value Expressions; CASE Conditional Expressions; CAST Data-Type Conversions; Row Value Expressions; Chapter 10: Zeroing In on the Data You Want
- Modifying ClausesFROM Clauses; WHERE Clauses; Logical Connectives; GROUP BY Clauses; HAVING Clauses; ORDER BY Clauses; Limited FETCH; Peering through a Window to Create a Result Set; Chapter 11: Using Relational Operators; UNION; INTERSECT; EXCEPT; Join Operators; ON versus WHERE; Chapter 12: Delving Deep with Nested Queries; What Subqueries Do; Chapter 13: Recursive Queries; What Is Recursion?; What Is a Recursive Query?; Where Might You Use a Recursive Query?; Where Else Might You Use a Recursive Query?; Part IV: Controlling Operations; Chapter 14: Providing Database Security
- The SQL Data Control LanguageUser Access Levels; Granting Privileges to Users; Granting Privileges across Levels; Granting the Power to Grant Privileges; Taking Privileges Away; Using GRANT and REVOKE Together to Save Time and Effort; Chapter 15: Protecting Data; Threats to Data Integrity; Reducing Vulnerability to Data Corruption; Constraints Within Transactions; Chapter 16: Using SQL within Applications; SQL in an Application; Hooking SQL into Procedural Languages; Part V: Taking SQL to the Real World; Chapter 17: Accessing Data with ODBC and JDBC; ODBC; ODBC in a Client/Server Environment
- Control code
- ocn855504594
- Dimensions
- unknown
- Edition
- Eighth edition.
- Extent
- 1 online resource
- Form of item
- online
- Isbn
- 9781118657188
- Isbn Type
- (electronic bk.)
- Media category
- computer
- Media MARC source
- rdamedia.
- Media type code
-
- c
- Other physical details
- illustrations.
- Specific material designation
- remote
- Stock number
- B4625823-D3C1-46D9-8691-CD34FD55DBC2
Library Locations
-
Central LibraryBorrow it200 SE Martin Luther King Jr. Blvd., Evansville, IN, 47713, US37.971461 -87.565988
-
-
-
-
-
-
-
Library Links
Embed
Settings
Select options that apply then copy and paste the RDF/HTML data fragment to include in your application
Embed this data in a secure (HTTPS) page:
Layout options:
Include data citation:
<div class="citation" vocab="http://schema.org/"><i class="fa fa-external-link-square fa-fw"></i> Data from <span resource="http://link.evpl.org/portal/SQL-for-dummies-by-Allen-G.-Taylor/oOL9TsttPoo/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.evpl.org/portal/SQL-for-dummies-by-Allen-G.-Taylor/oOL9TsttPoo/">SQL for dummies, by Allen G. Taylor</a></span> - <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.evpl.org/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.evpl.org/">Evansville Vanderburgh Public Library</a></span></span></span></span></div>
Note: Adjust the width and height settings defined in the RDF/HTML code fragment to best match your requirements
Preview
Cite Data - Experimental
Data Citation of the Item SQL for dummies, by Allen G. Taylor
Copy and paste the following RDF/HTML data fragment to cite this resource
<div class="citation" vocab="http://schema.org/"><i class="fa fa-external-link-square fa-fw"></i> Data from <span resource="http://link.evpl.org/portal/SQL-for-dummies-by-Allen-G.-Taylor/oOL9TsttPoo/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.evpl.org/portal/SQL-for-dummies-by-Allen-G.-Taylor/oOL9TsttPoo/">SQL for dummies, by Allen G. Taylor</a></span> - <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.evpl.org/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.evpl.org/">Evansville Vanderburgh Public Library</a></span></span></span></span></div>
