Android SQLite Database Tutorial 1 # Introduction + Creating Database and Tables (Part 1)

Find source-code here :

In this Android SQLite Database Tutorial video I will give you the Introduction to using SqLite with android on Android Studio. In addition we will be Creating Database and Tables in our sqlite database for use in our android sqlite database tutorial.
This Android sqlite database tutorial for beginners
Developing Android Apps - Optional SQLite Tutorial I will show step by step How to insert, create, update, delete, select data from SQLite using android app with android sqlite create database example. SQLite is an open-source social database i.e. used to perform database operations on android gadgets, for example, putting away, controlling or recovering relentless information from the database.
It is implanted in android by default. In this way, there is no compelling reason to play out any database setup or organization assignment.
Here, we are going to see the case of sqlite to store and get the information. Information is shown in the logcat. For showing information on the spinner or listview, move to the following page. SQLiteOpenHelper class gives the usefulness to utilize the SQLite database.

#SQLite #Android #ProgrammingKnowledge
★★★Top Online Courses From ProgrammingKnowledge ★★★

★★★ Online Courses to learn ★★★

★★★ Follow ★★★

DISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This help support the channel and allows us to continue to make videos like this. Thank you for the support!

[brianangeht]

I like this guy, 2 years since and he's more detailed than the latest videos!!

[belka]

This guy have answers for anything questions related to develop

[soonclass]

Thank you! I am doing a paid android app development course but it covers very basic SQLite, then I am doing some researchs to go deep in the topic. Your course is helping a lot!

[abdussamedbilginer]

I watched the complete tutorial of yours about sqlite databases. I had difficulties understanding it in school, however thanks to you I now know how to make use of databases in android. Thank you and Keep going! :D

[marketvending]

Easy to follow! Renaming my table, column names adding more columns and going well so far. Thank you for your videos!

[kaligasm]

As a newbie to Android Database apps, thanks very much for these videos.

[zimmykhumalo]

Simple and easy to understand! Thank you so much! ❤️ From South Africa 🇿🇦

[vpsir]

i really love your channel because it's save my time for coding and all this stuff...you provided all material to watch this videos....thanks again

Just curious, I'm looking at Android tutorials on Youtube and most of them seems to be out-dated. Their codes don't work. Has there been any changes to SQLite Database since you uploaded these series?

[ummesulaith]

i just created the table but i can't view the database file in ddms under data->data->mypackagename i can't really find database folder what do i do ?

[himanshukandwal]

Pls tell me where the database will be stored...what to do if we want online storage for database

[dattabhabal]

What dB should I select for making diet planner app . I mean in my app after BMi is displayed it's ask for what food you take in breakfast, lunch etc suggest me some thing I have stuck here

[vishalthapa]

Awesome video, "this is the best tutorial for beginners like me."

[mdmasidulhasan]

how can I execute the query
String proQuery = "SELECT * FROM " + DATABASE_TABLE + " WHERE "
+ KEY_NAME + " LIKE '%" + keyword +"%'";
do you have any answer ?

[aryanmishra]

hello sir, I m trying to add fifth attribute into my sqlite database but doing so makes the database completely empty. I am using a listview to display the db elements but it shows completely empty after adding fifth attribute. it works fine with 4
.plz help.

[Alex-vifr]

set speed to x1.25 is better, thank me later

[gigamgamboa]

Hi!

im trying to create a database. im using android studio. after i run the app. i check in 'ANDROID DEVICE MONITOR" data\data but there is no package name there (com.android.****.****) the only folder i can see is "con" folders.

any ideas?

[BigGoblinMan]

If you're working with two or more tables, would you have to create a database helper for each or can you use the same helper for both?

[monodeepdas]

Where is this database gets stored inside the file structure of the project and how do I access it remotely without the help of this class.

[BookFans-co-uk]

Excellent example which is simple for beginners but has all the CRUD functionality for manipulating the database. I request you to give a simple tutorial on using the latest Room persistance library also for working on SQLite databases.

I have searched and am not able to find a simple plain English tutorial like this for Room Persistance Library.