Reference no: EM13540477

Prepare a assignment in SQL . To create two table names (not in use employee ,product ,order )

Separate queries of all function,screen shots and queries.

Use below function

Sql operations
Sql logical operations
Sql like ,in
Sql order by
Sql group functions
Where
Having
Primary key
Foreign key
Data types - - all data types & use not null also
Having
Insert -- at least 5 tables
Update
Create data base
Create table
Alter table - column add - rename column ------------relation shop with and without ( foreign key, primary key )
Constraints -use -check -unique -upper /lower -primary key -foreign key -
Joins
Rename
Views
Indexes
Grant
Revoke
Drop
Truncate
Save point
Roll back
Commit
where clause
comparison operator
order by
gropup by
constraint ----
update
ltrim
rtrim
abs
ceil
floor
mod
power
sign
round
trunk
chr
ascii
concat
lower ,upper
substring
Ipad
Rpad
Itrim
Rteim
Trim