SQLite Books







 
OSgram.com   >   Shopping   >   Books   >   SQLite
Shop for books about SQLite.

Other web sites about SQLite:Additional pages on this web site, which may be of interest: SQLite is a relational database management system, implemented in a small C library which can be linked directly into programs, and released into the public domain. Although SQLite itself is developed in C, it can be used from a wide variety of programming languages including C, C++, Delphi, Java, Perl, PHP, Python, R, Smalltalk and Tcl.

Here are some books about SQLite ;

Disclosure: Products details and descriptions provided by Amazon.com. Our company may receive a payment if you purchase products from them after following a link from this website.

Using SQLite: Small. Fast. Reliable. Choose Any Three.

By Jay A. Kreibich

Brand: O'Reilly Media
Paperback (530 pages)

Using SQLite: Small. Fast. Reliable. Choose Any Three.
List Price: $49.99*
Lowest New Price: $31.19*
Lowest Used Price: $12.78*
Usually ships in 24 hours*
*(As of 14:46 Pacific 16 Oct 2017 More Info)


Click Here
  • ISBN13: 9780596521189
  • Notes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!
Product Description:

Application developers, take note: databases aren't just for the IS group any more. You can build database-backed applications for the desktop, Web, embedded systems, or operating systems without linking to heavy-duty client-server databases such as Oracle and MySQL. This book shows you how to use SQLite, a small and lightweight relational database engine that you can build directly into your application.

With SQLite, you'll discover how to develop a database-backed application that remains manageable in size and complexity. This book guides you every step of the way. You'll get a crash course in data modeling, become familiar with SQLite's dialect of the SQL database language, and much more.

  • Learn how to maintain localized storage in a single file that requires no configuration
  • Build your own SQLite library or use a precompiled distribution in your application
  • Get a primer on SQL, and learn how to use several language functions and extensions
  • Work with SQLite using a scripting language or a C-based language such as C# or Objective-C
  • Understand the basics of database design, and learn how to transfer what you already know to SQLite
  • Take advantage of virtual tables and modules

"Complex SQL concepts explained clearly."

--D. Richard Hipp, creator of SQLite

Getting Started with SQL: A Hands-On Approach for Beginners

By Thomas Nield

imusti
Released: 2016-02-18
Paperback (134 pages)

Getting Started with SQL: A Hands-On Approach for Beginners
List Price: $33.99*
Lowest New Price: $19.53*
Lowest Used Price: $21.17*
Usually ships in 24 hours*
*(As of 14:46 Pacific 16 Oct 2017 More Info)


Click Here
  • O REILLY
Product Description:

Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you’re a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases.

Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you’ll also discover how to efficiently design and manage databases to meet your needs.

You’ll also learn how to:

  • Explore relational databases, including lightweight and centralized models
  • Use SQLite and SQLiteStudio to create lightweight databases in minutes
  • Query and transform data in meaningful ways by using SELECT, WHERE, GROUP BY, and ORDER BY
  • Join tables to get a more complete view of your business data
  • Build your own tables and centralized databases by using normalized design principles
  • Manage data by learning how to INSERT, DELETE, and UPDATE records

The Definitive Guide to SQLite (Expert's Voice in Open Source)

By Grant Allen

Allen Grant Owens Mike
Paperback (368 pages)

The Definitive Guide to SQLite (Expert s Voice in Open Source)
List Price: $54.99*
Lowest New Price: $42.97*
Lowest Used Price: $30.00*
Usually ships in 24 hours*
*(As of 14:46 Pacific 16 Oct 2017 More Info)


Click Here
  • The Definitive Guide to SQLite
Product Description:

Outside of the world of enterprise computing, there is one database that enables a huge range of software and hardware to flex relational database capabilities, without the baggage and cost of traditional database management systems. That database is SQLite—an embeddable database with an amazingly small footprint, yet able to handle databases of enormous size. SQLite comes equipped with an array of powerful features available through a host of programming and development environments. It is supported by languages such as C, Java, Perl, PHP, Python, Ruby, TCL, and more.

The Definitive Guide to SQLite, Second Edition is devoted to complete coverage of the latest version of this powerful database. It offers a thorough overview of SQLite’s capabilities and APIs. The book also uses SQLite as the basis for helping newcomers make their first foray into database development. In only a short time you can be writing programs as diverse as a server-side browser plug-in or the next great iPhone or Android application!

  • Learn about SQLite extensions for C, Java, Perl, PHP, Python, Ruby, and Tcl.
  • Get solid coverage of SQLite internals.
  • Explore developing iOS (iPhone) and Android applications with SQLite.

SQLite is the solution chosen for thousands of products around the world, from mobile phones and GPS devices to set-top boxes and web browsers. You almost certainly use SQLite every day without even realizing it!

Learn SQLite in 1 Day: Definitive Guide to Learn SQLite for Beginners

By Krishna Rungta

Independently published
Paperback (102 pages)

Learn SQLite in 1 Day: Definitive Guide to Learn SQLite for Beginners
List Price: $9.99*
Lowest New Price: $9.99*
Usually ships in 24 hours*
*(As of 14:46 Pacific 16 Oct 2017 More Info)


Click Here
Product Description:

SQLite is a very lightweight database, with no installation required, zero configuration, and no server required. SQLite is widely used as a database of choice in mobile apps, camera, home electronic devices and other embedded systems.

This book is designed for beginners with little or no prior database experience.

Here is what you will learn:

Chapter 1: Introduction

Chapter 2: Create Database

CREATE Database

CREATE Database in a Specific Location

Create database and populate it with tables from a file

Backup & Database

Drop Database

Chapter 3: Create, Alter, Drop Table

Create table

Drop table

Alter table

Add columns- Using ALTER TABLE Command

Insert value into a table

Chapter 4: Primary & Foreign Key

SQLite constraint

Primary Key

Not null constraint

DEFAULT Constraint

UNIQUE constraint

What is a SQLite Foreign KEY?

Chapter 5: Data Types

Storage Classes

Affinity Type

Examples of storing data types in SQLite

Chapter 6: Select, Where, Limit, Count, Group By, Union

Reading data with select

WHERE

Limiting and Ordering

Group BY

Query & Subquery

Set Operations -UNION,Intersect

Conditional results

Advanced queries

Chapter 7: Joins

Introduction to SQLite JOIN Clause

INNER JOIN

JOIN … USING

NATURAL JOIN

LEFT OUTER JOIN

CROSS JOIN

Chapter 8: INSERT, UPDATE, DELETE

INSERT

Update

Delete

Conflict clause

Chapter 9: Index, Trigger & View

View

Index

Trigger

Chapter 10: SQLite Functions

Finding the LENGTH of a string

UPPER Function and LOWER Function

TRIM Function

TYPEOF Function

SQLite LAST_INSERT_ROWID

SQLite library

User-defined functions

The Definitive Guide to SQLite

By Mike Owens

Apress
Released: 2014-11-05
Paperback (440 pages)

The Definitive Guide to SQLite
List Price: $59.99*
Lowest New Price: $49.49*
Lowest Used Price: $62.15*
Usually ships in 24 hours*
*(As of 14:46 Pacific 16 Oct 2017 More Info)


Click Here
Product Description:
This is the first book to devote complete coverage to the most recent release of the popular embedded open source database SQLite. The book acts as both an ideal tutorial and reference guide. It will help readers to take full advantage of SQLite's features.

Learn SQLite Database - Crash course: All Android phones and iPhones uses SQLite and many mobile apps developed, Google, Skype and DropBox use it directly.

By Sunny Chanday

CreateSpace Independent Publishing Platform
Paperback (166 pages)

Learn SQLite Database - Crash course: All Android phones and iPhones uses SQLite and many mobile apps developed, Google, Skype and DropBox use it directly.
List Price: $39.99*
Lowest New Price: $39.99*
Usually ships in 24 hours*
*(As of 14:46 Pacific 16 Oct 2017 More Info)


Click Here

Using SQLite to Bypass the 2 GB .DBF Filesize Limit

By Whil Hentzen

Hentzenwerke Publishing
Mass Market Paperback (106 pages)

Using SQLite to Bypass the 2 GB .DBF Filesize Limit
List Price: $19.95*
Lowest New Price: $19.95*
Usually ships in 24 hours*
*(As of 14:46 Pacific 16 Oct 2017 More Info)


Click Here
Product Description:
The .DBF file format has been a standard for desktop applications for over 30 years. Pretty much every data-oriented application can read and write to a .DBF file. Back in the day when the format was created, the days of 180 kb floppies, sometime later surpassed by 1.44 MB 3 1/2 inch disks, and, eventually those monster hard disks that held hundreds of or even a thousand megabytes, its 2 GB limit was not a concern.

Even in the mid-2010s, the xBase family of applications are excellent tools for manipulating data. One common use is to import data from other formats, such as text files, and, once stored in a .DBF, slice and dice that data as desired. Over the past decade, though, it's become commonplace to run into data sets exceeding the 2 GB limit. This can happen due to accumulation of data over decades of use of an application or dumps from large SQL databases. Once such a data dump grows larger than two gigabytes, though, dealing with them with the Xbase tools becomes a problem, since they can't be directly imported into a DBF.

What is needed is intermediate data storage that can import a raw text file of any size and then allow the user to slice and dice the data as needed. Enter SQLite. This book will show you how to use SQLite, a fast, free, high-quality database for such intermediate data storage.

The SQL Guide to SQLite

By Rick F. van der Lans

lulu.com
Paperback (542 pages)

The SQL Guide to SQLite
List Price: $42.36*
Lowest New Price: $42.36*
Lowest Used Price: $35.16*
Usually ships in 24 hours*
*(As of 14:46 Pacific 16 Oct 2017 More Info)


Click Here
Product Description:
SQLite is a small, fast, embeddable, SQL-based database server. It is easy to install, needs no management, and is open source. This book describes SQLite in detail. With hundreds of examples, plus a proven approach and structure, the book teaches you how to use SQLite efficiently and effectively. It contains a complete description of the SQL dialect as implemented in SQLite version 3.6. The book can be seen as a tutorial and a reference book. Source code for the numerous SQL examples and exercises included in this book can be downloaded from www.r20.nl.

SQL in 10 Minutes, Sams Teach Yourself (4th Edition)

By Ben Forta

Sams Publishing
Paperback (288 pages)

SQL in 10 Minutes, Sams Teach Yourself (4th Edition)
List Price: $29.99*
Lowest New Price: $16.70*
Lowest Used Price: $14.88*
Usually ships in 24 hours*
*(As of 14:46 Pacific 16 Oct 2017 More Info)


Click Here
  • Sams Publishing
Product Description:

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition

New full-color code examples help you see how SQL statements are structured


Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job.


Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know–starting with simple data retrieval and quickly going on to more complex topics including the use of joins, subqueries, stored procedures, cursors, triggers, and table constraints.


You'll learn methodically, systematically, and simply–in 22 short, quick lessons that will each take only 10 minutes or less to complete.


With the Fourth Edition of this worldwide bestseller, the book has been thoroughly updated, expanded, and improved. Lessons now cover the latest versions of IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, MariaDB, and Apache Open Office Base. And new full-color SQL code listings help the beginner clearly see the elements and structure of the language.

10 minutes is all you need to learn how to...

  • Use the major SQL statements
  • Construct complex SQL statements using multiple clauses and operators
  • Retrieve, sort, and format database contents
  • Pinpoint the data you need using a variety of filtering techniques
  • Use aggregate functions to summarize data
  • Join two or more related tables
  • Insert, update, and delete data
  • Create and alter database tables
  • Work with views, stored procedures, and more
Table of Contents

1 Understanding SQL

2 Retrieving Data

3 Sorting Retrieved Data

4 Filtering Data

5 Advanced Data Filtering

6 Using Wildcard Filtering

7 Creating Calculated Fields

8 Using Data Manipulation Functions

9 Summarizing Data

10 Grouping Data

11 Working with Subqueries

12 Joining Tables

13 Creating Advanced Joins

14 Combining Queries

15 Inserting Data

16 Updating and Deleting Data

17 Creating and Manipulating Tables

18 Using Views

19 Working with Stored Procedures

20 Managing Transaction Processing

21 Using Cursors

22 Understanding Advanced SQL Features

Appendix A: Sample Table Scripts

Appendix B: Working in Popular Applications

Appendix C : SQL Statement Syntax

Appendix D: Using SQL Datatypes

Appendix E: SQL Reserved Words



  Run multiple operating systems on your machine!


 
     
Shopping
 
  Books
   Apache
   BSD
   Eclipse
   Firefox
   GIMP
   GNOME
   GNU
   JBoss
   Linux
   MySQL
   OpenOffice
   Open Source
   Perl
   PHP
   PostgreSQL
   Python
   Ruby
   Security
   Solaris
   SQLite

  Clothing

  Magazines

  Software
 

ATI Echo Server for Linux

News Resources
 
  Companies

  Conferences

  Embedded

  Mobile

  Patents

  Security

  Software

  VoIP
 


 
   
Contact Us   Privacy   Terms Of Use   Advertising/Endorsements Disclosures

Copyright © 2006-2015, Answers 2000 Limited.

Answers 2000 Limited has no opinion about any stories or content of, or views expressed in, any linked news resource or website. Information about companies, organizations, products and services was believed to be correct at the time it was first published on this website, but may out of date by the time you read this website. For current information about any company or organization, readers are advised to check with the applicable company or organization.

Answers 2000 Limited expresses no opinion about any company or organization (including expressing no opinion on any investments in, with, or relating to, any company or organization), product or service. This website is not intended as investment or financial advice.

In Association With Amazon.com
Answers 2000 Limited is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Disclosure: Our company's websites' content (including this website's content) includes advertisements for our own company's websites, products, and services, and for other organization's websites, products, and services. In the case of links to other organization's websites, our company may receive a payment, (1) if you purchase products or services, or (2) if you sign-up for third party offers, after following links from this website. Unless specifically otherwise stated, information about other organization's products and services, is based on information provided by that organization, the product/service vendor, and/or publicly available information - and should not be taken to mean that we have used the product/service in question. Additionally, our company's websites contain some adverts which we are paid to display, but whose content is not selected by us, such as Google AdSense ads. For more detailed information, please see Advertising/Endorsements Disclosures

Our sites use cookies, some of which may already be set on your computer. Use of our site constitutes consent for this. For details, please see Privacy.