What is an Oracle database?

Introduction to Oracle SQL

Sara Billen

Curriculum Manager

Man in business attire behind some database figures

Oracle SQL

Database diagram

Oracle logo

Oracle Database: relational database management system developed by Oracle
PL/SQL (Procedural Language/SQL): Oracle's implementation of SQL, with additional functionality

DB-Engines ranking of different database management systems

Oracle SQL

Advantages

Great for large databases
Easy to use
Well-written documentation
Amazing new features

Disadvantages

Cost

Entity-Relationship Diagram (ERD)

Databases support existing real-world systems
ERD
- tool to model a real-world system
- graphical representation of the relationships among different entities

Entity-Relationship Diagram (ERD)

ERD

Entity-Relationship Diagram (ERD)

Enhanced ERD

Relational database

CustomerId	FirstName	LastName	Address
1	Jack	Smith	1 Microsoft Way
2	Marc	Dubois	11, Place Bellecour
3	Lucas	Mancini	Via Degli Scipioni, 43

Relational database

Enhanced ERD

SQL

SQL is a language to:

Create databases and the objects within them
Store data in those databases
Change and analyze that data
Get that data back out in reports, web pages, etc.

Retrieving data

SELECT TrackName, Composer, Milliseconds
FROM Track

| TrackName                | Composer         | Milliseconds |
|--------------------------|------------------|--------------|
| Killer Queen             | Mercury, Freddie | 182099       |
| Smells Like Teen Spirit  | Kurt Cobain      | 301296       |
| The Star Spangled Banner | Hendrix, Jimi    | 43232        |
| With Or Without You      | U2               | 299023       |

Let's practice!

Introduction to Oracle SQL