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

I enjoy working on technically challenging problems - simulation, games, performance optimization, multiplayer systems, and XR experiences used in production.

If you’re looking for someone who can step in, understand the system, and deliver with minimal friction, feel free to reach out.

Let's work together

I enjoy working on technically challenging problems - simulation, games, performance optimization, multiplayer systems, and XR experiences used in production.

If you’re looking for someone who can step in, understand the system, and deliver with minimal friction, feel free to reach out.

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

Create a free website with Framer, the website builder loved by startups, designers and agencies.