ORACLE DATABASE 19C: SQL WORKSHOP

ORACLE DATABASE 19C: SQL WORKSHOP

Summary

Location

Location

Malaysia

Duration

Duration

5 Days
Format

Format

Public Class

Public Class

Course Details

Duration: 5 days; Instructor-led

Audience

  • Administrator
  • Analyst
  • Developer
  • Systems Administrator

Prerequisites

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.

Course Objectives

  • Identify the major structural components of the Oracle Database 12c
  • Create reports of aggregated data.
  • Write SELECT statements that include queries.
  • Retrieve row and column data from tables.
  • Run data manipulation statements (DML) in Oracle Database 12c
  • Create tables to store data.
  • Utilize views to display data.
  • Control database access to specific objects
  • Manage schema objects.
  • Display data from multiple tables using the ANSI SQL 99 JOIN syntax
  • Manage objects with data dictionary views.
  • Write multiple-column sub-queries.
  • Employ SQL functions to retrieve customized data.
  • Use scalar and correlated sub-queries.
  • Create reports of sorted and restricted data.

Outlines

  • Introduction
  • Entity Relationship Model
  • Practice 1-1: Introduction
  • Retrieving Data Using the SQL SELECT Statement
  • Practice 2-1: Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Practice 3-1: Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Number Functions
  • Practice 4-1: Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • General Functions
  • Practice 5-1: Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Practice 6-1: Reporting Aggregated Data by Using Group Functions
  • Displaying Data from Multiple Tables Using Joins
  • Practice 7-1: Displaying Data from Multiple Tables by Using Joins
  • Using Subqueries to Solve Queries
  • Practice 8-1: Using Subqueries to Solve Queries
  • Using Set Operators
  • Practice 9-1: Using Set Operators
  • Managing Tables Using DML Statements in Oracle
  • State of Data
  • Practice 10-1: Managing Tables by Using DML Statements
  • Practice 10-1: Managing Tables by Using DML Statements…. Cntd
  • Introduction to Data Definition Language in Oracle
  • FOREIGN KEY Constraint
  • Practice 11-1: Introduction to Data Definition Language
  • Introduction to Data Dictionary Views
  • Before you Begin Practice 12: Using SQL Developer
  • Practice 12-1: Introduction to Data Dictionary Views
  • Creating Sequences, Synonyms, and Indexes
  • Sequence Information
  • Practice 13-1: Creating Sequences, Synonyms, and Indexes
  • Creating Views
  • Practice 14-1: Creating Views
  • Managing Schema Objects
  • DROP TABLE
  • Practice 15-1: Managing Schema Objects
  • Practice 15-1: Managing Schema Objects…. Cntd
  • Retrieving Data by Using Subqueries
  • Practice 16-1: Retrieving Data by Using Subqueries
  • Manipulating Data by Using Subqueries
  • Practice 17-1: Manipulating Data by Using Subqueries
  • Controlling User Access
  • Practice 18-1: Controlling User Access
  • Manipulating Data Using Advanced Queries
  • MERGE Statement
  • Practice 19-1: Manipulating Data
  • Practice 19-1: Manipulating Data…Cntd
  • Managing Data in Different Time Zones
  • Practice 20-1: Managing Data in Different Time Zones
  • Conclusion
  • Q&A Sessions

Trainers

Reviews

Interested In

ORACLE DATABASE 19C: SQL WORKSHOP

Starting From
RM5900
Intake Date
2-6 OCT 2023, 4-8 DEC 2023
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Book Now

Course Name: ORACLE DATABASE 19C: SQL WORKSHOP
Duration: 5 Days
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM
0.00

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Download Details

Name *
Email *
Contact No. *