| |
|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910781039803321 |
|
|
Autore |
Taylor Allen G |
|
|
Titolo |
SQL for dummies [[electronic resource] /] / by Allen G. Taylor |
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Hoboken, NJ, : Wiley Publishing, 2010 |
|
|
|
|
|
|
|
ISBN |
|
0-470-59315-6 |
1-282-48294-7 |
9786612482946 |
0-470-59314-8 |
|
|
|
|
|
|
|
|
Edizione |
[7th ed.] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (467 p.) |
|
|
|
|
|
|
Collana |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
|
|
Soggetti |
|
SQL (Computer program language) |
Database management |
Computer programming |
Relational databases |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
|
|
|
|
|
Nota di contenuto |
|
SQL For Dummies®, 7th Edition; About the Author; Dedication; Author's Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; Who Should Read This Book?; How This Book Is Organized; Icons Used in This Book; Getting Started; Part I: Basic Concepts; 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 Intranet; Chapter 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 Data; Creating Views; Updating Views; Adding New Data; Updating Existing Data; Transferring Data; Deleting Obsolete Data; Chapter 7: Specifying Values; Values; Value Expressions; Functions; Chapter 8: Using Advanced SQL Value Expressions; CASE Conditional Expressions; CAST Data-Type Conversions; Row Value Expressions; Chapter 9: Zeroing In on the Data You Want; Modifying Clauses; FROM Clauses; WHERE Clauses; Logical Connectives; GROUP BY Clauses; HAVING Clauses; ORDER BY Clauses |
Chapter 10: Using Relational Operators UNION; INTERSECT; EXCEPT; Various Joins; ON versus WHERE; Chapter 11: Delving Deep with Nested Queries; What Subqueries Do; Chapter 12: 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 13: Providing Database Security; The SQL Data Control Language; User 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 14: Protecting Data; Threats to Data Integrity; Reducing Vulnerability to Data Corruption; Constraints Within Transactions; Chapter 15: Using SQL within Applications; SQL in an Application; Hooking SQL into Procedural Languages; Part V: Taking SQL to the Real World; Chapter 16: Accessing Data with ODBC and JDBC; ODBC; ODBC in a Client/Server Environment; ODBC and the Internet; ODBC and an Intranet; JDBC; Chapter 17: Operating on XML Data with SQL; How XML Relates to SQL; The XML Data Type; Mapping SQL to XML and XML to SQL |
SQL Functions That Operate on XML Data |
|
|
|
|
|
|
Sommario/riassunto |
|
Learn SQL the fun and easy way - no programming experience needed! SQL For Dummies, 7th Edition, shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. This book covers the core features of the SQL language. Topics covered include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database. This edition will be revised to reflect the new enhancements of SQL/XML:2008. The latest update of the perennial bestselling SQL For |
|
|
|
|
|
|
|
| |