Database is one of the crucial part of all computer related activities. The basic knowledge of data base is essential for every computer aspirants and enthusiasts. Basically database forms the vital part of all giant firms, which are having an attractive user interface. There are different types of databases according to the applications used. Most commonly used database model is the relational data base model, which can be mastered easily. When we talk about RDBMS, MySql is an unavoidable component that needs to be addressed. The studies of database starts with the usage of MySql database by defining simple queries over small tables. After getting a profound experience in MySql, people can easily work on small projects. With the basic knowledge on MySql database, they can extend their knowledge to other types of databases like graph based, object oriented etc.
The following files will help you to start with using MySQL database with various hand-son experiments on various queries.
You can get the installation file of mysql database from the link MYSQL DOWNLOAD. Download it and install the software. Do practice the lab questions in that and be experienced with database practically. Those who have doubt about the various installation process please do go through the video
TEXT BOOK FOR YOUR REFERENCE
LAB ESSENTIALS 1 - Basic of DBMS
LAB ESSENTIALS 2 - Creation of Tables
LAB ESSENTIALS 3 - Additional use cases
LAB ESSENTIALS 4 - Group by and Aggregations
LAB ESSENTIALS 5 - Join and Sub-Queries
TEST-1 Solutions