LearnSQLitein1Day_DefinitiveGuidetoLearn.epub

Learn SQLite in 1 Day By Krishna Rungta Copyright 2017 - All Rights Reserved – Krishna Rungta ALL RIGHTS RESERVED. No part of this publication may be reproduced or transmitted in any form whatsoever, electronic, or mechanical, including photocopying, recording, or by any informational storage or retrieval system without express written, dated and signed permission from the author. Table Of Content Chapter 1: Introduction Chapter 2: Create Database 1. CREATE Database 2. CREATE Database in a Specific Location 3. Create database and populate it with tables from a file 4. Backup & Database 5. Drop Database Chapter 3: Create, Alter, Drop Table 1. Create table 2. Drop table 3. Alter table 4. Add columns- Using ALTER TABLE Command 5. Insert value into a table Chapter 4: Primary & Foreign Key 1. SQLite constraint 2. Primary Key 3. Not null constraint 4. DEFAULT Constraint 5. UNIQUE constraint 6. What is a SQLite Foreign KEY? Chapter 5: Data Types 1. Storage Classes 2. Affinity Type 3. Examples of storing data types in SQLite Chapter 6: Select, Where, Limit, Count, Group By, Union 1. Reading data with select 2. WHERE......