33- Create SQL lite database in android studio |add, remove, ,show, display, sum, average and count
introduction to SQL lite database:(0:00)
design SQL lite database tools such as buttons, Edit texts and list views:(2:33)
reference designed tools in coding form in android studio:(9:25)
write a program in android studio to define class of SQL lite database name dbround2:(13:26)
create on create and on upgrade method in SQL lite database:(14:38)
create constructor to create SQL lite database named info.db:(14:46)
:(16:10)Create on create method to create table name student contains fields such as ID, name, mark1, mark2, sum and average
create on upgrade method to deletes or remove or update table in SQL lite database:(19:02)
define SQL lite class in the main class:(20:43)
create add method to enter data into SQL lite database:(21:42)
create Cursor method or show method to display or retrieve data using Cursor SQL lite database:(33:55)
create search method to find data stated with a letter A or B from SQL lite database:(51:33)
create method to count the number of records in SQL lite database in android studio:(1:05:27)
create method to delete or remove data from SQL lite database in android studio:(1:11:00)
create method to calculate average of marks entered into SQL lite database in android studio:(1:16:02)