LearnSQLitein1Day_DefinitiveGuidetoLearn.epub - (EPUB全文下载)

文件大小：3.48 mb。
文件格式：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
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
Chapter 1: Introduction
What is SQLite?
SQLite is a relational database management system. It was designed originally on August 2000. It is an Open source software.
SQLite is very lightweight; it is less than 500Kb size. Unlike other database management systems like SQL Server, or Oracle.
SQLite is not a client-server database management system: it is an in-memory library that you can call it and use it directly, no installation and no configuration required.
A typical SQLite database will be contained on a single file on the computer disk storage with all the database objects (tables, views, triggers, etc.) included on that file, no dedicated server required.
SQLite Performance - Why and When to use SQLite?
When to use SQLite:
Whenever you need a lightweight database, if you are developing an embedded software for devices like televisions, mobile phones, cameras, home electronic ............

书籍插图：

以上为书籍内容预览，如需阅读全文内容请下载EPUB源文件，祝您阅读愉快。