Oracle Database: Introduction to SQL Ed 2

Seminarbeschreibung:

Introduction

Working with Oracle Cloud Exadata Express Cloud Service

Retrieving Data using the SQL SELECT Statement

Restricting and Sorting Data

Using Single-Row Functions to Customize Output

Using Conversion Functions and Conditional Expressions

Reporting Aggregated Data Using the Group Functions

Displaying Data from Multiple Tables Using Joins

Using Subqueries to Solve Queries

Using the SET Operators

Managing Tables using DML statements

Introduction to Data Definition Language

Introduction to Data Dictionary Views

Creating Sequences, Synonyms, Indexes

Creating Views

Managing Schema Objects

Retrieving Data by Using Subqueries

Manipulating Data by Using Subqueries

Controlling User Access

Manipulating Data

Managing Data in Different Time Zones

Introduction to Oracle Database

Retrieve Data using the SQL SELECT Statement

Learn to Restrict and Sort Data

Usage of Single-Row Functions to Customize Output

Invoke Conversion Functions and Conditional Expressions

Aggregate Data Using the Group Functions

Display Data From Multiple Tables Using Joins

Use Sub-queries to Solve Queries

The SET Operators

Data Manipulation Statements

Use of DDL Statements to Create and Manage Tables

Other Schema Objects

Control User Access

Management of Schema Objects

Manage Objects with Data Dictionary Views

Manipulate Large Data Sets

Data Management in different Time Zones

Retrieve Data Using Sub-queries

Regular Expression Support