INTRODUCTION

SQL is an an open source relational database management system used by programmers to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases, MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups. Though MySQL began as a low-end alternative to more powerful proprietary databases, it has gradually evolved to support higher-scale needs as well. It is still most commonly used in small to medium scale single-server deployments, either as a component in a LAMP-based web application or as a standalone database server. Much of MySQL's appeal originates in its relative simplicity and ease of use, which is enabled by an ecosystem of open-source tools such as phpMyAdmin. In the medium range, MySQL can be scaled by deploying it on more powerful hardware, such as a multi-processor server with gigabytes of memory.

INSTALLATION

MySQL can be built and installed manually from source code, but it is more commonly installed from a binary package unless special customizations are required. On Windows the package management system can download and install MySQL with minimal effort, though further configuration is often required to adjust security and optimization settings. You simply go to any web browser and type dev.mysql.com/downloads then find MySQL installer for windows and download the latest version. Choose setup file, then custom and finally from the table that appears add MySQL programs, install them and execute the remaining commands.

PROJECT DESCRIPTION

This project entails creation of database from subcounty population density, writing queries which displays specific columns either by descending/ascending and analyzing them in a table. Various formulas such as sum, avg extra can be used in doing calculations.