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
7:49
FREE

Setup and Environment.mp4

Video
9:44

Create Tables.mp4

Video
6:30

Insert into tables Basic Query.mp4

Video
9:31
FREE

SQLite commands.mp4

Video
11:25

Data types.mp4

Video
9:33

Date in SQLite.mp4

Video
12:42

Constraints.mp4

Video
9:25

Update and Delete commands Alter tables.mp4

Video
7:2

First Challenge.mp4

Video
5:37

Advanced Query.mp4

Video
8:9

Joins.mp4

Video
13:22

Sub queries.mp4

Video
8:28

Functions

Video
8:9

Views.mp4

Video
8:33

Second Challenge.mp4

Video
9:46

Group by And Having Clauses.mp4

Video
5:46

Transactions.mp4

Video
5:13

Triggers.mp4

Video
14:3

Conditions Create your own Constraints.mp4

Video
8:21

Create Read and Write views.mp4

Video
13:9

Foreign key constraints.mp4

Video
11:19

Leftovers.mp4

Video
6:36

SQLiteOpenHelper Class.mp4

Video
13:59
FREE

Query the database in Android.mp4

Video
27:18

Course Instructor

tutor image

MYB

67 Courses   •   95 Students