INTRODUCTION
PART 1
TEKWILL 2021
Course Objectives
Oracle Database
Relational and Object Relational DB Management System
Data Models
Entity Relationship Model
Relational Database Terminology
AGENDA Tables Used in this course
Using SQL to Query Your Database
How SQL works
Introduction to Oracle SQL Live
Browsing Database Objects
Displaying the Table Structure
Tools
COURSE OBJECTIVE
Do you need to analyze and work with large volumes of data? For anyone looking to improve their knowledge of SQL (structured query
language) this course will teach you how to write SQL select statements to retrieve and analyze your data from a relational database.
This course offers you an introduction to the Oracle Database technology. Completing this course will equip you with essential SQL skills.
1 2 3 4 5
Identify the major Retrieve row and Create reports of Generate and Run complex
components of column data from sorted and retrieve queries to retrieve
Oracle Database tables with SELECT restricted data customized data data from multiple
statement tables
ORACLE DATABASE
What is a relational database?
High
Availability
Performance Manageability
Security Information
Integration
RELATIONAL AND OBJECT
RELATIONAL DB MANAGEMENT
SYSTEM
✓Relational model and object relational
model;
✓User-defined data types and objects;
✓Fully compatible with relational
database;
✓Supports multimedia and large objects;
✓High-quality database server features.
DATA MODELS
✓Hierarchical
✓Network
✓Relational
✓Object Relational
DATABASE DESIGN
Models help to
communicate the concepts
that are in people’s minds.
Models can be used to do the following:
• Communicate
• Categorize
• Describe
• Specify
• Investigate
• Evolve
• Analyze
• Imitate
ENTITY RELATIONSHIP SCENARIOS
MODEL
• “…Assign one or more employees
to a department…”
• “…Some departments do not yet
have assigned employees”
• “…Supervisor wants to check how
many employees has he per
project…”
KEY COMPONENTS
ENTITY : AN ASPECT OF ATTRIBUTE : RELATIONSHIP – A
SIGNIFICANCE ABOUT SOMETHING THAT NAMED ASSOCIATION
WHICH INFORMATION DESCRIBES OR BETWEEN ENTITIES
MUST BE KNOWN. QUALIFIES AN ENTITY. SHOWING
OPTIONALITY AND
DEGREE
RELATING
MULTIPLE
TABLES
• Each table can have one
PRIMARY KEY, which in effect
names the row and ensures no
duplicate rows exist.
• A FOREIGN KEY is a column (or
a set of columns) that refers to a
primary key in the same table or
another table.
RELATIONAL
DATABASE
TERMINOLOGY
1. Row
2. Column/Attribute - PK
3. A column that is not a key
value
4. Column/Attribute - FK
5. Field
6. Null value
TABLES USED IN THIS
COURSE
• Main tables used in this course:
• EMPLOYEES
• DEPARTMENTS
• JOB_GRADES
USING SQL TO QUERY
YOUR DATABASE
SQL is
• The ANSI standard language for
operating relational databases;
• Efficient, easy to learn and use;
• Functionally complete (with SWL,
you can define, retrieve and
manipulate data in tables)
HOW SQL WORKS
• SQL provides automatic navigation to the data.
• SQL processes groups of data.
• SQL lets you work with data at a logical level.
• SQL uses statements that are complex and
powerful individually and are therefore
standalone.
SQL
STATEMENTS
USED IN THE
COURSE
TOOLS DEMO
TOOL:
SQL DEVELOPER
ONLINE TOOL: ORACLE SQL LIVE
HTTPS://LIVESQL.ORACLE.COM
THANK YOU!
