Oracle Database 19c: SQL Workshop

Cui îi este dedicat cursul?

Database Administrator, Database Developer, Developer

Cunoștințe și abilități inițiale

-

Prezentarea cursului

This course offers students an introduction to Oracle Database 19c database technology. In this class students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

Ce subiecte abordează cursul

Retrieve Data using the SQL SELECT Statement

Restrict and Sort Data

Customize Output Using Single-Row Functions

Use Conversion Functions and Conditional Expressions

Report Aggregated Data Using the Group Functions

Display Data from Multiple Tables Using Joins

Manage Tables by Using DML Statements

Create Sequences, Synonyms, Indexes, Views, and Schema Objects

Manage Data by Using Subqueries and Advanced Queries

Control User Access and Manage Data in Different Time Zones

Ce abilități se dobândesc în urmă cursului

• -