Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Android MySQL Retrofit2 Multipart CRUD,Search,Pagination

How to INSERT,SELECT,UPDATE,DELETE,SEARCH and PAGINATE Data, including images and text.
(14 reviews)
78 students
Created by


CourseMarks Score®







Platform: Udemy
Price: $11.99
Video: 11h 38m
Language: English
Next start: On Demand

Top MySQL courses:

Detailed Analysis

CourseMarks Score®

9.8 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

10.0 / 10
This course was last updated on 4/2021.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

8.9 / 10
We analyzed factors such as the rating (4.4/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

9.8 / 10
Video Score: 9.4 / 10
The course includes 11h 38m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 5 hours 22 minutes of 128 MySQL courses on Udemy.
Detail Score: 10.0 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.9 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

18 articles.
13 resources.
0 exercise.
0 test.

Table of contents


LATEST PROJECT – Retrofit CRUD Multipart Image Upload/Download
Making any type of Software is all about data manipulation, be it pixels, images, text. Being able to write to and read from a database is therefore of paramount importance if you desire to create any meaningful app. Unfortunately there are surprisingly not many android tutorials online that give you an all in one solution for this.
I have been making apps for several NGOs here in Nairobi,Kenya and mostly I use MySQL, sometimes Firebase. Hence I have decided to produce a course to make working with MySQL and performing HTTP requests as easy as possible yet robust enough to be used in production.
Main Things You Will Learn

This course aims to teach you the following:
•How to Perform all CRUD operations against MySQL: INSERT SELECT UPDATE DELETE.
•How to perform a fast server side search and pagination.
•How to use retrofit as all in one solution HTTP Client  to make HTTP Requests in the background thread.
•How to write Object Oriented quality PHP code to perform CRUD, search and pagination for students coming from Java background who find most PHP code in the web weird and dirty looking.
•How to design and incorporate splash screen, dashboard, detail pages, data entry pages and listing pages into a an app.
•How to Create a reusable real world app template that can be modified by inexperienced programmers.
•The process of coding a full app in realtime.
My Style of Teaching
I have done many tutorials in YouTube in Java,Android and C# mainly, so am able to take students through a full course, covering everything, emphasizing important part yet moving at an amazing peace.
My courses assume no experience at all in app creation. Maybe my only assumption is that you can install android studio. Hence beginners can find this course very important. Intermediates can also benefit from this course as we cover several intermediate topics like Making HTTP requests and achieving pagination and search highlighting.
We code line by line and at the same time narrate and explain. We explain method by method.

What Can I create after this course?
Any app that involves CRUD. Your imagination is your limit.
For example recently I have used this template to create for a client an app. I will also be using this as a template to create other mysql apps as well as Firebase. Hence if you follow this course keenly, you will be able to create any type of app that involves CRUD.
Your app will be able to perform reliably in production. Your app won’t crush as we have handled exceptions reliably. For example if there is no connection or user enters wrong data. A beautiful dialog gets shown to the user informing of him of the error.
The app will be very fast, no matter how many hundreds of thousands or millions of rows you have. This is because the app doesn’t download all data at once. Instead short HTTP requests are made as the user scrolls through the recyclerview. The pagination takes place at the database engine level which is heavily optimized. The client downloads just a small chunk of data weighing a few bytes.
Your users will be able to take advantage of a search feature that doesn’t slow your app. This because the search also occurs at the database level.  This is a multi-column search, hence you can add as many columns in as you want. I have used two columns as an example in this app.

What if I don’t know PHP? How will I maintain the app?
Well you are in luck. The PHP code is the easiest to understand code you will ever find especially if you are a Java/C#/Python developer. It’s completely Object Oriented and is written in a single file. That file has only two classes. One class where you add the database credentials and the other class performs all the CRUD operations. All you will need to do is replace the table name and database name.

What Technologies does this course teach and Why?
The technologies that we use to create this simple app. And we cover them in a practical manner by coding.

1. Retrofit
We use it as our HTTP Client. It takes advantage of GSON as a dependency, using it to map our JSON data to our model classes. Thus this saves us from having to use JSONArray and JSONObjects to parse our JSON data.
Moreover Retrofit allows us uniquely map our HTTP requests using an interface. This gives us a higher level of abstraction and makes our code maintenable and clean.
We use it’s enqueue method to queue and asynchronously send our HTTP requests. Thus we are liberated from having to deal with AsyncTasks here and there.
Retrofit also allows us abstract our response from the server easily in a response model class. Moreover handling of Failure is abstracted away for us, thus we only have to log or show the exception message. No more try–catch blocks.
2. RecyclerView
It’s the most powerful adapterview in android. It’s more powerful and flexible than ListView. We rely on it’s onScroll events to do our pagination.
We will use it almost all our upcoming courses.
3. CollapsingToolbarLayout
It’s great and beautiful. It allows us show an image on top. It gives our app material design feel.

4. LovelyDialogs
Rather than showing exceptions and warnings in toasts, we use the lovely dialogs. I will use this library in many of my upcoming courses. It’s beautiful and is easy to wrap in a utility method that can then be invoked from anywhere.
Moreover it gives almost 4 dialog options: info,single-choice,multi-choice and input. It allows us easily align the dialog contents, control number of buttons shown, assign custom dialog images and handle onclick events.
5. Calligraphy
For your app to dominate play store you need the app to feel and taste nice. Fonts will make massively help with that. However not old fonts like sans serif and Times New Roman. We need custom fonts. Those you can download from the web.
Calligraphy is the best custom font library. I show you how to use it to load any font throughout your app or in individual widgets.

Do you provide support?
Obviously. I come from a YouTube background so am used to providing support to my students. I also welcome suggestions to improve myself as I enjoy learning, sharing and growing.

You will learn

✓ FULL CRUD : Performing INSERT SELECT UPDATE and DELETE against MySQL from Android
✓ Retrofit2 MULTIPART : Upload/download/Update/Delete of images and text
✓ PAGINATION : Server side pagination using ‘Load more’ technique.
✓ SEARCHING: Performing server side Search, Render SearchView in ToolBar,Highlight Search Results
✓ DESIGN : Splash Screen, Dashboard, Editing/CRUD screen, Lsting screen, Detail screen,CollapsingToolBar
✓ DATA PASSING: Serialize Objects,Pass them to Activities and Deserialize them, Show them
✓ SPLASH SCREEN: Use Animation class to load animations and apply them to widgets.
✓ CUSTOM FONTS: Apply any downloaded Custom Fonts to an android application
✓ PHP: Write Object Oriented PHP code that can perform all CRUD operations as well as search and page data
✓ RECYCLERVIEW: With Letter Icons,Search capability, Scroll events,Images Text
✓ Many more because we code in Realtime explaining line by line.


• Be able to use android studio

This course is for

• Beginner and Intermediate Android students
• Students who want a reusable template to create full app

How much does the Android MySQL Retrofit2 Multipart CRUD,Search,Pagination course cost? Is it worth it?

The course costs $11.99. And currently there is a 40% discount on the original price of the course, which was $19.99. So you save $8 if you enroll the course now.
The average price is $15.4 of 128 MySQL courses. So this course is 22% cheaper than the average MySQL course on Udemy.

Does the Android MySQL Retrofit2 Multipart CRUD,Search,Pagination course have a money back guarantee or refund policy?

YES, Android MySQL Retrofit2 Multipart CRUD,Search,Pagination has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the Android MySQL Retrofit2 Multipart CRUD,Search,Pagination course, but there is a $8 discount from the original price ($19.99). So the current price is just $11.99.

Who is the instructor? Is Clement Ochieng a SCAM or a TRUSTED instructor?

Clement Ochieng has created 8 courses that got 31 reviews which are generally positive. Clement Ochieng has taught 216 students and received a 4.0 average review out of 31 reviews. Depending on the information available, Clement Ochieng is a TRUSTED instructor.
Software Engineer and Instructor
Around 5 years, a change of events got me enrolled in a Software Engineering program as opposed to law. Since then I haven’t looked back and has continued enjoying myself day by day.I create apps for startups in Nairobi. I also an online instructor. I have contributed more than 400 projects in Github and published hundreds of free video and text tutorials. I have also published dozens of pro apps at Google Play.I enjoy learning and sharing my knowledge. Trying to make concepts easier for others is probably my biggest passion. I also enjoy attempting to make code as easy as possible yet re-usable.When not coding I do Meditation and try to understand Enlightenment. I also enjoying gazing at massive stars and galaxies. I also do mountain bike riding every two or three days to keep fit.


CourseMarks Score®







Platform: Udemy
Price: $11.99
Video: 11h 38m
Language: English
Next start: On Demand

Students are also interested in

Get this widget on your website (for course creators):

Android MySQL Retrofit2 Multipart CRUD,Search,Pagination rating
Copy this code and paste it to your website:
<a href="https://coursemarks.com/course/android-mysql-retrofit2-multipart-crudsearchpagination/" target="_blank" title="Android MySQL Retrofit2 Multipart CRUD,Search,Pagination on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/95.svg" width="200px" alt="Android MySQL Retrofit2 Multipart CRUD,Search,Pagination rating"/></a>