[go: up one dir, main page]
Scribd
Upload
84 views5 pages

Fundamental of Database Lab 1

This document provides instructions for installing MySQL Server. It first discusses installing the required Visual C++ application dependencies. It then explains how to start the WampServer, access the MySQL console, and log in with the default username and password. Finally, it outlines some basic SQL queries to try and provides an example of creating a student database with tables for basic info and grades, along with examples of INSERT, UPDATE, DELETE commands.

Uploaded by

Biftu Shibbire
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
84 views5 pages

Fundamental of Database Lab 1

This document provides instructions for installing MySQL Server. It first discusses installing the required Visual C++ application dependencies. It then explains how to start the WampServer, access the MySQL console, and log in with the default username and password. Finally, it outlines some basic SQL queries to try and provides an example of creating a student database with tables for basic info and grades, along with examples of INSERT, UPDATE, DELETE commands.

Uploaded by

Biftu Shibbire
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 5

Lab 1 : Installing MySQL Server

Fundamental of Database Lab 1 :


Installing Wamp Server
◼ Objective
o Installing wamp server
1 download Wamp Server from here
2. Installing Wamp Server
Wamp Server needs some application to be installed in order to install and run Wamp Server
Required application
◼ Visual C Redistribution
o VC2009
o VC2010
o VC2011
o VC2013
o VC2015
o VC2019-2022
After installing the above application , start installing Wamp Server
Lab 1 : Installing MySQL Server

After installing Wamp Server


◼ Start the wamp Server
o Click the wampserver shortcut from your Desktop
o Go to on right bottom corner of your Desktop and press the hidden icons
o Press the wampServer Icon and select MYSQL

__ Select MySQL Consol


Lab 1 : Installing MySQL Server

MySQL console will ask you for password


◼ When you install MySQL server you are given a username and password by default
o Username : root
o Password : (no password)
Press enter (you will see your MySQL console as below )

◼ Try your console (making mistake is appreciable, you will learn from their mistake )
Some queries(commands)
Show databases; ..
Lab 1 : Installing MySQL Server

Use mysql;
Show tables;

Desc db;

..continue
Lab 1 : Installing MySQL Server

Before proceeding to the next lab exercises make sure that you know

• What is database
• What is schema
• What is database management system
• What is table
• What is query
• What is MySQL
Working on SQL console
Creating a simple student database which holds the students information
Tables in the student database are

• Basic student info (student_id , name , age , gender , phone , email)


• Student grades (student id , CGPA)
Lab objective

• Write simple SQL queries


• Creating database
• Thinking in tables and creating tables
• Practicing the CRUD Operation
Create table student_info(student_id varchar(12) , name varchar(150) , age int , gender varchar(10) ,
phone varchar(15) , email varchar(100));

Create table student_grades(student_id varchar(12) , CGPA float )

Experiment in Insert command and insert at least 20 student information in both tables.
insert into student_grades (student_id,CGPA) values ("AIT123",3)
update student_grades set CGPA=3.2 (i.e use where condition)
delete from student_grades where student_id="abcd"
drop table student_info

Read the students information by using the select command

Select * from student_info;


Select * from student_grades

You might also like