dots bg

How To Create and Manage SQLite Databases From Scratch

The course "How To Create and Manage SQLite Databases From Scratch" is designed to teach you how to build and manage databases using SQLite, a lightweight, serverless, and self-contained database engine. The course covers the fundamental steps of creating a database, defining tables, inserting, querying, updating, and deleting data. It also explores advanced topics like indexing, foreign keys, and optimizing queries. Ideal for beginners and intermediate learners, this course focuses on hands-on practice with real-world applications, helping you understand both the technical and practical aspects of database management using SQLite.

Course Instructor MYB

₹999.00

dots bg

Course Overview

Schedule of Classes

Course Curriculum

1 Subject

How To Create and Manage SQLite Databases From Scratch

25 Learning Materials

Video Course

Introduction and Concepts.mp4

Video
00:07:49
FREE

Setup and Environment.mp4

Video
00:09:44

Create Tables.mp4

Video
00:06:30

Insert into tables Basic Query.mp4

Video
00:09:31
FREE

SQLite commands.mp4

Video
00:11:25

Data types.mp4

Video
00:09:33

Date in SQLite.mp4

Video
00:12:42

Constraints.mp4

Video
00:09:25

Update and Delete commands Alter tables.mp4

Video
00:07:02

First Challenge.mp4

Video
00:05:37

Advanced Query.mp4

Video
00:08:09

Joins.mp4

Video
00:13:22

Sub queries.mp4

Video
00:08:28

Functions

Video
00:08:09

Views.mp4

Video
00:08:33

Second Challenge.mp4

Video
00:09:46

Group by And Having Clauses.mp4

Video
00:05:46

Transactions.mp4

Video
00:05:13

Triggers.mp4

Video
00:14:03

Conditions Create your own Constraints.mp4

Video
00:08:21

Create Read and Write views.mp4

Video
00:13:09

Foreign key constraints.mp4

Video
00:11:19

Leftovers.mp4

Video
00:06:36

SQLiteOpenHelper Class.mp4

Video
00:13:59
FREE

Query the database in Android.mp4

Video
00:27:18

Course Instructor

tutor image

MYB

69 Courses   •   96 Students