Life Coding - SQLite
This is a SQLite lecture provided by Living Coding (Open Tutorials), which will help you get started with the relational database SQLite.
This course is prepared for Basic Learners.
What you will learn!
Concepts and Understanding of SQLite
Database CRUD Basics (Select, Insert, Update, Delete)
Relational databases for beginners,
Easy, small, and lightweight SQLite!
This is an introductory course on SQLite, the world's smallest relational database.
Let's start exploring SQLite, a relational database that is small yet has all the features you need.
What you will learn
- SQLite does not have a database server.
- sqlitestudio is a tool for handling SQLite in a GUI manner.
- SQL is a language for programmatically controlling relational databases.
- A database is a grouping of related tables.
- create table creates a table.
- The primary key is the index that allows the fastest search by identifier.
- If you specify an integer or primary key, it will be autoincremented.
- select queries a table.
- insert adds a row.
- update modifies a row.
- delete removes a row.
What is not covered
- join
- index
- backup
- programming linkage
- foreign key
A good lecture to listen to together
For a smooth understanding, we recommend that you take this course after studying the DATABASE 1 course.
Class Copyright
.jpg)
This lecture follows the CC license and can also be viewed through the following Life Coding Open Tutorials .
I would like to thank Life Coding for sharing good knowledge.
Recommended for
these people!
Who is this course right for?
For those who want to get started with SQLite
Anyone who wants to try out a simple relational database
Need to know before starting?
Basic understanding of databases
Curriculum
All
7 lectures ∙ (43min)
2. Installing SQLite
02:29
4. INSERT
07:56
5. SELECT
11:10
6. UPDATE & DELETE
03:11