SQLite: Mastering Android SQLite Database Development

Name: SQLite: Mastering Android SQLite Database Development
Rating: 2.5 (2 reviews)

Unlock the power of SQLite for seamless Android and iOS app development!

Created byEDUCBA Bridging the Gap

Last updated 6/2024

English

What you'll learn

Understand the fundamentals of SQLite databases and their applications in Android development.
Create, insert, update, and delete database tables and records within Android and iOS applications.
Implement database operations using SQLiteOpenHelper for efficient data management.
Design user interfaces for displaying and managing database records in Android apps.
Copy and utilize pre-defined databases from assets in Android applications.
Perform CRUD (Create, Read, Update, Delete) operations with SQLite in iOS 12.
Manage data storage and retrieval using SQLite in both Android and iOS environments.
Develop a complete Android login application using SQLite for data validation and navigation.
Explore the limitations and best practices of using SQLite for mobile app data storage.
Create a Python-based expense manager app with data plotting and custom category features using SQLite.

Course content

4 sections • 66 lectures • 10h 8m total length

Introduction to Sqlite Database7:16
Discover how Android's built-in SQLite database, stored as a text file, operates without JDBC/ODBC and how to open or create databases, execute SQL, and fetch data.
Example to Sqlite Database9:39
Table create and Insert Data in Sqlite Data Base12:03
Running Demo and Export Sqlite File10:21
Data Base Data Listing UI9:57
Implementing Code for Listing9:34
Convert Student List to Custom List9:17
Running Demo of Student List8:02
Sqlite Update Operation11:30
Update Values Setup8:23
Copy Predefine Data Base from Assets9:01
Implementation of Copy Predefine Data Base from Assets8:56
Learn to copy a predefined Android SQLite database from assets to internal storage by implementing an application class, asset manager usage, and a copy method.
Implement Copy Assets to Internal Storage8:48
UI Design for Login Application9:24
Make Query on Internal Storage Database10:26
Implements an on click listener for the login button, validates the username and password, queries the user information table in SQLite, and navigates to a welcome screen on success.
Validating and Navigate to Welcome Screen9:06
Sqlite Open Helper Basic Introduction11:32
Implementing Sqlite Open Helper9:18
Operation with Sqlite Open Helper10:02
Operation with Sqlite Open Helper Continues9:41
Add Contacts Data in Database Using Open Helper7:21
More on in Database Using Open Helper6:57
Master Android SQLite databases by implementing a database helper to add contacts with name and phone number, validate input, show toasts, run the app, and inspect data.
Display Data List Click with Confirm Alert8:01
Delete Data List Click with Confirm Alert11:04
Update Data with Custom Alert Dialog6:35
Refresh List with Custom Alert Dialog5:59

Introduction to Sqlite Database8:45
About Sqlite Database5:15
Create Sqlite Project Setup11:37
Create and configure an Android SQLite database with a DB helper class, implement onCreate and onUpgrade, define an employee table (id, name, designation), and insert/display data in a list view.
Add and Fetch Record9:40
Update Record8:19
Deleted Records7:04
Delete an employee record in android sqlite by id using the writable database and delete method, while noting the helper class, table schema (id, name, designation), and insert workflow.
Export DB8:05

Data storage using SQLite in iOS 126:50
Basic Concepts of UITable View13:22
UIAlert Controller Alert5:31
How to Create Database12:02
Table using SQLite Commands6:37
Prepare Query9:28
Execute Queries to Insert Values Into Table6:27
How to Create a Model Class6:02
Create a model class named checklist task with id, task, and status; insert and read records from a SQLite database using prepared statements.
Prepare Query and Traverse9:17
Write Update Query9:12
Create Attributed String11:31
Table with Strike Through Effect8:37
Learn to display strikethrough for tasks and manage their state in Android SQLite by updating, selecting, and deleting rows in a table view.
Execute Queries to Delete Values12:04
Understand limitation of SQLite1:29

Introduction to Project10:36
Expense Form Creation Part 17:52
Expense Form Creation Part 29:10
Expense Form Creation Part 39:21
Saving Expense Data11:52
Submit a form with post method to capture expense fields using request.form and save them to a SQLite database. Create an expenses table with id, category, amount, and date.
Saving Expense Data Continue9:33
Categories and Date7:15
Categories and Date Continue12:03
More on Categories and Date9:49
Adding Custom Category Part 112:22
Adding Custom Category Part 210:21
Insert a new category when 'other' is selected, obtain its id with last row id, and save the expense using that category id, date, and amount.
Adding Custom Category Part 36:08
Plotting Data on Chart Part 19:22
Retrieve expense data from a database and visualize it with matplotlib pie charts, while setting up a report module and bootstrap navigation in html templates.
Plotting Data on Chart Part 212:28
Plotting Data on Chart Part 310:39
Different Data Part 110:14
Learn to implement interval based reports in an Android SQLite app by adding daily, weekly, monthly, and yearly options with radio buttons and dictionary driven queries.
Different Data Part 212:05
Different Data Part 39:09
Auto submit the report form on radio changes, handle daily, weekly, monthly, and yearly interval options with templating, and adapt queries via report.js front-end logic.
Different Data Part 412:43

