Experiment-1
Aim: Installing MySQL
Step – 1 : Download MySQL from the Official Website
Navigated to this link https://dev.mysql.com/downloads/installer/ and clicked on Windows (x86, 32-bit), MSI Installer.
On MySQL community downloads, clicked on “No thanks, just start my download”.
Step – 2: Run the Installer and Do the Setup
Clicked on Next and proceeded
Executed for download and executed for installation.
Did all the basic setup by clicking on the “Next” button.
Step – 4: Verified the Installation
Entered the root password
Open the MySQL Command Line Client.
Enter the MySQL password.
Verified the successful installation.
Typed “help” to list out all the commands for MySQL cli.
Create user command :
CREATE USER ‘username’ IDENTIFIED BY ‘password’;
Create database command :
CREATE DATABASE dbname;
Delete database command :
DROP DATABASE dbname;
Delete MySQL user account :
DROP USER ‘username’;
Step – 6 : Conclusion
I downloaded and installed the MySQL command Line Client on my system.
Experiment-3:
Aim: Writing SQL statements using ORACLE/MySQL:
1. Writing basic SQL SELECT statements
2. Restricting and Sorting Data
3. Displaying data from multiple tables
4. Aggregating data using group functions
5. Manipulating Data
6. Creating and Managing Tables
Step-1: Created database, created table, inserted sample data
Create database
Create Tables
Inserted sample departments data and employee data
Step-2 : Performing Operations
a) Writing Basic SQL SELECT Statements
b) Restricting and Sorting Data
c) Displaying Data from Multiple Tables
d) Aggregating Data Using Group Functions
e) Manipulating Data
Insert a new employee
Update an employee’s department
Delete an employee
f) Creating and Managing Tables
Create a new table for projects
Add a column to the employee table
Drop the projects table
