inflearn logo

Database Learning through Practice: Building a Medication Reminder App (SQLite & React Native Expo)

We are developing a medication reminder app using React Native. Based on learning the basics of databases and SQL syntax, we will build an app that manages data using SQLite and proceed all the way to store deployment.

(5.0) 4 reviews

24 learners

Level Basic

Course period Unlimited

React Native
React Native
SQLite
SQLite
database
database
React Native
React Native
SQLite
SQLite
database
database

What you will gain after the course

  • How to manage databases using SQL

  • Experience in React Native app development and release

Building a Medication Reminder App with SQLite & React Native

React Native, SQLite, database

Course Introduction

We will develop a medication reminder app using React Native. We will build an app ready for actual store release, featuring custom medication schedule settings, medication time setup and scheduled push notifications, medication tracking, and viewing weekly and overall schedules.

You will learn how to create an app that stores and manages data using SQLite without a separate backend server, ensuring data persistence. In this process, you will also naturally learn database basics and SQL syntax.


In the AI era, how you store and manage data is becoming increasingly important, not just how you implement the screen. This course goes beyond simple functional implementation to provide experience in directly designing and handling the data flows required in actual services.


Anyone who understands basic React syntax can take this course, and it is structured so that even those new to mobile app development can follow along step-by-step to create a high-quality app. We will cover everything from development to building and deploying to stores, and I will also share the necessary preparations and know-how for app submission based on my experience launching various apps.

⚡ ️️Implemented Features & Learning Content

Medication schedule management / Schedule creation funnel / Schedule notification integration

Database Theory / Practice

Database Integration

⚠ Please check the curriculum for detailed learning content!

📖 What we cover

  • React Native environment setup and basic concepts

  • Database & SQL Syntax Basics

  • Component development based on Figma design systems


  • Routing and tab implementation using Expo Router + Liquid Glass

  • Scheduling notifications using Expo Notifications


  • Data retrieval/creation/deletion + migration based on Expo SQLite

  • Managing global state with Zustand

  • Handling SVG and animations

  • Custom Hook pattern, Render Props pattern

  • Handling date and time functions


  • App building and deployment using EAS (Expo Application Services)

  • How to submit apps for review to the iOS and Android stores / Know-how

In this course, we use React Native Expo.

There are two ways to develop apps with React Native: using Expo or using the CLI. Even the official React Native documentation recommends developing through Expo.

Compared to CLI, Expo makes environment setup and development truly simple. Testing on simulators or physical devices is easy, and using libraries is also straightforward, allowing you to start React Native development with ease using Expo. Furthermore, you can easily build and deploy apps using EAS (Expo Application Services).

This course covers beginner to lower-intermediate level app development based on Expo.
If you want a more diverse app development experience, please check out the courses below as well!

🔥 Development Tech Stack

The main technology stack of the course is React Native (Expo), TypeScript, Zustand, and SQLite. Various Expo libraries such as routers and push notifications are also used. As long as you have experience with React, it's okay even if you haven't used all of these before!

I will teach you how to develop an app that queries, saves, and deletes data based on SQLite, manages global state with Zustand, and ensures data persists even after the app is restarted.

⭐️ What makes this course different

1. Simultaneous Android and iOS Development

We will develop for both platforms simultaneously and create common components that are reusable across various platforms and screens. We will also teach you the differences between platforms and how to handle them.


2. Figma Design System Provided

We provide the complete product design, including colors, components, screens, and images. You can focus immediately on development based on the provided design system without having to worry about the design separately.

3. Source code provided for all lessons

For every lesson from the beginning to the end of the project, we provide source code that is identical to what is shown in class. Please check the attachments for each lesson.

4. Database Lecture Notes Provided

You can learn database theory and practice together through the lecture notes provided as PDF files. The content is designed to enhance understanding by combining theoretical summaries of core concepts with hands-on practice that you can follow along with.


❗ ️Notes

  • This course can be taken by both Windows and Mac users, and we will proceed while verifying operations on both Android and iOS. (A Mac environment is required for iOS app development)


  • This course was produced in 3840 × 2160 (4K) resolution, so you can enjoy better image quality by selecting a higher resolution.


🙋‍♂ Q&A

Q. Who is the target audience for this course?

  • The target audience includes those with knowledge of JavaScript ES6 and those who have experience using React's useState and useEffect.

Q. Is TypeScript required?

  • The project is based on TypeScript, but it focuses on basic types. Therefore, even those who are new to TypeScript will be able to follow along easily.


    Commonly used basic types (interface, type, etc.), ways to reduce type errors,

    How to use useful utility types

    I will explain these together so that you can naturally learn how to build apps with type safety.

Recommended for
these people

Who is this course right for?

  • Those who have studied the basics of JavaScript/React

  • Those who want to develop both iOS and Android apps using a single language.

  • Those who want to understand how database theory is applied in real-world apps through hands-on practice

  • Those who couldn't quite get a sense of when and why to use the DB and SQL concepts they learned

Need to know before starting?

  • You must have knowledge of JavaScript syntax.

  • Basic experience with React is required.

Hello
This is Kyo

2,246

Learners

183

Reviews

351

Answers

4.9

Rating

4

Courses

I started as a community service frontend developer and am currently working as a full-stack developer for a commerce platform.

At Inflearn, I provide lectures focused on creating high-quality products.

 

  • inkyo.dev@gmail.com

More

Curriculum

All

54 lectures ∙ (7hr 21min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

4 reviews

5.0

4 reviews

  • tarutaru님의 프로필 이미지
    tarutaru

    Reviews 4

    Average Rating 4.8

    5

    80% enrolled

    I thought only things like to-do lists were possible without a server, but it's great that SQL implementation is possible.

    • koy
      Instructor

      Thank you for the great review!!

  • n5i4님의 프로필 이미지
    n5i4

    Reviews 2

    Average Rating 5.0

    5

    35% enrolled

    I was curious about the local DB implementation, and since this was exactly what I needed, I purchased it right away. haha I went through it a bit quickly, focusing on the parts I was curious about. It's really great because the lecture contains only the essentials without any fluff. I'll enjoy the rest of it. Thank you for the great lecture.

    • koy
      Instructor

      I'm glad it was exactly what you needed!! Thank you for the great review.

  • zian009님의 프로필 이미지
    zian009

    Reviews 9

    Average Rating 4.1

    5

    39% enrolled

    • yeongjinyu679614님의 프로필 이미지
      yeongjinyu679614

      Reviews 4

      Average Rating 5.0

      5

      20% enrolled

      Kyo's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!

      Limited time deal

      $29.70

      49%

      $58.30