SQLite Database in Android Studio | 38 | Android Development Tutorial for Beginners

SQLite Database in Android Studio | 38 | Android Development Tutorial for Beginners

00:00 - Introduction
00:59 - What are Data tables
01:29 - What is database schema ?
01:51 - What are rows and column ?
02:11 - What is primary Key ?
02:56 - what is SQLite ?
03:18 - What is Structured Query Language (SQL) ?
03:44 - Practical Demo App

Hello guys welcome back in this video we are going to learn about Database handling in Android application. We will use SQLIte database for a practical demo application.
So stay tuned and watch the video till the end.

Almost every android application needs permananat data storage place for storing some kind of user data. Sqlite is light weight and compact database specifically designed to store
mobile apps data. This video is divided into two parts. In the first part we will cover some theoratical concepts about SQLite database management.
Whereas in second part we will develop a practical demo application to see Android OS and SQLite database management in action.

What are Data tables ?
Database table is the basic structure in any kind of database. These are used to store only specific kind of data.
For example user table will contain the user name, email, first name , last name and password etc.
Whereas products table will contain data including product name, price, expiry date, brand etc.

What is database scheme ?
schema is the check and balance on the limit and type of data. For example we can restrict customer name to 20 characters only or his phone number can have only numerical values and

What are rows and column ?
you must have seen excel sheet or any spread sheet where data is stored in rows and column. Same applies on database table having multiple rows and columns.
In columns we can see the data of different customers, whereas rows have data specific to a particular customer.

What is primary Key ?
So almost each database table must have one or more columns having unique data in them. It is used to recognize that particular row or record.
It also shows us that particular row or record belongs to that specif unique data entry.
for example in user column , user mobile or national ID card no or passport no must be unique and different to any other entry or record in database.
So this unique database entry column may serve us as a primary key. and without primary key, it will be nearly impossible to manage and get data from specific row in database.

what is SQLite ?
SQLite is a compact and light weight database and does not require any kind of server to run it. It is easily integrated with any kind of mobile application.
There are libraries and classes available in android to perform any kind of database query on SQLite.

What is Structured Query Language (SQL) ?

It is high level lanaguage, which is developed to perform any kind of query on database.
Suppose if you want to insert any kind of data in any database ROW. It provides very simple and easy Insert command syntaxt to perform that specific task

so , now we have all theoretical knowledge, now let us create our demo application.

sqlite database in android studio
sqlite database in android studio in hindi
sqlite android studio
sqlite
Android studio tutorial
sqlite database
Android Development Tutorial for Beginners
sqlite login and register android studio
sqlite database in android example step by step
simple sqlite database example in android studio
how to insert data in sqlite database in android studio
android sqlite crud example
how to get data from sqlite database in android studio
Coding Pursuits

[maddyvlogs]

HAI IAM LEARNING ANDROID STUDIO FROM YOUR YOUTUBE VIDEOS THANKYOU YOUR VIDEOS

[lukaknezevic]

Thank you man, you saved my project for my colledge intership

[astrophysicalscience]

Hi we will like to know do we need to install SQlite first into our PC from your video? If we need to install first for mobile phone development then which version of SQlite is the suitable one? Do we install only the sqlite-android version or the latest SQlite on the web such as the current SQlite Version 3.49.1? Please advise. Thanks. 👌

[jothamithagu]

I've followed you step by step and all went 100% right. However, the last part did not go well, the 'insert' option, I don't get the Database on my log section.
All the other process is fine, just I cant access or see the names and password I've added. Do I need to connect to internet to get that access?
Kindly assist.

Otherwise this is a 5-star tutorial, I'm definitely subscribing and will learn from your channel because your explain everything well. Lot's of appreciation from East Africa, - Kenya.

[EricBalcon]

Hello, interesting but at the end it's not a proper apk where it's possible to retrieve data from database and search for some previous entries, I don't what's the aim of this tutorial ?

[lamineslimany]

there are some tutorial which prefer "Using ROOM as SQL object mapping library" on working directly with sqlite .
what does it mean ?
and which is better ?
working directly with sqlite or "using room as sql ?
please give me a help

[rooban]

Please provide the source code of this video :)

[LeroyEixab]

What version of android studio is this

[Sj-yfjg]

Try to make a tutorial on sqlite using kotlin

[SweetPeachannel]

I need help, where can I contact you please