100% Free-Android studio (java) with SQLite browser and excel reporting

Spread the love

In this course we will learn how to create a new android studio project, create a SQLite database- Free udemy Course Android studio.

What you’ll learn

  • Create a new android studio project
  • Create a small database using SQLite
  • Generate 1000s of records in excel to simulate the database
  • Insert records in app database
  • Insert the generated records in excel into app database
  • Request a permission to the user, so we can save files in device storage
  • Create reports in app and save them in device as CSV files
  • Create one report then save it as CSV, and create several reports then save them in separated CSV files in one click

Requirements

  • basics in android studio ( java & XML ), basics in SQLite and excel

Description

In this course we will learn how to create a new android studio project, create a SQLite database and generate 1000’s of records using Excel to simulate the app, and then we will insert all generated records into our app’s database.

The database is about a school
  * we have levels: Elementary School, Middle School, High school, University
  * we have grades: First grade, Second grade, Third grade, Fourth grade, Fifth grade, Sixth grade, Seventh grade, Eighth grade, Ninth       grade, Tenth grade, Eleventh grade, Twelfth grade, Freshman, Sophomore, Junior, Senior.
  * we have subjects: English, Math, Sciences, Physics
  * we have 600 students
  *we have 2400 tests

We are going to:

1. Create the android project

2. Create the activities

  o menu activity ( java & XML )

  o levels activity ( java & XML )

  o grades activity ( java & XML )

  o subjects activity ( java & XML )

  o students activity ( java & XML )

  o tests activity ( java & XML )

  o test’s result activity ( java & XML )

  o insert activity ( java & XML ), to insert the generated records

  o design of result ( XML )

3. Create the database using SQLite

  o Tables ( levels, grades, subjects, students, tests)

  o View

4. Generate 1000’s of records in excel to simulate the app

5. Insert the generated records into SQLite browser

6. Insert the generated records into app’s database

7. Request a permission to access the device storage

8. Download the test’s results to device storage as CSV files

Who this course is for:

  • Beginner

If this course was expired means read our disclosure.

ENROLL NOW

Join with us to get free Udemy Courses with Certificate

WhatsappClick Here
FacebookClick Here
TwitterCLick Here
InstagramClick Here
Free Udemy Courses

Which Udemy Courses You want? Mention it in comments! It Will Be Post soon


Spread the love

We will be happy to hear your thoughts

Leave a reply

Techietweets
Logo