Android MySQL Retrofit2 Multipart CRUD,Search,Pagination

Android MySQL Retrofit2 Multipart CRUD,Search,Pagination, available at $19.99, has an average rating of 4.1, with 239 lectures, based on 17 reviews, and has 121 subscribers.

You will learn about 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. This course is ideal for individuals who are Beginner and Intermediate Android students or Students who want a reusable template to create full app It is particularly useful for Beginner and Intermediate Android students or Students who want a reusable template to create full app.

Enroll now: Android MySQL Retrofit2 Multipart CRUD,Search,Pagination

Summary

Title: Android MySQL Retrofit2 Multipart CRUD,Search,Pagination

Price: $19.99

Average Rating: 4.1

Number of Lectures: 239

Number of Published Lectures: 238

Number of Curriculum Items: 239

Number of Published Curriculum Objects: 238

Original Price: $19.99

Quality Status: approved

Status: Live

What 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.

Who Should Attend

Beginner and Intermediate Android students

Students who want a reusable template to create full app

Target Audiences

Beginner and Intermediate Android students

Students who want a reusable template to create full app

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:

1. How to Perform all CRUD operations against MySQL: INSERT SELECT UPDATE DELETE.

2. How to perform a fast server side search and pagination.

3. How to use retrofit as all in one solution HTTP Client  to make HTTP Requests in the background thread.

4. 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.

5. How to design and incorporate splash screen, dashboard, detail pages, data entry pages and listing pages into a an app.

6. How to Create a reusable real world app template that can be modified by inexperienced programmers.

7. 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.

Course Curriculum

Chapter 1: FULL APPS CREATED SO FAR

Lecture 1: Kotlin Largest Stars App – Kotlin+Retrofit+Multipart+Full CRUD+Disk Caching

Lecture 2: Largest Stars App – Retrofit Multipart Images Text CRUD

Lecture 3: (BONUS)Big Thinkers App – MVVM,Disk Caching,Pagination Full App

Lecture 4: Kotlin Scientists App – Retrofit CRUD App

Lecture 5: Scientists App – Retrofit CRUD App with Search and Pagination

Lecture 6: (BONUS) Kotlin Offline Pretty Tasks Planner(Room+MVVM)

Lecture 7: (BONUS) Scientific Gamechangers App – MVVM + Room + CRUD + LiveData

Lecture 8: (NEW)(BONUS) WakaWaka Music Player – Kotlin + MVVM + MediaPlayer

Chapter 2: Introduction

Lecture 1: Introduction and Demo

Chapter 3: Setting UP XAMPP

Lecture 1: How to Download XAMPP

Lecture 2: How to Start XAMPP

Lecture 3: How to Create MySQL Database in PhpMyAdmin

Chapter 4: PHP

Lecture 1: Create PHP File

Lecture 2: Constants Class To Hold Database Credentials

Lecture 3: Connect to MySQL

Lecture 4: INSERT into MySQL

Lecture 5: UPDATE Data in MySQL

Lecture 6: DELETE from MySQL

Lecture 7: SELECT from MySQL

Lecture 8: SEARCH and PAGINATE in MySQL

Lecture 9: Handle incoming HTTP Requests

Lecture 10: Test MySQL Connection From PHP

Chapter 5: Start Here

Lecture 1: Create Android Studio Project

Lecture 2: Add Gradle Dependencies

Chapter 6: Lets Prepare Resources

Lecture 1: Adding Drawables

Lecture 2: Menu Resources

Lecture 3: Value Resources

Chapter 7: How to use Custom Fonts

Lecture 1: Objectives

Lecture 2: Adding Downloaded Fonts in the Assets Folder

Lecture 3: Initializing Calligraphy in the Application Subclass

Chapter 8: How to Create a Professional Splash Screen for our app

Lecture 1: What We will Create

Lecture 2: How to Design the Splash screen in XML

Lecture 3: How to apply the animations in Java then Open another activity

Chapter 9: Creating Our Model Classes and RESTApi interface,using them with Retrofit

Lecture 1: What We will Create

Lecture 2: Scientist.java – Our model class

Lecture 3: RestAPI.java – Our REST API interface

Chapter 10: Lets Create Re-usable Utility Methods

Lecture 1: What We will Create

Lecture 2: Utils.java – Constants, Getting our IP Address

Lecture 3: How to instantiate Retrofit and add Converter Factory

Lecture 4: How to Create a Toast, How to Validate EditTexts

Lecture 5: How to Open another Activity

Lecture 6: How to Create a Material Lovely Info Dialog

Lecture 7: How to Create a Material Single Choice Dialog

Lecture 8: How to Convert a String to a Date safely

Lecture 9: How to send and receive serialized Objects across activities

Chapter 11: Creating Details Activity

Lecture 1: What We will Create

Lecture 2: Designing Detail Activity Layout

Lecture 3: Create the Activity, Initialize Widgets

Lecture 4: Receive and Show Data

Lecture 5: Inflate Menu and Handle Selection

Lecture 6: Handle Activity Callback Methods

Chapter 12: RENDER, SEARCH,HIGHLIGHT – in RecyclerView via Adapter

Lecture 1: What We will Create

Lecture 2: Designing Our Model Layout

Lecture 3: What is an Adapter?

Lecture 4: Creating a ViewHolder

Lecture 5: Inflating Views and Binding Data

Lecture 6: How to Highlight Search Results in a RecyclerView

Lecture 7: Listen to RecyclerView clicks and Open activity

Chapter 13: Creating a Dashboard

Lecture 1: What We will Create

Lecture 2: Designing Dashboard Interface in XML

Lecture 3: Creating Dashboard Activity

Lecture 4: Opening Other Activities when Dashboard Cards are Clicked

Chapter 14: INSERT,UPDATE,DELETE – via Retrofit

Lecture 1: What We will Create

Lecture 2: Designing a CRUD interface in XML

Lecture 3: Create Activity, Initialize Widgets

Lecture 4: INSERTING Data via Retrofit

Lecture 5: Data Validation Before Update

Lecture 6: UPDATING Data via Retrofit

Lecture 7: DELETING Data via Retrofit

Chapter 15: SELECT, PAGINATE via Retrofit

Lecture 1: What We will Create

Lecture 2: Design Listing Activity : RecyclerView and Title Text in XML

Lecture 3: Initialize Widgets

Lecture 4: SELECT/Download Data via Retrofit

Lecture 5: LOAD MORE on RecyclerView Scroll

Lecture 6: Inflate Menu, Listen to Selection Events

Lecture 7: Override Callback Methods

Chapter 16: Finishing Up

Lecture 1: AndroidManifest – Add Permissions, Register Activities

Lecture 2: Run Our Project and SOURCE CODE

Chapter 17: Kotlin MVVM Retrofit MySQL Full App with Disk Caching

Lecture 1: Introduction – What we will create

Chapter 18: Start Here – Second Project

Lecture 1: How to Load the Project into Android Studio

Lecture 2: Project Overview

Lecture 3: Gradle Scripts

Instructors

Clement Ochieng
Software Engineer and Instructor

Rating Distribution

1 stars: 1 votes

2 stars: 0 votes

3 stars: 3 votes

4 stars: 3 votes

5 stars: 10 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!