Scribd
Upload
6 views5 pages

Da Exp3

The document outlines Experiment 3 for a Data Analytics Lab course, focusing on the installation and configuration of Oracle/SQL software. It details the objectives of creating, modifying, and deleting various database objects using SQL commands. The procedure for installing SQL Developer on Windows is provided, along with the expected learning outcomes related to database management skills.

Uploaded by

Gautam Passi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views5 pages

Da Exp3

The document outlines Experiment 3 for a Data Analytics Lab course, focusing on the installation and configuration of Oracle/SQL software. It details the objectives of creating, modifying, and deleting various database objects using SQL commands. The procedure for installing SQL Developer on Windows is provided, along with the expected learning outcomes related to database management skills.

Uploaded by

Gautam Passi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Experiment – 3

Student Name: AADIL NAZIR UID: 24MCI10191


Branch: MCA (AI ML) Section/Group: 24MAM-3B
Semester: 4th Date of Performance: 13-02-2026
Subject Name: Data Analytics Lab Subject Code: 24CAH-771

Experiment No. 3 – Database Setup

• Installation of Oracle / SQL software

• Creation, modification, and deletion of:

o Databases

o Tables

o Views

o Functions

o Indexes

Aim & Objective:


To install and configure Oracle/SQL software and develop practical skills in creating, modifying, and
deleting database objects such as databases, tables, views, functions, and indexes using SQL commands.

Input / Apparatus Used

• Computer system with Windows/Linux operating system

• Oracle Database installed

• Oracle SQL Developer / SQL*Plus

• Stable internet connection

• Oracle installation and setup files

• Sample datasets for practice

• SQL DDL commands: CREATE, ALTER, DROP


Procedure

About SQL Developer:


Oracle SQL Developer is a free, integrated development environment used for database development and
management. It provides a worksheet to execute SQL queries and scripts and supports complete PL/SQL
application development.

Installing SQL Developer on Windows:

Follow the below steps to install SQL Developer on Windows:

Step 1: Browse to this link.

Step 2: Click on download.

Step 3: Login in Oracle account or create a new account. It is free


Step 4: Extract the downloaded zip file.

Step 5: Open your computer C drive & program files. Cut & Paste the extracted file there.

Step 6: Open the folder.

Step 7: Then open sqldeveloper folder.


Step 8: Find the sqldeveloper exe file there. Create a shortcut on desktop.

Step 9: Open the shortcut.

It will give you welcome page.


Oracle SQL –

Script Output:

Query Result:

Learning Outcomes

• Ability to install and use Oracle Database and SQL Developer.

• Understanding of basic SQL DDL commands in Oracle.

• Skill in creating, inserting, viewing, and deleting database tables.

• Improved knowledge of structured database management using Oracle SQL.

You might also like