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) 2.
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.4 Summary.
3 The Relational Model.
3.1 Background.
3.2 The Structural Component.
3.3 The Integrity Component.
3.4 Normalization.
3.5 The Manipulative Component.
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.2 The Example Database.
4.3 Syntax.
4.4 Creating a Database.
4.5 Querying a Database.
4.6 Modifying Data.
4.7 Data Integrity.
4.8 Transactions.
4.9 Database Administration.
4.10 Summary.
5 Database Concepts.
5.1 Database Types.
5.2 Executing SQL.
5.3 Multi-Client Access.
5.4 Summary.
6 Using Symbian SQL.
6.1 The Database Connection Class.
6.2 The Prepared Statement Class.
6.3 Working with Variable-Length Data Objects.
6.4 The Scalar Query Class.
6.5 Security Policies.
6.6 Summary.
7 SQLite Internals on Symbian.
7.1 Why SQLite Is Right for Symbian.
7.2 The SQLite Modules.
7.3 SQLite Configuration Options.
7.4 SQLite Optimizations on Symbian OS.
7.5 Summary.
8 Performance Tuning.
8.1 Design and Development Considerations.
8.2 An Introduction to Optimization.
8.3 Optimizing Applications.
8.4 Symbian SQL Optimization Tips.
8.5 Summary.
9 Using Symbian SQL: Three Case Studies.
9.1 Contacts Model.
9.2 Columbo Search Service.
9.3 Wikipedia Demo Application.
9.4 Summary.
Appendix A Troubleshooting.
Appendix B SDB Database Creation Tool.
Appendix C Symbian SQL Error Codes.
References.
Index.
