Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
SQL for dummies [[electronic resource] /] / by Allen G. Taylor
| SQL for dummies [[electronic resource] /] / by Allen G. Taylor |
| Autore | Taylor Allen G |
| Edizione | [8th ed.] |
| Pubbl/distr/stampa | Hoboken, NJ, : Wiley |
| Descrizione fisica | 1 online resource (483 p.) |
| Disciplina | 005.756 |
| Collana | --For dummies |
| Soggetto topico |
SQL (Computer program language)
Computer programming Relational databases (Computer program) |
| Soggetto genere / forma | Electronic books. |
| ISBN | 1-118-65718-7 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
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 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 Multi-table 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: 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 Clauses FROM 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 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 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 ODBC and the Internet |
| Record Nr. | UNINA-9910463766503321 |
Taylor Allen G
|
||
| Hoboken, NJ, : Wiley | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
SQL for dummies [[electronic resource] /] / by Allen G. Taylor
| SQL for dummies [[electronic resource] /] / by Allen G. Taylor |
| Autore | Taylor Allen G |
| Edizione | [8th ed.] |
| Pubbl/distr/stampa | Hoboken, NJ, : Wiley |
| Descrizione fisica | 1 online resource (483 p.) |
| Disciplina | 005.756 |
| Collana | --For dummies |
| Soggetto topico |
SQL (Computer program language)
Computer programming Relational databases (Computer program) |
| ISBN | 1-118-65718-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
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 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 Multi-table 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: 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 Clauses FROM 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 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 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 ODBC and the Internet |
| Record Nr. | UNINA-9910787326703321 |
|
Taylor Allen G
|
||
| Hoboken, NJ, : Wiley | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
SQL for dummies / / by Allen G. Taylor
| SQL for dummies / / by Allen G. Taylor |
| Autore | Taylor Allen G |
| Edizione | [8th ed.] |
| Pubbl/distr/stampa | Hoboken, NJ, : Wiley |
| Descrizione fisica | 1 online resource (483 p.) |
| Disciplina |
005.75/85
005.7585 |
| Collana | --For dummies |
| Soggetto topico |
SQL (Computer program language)
Computer programming Relational databases (Computer program) |
| ISBN |
9781118657188
1118657187 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
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 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 Multi-table 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: 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 Clauses FROM 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 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 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 ODBC and the Internet |
| Altri titoli varianti |
--For dummies
For dummies |
| Record Nr. | UNINA-9910973369603321 |
|
Taylor Allen G
|
||
| Hoboken, NJ, : Wiley | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
