A project-oriented guide to preparing for Android interviews

Android Official Logo and Title
Android Official Logo and Title

In my experience, applied learning is the best form of learning new concepts. Hence, for this series of articles aimed at Android interview preparation, I’m going to develop a small project (a Weather App), covering the most fundamental concepts of Android Application Development.

Laying the foundations

In the previous article, we created a table dogs inside a database dog_app_db.

We can use the DESC command to view our table structure -

DESC dogs;Output
| Field | Type | Null | Key | Default | Extra |
| name | varchar(100) | YES | | NULL | |
| breed | varchar(50) | YES | | NULL | |
| gender | varchar(10) | YES | | NULL | |
| age | int(11) | YES | | NULL | |
4 rows in set (0.00 sec)

But if we query our table…

Here’s a quick introduction to working with database tables with MySQL.

Database and Tables

Tables = structured way of organising data in a database.

Database = collection of tables.


Rows and Columns

Suppose we’re building a table for a dog database (to hold information about all the dogs in the world). Each Dog will have a Name, Breed, Age, Gender. We’ll also give each dog a unique (i.e. not same for any 2 dogs) Identification Number (or ID). Thus, our Dog table will look like -

ID | Name  | Breed | Age | Gender | <----- These are the COLUMNS
1 | Beast…

Here’s a quick list of commonly used commands to work with databases on MySQL -


Creating a new Database

CREATE DATABASE my_database_name;

Capitalising the words “create” and “database” is optional; however, it does help if we keep SQL keywords (such as CREATE & DATABASE) different from custom words (my_database_name).

Listing existing Databases

show databases;

Deleting Databases

DROP DATABASE my_database_name

Remember to be careful with this command! Once you drop a database, it’s gone!

Using Databases

USE my_database_name;
SELECT database();
Output :
| database() |
| my_database_name |
1 row in set (0.00 sec)

TL;DR : Here’s what we’ll cover in this article -

  1. Component Tests — Introduction
  2. Component Tests in React
  3. Translating Business Requirements to Tests
  4. Project Setup
  5. UI Testing
  6. Interaction Testing
  7. Testing with React Native Modules

Component Tests — Introduction

As per Martin Fowler’s blog -

A component test is a test that limits the scope of the exercised software to a portion of the system under test.

Component tests can be as large or small as you define your components. The essence of the difference is that component tests deliberately neglect parts of the system outside the scope of the test.

Component tests are usually easier to write and maintain than broad-stack tests. …

Kunal Chawla

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store