iPhone Database Programming Exercises: SQLite Norman McEntire

ISBN:

Published: March 1st 2010

Kindle Edition

47 pages


Description

iPhone Database Programming Exercises: SQLite  by  Norman McEntire

iPhone Database Programming Exercises: SQLite by Norman McEntire
March 1st 2010 | Kindle Edition | PDF, EPUB, FB2, DjVu, AUDIO, mp3, RTF | 47 pages | ISBN: | 7.41 Mb

This book is about iPhone database programming. It provides a set of hands-on, step-by-step exercises.The goal is to help you learn and master iPhone database programming quickly and easily.Native iPhone OS database applications make use of theMoreThis book is about iPhone database programming. It provides a set of hands-on, step-by-step exercises.The goal is to help you learn and master iPhone database programming quickly and easily.Native iPhone OS database applications make use of the embedded SQLite database engine framework. Hence, learning iPhone database programming is learning how to use the embedded SQLite database engine.The hands-on nature of these exercises is unique.

True learning happens when you take action by performing hands-on exercises. That is what this book is about.Here are the key iPhone Database Programming skills that you will learn:- SQLite Framework (/usr/include/sqlite3.h, libsqlite3.dylib)- SQLite Datatypes (NULL, INTEGER, REAL, TEXT, BLOB)- SQLite Functions (sqlite3_open(), sqlite3_exec(), etc.)- SQL Syntax (CREATE TABLE, INSERT INTO, etc.)- Navigation-based Application (UITableViewController, UITableView, etc.)Is this book for you?

To find out, perform these two steps.Step 1. Scan the Table of Contents, reading the title of each exercise. Each exercise focuses on a specific skill, and if the exercises look interesting to you, then this book is for you.Step 2. Read through the first Exercise, and see if the clear, step-by-step instructions make sense to you.

If so, then this book is for you.If you have access to a Mac OS X system, along with the iPhone OS SDK (Software Developers Kit), then you can read each exercise, and perform each step, using the iPhone OS SDK.However, even if you do not have a Mac OS X system with the iPhone OS SDK, you can still read and follow along in your mind.

When you do have access to a Mac, youll know exactly what to do.CONTENTSAbout This BookExercise 1. Navigation-based AppExercise 2. /usr/include/sqlite3.hExercise 3. sqlite3_libversion()Exercise 4. libsqlite3.dylibExercise 5. sqlite3 DatatypeExercise 6. sqlite3_open()/sqlite3_close()Exercise 7. sqlite3_exec() - CREATE TABLEExercise 8. sqlite3_free()Exercise 9. sqlite3_prepare_v2(), sqlite3_finalize() - SELECTExercise 10. sqlite3_step()Exercise 11. StudentViewController (.h, .m, .xib)Exercise 12.

sqlite3_exec() - INSERTExercise 13. Student (.h, .m)Exercise 14. UITableViewCellExercise 15. sqlite3_exec() - DELETEExercise 16. sqlite3_exec() - UPDATEReference: sqlite3 FrameworkReference: sqlite3 Internal DatatypesReference: sqlite3 FunctionsReference: sqlite3 Error CodesReference: SQL



Enter the sum





Related Archive Books



Related Books


Comments

Comments for "iPhone Database Programming Exercises: SQLite":


alabarda-metal.com

©2014-2015 | DMCA | Contact us