SQL Anywhere Studio 9 Developer’s Guide

Companion CD includes SQL Anywhere Studio 9 Developer Edition (for Windows), all the code from the examples and full BNF from the book in HTML format! SQL Anywhere Studio 9 Developer’s Guide describes in detail how to administer and program SQL Anywhere, the leading relational database for mobile, distributed, and embedded applications. This book focuses on the various tasks performed during the life cycle of a typical database, such as creating tables and other schema objects, and inserting, selecting, updating, and deleting data. Additional topics include packaging SQL code into procedures, triggers, and events; distributing data across multiple databases using MobiLink; protecting the database from disaster; and tuning for performance. Learn how to create and normalize tables with various data types and constraints; insert and manage data; retrieve data with the SELECT statement; synchronize data with MobiLink; protect your data through the use of logging, backups, and validation; optimize your database using the SQL Anywhere performance tuning tools: request-level logging, Index Consultant, Execution Profiler, and Graphical Plan.