DML (Data Manipulation Language &Queries) – Turn in SQL queries (SELECT/Update etc) for the lab project-
SQL select statements (basic & advanced) are developed for querying and developing reports from the database you created.
1. Select Statements – minimum 20 Queries / SQL select statements
Ref: Chapters 7 &8 (Database Systems Text Book – Coronel, Morris &Rob ISBN:9781285196145)

1. Select all columns, without explicitly naming them, and all rows from one table
2.Select 5 columns and 10 rows (use ROWNUM) from one table. Use ORDER BY to sort the results.
3.Use DISTINCT in a SELECT on one table that produces unique records in such a way so that the rows returned are less than the row count of the table (without use of ROWNUM)
4.Use WHERE to join 3 tables; select all columns, without explicitly naming them, and all rows. Use table aliases to identify the source table.
5. Use JOIN to select 5 columns and 10 rows (use ROWNUM) from two tables. Use table aliases to identify the source table. Use a WHERE clause that uses the “LIKE” special operator.6.Create a SELECT statement that uses SUM and GROUP BY
7.Create a SELECT statement that joins 2 tables (use WHERE) and IN
8.Create a SELECT statement that determines the LENGTH of a VARCHAR2 variable data column in one table
9.Create a SELECT statement that uses AVG. Use a column alias for at least two column headings
10.Create a SELECT statement that uses MIN and/or MAX
11.Create a SELECT statement that joins two or more tables. SELECT several columns from each table. Concatenate two or more columns to form a single column.
12. Create a SELECT statement that compares a column of type “DATE” with SYSDATE or that compares two date fields.
13.Use UPDATE to alter a single row in one table (use WHERE)
14.Use UPDATE to alter multiple rows in one table using a subquery
15.Use DELETE to delete a single row in one table (use WHERE)
16.Create a SELECT statement with a subquery in the WHERE clause
17.Create a SELECT statement with a subquery in the HAVING clause
18.Create a SELECT statement using a correlated subquery using a WHERE condition or WHERE EXISTS
19.Perform a left outer join on two tables (explain results)
20.Perform right outer join on two tables (at least one table different than 19; explain results)
Note: You should have 20 SQL select statements.
(Script file each separately).Develop the queries on your own and do not rely on Oracle SQL developer to generate them for you. The purpose of this assignment is to demonstrate that students know how to develop their own queries.

 
For a custom paper on the above topic, place your order now!

What We Offer:

• On-time delivery guarantee

• PhD-level writers

• Automatic plagiarism check

• 100% money-back guarantee

• 100% Privacy and Confidentiality

• High Quality custom-written paper