SQL App

Scent of Death

Simple Database

My Approach

My Approach

  • Aimed to dive deep into the workings of a SQL database in its raw form.

  • While cloud databases offer convenience, wanted to grasp the fundamentals, learning how things work at the core.

  • It was all about gaining a fundamental understanding of SQL databases, and this project provided the perfect opportunity for that.

My Approach

Vision and Innovation

My Approach

  • The vision for the "SQL App" catered to teachers needing a user-friendly tool to manage students' marks in a school database.

  • The innovation lies in enabling teachers to create, edit, and delete student records using their ID's, streamlining the process of managing student data efficiently.

My Approach

Resolving Complex Problems

My Approach

  • The main complexity of this project revolved around effectively managing classes of data elements and tables and ensuring their proper placement within the database.

  • Unlike in tools like Excel, there was no visual representation to guide the process, making it more complex.

My Approach

Identifying Unique Challenges

My Approach

  • One unique challenge we encountered in developing the app was creating a cursor class from scratch.

  • This cursor class was essential for traversing through each row in the database to retrieve the desired results.

My Approach

User-Centric Design

My Approach

  • For a user-centric design, the app incorporated basic Android UI elements and a simple form structure.

  • This approach aimed to provide users with a familiar and intuitive interface.

My Approach

Meeting User Needs

My Approach

  • The app was designed with a focus on basic usage, catering to everyday needs rather than professional use.

  • It efficiently handled essential functions like create, edit, delete, and retrieve.

  • It was built with proper anchoring, ensuring smooth operation across multiple Android versions.

My Approach

Screenshots

Skills required for this

Android Studio

Java

UI/UX

Let's work together

Ready to take your digital projects to the next level? Let's team up and craft exceptional solutions together. As an experienced game developer, I'm here to bring your ideas to life and ensure they resonate with your audience. Whether you're exploring cutting-edge technologies or simply need to optimize your existing projects, I'm committed to delivering results that exceed your expectations. Let's work together to make your vision a reality.

Let's work together

Ready to take your digital projects to the next level? Let's team up and craft exceptional solutions together. As an experienced game developer, I'm here to bring your ideas to life and ensure they resonate with your audience. Whether you're exploring cutting-edge technologies or simply need to optimize your existing projects, I'm committed to delivering results that exceed your expectations. Let's work together to make your vision a reality.

SQL App

Scent of Death

My Approach

My Approach

  • Aimed to dive deep into the workings of a SQL database in its raw form.

  • While cloud databases offer convenience, wanted to grasp the fundamentals, learning how things work at the core.

  • It was all about gaining a fundamental understanding of SQL databases, and this project provided the perfect opportunity for that.

My Approach

Vision and Innovation

My Approach

  • The vision for the "SQL App" catered to teachers needing a user-friendly tool to manage students' marks in a school database.

  • The innovation lies in enabling teachers to create, edit, and delete student records using their ID's, streamlining the process of managing student data efficiently.

My Approach

Resolving Complex Problems

My Approach

  • The main complexity of this project revolved around effectively managing classes of data elements and tables and ensuring their proper placement within the database.

  • Unlike in tools like Excel, there was no visual representation to guide the process, making it more complex.

My Approach

Identifying Unique Challenges

My Approach

  • One unique challenge we encountered in developing the app was creating a cursor class from scratch.

  • This cursor class was essential for traversing through each row in the database to retrieve the desired results.

My Approach

User-Centric Design

My Approach

  • For a user-centric design, the app incorporated basic Android UI elements and a simple form structure.

  • This approach aimed to provide users with a familiar and intuitive interface.

My Approach

Meeting User Needs

My Approach

  • The app was designed with a focus on basic usage, catering to everyday needs rather than professional use.

  • It efficiently handled essential functions like create, edit, delete, and retrieve.

  • It was built with proper anchoring, ensuring smooth operation across multiple Android versions.

My Approach

Screenshots

Skills required for this

Android Studio

Java

UI/UX