DSA-CLASS--SQL-CLASS

This is where I review some of the queries used SQL classes.

Table of Contents

• Project Overview
• Data Sources
• Tool Used
• Explorative Data Analysis
• Data Analysis
• Result/Findings
• Recommendations
• Limitations

Project Overview.

In this project, I will do well to chronicle all the commands and analysis done the class. The structured query language uses simple every day English terms, however, for analysis some commands had to be used to display the needed results.

Data Sources.

Most of the data for SQL are imported, however some queries will be written out here to show how some table are created.

Tool Used.

• Ms SSMS Download Here

Data Analysis.

Here are some queries for creating tables;

create table Employee(
Staffid varchar (10),
FirstName varchar (100),
LastName varchar (100),
Gender nvarchar (10),
Date_of_Birth date,
HireDate date,
primary key (staffid)
)
INSERT INTO Employee(Staffid, Firstname, LastName, Gender, Date_of_Birth, HireDate)
Values ('IM201','Thoby','Elumelu','male','1995-06-24','2020-02-03')
CREATE TABLE Salary(
salary_id int identity (1,1) not null,
Staffid varchar (255),
FirstName varchar (255),
lastname varchar (255),
department nvarchar (max),
salary decimal (10, 3)
)
INSERT INTO salary (Staffid, Firstname, LastName, department, salary)
Values ('IM201','Thoby','Elumelu','Tech','150000.9786')
create table payment(
paymentid int identity (1,1) primary key,
Account_no bigint not null,
staffid int,
Bank varchar (255) default 'Zenith Bank',
Payment_method varchar (50) check (Payment_method= 'Cash' or Payment_method= 'Transfer')
)
INSERT INTO payment (Account_no, Staffid, payment_method)
Values (3085640077,'IM201','Transfer')