SQLite Database Tutorial Contents

Why Do I Need a Tutor?!
Click here to know

I teach below topics for SQLite Database. The online tutoring via skype desktop sharing is only 30 USD per hour. For booking a class send message or call my whatsapp number: +98 912 490 8372

SQLite Database Complete Course
Lesson	Lesson Subject	pdf file
1	Introduction	lesson 1
2	Installation	lesson 2
3	Commands	lesson 3
4	Syntax	lesson 4
5	Data Type	lesson 5
6	CREATE Database	lesson 6
7	ATTACH Database	lesson 7
8	DETACH Database	lesson 8
9	CREATE Table	lesson 9
10	DROP Table	lesson 10
11	INSERT Query	lesson 11
12	SELECT Query	lesson 12
13	Operators	lesson 13
14	Expressions	lesson 14
15	WHERE Clause	lesson 15
16	AND & OR Clauses	lesson 16
17	UPDATE Query	lesson 17
18	DELETE Query	lesson 18
19	LIKE Clause	lesson 19
20	GLOB Clause	lesson 20
21	LIMIT Clause	lesson 21
22	ORDER By Clause	lesson 22
23	GROUP By Clause	lesson 23
24	HAVING Clause	lesson 24
25	DISTINCT Keyword	lesson 25
26	PRAGMA	lesson 26
27	Constraints	lesson 27
28	JOINS	lesson 28
29	UNIONS Clause	lesson 29
30	NULL Values	lesson 30
31	ALIAS Syntax	lesson 31
32	Triggers	lesson 32
33	Indexes	lesson 33
34	INDEXED By Clause	lesson 34
35	ALTER Command	lesson 35
36	TRUNCATE Command	lesson 36
37	Views	lesson 37
38	Transactions	lesson 38
39	Subqueries	lesson 39
40	AUTOINCREMENT	lesson 40
41	Injection	lesson 41
42	EXPLAIN	lesson 42
43	VACUUM	lesson 43
44	Date & Time	lesson 44
45	Useful Functions	lesson 45
46	SQLite Interfaces → C/C++	lesson 46
47	SQLite Interfaces → Java	lesson 47
48	SQLite Interfaces → Python	lesson 48
49	SQLite Interfaces → PHP	lesson 49
50	SQLite Interfaces → Perl	lesson 50
Stimated Required time for this course is: 40 hours

Hint: The online tutoring via skype desktop sharing is only 30 USD per hour. For booking a class send message or call my whatsapp number: +98 912 490 8372

Why Do I Need a Tutor?! Click here to know

I teach below topics for SQLite Database. The online tutoring via skype desktop sharing is only 30 USD per hour. For booking a class send message or call my whatsapp number: +98 912 490 8372

SQLite Database Complete Course

Lesson

Lesson Subject

pdf file

1

Introduction

2

Installation

3

Commands

4

Syntax

5

Data Type

6

CREATE Database

7

ATTACH Database

8

DETACH Database

9

CREATE Table

10

DROP Table

11

INSERT Query

12

SELECT Query

13

Operators

14

Expressions

15

WHERE Clause

16

AND & OR Clauses

17

UPDATE Query

18

DELETE Query

19

LIKE Clause

20

GLOB Clause

21

LIMIT Clause

22

ORDER By Clause

23

GROUP By Clause

24

HAVING Clause

25

DISTINCT Keyword

26

PRAGMA

27

Constraints

28

JOINS

29

UNIONS Clause

30

NULL Values

31

ALIAS Syntax

32

Triggers

33

Indexes

34

INDEXED By Clause

35

ALTER Command

36

TRUNCATE Command

37

Views

Why Do I Need a Tutor?!
Click here to know