SQLite Database for Android - Full Course

Learn how to use an SQLite database in Android Studio.

This tutorial shows every step of programming a demo Android application that uses an SQLlite local database. You will learn how to create an SQLite local database on the Android device, configure new tables with the onCreate method, setup the columns and data types, extend the SQLiteHelper class, create CRUD methods in a DAO (Data Access Object) class, display results on a listview, and more.

--

[brunoribeiro]

8:38 - Layout
18:20 - Data Model
22:02 - Button Click Listeners
32:07 - SQLite Open Helper Class
40:58 - Create New Tables with onCreate Method
58:25 - SELECT * FROM table
1:12:00 - Set Data In a ListView
1:19:37 - Delete a Record

[burakcanduzcan]

44:20 "Refactor -> Extract" is now called "Refactor -> Introduce Constant"

[VikSintus]

so many clever people on this planet, but not so many be able to share or deliver their knowledge to others like this one, thank you, sir

[ronanlarkin]

Normally I spend my time rifling through 10 minute videos but this was well worth taking the time to sit down and watch in full.

Thanks so much! Very helpful!

[brandonmchugh]

This is amazing. I've been trying to figure out SQL databases but all other tutorials have been lackluster and confusing. This is the first one that has made sense. Thank you!!!

[jothamithagu]

I've just completed my 19min and all works perfect.
I'll watch & follow along this vid repeatedly for 3 times and believe you me, I'll build my first Booking app from this course.

Lots of appreciation from Kenya...

You are a great tutor...👏👏👏👏👏👏👏👏👏

[fwoggr]

Went from nothing to everything in an incredibly comprehensive and cohesive manner. Incredible lecture even today; Thank you!

[coltjr]

Came here to learn about SQLite, and learned about a lot of cool features for refactoring and debugging in Android Studio. Great teacher and great video!

[ajieewin]

9:06 Part I - Layout
18:59 Part II - Data Model
22:35 Part III - Button Click Listeners
32:36 Part IV - SQLite Open Helper Class
41:27 Part V - Create New Tables with the OnCreate Method
58:54 Part VI - Pull Data from Database (Select * From Table)
1:12:31 Part VII - Set Data in a ListView
1:20:07 Part VIII - Delete a Record
1:26:46 Challenge

[MrStickmanish]

Great teacher and tutorial! One of the very few that don't rush things and show you exactly where you are in the code and why you are doing something. I actually laughed with voice on the context (this) part xD Even "funny" videos only make me blow air out of my nose but this was good! Thank you!

[tomm-_-]

If you are reading this God bless you and have a wonderful day and stay safe ❤️🥰

[黄驿淙]

Wonderful. Best teacher I've ever seen on YouTube.

[KASalgado]

Excellent tutorial. It has a very good focus in Code Standards like no other videos. Good job. Thanks.

[theguyf]

If you experience the db is not in the same path, you can use this code to get the right path to the db in the console.
String dbPath =
System.out.println(dbPath); . Great video thx!

[alwa]

Thank you for all the quality content you produce. You probably contributed more than my teachers toward obtaining my degree.

[siomarapantarotto]

What a great teacher. I loved this tutorial ❤ Thanks a lot, Professor Sluiter!

[dimitrigeorgoudakis]

Hey guys, first of all I would like to say that it was a very intuitive video. Thank you. Secondly, I did everything according to the video but the app crashed (probably when entering data into the database) Did anyone else experience this ?

[wkalou]

Exclusive video that helped to understand where other videos failed

Good job
GOD bless

[YuGan-lmce]

I am so glad that I found this video, the best teacher I found so far!

[jesusribeiro]

Commenting so I can get back to it tomorrow. ( 58:47 ) Awesome tutorial so far!