Practice Lab 1 Validation of A Sample Database Using Sql Developer Paper Instructions are attached. They should be everything that is needed. If there any

Practice Lab 1 Validation of A Sample Database Using Sql Developer Paper Instructions are attached. They should be everything that is needed. If there any questions please do not hesitate to ask, Instructions
Practice Lab #1 – Validate the sample database is populated with STUDENT tables and data
Login to the DaaS environment and connect to Oracle for DBST 651 using the DBST_USER account.
Before proceeding with the lab, you must validate that the COURSE, ENROLLMENT, GRADE,
GRADE_CONVERSION, GRADE_TYPE, GRADE_TYPE_WEIGHT, INSTRUCTOR, SECTION, STUDENT, and
ZIPCODE tables exist.
Validate tables exist using Oracle SQL Developer: Expand the ‘Tables’ node under the connection you
made and you should see the 10 tables from the STUDENT schema.
Validate tables exist using SQL Developer with the following query:
SELECT table_name FROM user_tables;
If the 10 STUDENT tables do not exist, navigate to Course Content > Hands-on Resources >
StudentSchema within the classroom using a browser in the DaaS environment. Extract the contents
of the zip file and follow the instructions in the Readme.pdf to create the STUDENT schema.*
For each STUDENT table, execute a SELECT query displaying a count of the total number of rows in
that table by replacing with the name of the STUDENT table.
SELECT COUNT(*) AS “Count of ” FROM ;
Example: SELECT COUNT(*) AS “Count of COURSE” FROM COURSE;
Deliverable:
Submit a single Word document that contains the query executed and output text or output
screenshots showing the results for all 10 STUDENT tables. Ensure that both the column alias (i.e.
‘Count of ’) and the count itself is visible on all 10 results.
*Please notify the course TA if these tables were not available to you.
Learning Resources
https://docs.oracle.com/database/121/SQLRF/sql_elements009.htm#SQLRF51132
https://www.w3schools.com/sql/sql_select.asp

Purchase answer to see full
attachment