• LOGIN
  • No products in the cart.

The [course_title] course focuses on the importance of data persistence when building an Android app.

At first, you will be familiarised with the fundamentals of SQL, and the programming language needed to interact with an SQLite relational database which is used for storing large sets of data locally on an Android device. Finally, you will learn to work with Content Providers that allows your data storage to be bug-free and to be shared if you want.

Assessment

This course does not involve any written exams. Students need to answer 5 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.

Certification

Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.

Having an Official Edukite Certification is a great way to celebrate and share your success. You can:

  • Add the certificate to your CV or resume and brighten up your career
  • Show it to prove your success

 

Course Credit: Udacity

Course Curriculum

Lesson 1: Database Basics
Intro 00:02:00
Interview with Jessica 00:02:00
Intro Part 2 00:01:00
Course Map 00:02:00
Why is Data Persistence Important? 00:02:00
Computer Memory 00:02:00
SQLite Databases in Android 00:02:00
Opening SQLite for the First Time 00:06:00
Quick SQL Tips 00:03:00
CRUD overview 00:02:00
Insert data in a database and select it 00:05:00
Quiz: Table Constraints 00:09:00
Select, where, and order by 00:04:00
UPDATE 00:03:00
Recap Lesson 00:01:00
Lesson 2: Using a Database in an Android App
Intro to Lesson 2 00:01:00
Steps to Create a DB 00:02:00
What is a Contract Class? 00:05:00
Create the Contract 00:05:00
Check Constant Names 00:07:00
Create Database with SQLiteOpenHelper 00:04:00
Getting a Database Connection 00:03:00
Pull database file from device 00:06:00
SQLite Database Object and Inserting Data 00:04:00
Insert Dummy Pet from Menu Item 00:07:00
Insert Pet From Editor 00:10:00
Database Query Method 00:05:00
What is a Cursor? 00:02:00
Use Database Query Method 00:02:00
Handling a Cursor object 00:06:00
Read Values from Cursor 00:07:00
Recap of Lesson 2 00:01:00
Lesson 3: Introduction to Content Providers
Intro to Content Providers 00:01:00
Why Use Content Providers ? 00:08:00
Use Case for Sharing Pet Data 00:01:00
Diving into ContentProviders 00:07:00
Add ContentProvider to Pets App 00:04:00
ContentProvider Operations 00:05:00
Design Pet Content URIs 00:08:00
URI Matcher 00:12:00
Add URIMatcher to ContentProvider 00:08:00
Implement ContentProvider Query() Method – Instructions 00:10:00
Using the ContentProvider Query() Method 00:03:00
Use Case For Querying Pet Shelter Data 00:01:00
ConnectProvider insert() Method 00:09:00
Sanity Checks 00:01:00
Lesson 3 Recap 00:01:00
Lesson 4: Loading Data Using CursorLoader
Intro to the Lesson 4 00:02:00
Intro to CursorAdapter 00:06:00
Implement a CursorAdapter 00:09:00
Intro to CursorLoader 00:04:00
Using a CursorLoader 00:07:00
CursorLoader Automatically Loading 00:08:00
Use EditorActivity for Editing Pets Too 00:05:00
Recap of Lesson 4 00:01:00
Assessment
Submit Your Assignment 00:00:00
Certification 00:00:00

Course Reviews

4.7

4.7
9 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

5 STUDENTS ENROLLED
©2021 Edukite. All Rights Resereved
Edukite is A Part Of Ebrahim College, Charity Commission
Reg No 110841