ORACLE DATABASE 19C: SQL WORKSHOP

ORACLE DATABASE 19C: SQL WORKSHOP

Summary

Location

Location

Malaysia

Duration

Duration

5 Days
Format

Format

Public Class

Public Class

Unlock Your Potential with Oracle Training

Are you ready to supercharge your career with top-notch Oracle training? Look no further than Info Trek’s ‘Oracle Database 19c: SQL Workshop’ course. This comprehensive 5-day instructor-led program is designed for administrators, analysts, developers, and systems administrators, and it’s your ticket to mastering the Oracle Database 19c.

What You'll Learn

In this course, you’ll delve into the intricacies of Oracle Database 19c, from understanding its structural components to crafting powerful SQL queries. You’ll learn how to retrieve and manipulate data, create tables, manage schema objects, and so much more. With a focus on hands-on exercises and interactive lectures, you’ll gain the practical skills you need to excel in the corporate world.

Elevate Your Career

Oracle training isn’t just about mastering technology; it’s about elevating your career to new heights. Whether you’re a seasoned IT professional or just starting, this course will equip you with the expertise to optimize database performance, reduce IT costs, and provide top-tier service. Don’t miss this opportunity to unlock your full potential and stay ahead in the fast-paced corporate landscape. Join Info Trek’s Oracle training and start your journey to success today!

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
RM6500
Intake Date
4-8 MAR 2024
,
6-10 MAY 2024
,
15-19 JULY 2024
,
2-6 SEPT 2024
,
11-15 NOV 2024
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. *