SQLite Database for Android - Full Course

  Рет қаралды 255,641

freeCodeCamp.org

freeCodeCamp.org

Күн бұрын

Пікірлер: 219
@RunnerDigest
@RunnerDigest 3 жыл бұрын
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
@noahbastola9386
@noahbastola9386 3 жыл бұрын
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 3 жыл бұрын
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 2 жыл бұрын
because this is a university preffossor, not just a freelancer KZbinrs. 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. :)
@burakcanduzcan
@burakcanduzcan 3 жыл бұрын
44:20 "Refactor -> Extract" is now called "Refactor -> Introduce Constant"
@definitionsupervillain4583
@definitionsupervillain4583 3 жыл бұрын
also works with 'ctrl + alt + c'
@jothamithagu7403
@jothamithagu7403 Жыл бұрын
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...👏👏👏👏👏👏👏👏👏
@VikSintus
@VikSintus 4 жыл бұрын
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
@ronanlarkin 2 жыл бұрын
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!
@brandonmchugh9821
@brandonmchugh9821 2 жыл бұрын
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!!!
@ajieewin2398
@ajieewin2398 2 жыл бұрын
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
@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
@fwogg3r158
@fwogg3r158 6 ай бұрын
Went from nothing to everything in an incredibly comprehensive and cohesive manner. Incredible lecture even today; Thank you!
@DagothDaddy
@DagothDaddy 4 жыл бұрын
I took his class when I attended GCU. He was great.
@attaullahshah6611
@attaullahshah6611 2 жыл бұрын
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 :)
@josejayant3127
@josejayant3127 3 жыл бұрын
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
@colt45jr
@colt45jr 8 ай бұрын
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!
@cryptonews-q-h4
@cryptonews-q-h4 2 жыл бұрын
One of the best video on KZbin for android sqlite database..
@黄驿淙
@黄驿淙 2 жыл бұрын
Wonderful. Best teacher I've ever seen on KZbin.
@rahulraj94391
@rahulraj94391 2 жыл бұрын
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)
@aivkhairulamirin9004
@aivkhairulamirin9004 Жыл бұрын
Thank you. This tutorial is worth our time. It provides the basic of SQLite with easy-to-follow instructions.
@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!
@infinix2003
@infinix2003 Ай бұрын
Thank you man, you saved a lot of my time
@okrimtech
@okrimtech Жыл бұрын
Amazing tutorial as always. Your materials helped me tremendously with several of my university classes. Thank you a thousand times!
@MrStickmanish
@MrStickmanish 3 жыл бұрын
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!
@albanmarku6743
@albanmarku6743 2 жыл бұрын
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.
@wkalou
@wkalou 2 жыл бұрын
Exclusive video that helped to understand where other videos failed Good job GOD bless
@Gerrit2686
@Gerrit2686 2 жыл бұрын
Danke!
@YuGan-lm4ce
@YuGan-lm4ce 2 жыл бұрын
I am so glad that I found this video, the best teacher I found so far!
@siomarapantarotto
@siomarapantarotto Жыл бұрын
What a great teacher. I loved this tutorial ❤ Thanks a lot, Professor Sluiter!
@taniamartinezvillagomez6448
@taniamartinezvillagomez6448 3 жыл бұрын
Thank you very much, your teaching skills are amazing. This is one of the best android tutorials I have ever seen.
@KASalgado
@KASalgado 4 жыл бұрын
Excellent tutorial. It has a very good focus in Code Standards like no other videos. Good job. Thanks.
@Tim-chik
@Tim-chik 3 жыл бұрын
You are a great person. I needed it and I found it! So thankful for your job!!!
@alwa6648
@alwa6648 2 жыл бұрын
Thank you for all the quality content you produce. You probably contributed more than my teachers toward obtaining my degree.
@akunformalitas
@akunformalitas 2 жыл бұрын
As a desktop programmer this video helps me so much to switch to android apps.
@sportscity5487
@sportscity5487 2 жыл бұрын
One of the best formal way to do this task. Thank you..
@poisonshroom64
@poisonshroom64 2 жыл бұрын
better and more straighforward than my uni teacher, thanks a bunch
@deepakpitaliya8932
@deepakpitaliya8932 Жыл бұрын
Thank you Prof. Sluiter for this excellent tutorial.
@dimitrigeorgoudakis3676
@dimitrigeorgoudakis3676 2 жыл бұрын
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 2 жыл бұрын
similar problem, had to make spaces inside commas when creating new table
@elohimalves
@elohimalves 3 жыл бұрын
You explain everything you are doing, Excellent Professor!
@jesusribeiro9447
@jesusribeiro9447 3 жыл бұрын
Commenting so I can get back to it tomorrow. ( 58:47 ) Awesome tutorial so far!
@oniii-chan_
@oniii-chan_ 4 жыл бұрын
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 🤞🤞
@lioneldynasty
@lioneldynasty Жыл бұрын
This tutorial is amazing andget he's really good at teaching
@eddyjaga8899
@eddyjaga8899 3 жыл бұрын
Thanks!
@eddyjaga8899
@eddyjaga8899 3 жыл бұрын
Thank you for your time. It's great and understandable content. Much better than my lecturer 👩‍🏫 👨‍🏫 🧑‍🏫
@crimsonblue1455
@crimsonblue1455 2 жыл бұрын
this guy is good at teaching people. very nice 🤗🤗
@vros14
@vros14 2 жыл бұрын
At 1:06:18, the professor uses a ternary operator, I would assume to demonstrate the syntax which may be unfamiliar to some people. To add a little bit of clarity on how Java types work, the == operator already returns a boolean value, so x == 1 already returns true or false, no ternary operator needed. While I'm sure the professor is aware, I'd just like to point it out for the people who are still learning Java.
@charleslyell3748
@charleslyell3748 6 ай бұрын
True, ternary operator is not necessary here.
@Simomajola1
@Simomajola1 4 жыл бұрын
Best Tutorial Ever !!!!!!!!!!!!!!!!!!!!!!!!!!
@xvzf115
@xvzf115 4 жыл бұрын
Really nice tutorial format. Thank you, very clear explanations!
@snoop3800
@snoop3800 8 ай бұрын
Thanks awesome tutorial, the good thing that you are showing how to use documentation added to that the clear explication
@bashconsole
@bashconsole 3 жыл бұрын
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.
@thejustinfernald
@thejustinfernald 4 жыл бұрын
Big fan of Professor Sluiter.
@h.r.60
@h.r.60 4 жыл бұрын
Keep up the amazing work my friend!
@andrefiord2357
@andrefiord2357 Жыл бұрын
Excellent tutorial. A bit incomplete w/o search and update but still extremely informative. Thank you!
@williamselinder9138
@williamselinder9138 2 жыл бұрын
What a great teacher! All understood, all worked well! Fantastic!!!
@kojofosuedue3686
@kojofosuedue3686 3 жыл бұрын
Very detailed...i loved every bit of it. Thanks guys
@tomm-_-16
@tomm-_-16 4 жыл бұрын
If you are reading this God bless you and have a wonderful day and stay safe ❤️🥰
@DevsLikeUs
@DevsLikeUs 4 жыл бұрын
Thank You 😊
@danielflorez3762
@danielflorez3762 4 жыл бұрын
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 7 ай бұрын
Same applies to You dear, the feelings are mutual, Jumma Mubarak ❤
@hhh48222
@hhh48222 3 жыл бұрын
Mind blowing tutorial
@bishnubhusal5999
@bishnubhusal5999 Жыл бұрын
Best explanation ever.
@ashishthaakur45
@ashishthaakur45 4 жыл бұрын
Love you freecodecamp
@kimsing1796
@kimsing1796 4 жыл бұрын
I just binge watch freecodecamp, but I learn a lot.
@rapyd5134
@rapyd5134 3 жыл бұрын
thanks Sir at 16:14 for buttons you could use "Chaining"
@patriciarodrigues598
@patriciarodrigues598 4 жыл бұрын
Great ! Thanks from Brazil!
@anathemafps5323
@anathemafps5323 Жыл бұрын
best tutorial ever
@floresjose
@floresjose Жыл бұрын
now I understand a lot of fundamental things, thanks a lot, by the way: You rock!
@lowblowjimboy
@lowblowjimboy 2 жыл бұрын
TOP CLASS TEACHER!!! Thank you Sir!
@minhphucnguyen3148
@minhphucnguyen3148 2 жыл бұрын
48:50 getWritable() 51:25 insert 1:00:54 select *
@Kunal-jp8tn
@Kunal-jp8tn 3 жыл бұрын
Thank you so much for providing such cool valuable content.
@mehdihachimi9624
@mehdihachimi9624 2 жыл бұрын
Awesome tutorial, thank you so much for this!
@lxdzii
@lxdzii Жыл бұрын
Wow, this was a beautiful one!
@hereistyagi
@hereistyagi Жыл бұрын
love the way you teach sir #BestTeacherHaveEverSeen
@amirchaka1407
@amirchaka1407 3 жыл бұрын
thanks very much sir please can u show us how to remove CustomerModel from list view and share search and add image as well
@rensonplacino2737
@rensonplacino2737 3 жыл бұрын
My deleteOne function has a problem it keeps crashing whenever I attempt to delete something in my database though I follow all your instructions
@tamaspej
@tamaspej 11 ай бұрын
I think the hardest part for a newbie is the first adding. The app was crashing and i didnt get anything on the terminal. I was thinking about the emulator and the switch component is obsolate etc. I know it part of the journey but the code what he writes at 29:00 is here. CustomerModel customerModel = new CustomerModel(-1,et_name.getText().toString(),Integer.parseInt(et_age.getText().toString()),sw_activeCustomer.isChecked()); U guys all doing a nice job here.
@parvizjonhojiev5528
@parvizjonhojiev5528 3 жыл бұрын
android studio has it's own database inspector
@returnMarcco
@returnMarcco Жыл бұрын
Thanks very much, awesome tutorial
@benukapunchihewa4125
@benukapunchihewa4125 3 жыл бұрын
Thank you very much. Great Video. Looking forward to watch awesome content like this.
@solomonjara9725
@solomonjara9725 3 жыл бұрын
it is very important tutorial i appreciate u
@mubaraknative
@mubaraknative Жыл бұрын
26:44 he add the button text name in tools atttribute of xml it is onlty visible in the xml layout not in application
@qpdbwvwdbqp4730
@qpdbwvwdbqp4730 2 жыл бұрын
Amazing! It was very useful! Thank you so much!
@dibyajyotiparida7316
@dibyajyotiparida7316 4 жыл бұрын
It would be very helpful if someone adds the timestamp🙂
@objectobj
@objectobj Жыл бұрын
not bad. it was getting worse by the end. on 1:23:46 you say, "View view is the ListView", which is not correct, but then later you say that "parent" is ListView so *View view* is the exact item that we click, and *AdapterView parent* is ListView the way you implemented it so ID is incremented every time you click "add" wasn't shown too, which makes no sense for the last part
@charleslyell3748
@charleslyell3748 6 ай бұрын
CUSTOMER_TABLE + " (" + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT.
@DavidThang-k8w
@DavidThang-k8w 3 ай бұрын
Thanks for teaching us
@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? :)
@sleave_exe
@sleave_exe Жыл бұрын
thank you man it was really good
@jajanaglobo
@jajanaglobo 4 жыл бұрын
PLEASE... even if I do not fill anything, it send the data, how can I do not accept if the fields are empty? I'm Brazilian, sorry for any mistake.
@manuelabarcacrespo8298
@manuelabarcacrespo8298 3 жыл бұрын
Add NOT NULL after data type when creating the table
@maryannadelman4438
@maryannadelman4438 2 жыл бұрын
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.
@vancheloChanel
@vancheloChanel 4 жыл бұрын
Very helpful! Thank you
@jothamithagu7403
@jothamithagu7403 Жыл бұрын
I have a quick question; Is it a must to install XAMPP for AndroidStudio to be complete?
@hoseinhoseiny8200
@hoseinhoseiny8200 3 жыл бұрын
hi thanks due to your excellent video , but in btn_viewAll.setOnClickListener ((v) → { how to write forward Arrow symbol ?
@henrybs14
@henrybs14 2 жыл бұрын
How do we get those hints? I've found control + P, but that hint menu looks way better eg looking at 51:39
@عبدالرحمنسالم-ت1ظ
@عبدالرحمنسالم-ت1ظ 2 жыл бұрын
Thanks a lot! It worked amazing
@tabassummansuri7998
@tabassummansuri7998 4 жыл бұрын
Sir can u make one video on payroll management system with database connectivity. your concent are really amazing.I want to learn more...
@kevinrea7820
@kevinrea7820 Жыл бұрын
Hi, i am up to 1:11:56 on the video when I go to list the entries in the database on the emulator window, it only shows the 1st record. I opened the database using DB Browser SQLite and there are about 20 records in the database. any ideas? kevin rea
@husseinchahine9456
@husseinchahine9456 2 жыл бұрын
hello at 56:46 i couldnt find my file? is there anyone could help me to find the file that i created.Thanks
@neerajahlawat7393
@neerajahlawat7393 2 жыл бұрын
Nice explanation
@alisasasasaa
@alisasasasaa 2 жыл бұрын
Where can I find the video about Room that he is talking about at the end ?
@HarderThanCalculus
@HarderThanCalculus 2 жыл бұрын
great video, thank you so much!
@jothamithagu7403
@jothamithagu7403 Жыл бұрын
I've followed the whole process fully, but on reaching 27:05, my emulator won't start. I get the error, "SQLDemo keeps stopping" Why could this be happening? Kindly assist.
@charleslyell3748
@charleslyell3748 6 ай бұрын
If your computer has 8G of RAM or less, consider an upgrade. Emulators are very heavy.
@utkarshrastogi8791
@utkarshrastogi8791 4 жыл бұрын
Thank you sir, this will be of great help to me.
@refikjaija6036
@refikjaija6036 2 жыл бұрын
Is it possible that when a checkbox for example is not checked instead of showing false to not show that entity at all.
@Marc1920x1080p
@Marc1920x1080p 3 жыл бұрын
Thank you so much for this great video. Really told me alot of new stuff :-)
@aboutiti2838
@aboutiti2838 2 жыл бұрын
Thks so much 😊🙏🏼
SQLite Databases With Python - Full Course
1:29:37
freeCodeCamp.org
Рет қаралды 694 М.
Android App Development Tutorial for Beginners - Your First App
55:20
freeCodeCamp.org
Рет қаралды 434 М.
Sigma Kid Mistake #funny #sigma
00:17
CRAZY GREAPA
Рет қаралды 30 МЛН
VIP ACCESS
00:47
Natan por Aí
Рет қаралды 30 МЛН
RecyclerView | Everything You Need to Know
25:07
Practical Coding
Рет қаралды 147 М.
Exploring Abandoned Games From Your Childhood
20:00
globert
Рет қаралды 2,9 М.
The FULL Beginner to Pro Roadmap for Android Development in 2023
10:47
Philipp Lackner
Рет қаралды 275 М.
SQLite Backend for Beginners - Create Quick Databases with Python and SQL
13:32
CS50x 2024 - Lecture 7 - SQL
2:14:05
CS50
Рет қаралды 535 М.
MySQL Database - Full Course
1:59:31
freeCodeCamp.org
Рет қаралды 303 М.
Sigma Kid Mistake #funny #sigma
00:17
CRAZY GREAPA
Рет қаралды 30 МЛН