SQLite Database Tutorial for Android Studio

Go to StudyCoding.org to subscribe to the full list of courses and get source code for projects.
Tutorial that shows every step of programming a demo application example that demonstrates how to create a 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.
Full course playlist for Android App development
• Android App Developmen...
Index
8:38 - Build the app constraint Layout
18:20 - Create the 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

Пікірлер: 366

  • @DanielValenzuelaPerez
    @DanielValenzuelaPerez3 жыл бұрын

    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

  • @GodlessUkr

    @GodlessUkr

    3 жыл бұрын

    Thanks! This should be included in the description. 👍

  • @FedoG88

    @FedoG88

    3 жыл бұрын

    MVP

  • @braxtonhancock5508
    @braxtonhancock55084 жыл бұрын

    i think this man is the best teacher i've ever learned from. this dude went above and beyond.

  • @avichayganz308

    @avichayganz308

    4 жыл бұрын

    gosh yea

  • @febryantoyanto2138

    @febryantoyanto2138

    2 жыл бұрын

    PP 0ppp00po

  • @febryantoyanto2138

    @febryantoyanto2138

    2 жыл бұрын

    Pppp0 PP

  • @febryantoyanto2138

    @febryantoyanto2138

    2 жыл бұрын

    0 PP PP ok p PT p p PP p PT 0o

  • @user-qc3nq6ny6q

    @user-qc3nq6ny6q

    2 жыл бұрын

    @@febryantoyanto2138 .

  • @yougiely
    @yougiely4 жыл бұрын

    Wonder why these well made videos never exist in my search results, only Indians results.

  • @manfrombritain6816

    @manfrombritain6816

    3 жыл бұрын

    LMAO so accurate... sadly

  • @yougiely

    @yougiely

    3 жыл бұрын

    @@VOTVRe possibly base on my isp region that joint the search command, and it's so annoying.

  • @2Smithyb
    @2Smithyb4 жыл бұрын

    One of the best demonstrations ive seen on utube. Thorough, complete; and with the right amount of theory and practical. Well presented with aims, objectives, and summary Thankyou

  • @unstoppable9668
    @unstoppable96683 жыл бұрын

    The satire at the end is the best part of this video, awesome teacher .

  • @PawanKumar-eg1nd
    @PawanKumar-eg1nd4 жыл бұрын

    The best ever explanation on youtube. What a combination of theory and practical!!!!

  • @AVdubs1
    @AVdubs13 жыл бұрын

    This is SUCH a great video. The quality is 10/10. Way better than the typical coding video that has someone that has audio quality that sounds like speaking into a shoebox or is so abstract you can't understand.

  • @shadsluiter

    @shadsluiter

    3 жыл бұрын

    Wow, thanks! Very kind of you. Hopefully the information worked well for you.

  • @mohamedelrhaouat5011
    @mohamedelrhaouat50114 жыл бұрын

    where have you been all that time, This is my best day. Thank God, I found someone explaining things in your own way. I prepare myself. I will see all your explanations, no matter how long it takes.

  • @Sam-id1yc
    @Sam-id1yc4 жыл бұрын

    Brilliant Tutorial! I never comment on videos but this was great. Really appreciate the work you put into this, Thank-you!

  • @omardotbio
    @omardotbio3 жыл бұрын

    That reverse psychology at the end made me subscribe and click the bell button.

  • @hmz8602

    @hmz8602

    3 жыл бұрын

    Thank you

  • @SiddharthNK
    @SiddharthNK4 жыл бұрын

    You are amazing, i'm so happy to have found your channel. I though of learning android during the quarantine time and i could find properly explained videos anywhere. Your tutorials are neatly explained, easy to follow for beginners and fairly descriptive. Keep up the great work :))

  • @ameanasaur
    @ameanasaur3 жыл бұрын

    Best tutorial I've seen in a looong time, was able to fix any issues I had because you explained everything so well. Wish I had you as a teacher in school.

  • @shoujozai3881
    @shoujozai38813 жыл бұрын

    The tutorial is the best w/necessary zoom in's whenever a process is done. Thank you

  • @johnnugent3992
    @johnnugent39924 жыл бұрын

    This is really good. Clear , accurate and covering the necessary ground. Thanks very much.

  • @learn_with_yvana
    @learn_with_yvana2 жыл бұрын

    You are simply the best Sir, You are my university. Not only this, every video are very helpful, not just to solve the problem, but to know how to solve them.

  • @kamilolech1498
    @kamilolech14982 жыл бұрын

    Honestly I feel embarrassed that I can watch this for free. Your channel is a huge source of knowledge. I think you should consider partonite or something. Thank you for your effort!

  • @shadsluiter

    @shadsluiter

    2 жыл бұрын

    Thank you for the compliment. I believe future courses are going to be offered as a premium service. In the meantime, you get to see the lessons I do with students.

  • @bryanalvarez8826
    @bryanalvarez88264 жыл бұрын

    I've been struggling to implement SQL on my apps. But after this video, I got it going and working. Thank you so much for your help. Really good tutorial!

  • @basselh5621
    @basselh56213 жыл бұрын

    Sir, you're incredible! thank you for your efforts. I haven't seen anyone who could explain things better than you.

  • @chriscampbell5901
    @chriscampbell59014 жыл бұрын

    The best explanation on the topic by far. Thanks for taking the time out!

  • @reboeiras
    @reboeiras3 жыл бұрын

    I"m beginning to learn Android Programming and came up with this wonderful class. Thank you very much from Brazil.

  • @adibchowdhury8819
    @adibchowdhury88194 жыл бұрын

    A very practical yet easy to follow guide, thank you so much! You are an excellent teacher!

  • @yeru2480
    @yeru24803 жыл бұрын

    This was incredibly helpful. Was actually a bit confused about Android development in general and even that confusion is gone now. Thanks a lot!

  • @shadsluiter

    @shadsluiter

    3 жыл бұрын

    Glad you liked it.

  • @Saulens110
    @Saulens1104 жыл бұрын

    The best demonstration I have seen here. Thank you! Very good work.

  • @MuhammadQasim76
    @MuhammadQasim764 жыл бұрын

    I am heartily impressed by the way you taught everything. This is more than amazing, I have become your fan. You are a gift from Allah. Thank you very much, Sir. Love from Pakistan ❤️

  • @zuhaibkhan1646
    @zuhaibkhan16464 жыл бұрын

    15 years in IT with numerous projects and technology. You are awesome for anyone to understand the concept no matter how many year of experience one has. Awesome Job!!!

  • @idle5992
    @idle59923 жыл бұрын

    You are a great teacher sir! You go into everything detailed and step by step and that is really helpful. thank you.

  • @topanime7563
    @topanime75632 жыл бұрын

    The way you explain things are very understandable!

  • @user-vl5ko5mw6d
    @user-vl5ko5mw6d3 жыл бұрын

    Usually I don't write comment in video but wow, that was the best explanation I heard for a lot of time. Thank you sir!

  • @terasoft-official
    @terasoft-official4 жыл бұрын

    I have started off Android Practically with your video, my target was to start with sqlite, I am a senior software architect for server side technologies. I am loving the way you gave a touch of UI and a full tutorial on how to startup a project and connect to sqlite and sqlite browser. I have just finished first hour of the video and i must say that this single video teaches a lot more in just 2 hours than many other tutorials. Your way of teaching is very pretty and straight fwd and error free. Thanks for this videos. I will keep watching rest of the video.

  • @shadsluiter

    @shadsluiter

    4 жыл бұрын

    Glad it works for you. What are you planning to build?

  • @terasoft-official

    @terasoft-official

    4 жыл бұрын

    offline sync app

  • @qwertyls8552
    @qwertyls85522 жыл бұрын

    This is the best explanation of sqlite ever!

  • @yodaking2003
    @yodaking20032 жыл бұрын

    Your tutorials have saved my senior project! I was struggling to connect my app to SQLite and retrieve the data, but your GPS and this tutorial were exactly what I needed for my Triathlon workout tracker app. THANK YOU!

  • @shadsluiter

    @shadsluiter

    2 жыл бұрын

    Sounds like an interesting app. Would you like to share the results? Look me up on Linked In.

  • @clarissearaujo1800
    @clarissearaujo18003 жыл бұрын

    thanks!!! I need make a presentation about Local Data Bases in Android Studio, your video is the most clearly and complete that I found

  • @dailybachat4631
    @dailybachat46314 жыл бұрын

    The best explanation on a particular topic i have ever seen on You Tube . Right amount of information neither too much nor too less. Thank you 🙏

  • @shadsluiter

    @shadsluiter

    3 жыл бұрын

    So nice of you

  • @chadzulu4328
    @chadzulu43282 жыл бұрын

    You videos are incredibly helpful. I really like how you allow the red squigglies to happen, and then show where to find the documentation on how to resolve them.

  • @tonylama1497
    @tonylama14973 жыл бұрын

    It is a helpful tutorial, for the beginners in Android Studio like me, it shows the errors everyone may do during the programming, instead of giving the right coding without mentioning the eventual mistakes. It is very well explained, thanks again.

  • @shadsluiter

    @shadsluiter

    3 жыл бұрын

    Glad it helped!

  • @Snowman11054
    @Snowman110544 жыл бұрын

    This really helped me understand how to use SQLite in android thank you so much

  • @laz0rama
    @laz0rama2 жыл бұрын

    this is a fantastic demo. i am not quite the beginner that this clearly targets, but i still appreciate the level of detail. thanks very much!

  • @abhijithbabu9735
    @abhijithbabu97353 жыл бұрын

    Shad Sluiter and Professor Chuck, the two best cs teachers I've seen in my life

  • @shadsluiter

    @shadsluiter

    3 жыл бұрын

    Great to hear. Professor Chuck must be a good guy. :-)

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

    hands down one of the best videos out there

  • @kahanx10
    @kahanx102 жыл бұрын

    It felt like I was back in my college, thanks for your wonderful efforts sir!

  • @ruzb4539
    @ruzb45393 жыл бұрын

    I can't say how helpful this video is and how wonderfully you teach, I just wanna thank you, this was very valuable to me

  • @shadsluiter

    @shadsluiter

    3 жыл бұрын

    You're very welcome!

  • @Haris.rana203
    @Haris.rana2032 жыл бұрын

    Really loved the way you explained and helped. I wish our teachers were like you

  • @randomrainforest
    @randomrainforest4 жыл бұрын

    Who the duck disliked this video... It is a gift from GOD!

  • @mohammaditani9249

    @mohammaditani9249

    3 жыл бұрын

    No sql developers:)

  • @SnedzTheBricklayer
    @SnedzTheBricklayer2 жыл бұрын

    Thanks for making this tutorial! This is a massive of the App I'm coding for my starter portfolio 😁 Massive thanks from across the pond 👍

  • @thomasoc.2051
    @thomasoc.20513 жыл бұрын

    Thank you so much!!! Dont know what i would have done without you

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

    Keep making amazing Android Studio tutorials! Thank you!

  • @shadsluiter

    @shadsluiter

    3 жыл бұрын

    Thanks, will do!

  • @fibershot
    @fibershot3 жыл бұрын

    Good video man, keep it going. Watched the whole thing in one sitting. Thanks alot

  • @scotthartman8390
    @scotthartman83904 жыл бұрын

    I am so thankful and it was so easy to understand. You are an outstanding person!!!

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

    Really helped me understand this part of my current subject. Thank you :)

  • @codewalters
    @codewalters2 жыл бұрын

    Thank you for sharing ! Your videos are easy to understand and well structured.

  • @helenphu4663
    @helenphu46634 жыл бұрын

    Thank you so much for the tutorial! Lovely and clear explanation of how to proceed and what to do and how to use the reference guide! Makes coding in android studios much easier!!

  • @gauravraj7005
    @gauravraj70053 жыл бұрын

    I am from india. The way u explained the things really helped a lot.

  • @charlesyoung3157
    @charlesyoung31573 жыл бұрын

    Thanks for your patience and well explained details of the various aspects of the Android Studio application. I am able to follow along fairly easily but since this tutorial there have been some version updates and we have to make a few guesses. Even with that said, this is superior to anything I have found elsewhere. I am trying to learn android app programming because I have several PHP web apps that I need to convert to android so they can run without external or added helper apps. I have installed several to run locally using Penguin and other mini web PHP server apps. But the need to find and install multiple apps to get my stuff to run adds a layer that I wish to avoid. So I really appreciate the help and look forward to putting these new skills to use. Thanks again Shad! Chuck

  • @calcipher5073
    @calcipher50733 жыл бұрын

    For everybody wondering how to tidy the entries in the Listview: Go to CustomerModell.java (The one with the getters and setters) and go to Line 19-23. Just edit out the parts you don't like or change them. To add a line break, copy and paste: + ' ' +

  • @kristians1550
    @kristians15503 жыл бұрын

    Shad, you're a chad! Loved the ending :D thanks for the great tutorial

  • @Bejanut
    @Bejanut3 жыл бұрын

    Really nice and simple presentation, and I love the fact that you make mistakes on the way so that we can learn and understand what everything means.

  • @shadsluiter

    @shadsluiter

    3 жыл бұрын

    Glad you enjoyed it!

  • @pstotw277
    @pstotw2774 жыл бұрын

    really underrated video, thank you so much

  • @wissembellara6411
    @wissembellara64112 жыл бұрын

    Thank You Very Much You Explained everything clearly and easy . Great Job

  • @anasalissa6574
    @anasalissa65744 жыл бұрын

    Thanks for this tutorial, It's clear & easy to follow Good job !!

  • @cpt.mechano4256
    @cpt.mechano42564 жыл бұрын

    Top Tutorial and best explanation. I recommend to watch this video✨👌. Great job, thank you very much.

  • @TheMan091997
    @TheMan0919973 жыл бұрын

    Amazing video! Everything completely explained

  • @calcipher5073
    @calcipher50733 жыл бұрын

    You are awesome. Way better than the book I bought for 50 bux. Awesome work

  • @Nitrolego
    @Nitrolego2 жыл бұрын

    thank you for making this video, it is very helpful and thorough

  • @user-dg2sg7ni2t
    @user-dg2sg7ni2t4 жыл бұрын

    amazing tutorial, you are explaining everything very well thank you!!!!

  • @konajap
    @konajap3 жыл бұрын

    Thank you for such an informative and well structured video!

  • @edwinlee94107
    @edwinlee941074 жыл бұрын

    Thanks for the quick and simple tutorial :)

  • @taqikhan5418
    @taqikhan54184 жыл бұрын

    Thanks for the wonderful explanation sir.

  • @andret8200
    @andret82002 жыл бұрын

    Straight up awesome tutorial. Thank you so much!!

  • @janel5334
    @janel53342 жыл бұрын

    That's the perfect tutorial!!! Keep up the great work!!!

  • @cesardanielyepez4093
    @cesardanielyepez40933 жыл бұрын

    Very nice video, it will help me with my final project at college

  • @ahmedfaarih778
    @ahmedfaarih7784 жыл бұрын

    An excellent video to learn SQLite and adroid studio.

  • @definitionsupervillain4583
    @definitionsupervillain45832 жыл бұрын

    Amazing teaching. Thank you so much sir!

  • @sandhyabhat7712
    @sandhyabhat77123 жыл бұрын

    Thank you for this video Sir. Concepts are explained clearly with right amount of theory and practical.

  • @shadsluiter

    @shadsluiter

    3 жыл бұрын

    Thanks and welcome

  • @Max-mx8cy
    @Max-mx8cy2 жыл бұрын

    Very clear, great tutorial thank you.

  • @dddd176
    @dddd1764 жыл бұрын

    Who are you? Why are you teaching very well with key point that I need? Really Thank you so much.

  • @barathan8766
    @barathan87663 жыл бұрын

    This content is amazing! I am using it for my bachelor thesis. You should put a complete course on Udemy!

  • @AllmightC94
    @AllmightC944 жыл бұрын

    thank you so much for this video. ti helps a lot. the best explained on youtube.

  • @newsmix8659
    @newsmix86593 жыл бұрын

    Excellent piece of work! Very helpful. Thanks a lot.

  • @vernevens1598
    @vernevens15983 жыл бұрын

    Thank you. Well worth the time to watch this video.

  • @sumanthr2103
    @sumanthr21033 жыл бұрын

    Thank you soo much sir, you taught this concept great.

  • @jeffscottrankentechnicalco8834
    @jeffscottrankentechnicalco88344 жыл бұрын

    Understood. Thanks for getting back to me.

  • @harsh9558
    @harsh95583 жыл бұрын

    This is the best video I found

  • @shadsluiter

    @shadsluiter

    3 жыл бұрын

    Thank you

  • @guriaulakh4691
    @guriaulakh46912 жыл бұрын

    excellent explaination ... simply amazing...

  • @robertmelcher5826
    @robertmelcher58264 жыл бұрын

    Really great tutorial. I mostly use Kotlin so i will check that tutorial next.

  • @inglesporpalavras
    @inglesporpalavras2 жыл бұрын

    Great Tutorial!! Thanks a lot to share all your knowledge with us. It's privilege.

  • @James-nf4tm
    @James-nf4tm3 жыл бұрын

    Amazing tutorial!!! The source code would have been nice... but 5 star tutorial. Thanks for making this!!!

  • @KristoLaptalo
    @KristoLaptalo4 жыл бұрын

    Amazing! Thank you for sharing knowledge!

  • @veys7035
    @veys70353 жыл бұрын

    This video is the best thing happened to me in this month. Thank you very much. Also sorry but I subscribed , liked and will watch the next video.

  • @shadsluiter

    @shadsluiter

    3 жыл бұрын

    Thanks and welcome

  • @ismailkoyuncu5518
    @ismailkoyuncu55184 жыл бұрын

    Thanks for explations. God bless you.

  • @mehmetsenacelik8279
    @mehmetsenacelik82793 жыл бұрын

    Really good Tutorial.Thanks so much ...

  • @joelsiennicki3590
    @joelsiennicki35904 жыл бұрын

    This is amazing, thank you!

  • @PushpendraKumar-ck8op
    @PushpendraKumar-ck8op3 жыл бұрын

    Thank you sir awesome video , very detailed explanation;

  • @saugatdhakal5732
    @saugatdhakal57324 жыл бұрын

    really good tutorial 😊 it help me a lot thank you

  • @rosellerpelonia2641
    @rosellerpelonia26413 жыл бұрын

    Every newbies dream

  • @shadsluiter

    @shadsluiter

    3 жыл бұрын

    Thank you too!

  • @Ome_cent___
    @Ome_cent___2 жыл бұрын

    This really made me come along! Thank you very much! I will write you a postcard from my Yacht when i made tons of money with my app!!! Just kidding...

  • @rjrmatias
    @rjrmatias2 жыл бұрын

    Excellent video, thanks professor !

  • @shadsluiter

    @shadsluiter

    2 жыл бұрын

    No worries!

  • @AyuJessieM
    @AyuJessieM3 жыл бұрын

    Very well explanation, Sir :) Thank you very much

  • @xShaxOx
    @xShaxOx3 жыл бұрын

    Thank you so much for this.. no idea how much it helped me

  • @shadsluiter

    @shadsluiter

    3 жыл бұрын

    You're very welcome!

  • @CodeYourselfToDeath
    @CodeYourselfToDeath3 жыл бұрын

    My good sir, your tutorial is excellent!

  • @shadsluiter

    @shadsluiter

    3 жыл бұрын

    Glad it was helpful! Did you get an app working?

  • @CodeYourselfToDeath

    @CodeYourselfToDeath

    3 жыл бұрын

    @@shadsluiter yes sir, developed an app for my school assignment which required the implementation of 3 database tables. After watching this I got it done super fast and super neat thanks to your precise explanation

  • @jangevaert3615
    @jangevaert36153 жыл бұрын

    weereens 'n baie interessante handleiding, baie dankie!!