trainocate-oracle-training-b
Home > Vendors > Oracle > D80174

D80174 - Oracle Database: Introduction to SQL Ed 2

Overview

Duration: 5 days

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.

Objectives

Upon completing this course, the learner will be able to meet these overall 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

Content

Module 1: Introduction
Module 2: Working with Oracle Cloud Exadata Express Cloud Service
Module 3: Restricting and Sorting Data
Module 4: Using Single-Row Functions to Customize Output
Module 5: Using Conversion Functions and Conditional Expressions
Module 6: Reporting Aggregated Data Using the Group Functions
Module 7: Displaying Data from Multiple Tables Using Joins
Module 8: Using Subqueries to Solve Queries
Module 9: Using the SET Operators
Module 10: Managing Tables using DML statements
Module 11: Introduction to Data Definition Language
Module 12: Introduction to Data Dictionary Views
Module 13: Creating Sequences, Synonyms, Indexes
Module 14: Creating Views
Module 15: Managing Schema Objects
Module 16: Retrieving Data by Using Subqueries
Module 17: Manipulating Data by Using Subqueries
Module 18: Controlling User Access
Module 19: Manipulating Data
Module 20: Managing Data in Different Time Zones

Audience

  • Data Warehouse Administrator
  • PL/SQL Developer
  • Application Developers
  • System Analysts
  • Business Analysts
  • Forms Developer
  • Developer

Prerequisites

  • Data processing
  • Familiarity with data processing concepts and techniques

Certification

This course is not associated with any Certification.

Schedule

Show Schedule for: