This Oracle Database 12c: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

Learn to:

• Understand the basic concepts of relational databases ensure refined code by developers.
• Create reports of sorted and restricted data.
• Run data manipulation statements (DML).
• Control database access to specific objects.
• Manage schema objects.
• Manage objects with data dictionary views.
• Retrieve row and column data from tables.
• Control privileges at the object and system level.
• Create indexes and constraints; alter existing schema objects.
• Create and query external tables.

Course objectives:

• Identify the major structural components of the Oracle Database 12c
• Manage objects with data dictionary views
• Manage schema objects
• Retrieve row and column data from tables
• Run data manipulation statements (DML) in Oracle Database 12c
• Use scalar and correlated sub-queries
• Utilize views to display data
• Write SELECT statements that include queries
• Write multiple-column sub-queries
• Control database access to specific objects
• Create reports of aggregated data
• Create reports of sorted and restricted data
• Create tables to store data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Employ SQL functions to retrieve customized data

Read the official course description here. 

Stedsbeskrivelse

Our Oracle courses will take place at Glasspaper`s course center at Crayon in Nydalen:
Adress: Crayon, Sandakerveien 114A, 0402 Oslo. 9-16

Forkunnskaper

• Data processing
• Familiarity with data processing concepts and techniques

Varighet

5 days

Innlevering

This course is recommended as preparation for exam 1Z0-071.

Målgruppe

• Datavarehusadministrator
• PL/SQL-utvikler

Les mer om Glasspaper

Se flere kurs fra Glasspaper (193)

17 Kurs i SQL programmering