Requirements

Basic Knowledge of Programming: Familiarity with programming concepts and experience in at least one programming language, such as Java, Python, or Swift.
Android Development Basics: Understanding of basic Android development concepts and familiarity with Android Studio.
iOS Development Basics: Basic knowledge of iOS development and familiarity with Xcode for iOS-related sections.
SQL Fundamentals: Basic understanding of SQL (Structured Query Language) and database concepts.
Software Installation: Ability to install and configure Android Studio, Xcode, and any necessary libraries or SDKs for SQLite.

Description

Course Intro:

Welcome to "Mastering Android SQLite Database Development," a comprehensive course designed to equip you with the skills and knowledge needed to effectively integrate and manage SQLite databases within Android applications. Whether you are new to Android development or looking to enhance your existing skills, this course provides step-by-step guidance, practical examples, and real-world applications to help you become proficient in SQLite database development.

Section 1: Android SQLite Database

In this section, you'll start with the basics of SQLite database integration within Android applications. You'll learn about the SQLite database architecture and its advantages, followed by practical examples of creating, reading, updating, and deleting (CRUD) operations. As you progress, you'll gain hands-on experience with table creation, data insertion, running demos, and exporting SQLite files. You'll also explore designing user interfaces for listing database data, converting lists to custom lists, and implementing various database operations. This section ensures a solid foundation in SQLite database management and UI integration.

Section 2: SQLite Database and Android Apps

Building on the fundamentals, this section delves deeper into SQLite database integration within Android apps. You'll revisit the core concepts of SQLite, focusing on setting up projects, adding and fetching records, updating and deleting records, and exporting databases. This section emphasizes practical applications and provides detailed instructions for managing SQLite databases effectively within Android projects. By the end of this section, you'll have a thorough understanding of how to handle various database operations and ensure efficient data management in your Android applications.

Section 3: Data Storage using SQLite in iOS 12

Expanding your knowledge to iOS development, this section covers SQLite database integration in iOS 12 applications. You'll learn about basic concepts of UITableView and UIAlertController, database creation, and executing SQL commands. This section provides a comprehensive overview of preparing queries, inserting values into tables, creating model classes, and implementing various database operations in iOS. By understanding the limitations of SQLite and exploring advanced topics, you'll be equipped to manage data storage in iOS applications effectively.

Section 4: Python Case Study - Expense Manager App

In the final section, you'll apply your knowledge through a practical case study by developing an Expense Manager App using Python. You'll start with the creation of an expense form, focusing on user input and data capture. As you progress, you'll implement functionality to save expense data, add support for categories and dates, and develop features for custom categories. This section also includes plotting expense data on charts for visual insights and analysis. By handling different data types and refining various features, you'll gain practical experience in creating a fully functional expense management application.

Course Conclusion:

Congratulations on completing "Mastering Android SQLite Database Development"! By now, you have gained a comprehensive understanding of SQLite database integration in both Android and iOS applications. You have developed practical skills in managing databases, designing user interfaces, and implementing advanced features through hands-on projects. With this knowledge, you are well-equipped to create robust and efficient database-driven applications. Continue practicing and exploring new challenges to further enhance your expertise in database development. Happy coding!

Who this course is for:

Beginner Developers: Individuals who are new to Android and iOS development and want to learn how to integrate SQLite databases into their apps.
Intermediate Developers: Those with some experience in mobile app development looking to deepen their understanding of data storage and database management.
Software Engineers: Professionals aiming to expand their technical expertise by mastering database operations in mobile environments.
Students: Computer science or IT students seeking practical, hands-on experience in mobile app development and database integration.
Hobbyists: Mobile app enthusiasts who enjoy building and experimenting with new applications and want to add database functionalities.
Freelancers and Consultants: Independent developers looking to offer more comprehensive solutions to their clients by incorporating robust data management capabilities.
Career Changers: Individuals transitioning into a mobile development career and seeking a solid foundation in Android and iOS database management.
Tech-Savvy Entrepreneurs: Entrepreneurs planning to develop mobile apps for their startups and need to understand how to effectively manage app data.
Continuing Education Seekers: Developers and IT professionals seeking to keep their skills up-to-date with the latest mobile database technologies.
Anyone Interested in Mobile App Development: Anyone with a passion for technology and mobile applications who wants to gain a thorough understanding of SQLite database integration in Android and iOS apps.

SQLite: Mastering Android SQLite Database Development

What you'll learn

Explore related topics

Course content

Android SQLITE Database26 lectures • 3hr 58min

SQLite Database and Android Apps7 lectures • 59min

Data Storage using SQLite in iOS 1214 lectures • 1hr 58min

Python Case Study - Expense Manager App19 lectures • 3hr 13min

Requirements

Description

Who this course is for: