Learn Sqlite In 1 Day
Download Learn Sqlite In 1 Day PDF/ePub or read online books in Mobi eBooks. Click Download or Read Online button to get Learn Sqlite In 1 Day book now. This website allows unlimited access to, at the time of writing, more than 1.5 million titles, including hundreds of thousands of titles in various foreign languages.
Learn SQLite in 1 Day
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
SQLite Tutorial
This SQLite tutorial is for beginners.SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain. This tutorial will give you a quick start with SQLite and make you comfortable with SQLite programmingThis book provides an overview of SQLite and demonstrates how to create a database, tables, insert data, and more...