Description

Lab 01 – Getting Started
Objectives:
The purpose of the first lab of DBS211 is to familiarize yourself with the User Interface, SQL Developer, that we will be using throughout the course to communicate with the Oracle server. By the end of this lab, you should be able to:
• Successfully establish a connection and login to the Oracle database server using SQL Developer
• Run the sample database creation script
• Navigate SQL Developer to view the tables created, their structure and the data contained within them.
Preface:
If you have not already done so, you will need to complete the instructions given in the Oracle SQL Developer Setup and Schema Creation.
LAB 01 – SUBMISSION
Explore the Database
Answer the following questions in an SQL file format and name it using your first and last names. See example below. Submissions with incorrect file format will receive 0.
DBS211_Lab01_Fardeen_Panjwani.sql

Tasks:
To answer the questions in this lab you need the Oracle SQL developer running and the sample database created.
In the connections window, expand Tables.
1) What is the value of each column in the first row in table customers? Write the column name and the column value. (1 mark)

“CUSTOMERNUMBER” : 103,
“CUSTOMERNAME” : “Atelier graphique”,
“CONTACTLASTNAME” : “Schmitt”, “CONTACTFIRSTNAME” : “Carine “,
“PHONE” : “40.32.2555”,
“ADDRESSLINE1” : “54, rue Royale”,
“ADDRESSLINE2” : null,
“CITY” : “Nantes”,
“STATE” : null,
“POSTALCODE” : “44000”,
“COUNTRY” : “France”,
“SALESREPEMPLOYEENUMBER” : 1370,
“CREDITLIMIT” : 21000

2) Write the number of rows and columns for all the tables in your schema. Format it something like the following. (1.5 marks)

3) Write the following SQL statement in the new tab.
desc offices;
You can also write
describe offices;
What is the result of the statement execution? (0.5 marks)
Name Null? Type
———— ——– ————
OFFICECODE NOT NULL VARCHAR2(10)
CITY NOT NULL VARCHAR2(50)
PHONE NOT NULL VARCHAR2(50)
ADDRESSLINE1 NOT NULL VARCHAR2(50)
ADDRESSLINE2 VARCHAR2(50)
STATE VARCHAR2(50)
COUNTRY NOT NULL VARCHAR2(50)
POSTALCODE NOT NULL VARCHAR2(15)
TERRITORY NOT NULL VARCHAR2(10)

4) Type the following statements in, execute them, then briefly describe what the statements are doing. (1 mark)

SELECT * FROM employees;
The given statement is fetching all the rows in the EMPLOYEES table.

SELECT * FROM customers ORDER BY ContactLastName;
This statement fetches all the rows from the customers table and then orders them by the value of the “ContactLastName” column in each row