Oracle Database Introduction to SQL Ed 2

Course overview for the course Oracle Database Introduction to SQL Ed 2

This Oracle Database Introduction to SQL Ed 2 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 Information

  • Delivery Method: Classroom
  • Course Duration: 5 days
  • Course Level: Intermediate

Audience Summary

  • Database Administrators
  • PL/SQL Developers

Prerequisites for the course Oracle Database Introduction to SQL Ed 2

Recommended Related Training Courses:

  • Oracle Database: SQL and PL/SQL Fundamentals Ed 2
  • Oracle Database: Program with PL/SQL Ed 2

Learn To:

  • Identify what a SQL statement is.
  • Understand the Oracle Relational Database.
  • Use SQL Developer.
  • Write reports using SQL Statements.
  • Manipulate data in relational tables and save the data.

Course content summary for the course Oracle Database Introduction to SQL Ed 2

  • 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

More Evolutiontech Courses for Oracle Database

Fale Conosco

Solicite o conteúdo programático completo do treinamento “for the course Oracle Database Introduction to SQL Ed 2” ao nosso departamento comercial

Deixe uma resposta

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *