Inside the Symbian SQL a mobile developer's guide to SQLite
This is the definitive guide for Symbian C++ developers looking to use Symbian SQL in applications or system software. Since Symbian SQL and SQLite are relatively new additions to the Symbian platform, Inside Symbian SQL begins with an introduction to database theory and concepts, including a Struct...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Hoboken, N.J. :
John Wiley & Sons
2010.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628241206719 |
Tabla de Contenidos:
- Inside Symbian SQL; Contents; Foreword by Richard Hipp; Foreword by Chris Dudding; Author Biographies; Author's Acknowledgments; Symbian Acknowledgments; Publisher's Acknowledgements; 1 Introduction; 1.1 Where Should You Start?; 1.2 Symbian Terminology and Version Numbering; 1.3 The Relational Model and the Structured Query Language (SQL); 1.4 What Is Symbian SQL?; 1.5 A Well-Oiled Machine; 1.6 Tools and Troubleshooting; 1.7 Further Reading and Resources; 2 Getting Started; 2.1 Where to Get Symbian SQL; 2.2 Overview of Symbian SQL APIs; 2.3 First Database Example; 2.3.1 Project Setup
- 2.3.2 Creating a Database2.3.3 Creating a Table; 2.3.4 Creating an Index; 2.3.5 Inserting Records; 2.3.6 Selecting Records; 2.3.7 Updating a Record; 2.3.8 Updating Records Using Column Binding and Streaming; 2.3.9 Deleting a Record; 2.3.10 Closing a Database; 2.4 Summary; 3 The Relational Model; 3.1 Background; 3.1.1 The Three Components; 3.1.2 SQL and the Relational Model; 3.2 The Structural Component; 3.2.1 The Information Principle; 3.2.2 The Sanctity of the Logical Level; 3.2.3 The Anatomy of the Logical Level; 3.2.4 Tuples; 3.2.5 Relations; 3.2.6 Tables: Relation Variables
- 3.2.7 Views: Virtual Tables3.2.8 The System Catalog; 3.3 The Integrity Component; 3.3.1 Primary Keys; 3.3.2 Foreign Keys; 3.3.3 Constraints; 3.3.4 Null Values; 3.4 Normalization; 3.4.1 Normal Forms; 3.4.2 First Normal Form; 3.4.3 Functional Dependencies; 3.4.4 Second Normal Form; 3.4.5 Third Normal Form; 3.5 The Manipulative Component; 3.5.1 Relational Algebra and Calculus; 3.5.2 The Relational Query Language; 3.5.3 The Advent of SQL; 3.6 The Meaning of Relational; 3.7 Summary; 4 Everything You Ever Wanted to Know about SQL but Were Afraid to Ask; 4.1 The Relational Model
- 4.1.1 Query Languages4.1.2 Growth of SQL; 4.2 The Example Database; 4.2.1 Installation; 4.2.2 Running the Examples; 4.3 Syntax; 4.3.1 Commands; 4.3.2 Literals; 4.3.3 Keywords and Identifiers; 4.3.4 Comments; 4.4 Creating a Database; 4.4.1 Creating a Table; 4.4.2 Altering a Table; 4.5 Querying a Database; 4.5.1 Relational Operations; 4.5.2 The Operational Pipeline; 4.5.3 Filtering Rows; 4.5.4 Limiting and Ordering; 4.5.5 Functions and Aggregates; 4.5.6 Grouping; 4.5.7 Removing Duplicates; 4.5.8 Joining Tables; 4.5.9 Column Names and Aliases; 4.5.10 Subqueries; 4.5.11 Compound Queries
- 4.5.12 Conditional Results4.5.13 The Thing Called NULL; 4.5.14 Set Operations; 4.6 Modifying Data; 4.6.1 Inserting Records; 4.6.2 Updating Records; 4.6.3 Deleting Records; 4.7 Data Integrity; 4.7.1 Entity Integrity; 4.7.2 Domain Integrity; 4.7.3 Storage Classes; 4.7.4 Manifest Typing; 4.7.5 Type Affinity; 4.8 Transactions; 4.8.1 Transaction Scope; 4.8.2 Conflict Resolution; 4.8.3 Transaction Types; 4.9 Database Administration; 4.9.1 Views; 4.9.2 Indexes; 4.9.3 Triggers; 4.9.4 Attaching Databases; 4.9.5 Cleaning Databases; 4.9.6 The System Catalog; 4.9.7 Viewing Query Plans; 4.10 Summary
- 5 Database Concepts
