title
Android SQLite Tutorial | Android CRUD Tutorial with SQLite (Create, Read, Update, Delete)

description
Welcome to this Android SQLite Database Tutorial video. This video shows How to use 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. So I video Android SQLite Database Tutorial How to create a SqLite database and then Select, Insert, Update, Delete which correspond to CRUD functionality in SQLite database. SQLite database management system comes bundled with the Android OS. 00:01 # Introduction + Creating Database and Tables 24:30 # Insert values to SQLite Database table using Android 38:19 # Show SQLite Database table Values using Android 52:46 # Update values in SQLite Database table using Android 01:07:32 # Delete values in SQLite Database table using Android 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. #SQLite #Android #ProgrammingKnowledge ★★★Top Online Courses From ProgrammingKnowledge ★★★ Python Programming Course ➡️ http://bit.ly/2vsuMaS ⚫️ http://bit.ly/2GOaeQB Java Programming Course ➡️ http://bit.ly/2GEfQMf ⚫️ http://bit.ly/2Vvjy4a Bash Shell Scripting Course ➡️ http://bit.ly/2DBVF0C ⚫️ http://bit.ly/2UM06vF Linux Command Line Tutorials ➡️ http://bit.ly/2IXuil0 ⚫️ http://bit.ly/2IXukt8 C Programming Course ➡️ http://bit.ly/2GQCiD1 ⚫️ http://bit.ly/2ZGN6ej C++ Programming Course ➡️ http://bit.ly/2V4oEVJ ⚫️ http://bit.ly/2XMvqMs PHP Programming Course ➡️ http://bit.ly/2XP71WH ⚫️ http://bit.ly/2vs3od6 Android Development Course ➡️ http://bit.ly/2UHih5H ⚫️ http://bit.ly/2IMhVci C# Programming Course ➡️ http://bit.ly/2Vr7HEl ⚫️ http://bit.ly/2W6RXTU JavaFx Programming Course ➡️ http://bit.ly/2XMvZWA ⚫️ http://bit.ly/2V2CoAi NodeJs Programming Course ➡️ http://bit.ly/2GPg7gA ⚫️ http://bit.ly/2GQYTQ2 Jenkins Course For Developers and DevOps ➡️ http://bit.ly/2Wd4l4W ⚫️ http://bit.ly/2J1B1ug Scala Programming Tutorial Course ➡️ http://bit.ly/2PysyA4 ⚫️ http://bit.ly/2PCaVj2 Bootstrap Responsive Web Design Tutorial ➡️ http://bit.ly/2DFQ2yC ⚫️ http://bit.ly/2VoJWwH MongoDB Tutorial Course ➡️ http://bit.ly/2LaCJfP ⚫️ http://bit.ly/2WaI7Ap QT C++ GUI Tutorial For Beginners ➡️ http://bit.ly/2vwqHSZ ★★★ Online Courses to learn ★★★ Get 2 FREE Months of Unlimited Classes from skillshare - https://skillshare.eqcm.net/r1KEj Data Science - http://bit.ly/2lD9h5L | http://bit.ly/2lI8wIl Machine Learning - http://bit.ly/2WGGQpb | http://bit.ly/2GghLXX Artificial Intelligence - http://bit.ly/2lYqaYx | http://bit.ly/2NmaPya MERN Stack E-Degree Program - http://bit.ly/2kx2NFe | http://bit.ly/2lWj4no DevOps E-degree - http://bit.ly/2k1PwUQ | http://bit.ly/2k8Ypfy Data Analytics with R - http://bit.ly/2lBKqz8 | http://bit.ly/2lAjos3 AWS Certification Training - http://bit.ly/2kmLtTu | http://bit.ly/2lAkQL1 Projects in Java - http://bit.ly/2kzn25d | http://bit.ly/2lBMffs Machine Learning With TensorFlow - http://bit.ly/2m1z3AF | http://bit.ly/2lBMhnA Angular 8 - Complete Essential Guide - http://bit.ly/2lYvYRP Kotlin Android Development Masterclass - http://bit.ly/2GcblsI Learn iOS Programming Building Advance Projects - http://bit.ly/2kyX7ue ★★★ Follow ★★★ My Website - http://www.codebind.com 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!

