Andro Geeks

Helping you out to be an Android Geeks

Category

Database

Query Optimization!

Context: Recently, I was asked to load some data quickly for a particular tab. For around 1000 rows of data, it was taking almost 40-45 seconds! The admins had to wait for a long time when they used to see… Continue Reading →

How to import large SQL dump file in MySQL using CMD

In this tutorial, I will show you how to import a large SQL file (1GB<) to MySQL database using Windows Command Line. This tutorial will cover both Windows and Linux platform as those commands are the same for both OS…. Continue Reading →

Create REST API with SPRING BOOT

the In this tutorial, we will show you how to create REST API with full Database CRUD functionality. We will start from configuration to database functionality step by step. If you are not familiar or not have a better knowledge… Continue Reading →

Database Event(1.1) : Scheduler Event

Definition: The MySQL Event Scheduler is a process which runs in the background and constantly looks for events to execute. DB Outline & Context of the example: Suppose, we are monitoring traffic intensity in our living city Dhaka, Bangladesh. Android,… Continue Reading →

Database Event(1.0) : Triggering

DML: According to Wikipedia, A data manipulation language (DML) is a family of syntax elements similar to a computer programming language used for selecting, inserting, deleting and updating data in a database. Triggering: Whenever you operate any DML operations in… Continue Reading →

No More Redundant Data !

Background In every real life Application, Database is a must. It might reside in Backend (ex: MySQL server-side) or in Application-end (ex: Android’s Local DB) to make application user-friendly and fetch data faster. A handy knowledge on Database always makes… Continue Reading →

Database’s 4 Transaction Properties

Basic Terminologies: Table: where all the information of the real world is stored. Database(DB) : comprises of Table(s) . Server: where the Database is hosted. A Database might be hosted in USA/Bangladesh etc. Transaction:  An example might be transferring money… Continue Reading →

© 2019 Andro Geeks — Powered by WordPress

Theme by Anders NorenUp ↑