Live Chat Support

Oracle Database: Introduction to SQL Ed 2 (D80174)

Oracle Database: Introduction to SQL Ed 2 (D80174)

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
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
N/A
  • Data processing
  • Familiarity with data processing concepts and techniques
Course ID:
D80174


Show Schedule for:

Please provide as much information as possible for us to help you with your enquiry.