detail
{'title': 'Android SQLite Tutorial | Android CRUD Tutorial with SQLite (Create, Read, Update, Delete)', 'heatmap': [{'end': 1216.666, 'start': 1023.609, 'weight': 0.918}, {'end': 1972.996, 'start': 1869.165, 'weight': 0.731}, {'end': 3149.408, 'start': 3085.379, 'weight': 0.726}], 'summary': "This android sqlite tutorial covers creating, querying, and managing a sqlite database in an android application, including creating a 'student' table, demonstrating data insertion, updating, and deletion operations, and using alert dialogs for data manipulation, providing practical guidance for database management.", 'chapters': [{'end': 308.811, 'segs': [{'end': 134.767, 'src': 'embed', 'start': 1.043, 'weight': 0, 'content': [{'end': 4.726, 'text': 'Hello guys, welcome to Android Escalide database tutorial for beginners.', 'start': 1.043, 'duration': 3.683}, {'end': 11.631, 'text': "In this video series, I'm going to show you how you can get started with Escalide using Android.", 'start': 5.507, 'duration': 6.124}, {'end': 17.776, 'text': 'We will look in this video series how we can create a database.', 'start': 12.532, 'duration': 5.244}, {'end': 31.22, 'text': 'and perform some database queries like insertion, updation, or deletion, or other basic queries on SQLite database using Android.', 'start': 18.656, 'duration': 12.564}, {'end': 40.923, 'text': "So let's get started and let's see some important stuff regarding SQLite on Android.", 'start': 32.52, 'duration': 8.403}, {'end': 43.303, 'text': 'So, first of all, what is SQLite?', 'start': 41.963, 'duration': 1.34}, {'end': 56.451, 'text': "as you all know, SQLite is a database which is a open source database, so you can use it for free, and it's a relational database.", 'start': 45.544, 'duration': 10.907}, {'end': 65.336, 'text': "okay, and the most important feature about SQLite database is it's a local database,", 'start': 56.451, 'duration': 8.885}, {'end': 76.585, 'text': "so it doesn't require any server or any odbc or jdbc queries for query or connection for its, you know, functionality.", 'start': 65.336, 'duration': 11.249}, {'end': 78.046, 'text': "It's just.", 'start': 77.265, 'duration': 0.781}, {'end': 86.916, 'text': "you can say it saves its data into a text file and it's saved locally on your, you can say,", 'start': 78.046, 'duration': 8.87}, {'end': 93.163, 'text': 'mobile device or your tablet or whatever Android device you are using.', 'start': 86.916, 'duration': 6.247}, {'end': 99.188, 'text': 'And Android comes with the built-in Escalite database implementation.', 'start': 93.343, 'duration': 5.845}, {'end': 106.873, 'text': "So you don't need to install any extra libraries to use Escalite with Android.", 'start': 99.268, 'duration': 7.605}, {'end': 114.459, 'text': 'And the last point is to create, update a database.', 'start': 108.094, 'duration': 6.365}, {'end': 122.264, 'text': 'in your Android application, you can create a subclass of a class called Escalite, open helper.', 'start': 114.459, 'duration': 7.805}, {'end': 131.467, 'text': 'this is a class which will help us to create and, you know, manage our SQLite database.', 'start': 122.264, 'duration': 9.203}, {'end': 134.767, 'text': 'now enough of the theory.', 'start': 131.467, 'duration': 3.3}], 'summary': 'Tutorial introduces beginners to sqlite database for android, covering creation, queries, and escalite open helper class.', 'duration': 133.724, 'max_score': 1.043, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY1043.jpg'}], 'start': 1.043, 'title': 'Android sqlite database', 'summary': 'Covers the basics of sqlite database on android, including its features and the scope of the tutorial on creating and querying a database, emphasizing its open-source nature and its use as a local, relational database. it also discusses using sqlite database in android, highlighting its functionality, local data storage, and the process of creating and managing sqlite database in an android application.', 'chapters': [{'end': 65.336, 'start': 1.043, 'title': 'Android sqlite database tutorial', 'summary': 'Covers the basics of sqlite database on android, including its features and the scope of the tutorial on creating and querying a database, emphasizing its open-source nature and its use as a local, relational database.', 'duration': 64.293, 'highlights': ['SQLite is an open-source relational database, allowing free usage.', 'The tutorial series will cover creating and querying a database on Android, including insertion, updation, deletion, and basic queries.', 'SQLite is a local database, emphasizing its importance for local storage on Android devices.']}, {'end': 308.811, 'start': 65.336, 'title': 'Using sqlite database in android', 'summary': 'Discusses using sqlite database in android, highlighting its functionality, local data storage, and the process of creating and managing sqlite database in an android application.', 'duration': 243.475, 'highlights': ['Android comes with the built-in Escalite database implementation Android has a built-in Escalite database implementation, eliminating the need to install extra libraries for using Escalite with Android.', 'Process of creating and managing SQLite database in an Android application To create and manage the SQLite database in an Android application, a subclass of a class called Escalite open helper is created, which assists in handling the SQLite database.', 'Functionality of SQLite in Android SQLite in Android does not require any server or ODBC or JDBC queries for query or connection, saving data into a text file that is stored locally on the device.']}], 'duration': 307.768, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY1043.jpg', 'highlights': ['SQLite is an open-source relational database, allowing free usage.', 'The tutorial series will cover creating and querying a database on Android, including insertion, updation, deletion, and basic queries.', 'SQLite is a local database, emphasizing its importance for local storage on Android devices.', 'Android has a built-in Escalite database implementation, eliminating the need to install extra libraries for using Escalite with Android.', 'Process of creating and managing SQLite database in an Android application involves creating a subclass of a class called Escalite open helper.', 'SQLite in Android does not require any server or ODBC or JDBC queries for query or connection, saving data into a text file that is stored locally on the device.']}, {'end': 707.403, 'segs': [{'end': 381.829, 'src': 'embed', 'start': 346.098, 'weight': 1, 'content': [{'end': 349.56, 'text': 'first of all, we need a database name.', 'start': 346.098, 'duration': 3.462}, {'end': 361.323, 'text': "Now let's see how we can you know how we are going to create a database and what will be the name of our database and all other stuff?", 'start': 350.561, 'duration': 10.762}, {'end': 375.106, 'text': 'So, for this, for example, to start with, we are going to create a SQLite database like this and the name of the database will be student.db.', 'start': 362.163, 'duration': 12.943}, {'end': 381.829, 'text': 'The Escalite database is not case sensitive.', 'start': 375.286, 'duration': 6.543}], 'summary': 'Creating a sqlite database named student.db.', 'duration': 35.731, 'max_score': 346.098, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY346098.jpg'}, {'end': 449.468, 'src': 'embed', 'start': 412.347, 'weight': 0, 'content': [{'end': 417.75, 'text': 'and we are going to create database or insert some data like this.', 'start': 412.347, 'duration': 5.403}, {'end': 425.615, 'text': 'so id will can be one, two, three, four, for example, name, surnames and marks scored by this student.', 'start': 417.75, 'duration': 7.865}, {'end': 436.881, 'text': 'And in this video we will just see how we can create this database, which is student.db, and create the table, this table for our database.', 'start': 426.435, 'duration': 10.446}, {'end': 449.468, 'text': "Okay So, now what we are going to do is, let's declare some variables so that we can define the name of our database.", 'start': 437.261, 'duration': 12.207}], 'summary': 'Demonstrating creation of a student database with example data and variable declaration.', 'duration': 37.121, 'max_score': 412.347, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY412347.jpg'}, {'end': 661.286, 'src': 'embed', 'start': 627.182, 'weight': 2, 'content': [{'end': 630.425, 'text': 'So our database name is this variable, pass it here.', 'start': 627.182, 'duration': 3.243}, {'end': 634.929, 'text': 'Third is factory, we are going to pass null here.', 'start': 631.066, 'duration': 3.863}, {'end': 638.912, 'text': 'And the version, for example, version is equal to one.', 'start': 636.07, 'duration': 2.842}, {'end': 644.937, 'text': 'Now whenever this constructor is called, your database will be created.', 'start': 639.633, 'duration': 5.304}, {'end': 661.286, 'text': 'Okay, now, in order to create the table inside your database, we are going to create a table whenever this onCreate method of this class is called.', 'start': 646.061, 'duration': 15.225}], 'summary': 'Database name set, factory to null, table created on method call.', 'duration': 34.104, 'max_score': 627.182, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY627182.jpg'}], 'start': 308.811, 'title': 'Creating sqlite database and table', 'summary': "Demonstrates the process of creating a sqlite database named 'student.db' containing a table with four columns for student details and marks, and the creation of the table within the database, emphasizing the use of sqliteopenhelper and necessary methods.", 'chapters': [{'end': 707.403, 'start': 308.811, 'title': 'Creating sqlite database and table', 'summary': "Demonstrates the process of creating a sqlite database named 'student.db' containing a table with four columns for student details and marks, and the creation of the table within the database, emphasizing the use of sqliteopenhelper and necessary methods.", 'duration': 398.592, 'highlights': ["The database is named 'student.db' and contains four columns for student details and marks, with the table name set as 'student_data_table' and the column names defined as 'id', 'name', 'surname', and 'marks'.", "The process of creating the SQLite database involves defining the database name as 'student.db' and the table name as 'student_data_table', with the use of SQLiteOpenHelper constructor and the onCreate method to create the database and table with the necessary columns.", "The SQLite database is created using the constructor and the database name 'student.db', with the version set as 1, and the table is created using the onCreate method, executing the SQL query to create the table with the defined columns."]}], 'duration': 398.592, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY308811.jpg', 'highlights': ["The database is named 'student.db' and contains four columns for student details and marks, with the table name set as 'student_data_table' and the column names defined as 'id', 'name', 'surname', and 'marks'.", "The process of creating the SQLite database involves defining the database name as 'student.db' and the table name as 'student_data_table', with the use of SQLiteOpenHelper constructor and the onCreate method to create the database and table with the necessary columns.", "The SQLite database is created using the constructor and the database name 'student.db', with the version set as 1, and the table is created using the onCreate method, executing the SQL query to create the table with the defined columns."]}, {'end': 1128.091, 'segs': [{'end': 740.21, 'src': 'embed', 'start': 707.403, 'weight': 1, 'content': [{'end': 713.428, 'text': 'so it takes the string variable or a string query.', 'start': 707.403, 'duration': 6.025}, {'end': 724.517, 'text': "so here you can prepare your create table query and then, whenever it's called, it's going to execute this query and it's going to create this table.", 'start': 713.428, 'duration': 11.089}, {'end': 726.918, 'text': "okay, so let's write our query.", 'start': 724.517, 'duration': 2.401}, {'end': 740.21, 'text': 'for example, create the table name, so create table, And the table name in our case is this one', 'start': 726.918, 'duration': 13.292}], 'summary': 'A function that takes a string query to create a table in a database.', 'duration': 32.807, 'max_score': 707.403, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY707403.jpg'}, {'end': 879.235, 'src': 'embed', 'start': 844.388, 'weight': 0, 'content': [{'end': 854.551, 'text': 'For example, the third column will be surname and the data type is text for it also.', 'start': 844.388, 'duration': 10.163}, {'end': 858.993, 'text': 'And the fourth column is the marks column.', 'start': 855.772, 'duration': 3.221}, {'end': 867.108, 'text': "So marks and let's create it as integer.", 'start': 861.164, 'duration': 5.944}, {'end': 870.55, 'text': 'So we have created a table using this query.', 'start': 867.508, 'duration': 3.042}, {'end': 875.573, 'text': 'So this query is create table and your table name is student table.', 'start': 871.33, 'duration': 4.243}, {'end': 879.235, 'text': 'And in the brackets we have provided four columns to it.', 'start': 876.233, 'duration': 3.002}], 'summary': "Created a 'student table' with four columns: name, age, surname, and marks.", 'duration': 34.847, 'max_score': 844.388, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY844388.jpg'}, {'end': 1077.12, 'src': 'embed', 'start': 1049.682, 'weight': 2, 'content': [{'end': 1059.153, 'text': 'and now, in our onCreate method of mainActivity.java file, you can just create a new instance.', 'start': 1049.682, 'duration': 9.471}, {'end': 1066.118, 'text': 'so mydb, new and then new database helper.', 'start': 1059.153, 'duration': 6.965}, {'end': 1071.058, 'text': 'okay, and this takes one argument, which is the context.', 'start': 1066.118, 'duration': 4.94}, {'end': 1075.679, 'text': 'so you can just write this and everything will be fine.', 'start': 1071.058, 'duration': 4.621}, {'end': 1077.12, 'text': 'now, once everything is done,', 'start': 1075.679, 'duration': 1.441}], 'summary': 'In the oncreate method of mainactivity.java, create a new instance of mydb using new database helper with one argument, context.', 'duration': 27.438, 'max_score': 1049.682, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY1049682.jpg'}], 'start': 707.403, 'title': 'Creating database and table in android', 'summary': 'Explains creating a table in android using a string variable as a query, concatenation operator for column names, and exec sql to execute the query. it also covers the process of creating a sqlite database and table, including the use of the oncreate method and instantiation of the database helper class.', 'chapters': [{'end': 918.488, 'start': 707.403, 'title': 'Creating table query in android', 'summary': "Explains how to create a table in android using a string variable as a query, concatenation operator for column names, and the use of exec sql to execute the query, with an example of creating a 'student table' with four columns.", 'duration': 211.085, 'highlights': ['The chapter explains how to create a table in Android using a string variable as a query It describes the process of creating a table in Android using a string variable as a query.', "An example of creating a 'student table' with four columns It provides an example of creating a 'student table' with four columns: ID, name, surname, and marks.", 'Use of exec sql to execute the query It demonstrates the use of exec sql to execute the query for creating the table.', 'Concatenation operator for column names It explains the use of the concatenation operator for column names in the create table query.']}, {'end': 1128.091, 'start': 918.488, 'title': 'Creating sqlite database and table', 'summary': 'Explains the process of creating a sqlite database and table, including the use of the oncreate method, instantiation of the database helper class, and the call to the constructor for creating the database and table.', 'duration': 209.603, 'highlights': ['The chapter explains the process of creating a SQLite database and table.', 'It includes the use of the onCreate method and instantiation of the database helper class.', 'The constructor is called for creating the database and table.', 'The database and table are created once the constructor is called.']}], 'duration': 420.688, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY707403.jpg', 'highlights': ["An example of creating a 'student table' with four columns: ID, name, surname, and marks.", 'The chapter explains how to create a table in Android using a string variable as a query.', 'It includes the use of the onCreate method and instantiation of the database helper class.', 'Use of exec sql to execute the query for creating the table.']}, {'end': 1928.903, 'segs': [{'end': 1193.809, 'src': 'embed', 'start': 1164.498, 'weight': 2, 'content': [{'end': 1175.633, 'text': 'ok, so click android device monitor And once your Android device monitor is open, you will be able to find your project name in here.', 'start': 1164.498, 'duration': 11.135}, {'end': 1180.257, 'text': 'So my project name or my app name is SQLite App.', 'start': 1176.054, 'duration': 4.203}, {'end': 1182.92, 'text': 'And I can find my app here.', 'start': 1181.018, 'duration': 1.902}, {'end': 1185.482, 'text': 'You can see SQLite App.', 'start': 1183.62, 'duration': 1.862}, {'end': 1192.688, 'text': 'okay?. Once you select this, go to the right hand side and in here choose File Explorer.', 'start': 1185.482, 'duration': 7.206}, {'end': 1193.809, 'text': 'from here, okay?', 'start': 1192.688, 'duration': 1.121}], 'summary': 'Using android device monitor, find sqlite app in file explorer.', 'duration': 29.311, 'max_score': 1164.498, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY1164498.jpg'}, {'end': 1319.965, 'src': 'embed', 'start': 1285.536, 'weight': 1, 'content': [{'end': 1293.18, 'text': "So this is just for checking the content of your database by transferring this database to your local PC and see what's inside it.", 'start': 1285.536, 'duration': 7.644}, {'end': 1305.347, 'text': 'So just select your database, in my case student.db and you will be able to see this small button here which says pull a file from a device.', 'start': 1293.801, 'duration': 11.546}, {'end': 1306.228, 'text': 'So click this.', 'start': 1305.587, 'duration': 0.641}, {'end': 1319.965, 'text': "and it's going to open a file explorer and then you can select your chosen location and save it on your chosen location.", 'start': 1307.248, 'duration': 12.717}], 'summary': 'Transfer and check database content on local pc.', 'duration': 34.429, 'max_score': 1285.536, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY1285536.jpg'}, {'end': 1373.537, 'src': 'embed', 'start': 1340.714, 'weight': 3, 'content': [{'end': 1353.96, 'text': "One more helpful tool I'm going to show you in order to see inside this database and this tool is called SQLite Manager which is a Firefox plugin.", 'start': 1340.714, 'duration': 13.246}, {'end': 1358.662, 'text': "So if you have a Firefox browser, it's going to help you a lot.", 'start': 1354.54, 'duration': 4.122}, {'end': 1373.537, 'text': 'what you can do is you can open your Firefox browser and go to the settings here and go to add-ons and search for add-on called SQLite,', 'start': 1359.322, 'duration': 14.215}], 'summary': 'Firefox users can use sqlite manager tool to access and manage databases in firefox browser.', 'duration': 32.823, 'max_score': 1340.714, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY1340714.jpg'}, {'end': 1490.607, 'src': 'embed', 'start': 1459.524, 'weight': 0, 'content': [{'end': 1465.69, 'text': 'you can see so the database content you can see using this SQLite manager.', 'start': 1459.524, 'duration': 6.166}, {'end': 1470.531, 'text': 'Okay, so this is a simple little trick which you can use.', 'start': 1466.368, 'duration': 4.163}, {'end': 1478.117, 'text': 'In the last video we have seen how we can create a database which is a SQLite database using Android.', 'start': 1471.252, 'duration': 6.865}, {'end': 1487.684, 'text': 'Now in this video we are going to see how we can insert some data into our table inside that SQLite database.', 'start': 1479.018, 'duration': 8.666}, {'end': 1490.607, 'text': "So let's get started.", 'start': 1489.045, 'duration': 1.562}], 'summary': 'Demonstrating insertion of data into a sqlite database in android.', 'duration': 31.083, 'max_score': 1459.524, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY1459524.jpg'}], 'start': 1128.091, 'title': 'Sqlite database management in android studio', 'summary': 'Covers locating the sqlite database in android studio, exporting it to a local pc, and viewing its content using sqlite manager. it also demonstrates inserting data into the table, providing practical guidance for database management.', 'chapters': [{'end': 1219.649, 'start': 1128.091, 'title': 'Checking sqlite database location', 'summary': "Demonstrates how to locate the sqlite database created in android studio by navigating through the android device monitor and accessing the project's data folder, revealing the database's location and project name.", 'duration': 91.558, 'highlights': ["The Android Device Monitor is accessed by navigating to the 'Tool' tab, then 'Android' and clicking on 'Android Device Monitor', where the project name can be found under the File Explorer, aiding in locating the SQLite database.", "To check the location of the SQLite database, one needs to navigate through the Android Device Monitor to locate the project name, such as 'SQLite App', within the 'data' category and folder, and then further within the 'data' folder under 'SQLite App'."]}, {'end': 1928.903, 'start': 1219.649, 'title': 'Export and view sqlite database', 'summary': 'Demonstrates how to export an sqlite database from an android device to a local pc, view its content using sqlite manager, and insert data into the table.', 'duration': 709.254, 'highlights': ['The chapter demonstrates how to export an SQLite database from an Android device to a local PC. The process involves selecting the database file, pulling it from the device, and saving it to the desired location.', 'The chapter explains how to view the SQLite database content using SQLite Manager, a Firefox plugin. The process includes installing the SQLite Manager plugin, opening it from the Firefox browser, and browsing the database to view its content and structure.', 'The chapter provides guidance on inserting data into the SQLite table from an Android app. The method involves designing the UI in the activity main.xml file, creating a method to insert data, and using the DB instance to insert data with error handling.']}], 'duration': 800.812, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY1128091.jpg', 'highlights': ['The chapter provides guidance on inserting data into the SQLite table from an Android app, involving designing the UI, creating a method to insert data, and using the DB instance for insertion with error handling.', 'The process of exporting an SQLite database from an Android device to a local PC is demonstrated, involving selecting the database file, pulling it from the device, and saving it to the desired location.', "To check the location of the SQLite database, one needs to navigate through the Android Device Monitor to locate the project name within the 'data' category and folder, aiding in locating the SQLite database.", 'The chapter explains how to view the SQLite database content using SQLite Manager, a Firefox plugin, including the process of installing the plugin, opening it from the Firefox browser, and browsing the database to view its content and structure.']}, {'end': 2884.948, 'segs': [{'end': 2059.496, 'src': 'embed', 'start': 1929.183, 'weight': 0, 'content': [{'end': 1936.389, 'text': 'Now once this method is created, we can just go to our main activity.java file here.', 'start': 1929.183, 'duration': 7.206}, {'end': 1947.533, 'text': 'and in here we can define three edit text variables because we have created in our design edit text.', 'start': 1937.587, 'duration': 9.946}, {'end': 1954.538, 'text': 'so we are going to create three variables for edit text and one variable for our button.', 'start': 1947.533, 'duration': 7.005}, {'end': 1972.996, 'text': 'okay, Once these three variables are created, what we are going to do is, inside our onCreate method,', 'start': 1954.538, 'duration': 18.458}, {'end': 1978.182, 'text': 'we are going to cast all these four variables three editText and one button.', 'start': 1972.996, 'duration': 5.186}, {'end': 2000.065, 'text': 'Now, once our casting is done, we can use this button add data variable to call some action right?', 'start': 1990.731, 'duration': 9.334}, {'end': 2001.728, 'text': 'So what we are going to do?', 'start': 2000.546, 'duration': 1.182}, {'end': 2017.926, 'text': 'we are going to create a method public void, add data and inside this method we can take this button add variable and call setOnClick method.', 'start': 2001.728, 'duration': 16.198}, {'end': 2026.367, 'text': 'So setOnClick method and in here new OnClick listener.', 'start': 2018.386, 'duration': 7.981}, {'end': 2035.129, 'text': 'Now inside this OnClick method what we can do is we can call our insert data method here.', 'start': 2027.127, 'duration': 8.002}, {'end': 2045.752, 'text': 'Using the instance of this data helper Class so in the last video we have created this instance my data.', 'start': 2036.669, 'duration': 9.083}, {'end': 2054.074, 'text': 'So just take this dot Insert data now as an argument for this insert data.', 'start': 2046.412, 'duration': 7.662}, {'end': 2059.496, 'text': 'We need three Arguments, right, so we can see.', 'start': 2054.435, 'duration': 5.061}], 'summary': 'In the main activity file, three edit text variables and one button variable are created and casted, and a method to add data is defined.', 'duration': 130.313, 'max_score': 1929.183, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY1929183.jpg'}, {'end': 2319.476, 'src': 'embed', 'start': 2293.207, 'weight': 4, 'content': [{'end': 2298.55, 'text': 'So we are going to create some code to display the data using some button.', 'start': 2293.207, 'duration': 5.343}, {'end': 2306.944, 'text': 'in the last video, we have seen how to insert data into sqlite database using android.', 'start': 2299.798, 'duration': 7.146}, {'end': 2317.734, 'text': 'in this video, we will see how we can get all data from sqlite database table and show it on your android.', 'start': 2306.944, 'duration': 10.79}, {'end': 2319.476, 'text': "so let's get started.", 'start': 2317.734, 'duration': 1.742}], 'summary': 'Creating code to display data using buttons, retrieving all data from sqlite database in android.', 'duration': 26.269, 'max_score': 2293.207, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY2293207.jpg'}], 'start': 1929.183, 'title': 'Android app data entry and sqlite database insertion', 'summary': 'Provides a tutorial on creating and using edit text variables, casting variables in the oncreate method, implementing a method to add data using setonclick method, and inserting data with three arguments. it also describes the process of inserting data into an sqlite database, including creating a method to insert data, checking successful insertion, and querying the database to display all the data on the android app.', 'chapters': [{'end': 2059.496, 'start': 1929.183, 'title': 'Android app data entry tutorial', 'summary': 'Explains how to create and use edit text variables, cast variables in the oncreate method, and implement a method to add data using setonclick method and insert data with three arguments.', 'duration': 130.313, 'highlights': ['The chapter explains how to create and use edit text variables, cast variables in the onCreate method, and implement a method to add data using setOnClick method and insert data with three arguments.', 'The method involves creating three edit text variables and one variable for the button in the main activity.java file.', 'The chapter also demonstrates the process of casting all four variables, including three editText and one button, inside the onCreate method.', "The method 'add data' is created as public void, and it calls setOnClick method to implement new OnClick listener and insert data with three arguments using the instance of the data helper Class."]}, {'end': 2884.948, 'start': 2059.496, 'title': 'Insert data into sqlite database', 'summary': 'Describes the process of inserting data into an sqlite database in an android app, including creating a method to insert data, checking if the data is successfully inserted, and running the app to confirm the insertion. it also outlines the steps for querying the database to display all the data on the android app.', 'duration': 825.452, 'highlights': ['The chapter describes the process of inserting data into an SQLite database in an Android app. It includes creating a method to insert data, checking if the data is successfully inserted, and running the app to confirm the insertion.', 'The steps for querying the database to display all the data on the Android app are outlined. The process involves creating a method to get all the table data and using a cursor class to access the database.']}], 'duration': 955.765, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY1929183.jpg', 'highlights': ['The chapter explains how to create and use edit text variables, cast variables in the onCreate method, and implement a method to add data using setOnClick method and insert data with three arguments.', 'The method involves creating three edit text variables and one variable for the button in the main activity.java file.', 'The chapter also demonstrates the process of casting all four variables, including three editText and one button, inside the onCreate method.', "The method 'add data' is created as public void, and it calls setOnClick method to implement new OnClick listener and insert data with three arguments using the instance of the data helper Class.", 'The chapter describes the process of inserting data into an SQLite database in an Android app. It includes creating a method to insert data, checking if the data is successfully inserted, and running the app to confirm the insertion.', 'The steps for querying the database to display all the data on the Android app are outlined. The process involves creating a method to get all the table data and using a cursor class to access the database.']}, {'end': 3256.495, 'segs': [{'end': 3055.724, 'src': 'embed', 'start': 2884.968, 'weight': 0, 'content': [{'end': 2886.069, 'text': "So let's write a comment.", 'start': 2884.968, 'duration': 1.101}, {'end': 2906.275, 'text': "so let's create a new method, which will be also a public method, and it will return nothing so void, and the method name will be show message.", 'start': 2888.26, 'duration': 18.015}, {'end': 2915.74, 'text': "it's going to take two argument First is the title and second is the message itself.", 'start': 2906.275, 'duration': 9.465}, {'end': 2921.244, 'text': 'Okay, so string message.', 'start': 2916.481, 'duration': 4.763}, {'end': 2929.33, 'text': 'And in here we are going to create an instance of alert dialog builder.', 'start': 2924.727, 'duration': 4.603}, {'end': 2935.335, 'text': 'So just write alert dialog dot builder.', 'start': 2929.49, 'duration': 5.845}, {'end': 2947.088, 'text': 'And we will name it as builder is equal to new alert dialog dot builder.', 'start': 2938.42, 'duration': 8.668}, {'end': 2952.193, 'text': 'And it takes the argument, which is the context.', 'start': 2948.169, 'duration': 4.024}, {'end': 2961.74, 'text': 'So this itself and using this builder, we can create a alert dialog.', 'start': 2952.774, 'duration': 8.966}, {'end': 2969.871, 'text': 'okay, so we can set our title and set message using this builder to alert dialog.', 'start': 2961.74, 'duration': 8.131}, {'end': 2970.952, 'text': "so let's create.", 'start': 2969.871, 'duration': 1.081}, {'end': 2978.903, 'text': "First of all, let's use this builder to set cancel label.", 'start': 2972.677, 'duration': 6.226}, {'end': 2986.109, 'text': "So set is as cancel label so that, uh, we can cancel it after it's use.", 'start': 2979.043, 'duration': 7.066}, {'end': 2989.052, 'text': 'And then we will set the title.', 'start': 2986.77, 'duration': 2.282}, {'end': 2999.561, 'text': 'So builder dot set title and title will be the title, which we get from this argument.', 'start': 2989.072, 'duration': 10.489}, {'end': 3004.369, 'text': 'and then we will set the message.', 'start': 3001.286, 'duration': 3.083}, {'end': 3021.005, 'text': 'so builder.setMessage, and message will be this message which we will get in the argument okay, and then we can just call show method on this.', 'start': 3004.369, 'duration': 16.636}, {'end': 3023.227, 'text': 'builder. this will show our dialogue.', 'start': 3021.005, 'duration': 2.222}, {'end': 3026.963, 'text': 'okay dialogue or alert dialogue.', 'start': 3024.201, 'duration': 2.762}, {'end': 3028.565, 'text': "so let's just copy this.", 'start': 3026.963, 'duration': 1.602}, {'end': 3030.106, 'text': 'so show message.', 'start': 3028.565, 'duration': 1.541}, {'end': 3031.647, 'text': 'function here.', 'start': 3030.106, 'duration': 1.541}, {'end': 3038.813, 'text': 'and first of all, if no data is found, what we are going to do is we are going to show some message,', 'start': 3031.647, 'duration': 7.166}, {'end': 3055.724, 'text': 'so the title of this message box will be error and we will display nothing Found, or you can say no data found.', 'start': 3038.813, 'duration': 16.911}], 'summary': "Creating a public method 'show message' with 'title' and 'message' arguments. utilizing 'alert dialog builder' to display error message if no data found.", 'duration': 170.756, 'max_score': 2884.968, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY2884968.jpg'}, {'end': 3191.448, 'src': 'heatmap', 'start': 3085.379, 'weight': 4, 'content': [{'end': 3092.488, 'text': 'One more thing which remains is we need to call this view all method inside our own create method.', 'start': 3085.379, 'duration': 7.109}, {'end': 3101.578, 'text': 'So just copy this view all method and paste it inside your own create method of your main activity.', 'start': 3092.528, 'duration': 9.05}, {'end': 3104.081, 'text': "Okay Now let's run our program.", 'start': 3102.079, 'duration': 2.002}, {'end': 3116.027, 'text': 'so our app is running now and when we click this view all button, we will be able to see the data.', 'start': 3107.665, 'duration': 8.362}, {'end': 3130.591, 'text': "so right now we only have one student data, so it's showing id1 and name, surname and age, and we can add some more data for the student.", 'start': 3116.027, 'duration': 14.564}, {'end': 3142.785, 'text': "and let's add this second student data here.", 'start': 3138.963, 'duration': 3.822}, {'end': 3149.408, 'text': "and i'm going to click this add data button and data is inserted and now view all the data.", 'start': 3142.785, 'duration': 6.623}, {'end': 3153.15, 'text': 'and now we have two student data id1 and id2.', 'start': 3149.408, 'duration': 3.742}, {'end': 3165.727, 'text': 'okay, So in this way you can insert some more data and then, using this view all button, you will be able to see all the data here.', 'start': 3153.15, 'duration': 12.577}, {'end': 3174.495, 'text': 'And in this video we will see how we can update data in SQLite database using our Android app.', 'start': 3166.348, 'duration': 8.147}, {'end': 3180.96, 'text': 'Till now we have seen how to insert data into the SQLite database and how to view it.', 'start': 3175.355, 'duration': 5.605}, {'end': 3188.986, 'text': "and let's add one more button here, and this button we are going to use to update the data.", 'start': 3182.041, 'duration': 6.945}, {'end': 3191.448, 'text': "so I'm going to change the name as update.", 'start': 3188.986, 'duration': 2.462}], 'summary': 'Demonstration of inserting, viewing, and updating data in sqlite database using an android app.', 'duration': 52.485, 'max_score': 3085.379, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY3085379.jpg'}, {'end': 3256.495, 'src': 'embed', 'start': 3228.833, 'weight': 6, 'content': [{'end': 3239.101, 'text': 'so if you want to change the name of one person Which shares the name with the other person, then the data can be changed for both the names.', 'start': 3228.833, 'duration': 10.268}, {'end': 3246.747, 'text': "if you don't know What is the unique? You know row or unique column in this?", 'start': 3239.101, 'duration': 7.646}, {'end': 3256.495, 'text': 'Okay, so ID we have defined as a unique column for this database table.', 'start': 3247.287, 'duration': 9.208}], 'summary': 'Data can be changed for both names if they share the same name, and the id is defined as a unique column for the database table.', 'duration': 27.662, 'max_score': 3228.833, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY3228833.jpg'}], 'start': 2884.968, 'title': 'Creating alert dialog in java and sqlite database data manipulation', 'summary': 'Demonstrates creating a method to show message in an alert dialog, and displaying, inserting, and updating data in an sqlite database using an android app, emphasizing the need for a unique reference, such as the id column, for updating data.', 'chapters': [{'end': 3021.005, 'start': 2884.968, 'title': 'Creating alert dialog in java', 'summary': "Demonstrates creating a method called 'show message' which takes two arguments, sets a title and a message for an alert dialog, and then displays the dialog using the show method.", 'duration': 136.037, 'highlights': ["The method 'show message' is created as a public method that takes two arguments: title and message.", "An instance of alert dialog builder is created using 'new alert dialog dot builder'.", "The title and message for the alert dialog are set using 'builder.setTitle' and 'builder.setMessage' respectively.", "The alert dialog is displayed using the 'show' method."]}, {'end': 3256.495, 'start': 3021.005, 'title': 'Sqlite database data manipulation', 'summary': 'Demonstrates how to display, insert, and update data in an sqlite database using an android app, with a focus on showing message boxes, inserting data, and updating data. it also emphasizes the importance of having a unique reference for updating data, such as the id column.', 'duration': 235.49, 'highlights': ['The chapter covers displaying, inserting, and updating data in an SQLite database using an Android app.', 'The process includes showing message boxes for error and data found cases, inserting new data, and viewing all existing data.', 'Emphasizes the need for a unique reference, such as the ID column, for updating data to avoid unintended modifications.']}], 'duration': 371.527, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY2884968.jpg', 'highlights': ["The method 'show message' is created as a public method that takes two arguments: title and message.", "An instance of alert dialog builder is created using 'new alert dialog dot builder'.", "The title and message for the alert dialog are set using 'builder.setTitle' and 'builder.setMessage' respectively.", "The alert dialog is displayed using the 'show' method.", 'The chapter covers displaying, inserting, and updating data in an SQLite database using an Android app.', 'The process includes showing message boxes for error and data found cases, inserting new data, and viewing all existing data.', 'Emphasizes the need for a unique reference, such as the ID column, for updating data to avoid unintended modifications.']}, {'end': 3939.371, 'segs': [{'end': 3324.819, 'src': 'embed', 'start': 3256.495, 'weight': 0, 'content': [{'end': 3267.104, 'text': "So what I'm going to do is I'm going to quickly add this ID Text view, and, you know, added text so that we can enter the ID also.", 'start': 3256.495, 'duration': 10.609}, {'end': 3272.869, 'text': 'so now I have added this ID, added text and Text you here right?', 'start': 3267.104, 'duration': 5.765}, {'end': 3275.572, 'text': 'now we are good to go.', 'start': 3273.63, 'duration': 1.942}, {'end': 3287.201, 'text': 'so next thing you need to do is we need to create a function in our database helper.java class, which we have created in the last videos.', 'start': 3275.572, 'duration': 11.629}, {'end': 3297.749, 'text': "so let's go to database helper.java file and in here, till now we have created insert data and get all data functions right.", 'start': 3287.201, 'duration': 10.548}, {'end': 3304.694, 'text': 'we will create one more function here and we will call it as update data.', 'start': 3297.749, 'duration': 6.945}, {'end': 3309.515, 'text': 'okay, so it will be public and it will return boolean.', 'start': 3304.694, 'duration': 4.821}, {'end': 3312.896, 'text': 'so we need to know if the data is really updated or not.', 'start': 3309.515, 'duration': 3.381}, {'end': 3324.819, 'text': 'so we are going to return boolean and we say this uh, function name is update data.', 'start': 3312.896, 'duration': 11.923}], 'summary': 'Adding id text view, creating update data function in database helper.java', 'duration': 68.324, 'max_score': 3256.495, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY3256495.jpg'}, {'end': 3719.659, 'src': 'embed', 'start': 3680.952, 'weight': 3, 'content': [{'end': 3689.899, 'text': 'so dot, set on click listener and inside this new on click listener.', 'start': 3680.952, 'duration': 8.947}, {'end': 3700.788, 'text': 'and inside this we just need to, uh, call our update function from our database helper.', 'start': 3689.899, 'duration': 10.889}, {'end': 3703.89, 'text': 'so this was update function.', 'start': 3700.788, 'duration': 3.102}, {'end': 3706.571, 'text': 'the name was little bit wrong.', 'start': 3703.89, 'duration': 2.681}, {'end': 3711.274, 'text': "so let's update, make it update function right.", 'start': 3706.571, 'duration': 4.703}, {'end': 3719.659, 'text': 'and now what we are going to do is in our main activity.java file, inside this on click method,', 'start': 3711.274, 'duration': 8.385}], 'summary': 'Updating the update function in the database helper from the main activity file.', 'duration': 38.707, 'max_score': 3680.952, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY3680952.jpg'}, {'end': 3899.192, 'src': 'embed', 'start': 3859, 'weight': 6, 'content': [{'end': 3867.522, 'text': 'we have called our update data function and we have passed whatever we are getting from edit text right?', 'start': 3859, 'duration': 8.522}, {'end': 3878.006, 'text': 'now, if this function returns true, which is update data, then so we will check.', 'start': 3869.002, 'duration': 9.004}, {'end': 3889.771, 'text': 'if of is update is equal to true, then what we are going to do?', 'start': 3878.006, 'duration': 11.765}, {'end': 3899.192, 'text': 'we are going to show some message right so we can take these messages from our last video.', 'start': 3889.771, 'duration': 9.421}], 'summary': 'The update data function is called with input from edit text. if it returns true, a message will be displayed.', 'duration': 40.192, 'max_score': 3859, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY3859000.jpg'}], 'start': 3256.495, 'title': 'Updating data in sqlite database', 'summary': "Covers quickly adding an id text view for entering the id, creating an 'update data' function in the database helper.java class, emphasizing the function's return type as boolean for determining successful data update. it also explains the process of updating data in a sqlite database by passing four arguments and creating an update function in the main activity.java file, including declaring a button variable, casting the button instance, creating a public update data function, and passing arguments through edit text variables to the update data method.", 'chapters': [{'end': 3324.819, 'start': 3256.495, 'title': 'Adding id text view and creating update data function', 'summary': "Covers quickly adding an id text view for entering the id, creating an 'update data' function in the database helper.java class, and emphasizing the function's return type as boolean for determining successful data update.", 'duration': 68.324, 'highlights': ["Emphasizing the need for creating an 'update data' function with a boolean return type for determining successful data update", 'Adding an ID Text view to enable entering the ID for data manipulation', "Prompting the creation of the 'update data' function within the database helper.java class"]}, {'end': 3939.371, 'start': 3324.819, 'title': 'Updating data in sqlite database', 'summary': 'Explains the process of updating data in a sqlite database by passing four arguments and creating an update function in the main activity.java file, including declaring a button variable, casting the button instance, creating a public update data function, and passing arguments through edit text variables to the update data method.', 'duration': 614.552, 'highlights': ['The chapter explains the process of updating data in a SQLite database by passing four arguments and creating an update function in the main activity.java file, including declaring a button variable, casting the button instance, creating a public update data function, and passing arguments through edit text variables to the update data method. Explains the process of updating data in a SQLite database, creating an update function in the main activity.java file, and passing arguments through edit text variables.', 'The function update data is created in the main activity.java file to update data in the SQLite database, and it takes no arguments. Creation of the update data function in the main activity.java file.', 'The on click listener is called on the update button, and the update function from the database helper is invoked. Invoking the update function from the database helper.', 'The update data function is passed the values from the edit text fields for ID, name, surname, and marks. Passing values from the edit text fields to the update data function.', 'A boolean variable is used to check if the data is updated, and messages are shown based on the result. Using a boolean variable to check if the data is updated and showing messages based on the result.']}], 'duration': 682.876, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY3256495.jpg', 'highlights': ["Emphasizing the need for creating an 'update data' function with a boolean return type for determining successful data update", 'Adding an ID Text view to enable entering the ID for data manipulation', "Prompting the creation of the 'update data' function within the database helper.java class", 'The chapter explains the process of updating data in a SQLite database by passing four arguments and creating an update function in the main activity.java file, including declaring a button variable, casting the button instance, creating a public update data function, and passing arguments through edit text variables to the update data method. Explains the process of updating data in a SQLite database, creating an update function in the main activity.java file, and passing arguments through edit text variables.', 'The function update data is created in the main activity.java file to update data in the SQLite database, and it takes no arguments. Creation of the update data function in the main activity.java file.', 'The on click listener is called on the update button, and the update function from the database helper is invoked. Invoking the update function from the database helper.', 'The update data function is passed the values from the edit text fields for ID, name, surname, and marks. Passing values from the edit text fields to the update data function.', 'A boolean variable is used to check if the data is updated, and messages are shown based on the result. Using a boolean variable to check if the data is updated and showing messages based on the result.']}, {'end': 4664.126, 'segs': [{'end': 3993.514, 'src': 'embed', 'start': 3968.118, 'weight': 1, 'content': [{'end': 3974.642, 'text': 'one is ID 1 and name is Mark and surname is Benson and second is Tom.', 'start': 3968.118, 'duration': 6.524}, {'end': 3981.407, 'text': 'right. for example, I want to update the first letter of the name, Mark.', 'start': 3974.642, 'duration': 6.765}, {'end': 3988.031, 'text': 'I want capital M here instead of small m, and same I want to do for this Benson here.', 'start': 3981.407, 'duration': 6.624}, {'end': 3990.372, 'text': 'right, so what we are going to do?', 'start': 3988.391, 'duration': 1.981}, {'end': 3993.514, 'text': 'we are going to just write the name here.', 'start': 3990.372, 'duration': 3.142}], 'summary': "Update id 1's name to capitalize first letters.", 'duration': 25.396, 'max_score': 3968.118, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY3968118.jpg'}, {'end': 4086.538, 'src': 'embed', 'start': 4052.586, 'weight': 2, 'content': [{'end': 4059.032, 'text': 'And in this video we will see how to delete data in SQLite database using our Android app.', 'start': 4052.586, 'duration': 6.446}, {'end': 4061.394, 'text': "So let's get started.", 'start': 4060.373, 'duration': 1.021}, {'end': 4067.64, 'text': 'Till now we have seen how to insert data, how to update data and how to view data in Escalite database.', 'start': 4061.474, 'duration': 6.166}, {'end': 4074.567, 'text': "So let's add a new button and we will call this button as delete data.", 'start': 4068.281, 'duration': 6.286}, {'end': 4086.538, 'text': "So let's change the text of this button as delete, and the button ID will change it to button delete.", 'start': 4075.128, 'duration': 11.41}], 'summary': 'Demonstrating how to delete data in sqlite using android app', 'duration': 33.952, 'max_score': 4052.586, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY4052586.jpg'}, {'end': 4275.896, 'src': 'embed', 'start': 4246.165, 'weight': 0, 'content': [{'end': 4249.246, 'text': 'or number of rows which are deleted.', 'start': 4246.165, 'duration': 3.081}, {'end': 4254.607, 'text': 'otherwise, if no data is deleted, it returns zero.', 'start': 4249.246, 'duration': 5.361}, {'end': 4264.89, 'text': 'okay, so we are going to use this return integer to check how many rows are affected or if any rows are affected or not,', 'start': 4254.607, 'duration': 10.283}, {'end': 4269.492, 'text': 'and on the basis of this we can print the result right.', 'start': 4264.89, 'duration': 4.602}, {'end': 4272.074, 'text': 'so we will come back to our database helper class.', 'start': 4269.492, 'duration': 2.582}, {'end': 4275.896, 'text': 'and first argument, we will pass it as the table name.', 'start': 4272.074, 'duration': 3.822}], 'summary': 'The function returns the number of rows deleted or zero if no data is deleted.', 'duration': 29.731, 'max_score': 4246.165, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY4246165.jpg'}], 'start': 3940.839, 'title': 'Sqlite database operations in android', 'summary': 'Demonstrates updating and deleting data in an sqlite database using an android app with examples of modifying names and surnames and deleting data based on unique id, successfully showing the number of affected rows in each case.', 'chapters': [{'end': 4664.126, 'start': 3940.839, 'title': 'Sqlite database operations in android', 'summary': 'Demonstrates how to update and delete data in an sqlite database using an android app, with examples of updating data by changing the first letter of a name and surname, and deleting data based on the unique id. the program successfully updates and deletes data, showing the number of affected rows in each case.', 'duration': 723.287, 'highlights': ['The program successfully updates and deletes data, showing the number of affected rows in each case. The program demonstrates successful data update and deletion, displaying the number of affected rows, such as when the first letter of a name and surname is updated, and when data is deleted based on the unique ID.', 'Examples of updating data by changing the first letter of a name and surname are provided. The chapter provides examples of updating data by changing the first letter of a name and surname, demonstrating the process of editing data based on the unique ID and showing the successful update of data.', 'The chapter demonstrates how to update and delete data in an SQLite database using an Android app. The chapter illustrates the process of updating and deleting data in an SQLite database via an Android app, employing functions such as updating the first letter of a name and deleting data based on the unique ID.']}], 'duration': 723.287, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kDZES1wtKUY/pics/kDZES1wtKUY3940839.jpg', 'highlights': ['The program successfully updates and deletes data, showing the number of affected rows in each case.', 'The chapter provides examples of updating data by changing the first letter of a name and surname, demonstrating the process of editing data based on the unique ID and showing the successful update of data.', 'The chapter illustrates the process of updating and deleting data in an SQLite database via an Android app, employing functions such as updating the first letter of a name and deleting data based on the unique ID.']}], 'highlights': ['The tutorial series will cover creating and querying a database on Android, including insertion, updation, deletion, and basic queries.', 'The process of creating and managing SQLite database in an Android application involves creating a subclass of a class called Escalite open helper.', 'The chapter explains how to create a table in Android using a string variable as a query.', 'The chapter provides guidance on inserting data into the SQLite table from an Android app, involving designing the UI, creating a method to insert data, and using the DB instance for insertion with error handling.', 'The chapter explains how to view the SQLite database content using SQLite Manager, a Firefox plugin, including the process of installing the plugin, opening it from the Firefox browser, and browsing the database to view its content and structure.', 'The chapter explains how to create and use edit text variables, cast variables in the onCreate method, and implement a method to add data using setOnClick method and insert data with three arguments.', "The method 'add data' is created as public void, and it calls setOnClick method to implement new OnClick listener and insert data with three arguments using the instance of the data helper Class.", "The method 'show message' is created as a public method that takes two arguments: title and message.", 'The chapter covers displaying, inserting, and updating data in an SQLite database using an Android app.', "Emphasizing the need for creating an 'update data' function with a boolean return type for determining successful data update", 'The chapter provides examples of updating data by changing the first letter of a name and surname, demonstrating the process of editing data based on the unique ID and showing the successful update of data.']}