Entdecke diesen und 400.000 weitere Titel mit der Flatrate von Skoobe. Ab 12,99 € im Monat.
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