SQLite + Android - Create Database Schema (Book Library App) | Part 1

🏆 My Online Courses
⭐Discount Coupon: LAUNCH-STEVDZA-SAN

🐱‍👤 Wanna become a member? Join!

📸 Instagram

With this video I'm going to start tutorial series for SQLite Database on Android. We are going to create a Book Library application. Our application will have all the necessary functionality which every app with database should have. That includes CRUD, or Create, Read, Update and Delete functions. Also I'm going to teach you how to add Recyclerview and display data from our SQLite database in it. We are going to add some animations as well.

One of the main principles of SQL databases is the schema: a formal declaration of how the database is organized. The schema is reflected in the SQL statements that you use to create your database. You may find it helpful to create a companion class, known as a contract class, which explicitly specifies the layout of your schema in a systematic and self-documenting way.

A contract class is a container for constants that define names for URIs, tables, and columns. The contract class allows you to use the same constants across all the other classes in the same package. This lets you change a column name in one place and have it propagate throughout your code.

[zbien]

This guide litterally saved me on my university's android course!! I couldn't have done it without you!! much love from portugal <3 :)

[fajarfardiansyah]

This Channel its amazing. Easy to understand step by step and the more importantly a short video but covered important thing.

[calebblaze]

Just the vidoe i was looking for. thanks for this great tutorial 🔥

[mirsadhadzic]

Svaka cast, tutorial je za 10! Preporucujem svima.

[dmytroazhdier]

Its great! Thank u, and waiting for the next video :)

[veteranJUGGERNAUT]

THANK YOU FOR THIS AMAZING TUTORIAL. REALLY HELPED ME AT MY INTERNSHIP, LOVE FROM NIGERIA.

[lenerggonzalez]

You are amazing, i found you yesterday and i love and i watch all your videos, you are the man of the movie, BEST

[kyokyo]

how do you setup your project at the start in order to get that?

[tubhtvq]

Thank you i completed my university project with your help

[DiptaSahaCSE]

sir, can you make a video using multiple table communication like, how to use foreign key in SQLite.can you make an demo app where having all the concept about all sqlite features like foreign key, order by, join etc

[leolwin]

Thanks for this tutorial.
Really helpful for me.

[pratikdhargalkar]

Thank You Very Much For Putting This Much Of Hardwork.

[Gandalf]

Greetings ! I have a question. Why do we need to drop table in onUpgrade method, than create the same table in onCreate method ?

[ZeeshanAcademy]

excellent tutorial. very helpful thanks.

[EricBalcon]

Very nice, but how can we retrieve data from a sqlite local database stored in android studio ?

[Effectivebasketball]

Hello, first of all, thank you for your hard work. Second I am new to Android dev. and your tutorials helped me a lot.
At this stage, I have to ask you regarding SQLite vs ROOT. Basically, I work on an app, and I have to implement local DB or save data locally. The question quite simple should I go and deal with SQLite or I rather just go straight to ROOT? without bothering with SQLite understanding and implementations. The reason I have to because I afraid if I do skip SQLite at some point I get in trouble. Would be enough to dedicate my time only for ROOT? Thank you.

[elliotmiller]

Thanks for Nice tutorial, keep most of your tutorials in Java, thank you. :D

[sebastianochoa]

Thanks, this tutorial has been very useful and helper

[pandakaradi]

How to add images also when creating a new book title ?

[KIRUZE]

What version android studio you use in this video?