Oracle Database 19c: SQL Workshop | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Oracle Database 19c: SQL Workshop

Location

Format What’s this?
Starting From
RM 5900.00
  1. 5 Day with 08 hours per day
  1. Mon 19 Sep 09:00 - Fri 23 Sep 17:00
  1. HRDF SBL Claimable
  2. Certificate of Attendance available
  1. 5 Days
  1. All of our private classes are customized to your organization's needs.
  2. Click on the button below to send us your details and you will be contacted shortly.
Request more information

Inquiry for: Myself    My Company

By providing your contact details, you agree to our Privacy Policy

 

 

 

Thank You

Our learning consultant will get back to you in 1 business day

Oracle Database 19c: SQL Workshop

WHAT YOU WILL LEARN

This Oracle Database: 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.


Benefits to You

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.


Learn Advanced Features of SQL

This course will help you understand the advanced features of SQL. Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL through expert instruction.


AUDIENCE

• Administrator

• Analyst

• Developer

• Systems Administrator


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.


Expand All

Modules

Module 1: Introduction

• Introduction

• Entity Relationship Model

• Practice 1-1: Introduction


Module 2: Retrieving Data Using the SQL SELECT Statement

• Retrieving Data Using the SQL SELECT Statement

• Practice 2-1: Retrieving Data Using the SQL SELECT Statement


Module 3: Restricting and Sorting Data

• Restricting and Sorting Data

• Practice 3-1: Restricting and Sorting Data


Module 4: Using Single-Row Functions to Customize Output

• Using Single-Row Functions to Customize Output

• Number Functions

• Practice 4-1: Using Single-Row Functions to Customize Output


Module 5: Using Conversion Functions and Conditional Expressions

• Using Conversion Functions and Conditional Expressions

• General Functions

• Practice 5-1: Using Conversion Functions and Conditional Expressions


Module 6: Reporting Aggregated Data Using the Group Functions

• Reporting Aggregated Data Using the Group Functions

• Practice 6-1: Reporting Aggregated Data by Using Group Functions


Module 7: Displaying Data from Multiple Tables Using Joins

• Displaying Data from Multiple Tables Using Joins

• Practice 7-1: Displaying Data from Multiple Tables by Using Joins


Module 8: Using Subqueries to Solve Queries

• Using Subqueries to Solve Queries

• Practice 8-1: Using Subqueries to Solve Queries


Module 9: Using Set Operators

• Using Set Operators

• Practice 9-1: Using Set Operators


Module 10: Managing Tables Using DML Statements in Oracle

• 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


Module 11: Introduction to Data Definition Language in Oracle

• Introduction to Data Definition Language in Oracle

• FOREIGN KEY Constraint

• Practice 11-1: Introduction to Data Definition Language


Module 12: Introduction to Data Dictionary Views

• Introduction to Data Dictionary Views

• Before you Begin Practice 12: Using SQL Developer

• Practice 12-1: Introduction to Data Dictionary Views


Module 13: Creating Sequences, Synonyms, and Indexes

• Creating Sequences, Synonyms, and Indexes

• Sequence Information

• Practice 13-1: Creating Sequences, Synonyms, and Indexes


Module 14: Creating Views

• Creating Views

• Practice 14-1: Creating Views


Module 15: Managing Schema Objects

• Managing Schema Objects

• DROP TABLE

• Practice 15-1: Managing Schema Objects

• Practice 15-1: Managing Schema Objects…. Cntd


Module 16: Retrieving Data by Using Subqueries

• Retrieving Data by Using Subqueries

• Practice 16-1: Retrieving Data by Using Subqueries


Module 17: Manipulating Data by Using Subqueries

• Manipulating Data by Using Subqueries

• Practice 17-1: Manipulating Data by Using Subqueries


Module 18: Controlling User Access

• Controlling User Access

• Practice 18-1: Controlling User Access


Module 19: Manipulating Data Using Advanced Queries

• Manipulating Data Using Advanced Queries

• MERGE Statement

• Practice 19-1: Manipulating Data

• Practice 19-1: Manipulating Data…Cntd


Module 21: Conclusion

• Conclusion

• Q&A Sessions


Oracle Certified Trainer

Oracle Certified Trainer

Read More

Genesis Douglas Row

Genesis Douglas Row

Mr. Genesis Douglas Row has been working in the IT industry since 1996 and has contributed more than 17 years to the industry. Along the years, he has picked up skills in sales, marketing, business management, presales and product management that has made him an all-rounded skilled and experienced IT personnel in the industry.He has a strong technical background in Oracle Database Management, Solaris System Administration and Web Publishing. He has also proven to be a very talented and passionate trainer in delivering easy-to-understand, straight-to-the-point training sessions. He utilizes effective training techniques for maximum knowledge transfer, information retention and customer satisfaction. Read More

Course Reviews

No Remarks

0

0 Ratings