Inside the Symbian SQL : a mobile developer's guide to SQLite / lead authors, Ivan Litovski with Richard Maynard with James Aley ... [et al.].

Format:

Book

Author/Creator:

Litovski, Ivan.

Contributor:

Maynard, Richard, 1973-

Language:

English

Subjects (All):

Database management.

Mobile computing.

Symbian SQL.

Symbian OS (Computer file).

Physical Description:

1 online resource (434 p.)

Edition:

1st edition

Place of Publication:

Hoboken, N.J. : John Wiley & Sons, 2010.

Language Note:

English

System Details:

text file

Summary:

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 Structured Query Language (SQL) tutorial. Inside Symbian SQL also provides a detailed overview of the Symbian SQL APIs. From the outset, you will "get your hands dirty" writing Symbian SQL code. The book includes snippets and examples that application developers can immediately put to us

Contents:

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

Notes:

Description based upon print version of record.

Includes bibliographical references and index.

ISBN:

9786612686702

9781282686700

1282686704

9780470744758

0470744758

OCLC:

593335572