Installing Oracle Database
To install the Oracle database on your computer, you need to download the installer from the below
link.
https://drive.google.com/drive/folders/13iCU3E6x8DoHVVmYDTtmyp2dnJiEEDJd?usp=sharing
After having the installation files which are in ZIP format, you need to extract them into a specific
folder on your computer.
The following picture shows the structure of the folder of the Oracle installation
files after extraction.
Installing Oracle Database
Now you need to double-click the setup.exe file to start the installation process. There will be 9 steps
that mostly automatically execute.
Step 1. It will show below window.
Installing Oracle Database
Step 2. Click on Next button.
Installing Oracle Database
Step 3. Select I accept the term in the license agreement
and click on next button.
Installing Oracle Database
Step 4. click on next button.
Installing Oracle Database
Step 5. Click on YES.
Installing Oracle Database
Step 6. Enter your password e.g sys and confirm your password sys.(both password should
be same) and click on next button.
Installing Oracle Database
Step 7. Click on Install button.
Installing Oracle Database
Step 8. Now installation process will be start (if any window is appear on your screen click
on YES. ) .
Installing Oracle Database
Step 9. Once installation completes successfully, the installer will inform you as shown in the
following screenshot. Click the Finish button to close the window.
Installing PL/SQL Developer
To install the Oracle database on your computer, you need to download the installer from the below
link.
https://drive.google.com/drive/folders/13iCU3E6x8DoHVVmYDTtmyp2dnJiEEDJd?usp=sharing
After having the installation files which are in ZIP format, you need to extract them into a specific
folder on your computer.
Installing PL/SQL Developer
Step 1. Open extracted folder and double click on plsqldev1103 exc file and click on ok/yes
button.
Installing PL/SQL Developer
Step 2.Click on I agree button.
Installing PL/SQL Developer
Step 3.Click on next button.
Installing PL/SQL Developer
Step 4.Click on next button.
Installing PL/SQL Developer
Step 5.Click on Finish button.
Installing PL/SQL Developer
Step 6.Click on close button.
Installing PL/SQL Developer
Step 7. PLSQL Developer icon is created on your desktop double click on that icon. Below
window will be open.
Installing PL/SQL Developer
Step 8. Please keep Username as it is i.e sys, enter password which you have enter at the
time of oracle installation e.g sys,
Database XE and Connect as SYSDBA.
Installing PL/SQL Developer
Step 9. Click on OK. Now you are able to connect database server using PLSQL Developer.
Introduction to Core
Database Concepts
Getting started with Databases and Structure Query Language (SQL)
Objectives
Define Databases
Discuss the functionality of relational database management systems.
Define SQL
What is a Database (db)?
A Database (db) is an organized collection of data, typically stored in electronic format.
It allows you to input, manage, organize and retrieve data quickly.
Traditional databases are organized by records (rows), fields (columns) stored in tables which
are stored in database files.
It’s a file used to store information.
A database table is a collection of rows and columns that is used to organize
information about a single topic or object. Each row within a table corresponds to a
single record and contains several different attributes that describe the row.
A database table is the most common and simplest form of data storage in a relational
database.
What is a database schema?
The database schema defines how the data is organized and how the relationships between them are
associated. In addition, it determines all the restrictions that will be applied to the data.
A database schema is basically like any other database object. It is like a container for other objects
that makes it easy to manage sets of objects in complex databases, which could help database
administrators grant roles and permissions establishing the security that is so necessary when working
with data in a database.
A database user account has a specific database password and privileges. Each user account has a
unique schema which, as we mentioned before, has the same name as the user. The database schema
contains the data of the user who owns the schema. For example, the HR user account owns the HR
schema which contains schema objects such as the Employees (EMP) table.
In short, we can think of a database as a box that contains objects of type schemas, tables, indexes,
etc. And a schema is the container for all the objects of a user account.
What is a Database (db)?
What is a Database (db)?
A relational database is a collection of tables of data all of which are formally
described and organized according to the relational model. Each table must identify a
column or group of columns, called the Primary Key, to uniquely identify each row.
Entity
Object comprised of various pieces of data.
Attribute
Piece of information (data) that describes an entity.
What is a Database (db)?
Database Management System (DBMS) is a software application/tool used by end
users to access the data stored in the database files. A DBMS is also used to perform
administrative tasks on the database and objects contained within the database.
DBMS is a collection of applications that allow users and other programs to capture
and analyze data by providing additional functionality like reporting services to help
you create, deploy and manage reports for your organization.
This application is responsible for handling data requests, committing changes to the
data and enforcing the structure of the database including:
Ensuring data is stored properly and that rules for defining data are not violated.
Providing a level of disaster recovery by which data can be restored to a consistent state.
Maintaining relationships between data entities residing in the database.
What is a Database (db)?
What is a Database (db)?
Relational Database Management Software (RDBMS) is a software system
designed to allow the definition, creation, querying and updating of data stored in a
relational database.
A few examples of RDBMS include:
Microsoft SQL Server
Microsoft Access
MYSQL
Oracle
What is a Database (db)?
An instance of an RDBMS such as oracle contains many objects.
The database itself
Transaction Log
Tables
Indexes
Filegroups
Views
Stored Procedures
Users/Roles
What is a Database (db)?
The main differences between DBMS and RDBMS are:
A DBMS has to provide some uniform methods independent of a specific application accessing
the information that is stored in the tables.
RDBMS adds the additional condition that the system supports a tabular structure for the
data, with enforced relationships between the tables.
DBMS does not impose any constraints or security with regard to data manipulation, while
RDBMS does utilize an internal security model.
RDBMS is the basis for Structured Query Language (SQL).
What is SQL?
Structure Query Language (SQL)
Used to insert, retrieve, modify and delete data in a relational database.
The language is supported by most relational databases with slight variations.
Originally developed by IBM in mid 1970s.
PLSQL
Used in oracle database management systems.
What is Oracle 11g
Robust, feature laden Relational Database Management System.
Can support the most demanding applications.
The administrative tools and simple installation make it one of the easiest database
servers to configure and deploy.
Scalability and Availability
Availability
Ability of a system to be constantly accessible by it’s users.
Provides reliability through features like online backups, failover clustering and log shipping.
Scalability
Ability to easily grow in size to support a growing user base.
Distributed partition view which is a single queriable entity that is horizontally partitioned and housed
on multiple physical computers.
Summary
A database (db) is an organized collection of data, typically stored in electronic format.
Microsoft SQL Server and Oracle are examples of relational databases.
DBMS is an application used to perform administrative tasks on database and used to
interact with data stored in databases.
Database server hosts DBMS system and one or more instances of SQL Server.
SQL Developer and PLSQL Developer is GUI used to oracle data base server, its
databases, and the content contained within the database.
Relational databases allow data entities to be defined in tables.
A set of attributes for a given entity is defined as a row in a table (a collection of
column values).
Summary
Relational databases perform the following functions:
Ensure data is stored properly and that rules for defining data are not violated.
Providing some level of disaster recover.
Maintaining relationships between data entities residing in the database.
Data base is capable of high availability and scalability through clustering and
improved backup functionality.
