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
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
3 жыл бұрын
Thanks! This should be included in the description. 👍
@FedoG88
3 жыл бұрын
MVP
i think this man is the best teacher i've ever learned from. this dude went above and beyond.
@avichayganz308
4 жыл бұрын
gosh yea
@febryantoyanto2138
2 жыл бұрын
PP 0ppp00po
@febryantoyanto2138
2 жыл бұрын
Pppp0 PP
@febryantoyanto2138
2 жыл бұрын
0 PP PP ok p PT p p PP p PT 0o
@user-qc3nq6ny6q
2 жыл бұрын
@@febryantoyanto2138 .
Wonder why these well made videos never exist in my search results, only Indians results.
@manfrombritain6816
3 жыл бұрын
LMAO so accurate... sadly
@yougiely
3 жыл бұрын
@@VOTVRe possibly base on my isp region that joint the search command, and it's so annoying.
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
The satire at the end is the best part of this video, awesome teacher .
The best ever explanation on youtube. What a combination of theory and practical!!!!
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
3 жыл бұрын
Wow, thanks! Very kind of you. Hopefully the information worked well for you.
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.
Brilliant Tutorial! I never comment on videos but this was great. Really appreciate the work you put into this, Thank-you!
That reverse psychology at the end made me subscribe and click the bell button.
@hmz8602
3 жыл бұрын
Thank you
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 :))
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.
The tutorial is the best w/necessary zoom in's whenever a process is done. Thank you
This is really good. Clear , accurate and covering the necessary ground. Thanks very much.
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.
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
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.
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!
Sir, you're incredible! thank you for your efforts. I haven't seen anyone who could explain things better than you.
The best explanation on the topic by far. Thanks for taking the time out!
I"m beginning to learn Android Programming and came up with this wonderful class. Thank you very much from Brazil.
A very practical yet easy to follow guide, thank you so much! You are an excellent teacher!
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
3 жыл бұрын
Glad you liked it.
The best demonstration I have seen here. Thank you! Very good work.
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 ❤️
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!!!
You are a great teacher sir! You go into everything detailed and step by step and that is really helpful. thank you.
The way you explain things are very understandable!
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!
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
4 жыл бұрын
Glad it works for you. What are you planning to build?
@terasoft-official
4 жыл бұрын
offline sync app
This is the best explanation of sqlite ever!
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
2 жыл бұрын
Sounds like an interesting app. Would you like to share the results? Look me up on Linked In.
thanks!!! I need make a presentation about Local Data Bases in Android Studio, your video is the most clearly and complete that I found
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
3 жыл бұрын
So nice of you
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.
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
3 жыл бұрын
Glad it helped!
This really helped me understand how to use SQLite in android thank you so much
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!
Shad Sluiter and Professor Chuck, the two best cs teachers I've seen in my life
@shadsluiter
3 жыл бұрын
Great to hear. Professor Chuck must be a good guy. :-)
hands down one of the best videos out there
It felt like I was back in my college, thanks for your wonderful efforts sir!
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
3 жыл бұрын
You're very welcome!
Really loved the way you explained and helped. I wish our teachers were like you
Who the duck disliked this video... It is a gift from GOD!
@mohammaditani9249
3 жыл бұрын
No sql developers:)
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 👍
Thank you so much!!! Dont know what i would have done without you
Keep making amazing Android Studio tutorials! Thank you!
@shadsluiter
3 жыл бұрын
Thanks, will do!
Good video man, keep it going. Watched the whole thing in one sitting. Thanks alot
I am so thankful and it was so easy to understand. You are an outstanding person!!!
Really helped me understand this part of my current subject. Thank you :)
Thank you for sharing ! Your videos are easy to understand and well structured.
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!!
I am from india. The way u explained the things really helped a lot.
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
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: + ' ' +
Shad, you're a chad! Loved the ending :D thanks for the great tutorial
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
3 жыл бұрын
Glad you enjoyed it!
really underrated video, thank you so much
Thank You Very Much You Explained everything clearly and easy . Great Job
Thanks for this tutorial, It's clear & easy to follow Good job !!
Top Tutorial and best explanation. I recommend to watch this video✨👌. Great job, thank you very much.
Amazing video! Everything completely explained
You are awesome. Way better than the book I bought for 50 bux. Awesome work
thank you for making this video, it is very helpful and thorough
amazing tutorial, you are explaining everything very well thank you!!!!
Thank you for such an informative and well structured video!
Thanks for the quick and simple tutorial :)
Thanks for the wonderful explanation sir.
Straight up awesome tutorial. Thank you so much!!
That's the perfect tutorial!!! Keep up the great work!!!
Very nice video, it will help me with my final project at college
An excellent video to learn SQLite and adroid studio.
Amazing teaching. Thank you so much sir!
Thank you for this video Sir. Concepts are explained clearly with right amount of theory and practical.
@shadsluiter
3 жыл бұрын
Thanks and welcome
Very clear, great tutorial thank you.
Who are you? Why are you teaching very well with key point that I need? Really Thank you so much.
This content is amazing! I am using it for my bachelor thesis. You should put a complete course on Udemy!
thank you so much for this video. ti helps a lot. the best explained on youtube.
Excellent piece of work! Very helpful. Thanks a lot.
Thank you. Well worth the time to watch this video.
Thank you soo much sir, you taught this concept great.
Understood. Thanks for getting back to me.
This is the best video I found
@shadsluiter
3 жыл бұрын
Thank you
excellent explaination ... simply amazing...
Really great tutorial. I mostly use Kotlin so i will check that tutorial next.
Great Tutorial!! Thanks a lot to share all your knowledge with us. It's privilege.
Amazing tutorial!!! The source code would have been nice... but 5 star tutorial. Thanks for making this!!!
Amazing! Thank you for sharing knowledge!
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
3 жыл бұрын
Thanks and welcome
Thanks for explations. God bless you.
Really good Tutorial.Thanks so much ...
This is amazing, thank you!
Thank you sir awesome video , very detailed explanation;
really good tutorial 😊 it help me a lot thank you
Every newbies dream
@shadsluiter
3 жыл бұрын
Thank you too!
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...
Excellent video, thanks professor !
@shadsluiter
2 жыл бұрын
No worries!
Very well explanation, Sir :) Thank you very much
Thank you so much for this.. no idea how much it helped me
@shadsluiter
3 жыл бұрын
You're very welcome!
My good sir, your tutorial is excellent!
@shadsluiter
3 жыл бұрын
Glad it was helpful! Did you get an app working?
@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
weereens 'n baie interessante handleiding, baie dankie!!