Introduction into Databases and SQL Language in the Oracle

Students learn basic skills needed for working with Oracle database. The course covers SQL fundamentals to retrieve, insert, update or delete data in database and fundamentals of procedural PL/SQL. Students get familiar with Oracle [...]

OFUN
Duration 3 days
30 ITK points
6 terms
Praha (23 625 Kč)

Brno (23 625 Kč)

Bratislava (990 €)

IT Project Managers

System Analytics

Developers

Administrators

Technical Support Staff

What we teach you

Introduction to relation databases
Data modeling
Purpose and benefits of ER Diagrams
Fundamentals of Oracle architecture
SQL fundamentals
PL/SQL fundamentals
Introduction to Object-oriented technology
Workshop

Required skills

Familiarity with data processing concepts and techniques

Ability to use a graphical user interface (GUI)

Course Outline

Database management systems

What is database systems

Traditional database systems

Relational database systems

Data modeling

Oracle software life cycle

Conceptual data models

Data storage in relational databases, data normalization

Oracle architecture fundamentals

Why to understand the architecture

Logical, Physical and memory structures

Oracle 9i features

Oracle product family

SQL fundamentals

What is SQL

SELECT statement

Data Definition Language (DDL)

Data Manipulation Language (DML)

Transaction Control Language (TCL)

Data Control Language (DCL)

Differences in SQL and SQL*Plus

PL/SQL fundamentals

What is PL/SQL

PL/SQL basics

Control structures in PL/SQL

Introduction to Object-oriented technology

OO basics

Object-Relations Database Management Systems

Workshop

Workshop

Download PDF detail
Download PDF detail (no terms)

The prices are without VAT.

Introduction into Databases and SQL Language in the Oracle

What we teach you

Required skills

Course Outline

GOPAS Praha

GOPAS Brno

GOPAS Bratislava

Business details

Introduction into Databases and SQL Language in the Oracle

What we teach you

Required skills

Course Outline

Next courses

GOPAS Praha

GOPAS Brno

GOPAS Bratislava

Business details