Learn SQLite in 24 Hours

Alex Nordeen

Bisher keine Bewertungen
0.0

+ Merken

Entdecke diesen und 400.000 weitere Titel mit der Flatrate von Skoobe. Ab 12,99 € im Monat.

Beschreibung zu „Learn SQLite in 24 Hours“

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.


Table Of Content


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


Verlag:

PublishDrive

Veröffentlicht:

2021

Druckseiten:

ca. 63

Sprache:

English

Medientyp:

eBook


Ähnliche Titel wie „Learn SQLite in 24 Hours“

Lesen. Hören. Bücher erleben.

Jetzt kostenlos testen