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
No Reviews found for this course.