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.
✏️ Course developed by Shad Sluiter. Check out his KZread channel: / shadsluiter
--
Learn to code for free and get a developer job: www.freecodecamp.org
Read hundreds of articles on programming: freecodecamp.org/news

Пікірлер: 216

  • @brunoribeiro3376
    @brunoribeiro33763 жыл бұрын

    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

  • @habibanwar6592

    @habibanwar6592

    3 жыл бұрын

    Thanks

  • @venkatram3936

    @venkatram3936

    3 жыл бұрын

    Thanks man 👍

  • @whatif6821

    @whatif6821

    3 жыл бұрын

    Thank you very much! I was intimidated by the hour and a half of runtime

  • @thenostalgichani3790

    @thenostalgichani3790

    3 жыл бұрын

    Thanks

  • @audreysheenpula1443

    @audreysheenpula1443

    3 жыл бұрын

    life saver, thank you very much

  • @burakcanduzcan
    @burakcanduzcan3 жыл бұрын

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

  • @definitionsupervillain4583

    @definitionsupervillain4583

    2 жыл бұрын

    also works with 'ctrl + alt + c'

  • @noahbastola9386
    @noahbastola93863 жыл бұрын

    I'm not usually one to comment on videos, but this is by far the best coding teacher I've ever seen on youtube. What I like most is that he shows you how to use the documentation as a guide for development, because no one has an encyclopedic knowledge base of code.

  • @rxtechandtrading

    @rxtechandtrading

    2 жыл бұрын

    Yeah, hes beter than most of the cluster f@$%s out there...BUT. as good as he is, what pisses me off about his tutorials is when he forgets to go into some essential details about the documentation and how different sections of it apply to different SDK versions or API levels

  • @mohamedmire8646

    @mohamedmire8646

    Жыл бұрын

    because this is a university preffossor, not just a freelancer KZreadrs. He's trainined prof.

  • @Kirmeins

    @Kirmeins

    Жыл бұрын

    @@mohamedmire8646 From my experience, a "trained proffessor" is rarely equal to a trained teacher in their pedagogical approach. In fact, most professors have no training at all in pedagogics and tend to just monotonously read some high level facts off of their screen without explaining the base concepts. Sometimes they don't even make and update their slides themselves. And university students are usually expected to learn those basic things in their own time or in tutoriums led by older students. So in other words: this guy is better than most not just on YT because he has both the talent and the wish to teach. :)

  • @brandonmchugh9821
    @brandonmchugh98212 жыл бұрын

    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!!!

  • @ronanlarkin
    @ronanlarkin2 жыл бұрын

    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!

  • @VikSintus
    @VikSintus3 жыл бұрын

    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

  • @attaullahshah6611
    @attaullahshah66112 жыл бұрын

    Hello, feeling lucky to found you. You are teaching so professionally like nothing is vague and the concept is also building. Please keep it up :)

  • @albanmarku6743
    @albanmarku67432 жыл бұрын

    Very good video. Really like how you talk through your thought process when using classes that require inputs and making it clear what the current goal is.

  • @poogaia
    @poogaia Жыл бұрын

    This is the best Android Studio Java tutorial I've seen yet. I'm halfway through developing my first app and I've just learned so much. Boom

  • @KASalgado
    @KASalgado3 жыл бұрын

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

  • @okrimtech
    @okrimtech Жыл бұрын

    Amazing tutorial as always. Your materials helped me tremendously with several of my university classes. Thank you a thousand times!

  • @MrStickmanish
    @MrStickmanish2 жыл бұрын

    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!

  • @jothamithagu7403
    @jothamithagu74039 ай бұрын

    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...👏👏👏👏👏👏👏👏👏

  • @fwogg3r158
    @fwogg3r15829 күн бұрын

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

  • @alwa6648
    @alwa66482 жыл бұрын

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

  • @siomarapantarotto
    @siomarapantarotto Жыл бұрын

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

  • @taniamartinezvillagomez6448
    @taniamartinezvillagomez64482 жыл бұрын

    Thank you very much, your teaching skills are amazing. This is one of the best android tutorials I have ever seen.

  • @ajieewin2398
    @ajieewin23982 жыл бұрын

    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

  • @wizardry-of-science

    @wizardry-of-science

    Жыл бұрын

    This one makes more sense

  • @Tim-chik
    @Tim-chik2 жыл бұрын

    You are a great person. I needed it and I found it! So thankful for your job!!!

  • @xvzf115
    @xvzf1153 жыл бұрын

    Really nice tutorial format. Thank you, very clear explanations!

  • @user-sr4gg2rk9i
    @user-sr4gg2rk9i2 жыл бұрын

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

  • @colt45jr
    @colt45jr3 ай бұрын

    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!

  • @elohimalves
    @elohimalves3 жыл бұрын

    You explain everything you are doing, Excellent Professor!

  • @aivkhairulamirin9004
    @aivkhairulamirin900410 ай бұрын

    Thank you. This tutorial is worth our time. It provides the basic of SQLite with easy-to-follow instructions.

  • @YuGan-lm4ce
    @YuGan-lm4ce Жыл бұрын

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

  • @anand45784
    @anand457842 жыл бұрын

    One of the best video on KZread for android sqlite database..

  • @williamselinder9138
    @williamselinder91382 жыл бұрын

    What a great teacher! All understood, all worked well! Fantastic!!!

  • @wkalou
    @wkalou2 жыл бұрын

    Exclusive video that helped to understand where other videos failed Good job GOD bless

  • @sportscity5487
    @sportscity54872 жыл бұрын

    One of the best formal way to do this task. Thank you..

  • @kojofosuedue3686
    @kojofosuedue36863 жыл бұрын

    Very detailed...i loved every bit of it. Thanks guys

  • @h.r.60
    @h.r.603 жыл бұрын

    Keep up the amazing work my friend!

  • @DagothDaddy
    @DagothDaddy3 жыл бұрын

    I took his class when I attended GCU. He was great.

  • @eddyjaga8899
    @eddyjaga88992 жыл бұрын

    Thank you for your time. It's great and understandable content. Much better than my lecturer 👩‍🏫 👨‍🏫 🧑‍🏫

  • @oniii-chan_
    @oniii-chan_3 жыл бұрын

    WOw! today only I was told in class that we would start sqlite(in python) tomorrow and this appeared I hope this would be helpful for it 🤞🤞

  • @deepakpitaliya8932
    @deepakpitaliya893210 ай бұрын

    Thank you Prof. Sluiter for this excellent tutorial.

  • @poisonshroom64
    @poisonshroom64 Жыл бұрын

    better and more straighforward than my uni teacher, thanks a bunch

  • @snoop3800
    @snoop38003 ай бұрын

    Thanks awesome tutorial, the good thing that you are showing how to use documentation added to that the clear explication

  • @mehdihachimi9624
    @mehdihachimi96242 жыл бұрын

    Awesome tutorial, thank you so much for this!

  • @andrefiord2357
    @andrefiord2357 Жыл бұрын

    Excellent tutorial. A bit incomplete w/o search and update but still extremely informative. Thank you!

  • @patriciarodrigues598
    @patriciarodrigues5983 жыл бұрын

    Great ! Thanks from Brazil!

  • @Kunal-jp8tn
    @Kunal-jp8tn2 жыл бұрын

    Thank you so much for providing such cool valuable content.

  • @Simomajola1
    @Simomajola13 жыл бұрын

    Best Tutorial Ever !!!!!!!!!!!!!!!!!!!!!!!!!!

  • @zekeriemand6336
    @zekeriemand63363 жыл бұрын

    Thank you very much for this video. It helped me a lot.

  • @thejustinfernald
    @thejustinfernald3 жыл бұрын

    Big fan of Professor Sluiter.

  • @akunformalitas
    @akunformalitas2 жыл бұрын

    As a desktop programmer this video helps me so much to switch to android apps.

  • @lioneldynasty
    @lioneldynasty Жыл бұрын

    This tutorial is amazing andget he's really good at teaching

  • @vancheloChanel
    @vancheloChanel3 жыл бұрын

    Very helpful! Thank you

  • @josejayant3127
    @josejayant31273 жыл бұрын

    9:08 Layout 18:51 Data Model 22:34 Button Click Listeners 32:37 SQLite Open Helper Class 41:28 Create New Tables with onCreate Method 58:44 SELECT * FROM table @ - Set Data In a ListView @ - Delete a Record

  • @benukapunchihewa4125
    @benukapunchihewa41252 жыл бұрын

    Thank you very much. Great Video. Looking forward to watch awesome content like this.

  • @theguyf8316
    @theguyf8316 Жыл бұрын

    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 = getDatabasePath("bar_rater.db").getAbsolutePath(); System.out.println(dbPath); . Great video thx!

  • @crimsonblue1455
    @crimsonblue1455 Жыл бұрын

    this guy is good at teaching people. very nice 🤗🤗

  • @qpdbwvwdbqp4730
    @qpdbwvwdbqp47302 жыл бұрын

    Amazing! It was very useful! Thank you so much!

  • @lowblowjimboy
    @lowblowjimboy2 жыл бұрын

    TOP CLASS TEACHER!!! Thank you Sir!

  • @lxdzii
    @lxdzii7 ай бұрын

    Wow, this was a beautiful one!

  • @ashishthaakur45
    @ashishthaakur453 жыл бұрын

    Love you freecodecamp

  • @jesusribeiro9447
    @jesusribeiro94472 жыл бұрын

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

  • @floresjose
    @floresjose Жыл бұрын

    now I understand a lot of fundamental things, thanks a lot, by the way: You rock!

  • @bishnubhusal5999
    @bishnubhusal5999 Жыл бұрын

    Best explanation ever.

  • @returnMarcco
    @returnMarcco Жыл бұрын

    Thanks very much, awesome tutorial

  • @solomonjara9725
    @solomonjara97252 жыл бұрын

    it is very important tutorial i appreciate u

  • @tabassummansuri7998
    @tabassummansuri79983 жыл бұрын

    Sir can u make one video on payroll management system with database connectivity. your concent are really amazing.I want to learn more...

  • @user-hu7ne5ut5g
    @user-hu7ne5ut5g2 жыл бұрын

    Thanks a lot! It worked amazing

  • @Marc1920x1080p
    @Marc1920x1080p2 жыл бұрын

    Thank you so much for this great video. Really told me alot of new stuff :-)

  • @hhh48222
    @hhh482222 жыл бұрын

    Mind blowing tutorial

  • @kimsing1796
    @kimsing17963 жыл бұрын

    I just binge watch freecodecamp, but I learn a lot.

  • @sleave_exe
    @sleave_exe6 ай бұрын

    thank you man it was really good

  • @dibyajyotiparida7316
    @dibyajyotiparida73163 жыл бұрын

    It would be very helpful if someone adds the timestamp🙂

  • @marcusgarner1146
    @marcusgarner1146 Жыл бұрын

    Great video, thank you! Can you make a video where you show how to implement the search function for the database in the app? :)

  • @amirchaka1407
    @amirchaka14072 жыл бұрын

    thanks very much sir please can u show us how to remove CustomerModel from list view and share search and add image as well

  • @HarderThanCalculus
    @HarderThanCalculus2 жыл бұрын

    great video, thank you so much!

  • @bashconsole
    @bashconsole2 жыл бұрын

    That felling when you watch this video with a cup of coffee having 23+ years of software development experience and understanding what is SQLite. Relaxed.

  • @anathemafps5323
    @anathemafps532311 ай бұрын

    best tutorial ever

  • @rapyd5134
    @rapyd51343 жыл бұрын

    thanks Sir at 16:14 for buttons you could use "Chaining"

  • @aislinggallagher7841
    @aislinggallagher78413 жыл бұрын

    Very new to android apps and databases, my question is, if I follow what you have done in the above video, and leave out the delete function, can anyone update, add to the same database or is that strictly when you add to db, it only goes to your phone? If I wanted to do a 'universal' db that anyone can add to it, what do I do? Thank you, and also, great video, easy to follow.

  • @indeep6820
    @indeep68202 жыл бұрын

    thanks for tutorials

  • @rensonplacino2737
    @rensonplacino27373 жыл бұрын

    My deleteOne function has a problem it keeps crashing whenever I attempt to delete something in my database though I follow all your instructions

  • @dimitrigeorgoudakis3676
    @dimitrigeorgoudakis36762 жыл бұрын

    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 ?

  • @maryannadelman4438

    @maryannadelman4438

    2 жыл бұрын

    I did everything also. All was working until I got to the point of changing the View All button to show the list instead of the Toast msg. And as a newbie, trying to figure out what went wrong is very difficult.

  • @dimitrigeorgoudakis3676

    @dimitrigeorgoudakis3676

    2 жыл бұрын

    @@maryannadelman4438 Hey Mary, so, my problem was at the point where we insert the SQL statement into the code . I had left out a comma or something and expected the debugger to pick up on it but it wasn't so it was just crashing .Either than that it worked fine for me. Try to check and compare your code line by line to the original code.

  • @mirsadhadzic5076

    @mirsadhadzic5076

    Жыл бұрын

    similar problem, had to make spaces inside commas when creating new table

  • @rahulraj94391
    @rahulraj94391 Жыл бұрын

    26:54 You have used tools:text = "View All" (This will show the text only in Design window) You have to use android:text = "View All" (This will show "View All" at runtime)

  • @hereistyagi
    @hereistyagi Жыл бұрын

    love the way you teach sir #BestTeacherHaveEverSeen

  • @utkarshrastogi8791
    @utkarshrastogi87913 жыл бұрын

    Thank you sir, this will be of great help to me.

  • @maryannadelman4438
    @maryannadelman44382 жыл бұрын

    Great teaching style. I'm a newbie and so far this has helped tremendously. However, I've followed everything exactly and it was working just fine until I got to the last section about changing the View All button to show the list instead of the Toast msg. "ArrayAdapter" is yellowed out and now the app crashes when clicking "view all". Any idea why this would be the case? I'm running Bumblebee version.

  • @yeasinarafat2667
    @yeasinarafat26673 жыл бұрын

    Excellent

  • @tonystark_2017
    @tonystark_20173 жыл бұрын

    Perfect time .

  • @parvizjonhojiev5528
    @parvizjonhojiev55283 жыл бұрын

    android studio has it's own database inspector

  • @neerajahlawat7393
    @neerajahlawat73932 жыл бұрын

    Nice explanation

  • @mohamadmaleki3026
    @mohamadmaleki30267 ай бұрын

    Thanks a lot Mr. Sluiter for this very usefull video. Is the code of the program available to download?

  • @aboutiti2838
    @aboutiti28382 жыл бұрын

    Thks so much 😊🙏🏼

  • @alisasasasaa
    @alisasasasaa2 жыл бұрын

    Where can I find the video about Room that he is talking about at the end ?

  • @pcradwan8704
    @pcradwan87042 жыл бұрын

    Thank you sir

  • @ahmedlshubaky7336
    @ahmedlshubaky73362 жыл бұрын

    amazing , but i think ViewList btn feature is useless after enhance the code at the end :)

  • @keshavarya2771
    @keshavarya27713 жыл бұрын

    When will Rust course come?

  • @SuperTenja
    @SuperTenja2 жыл бұрын

    Awesome!

  • @jothamithagu7403
    @jothamithagu74039 ай бұрын

    I have a quick question; Is it a must to install XAMPP for AndroidStudio to be complete?

  • @madonnalamin
    @madonnalamin12 күн бұрын

    Thank You

  • @hoseinhoseiny8200
    @hoseinhoseiny82002 жыл бұрын

    hi thanks due to your excellent video , but in btn_viewAll.setOnClickListener ((v) → { how to write forward Arrow symbol ?

  • @Tom-tu2xq
    @Tom-tu2xq3 жыл бұрын

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

  • @DevsLikeUs

    @DevsLikeUs

    3 жыл бұрын

    Thank You 😊

  • @danielflorez3762

    @danielflorez3762

    3 жыл бұрын

    im not going to give you like but thanks :)

  • @alibindrayton5211

    @alibindrayton5211

    Жыл бұрын

    Thank you ba HA SHAM AHAYAH same to you ba HA SHAM YASHAYAH

  • @NHKCarimi

    @NHKCarimi

    Ай бұрын

    Same applies to You dear, the feelings are mutual, Jumma Mubarak ❤

  • @PraneshPyaraShrestha
    @PraneshPyaraShrestha3 жыл бұрын

    Make videos on projects of android development

  • @eddyjaga8899
    @eddyjaga88992 жыл бұрын

    Thanks!

  • @henrybs14
    @henrybs142 жыл бұрын

    How do we get those hints? I've found control + P, but that hint menu looks way better eg looking at 51:39