SQLite Database in Android Studio | 38 | Android Development Tutorial for Beginners
𝐃𝐨𝐧𝐚𝐭𝐞 𝐨𝐫 𝐁𝐮𝐲 𝐦𝐞 𝐂𝐮𝐩 𝐨𝐟 𝐂𝐨𝐟𝐟𝐞𝐞 : paypal.me/codingpursuits
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
an email must have email with @mailname.com etc.
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.
Subscribe to Our Channel: / @codingpursuit914
Facebook Group: / 2030125363667051
Twitter: / codingpursuits
Facebook Page : / codingpursuits
Linkdin: www.linkedin.com/in/coding-pursuits
Pinterest: / codingpursuits
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
• SQLite Database in And...