SQL Certification from Sololearn

As I started developing android apps I felt the necessity of storing data. But I had no prior knowledge about Databases. So started learning about My SQL  from Sololearn. They have a nice interface and a very friendly interactive learning platform. It usually follows the videos of  newboston but at the same time has quizzes to test the knowledge instantly. I've been at it for the last 2 weeks and managed to finish it .

Certificate Link: http://www.sololearn.com/Certificate/1060-1489426/pdf/



Some of the concepts I have learned about SQL from the course are mentioned below:

*Introduction to Databases
*SQL Statements: Select
*SQL Syntax Rules
*Selecting Multiple Columns
*Distinct and Limits
*Storing Results
*WHERE Statements
*Filtering with AND,OR
*IN,NOT IN Statements
*Custom Columns
*Functions
*Sub queries
*LIKE and MIN
*Joining Tables
*Types of Join
*UNION
*The INSERT Statement
*UPDATE and DELETE Statements
*Creating a Table
*NOT NULL and AUTO_INCREMENT
*Alter,Drop,Rename a Table
*Views

Extras:
*Quizzes from each of the topics
* Quizzes from a group of topics
*Challenges on all the overall topics

Marks Converter -Android App

Did you ever had to convert your exam marks to a different weightage for example you got 45/50 in your midterm but your midterm is actually 25% of your final so you needed to know how much you got out of 25?If you're a student you might have been doing these conversions of marks more often and it really becomes annoying when you have to do it often. So this app basically does it for you. Just enter your achieved marks & the total and sit tight and let the app do it for you.

The app will calculate it for you how much you got out of different totals. Just making life a little more easier and lazy.

The app is a very simple one but the concept is new cause I couldn't find any app similar to this.

Features of the App:
* The app converts one's marks to different weightages (Usually to the mostly used Totals) 
* The app also has the option to enter own modified totals to convert the marks weightage to.

* The app has a "Contact Us" tab for the users to contact the developer

* The app has an "About Us" tab which has information about the developer

You can help me By:

• Letting me know if you find any bugs
• Letting me know any improvements I can make for the app
• Ways of making the app user interface more user friendly
• New features that can be added to the app
• Any new ideas or concerns regarding the app

Google Playstore Link
Git Hub

Android App-Simple Multi Counter

I have always had interest on android apps. Its a way for me to give physical existence to my ideas. 

I've been using android studio for developing simple android apps. I have developed some simple android apps but always was eager to see how publishing an app on Google Play-store works. So I made a simple counter app just to experience the app publishing system on play-store. 

My app is named under "Simple Multi Counter". The idea is pretty simple , 

Features of the App:

* There are 3 counters which one can use to count elements from passengers on a plane to laps in a         field. 

* Each counter displays separate total  and there's also a Total field which displays the total of all the      three counters.

* The app also features the reset button so that one can easily reset the counters to 0.

* I also added a "Contact Us" tab and a "About Us" Tab in the settings option in the app situated in        the top right corner. These tabs shows my ability to successfully migrate from one activity of the        android to another activity.

Though there are similar apps on play-store I found this app idea a simple one to get familiar with the process of publishing apps on play-store. So I made the app within an hour and tested it for another hour and published it on the play-store.

Feel free to check it out:
Google Plays Store
Git Hub

You can help me By:

• Letting me know if you find any bugs
• Letting me know any improvements I can make for the app
• Ways of making the app user interface more user friendly
• New features that can be added to the app
• Any new ideas or concerns regarding the app

Saving Interest Calculator For Parents

I believe computer science is a field which can be used to help all categories of people which is one of the inspirations behind me choosing this field for higher studies.

During this semester break I went to visit my parents for a week in Mississauga and during my visit thought of helping my parents keep track of their life's saving by writing a program to manage all that.

So I  wrote a java application for my parents.

What it does?

* Reads bank account info from a text file 

( Can edit all the info's from the text file )

* Calculates the interest rate 

* Then prints out the summary of the amount of interest gained monthly from all the different accounts

* Also separates how much interest in total has been added from the primary amount up till the current date. (The program takes the computer's current date)

Note: The program might seem very simple but it has to take into account a lot of facts, below are some of the problems I faced while developing the program:

GitHub:
https://github.com/ohin94/Savings-And-Interest-Rate-Calculator

Challenges:

*As all the money were invested for bonds and different bonds had different time to maturity had to take that in account 

* As some bonds were bought before  and some were bought after one another so all the calculations had to be managed well to give the right calculation

* As the program was taking the current time from the computer and some bonds time period has already been finished had to stop calculating interest rate for those specific bonds also had to adjust the monthly interest rate as those bonds were not in play anymore.

Design:

* The program takes all the information from a text file so that my parents can change the info without having to change the code which wouldn't have been possible if all the values were hard coded.

* My parents have to just click the run button and enter 1 to generate the summary  text file containing all the updated info about the interest rate and the bank accounts implementing information hiding and encapsulation.

I want to help the people of the  world with my computer science skills. But everything has its beginning and the people I started helping  happens to be my parents and this is just the beginning ........

Java Programmes I wrote At Work

I started my first job at University of  Manitoba  Deft Media Lab in February 2016. The job was under the University of Manitoba Work-Study programme.

Programmes I wrote for the lab:

1. Barcode generator for the DVD's in the lab.
2. Database Management service for the DVD's.
3. Sorting DVD's in the lab.

Though the job was only 2.5 months long I have had an awesome experience working there and learned so many things. I also learned to work with real life data's and how to manage them efficiently. Thus this work experience has given me the taste of becoming a professional programmer.