Connect with us:

Client Testimonials

"This is the second Cognos class I've taken with the same instructor, and what I love most is that he is so knowledgeable and course materials provide step by step instructions that you can easily use out in the real world. Great job!"

Student - RGCO-230 Cognos 8 Report Studio Introduction

View More Testimonials

Using SQL Navigator 4 Training

Available in LearnGreen Course Number: DBOR-600
Duration: 1 day

Price per Student for Scheduled Classes: $500.00
Contact Us for Group Pricing

Format: On-Site Training, Virtual Training

Print this page

Course Description

This course is designed to provide a comprehensive introduction to Quest Software’s SQL/Navigator Oracle development tool. Students will learn to use SQL/Navigator to execute SQL commands, research the Oracle data dictionary and use the PL/SQL development and debugging features.

Course Objectives

Upon completion of the course, students will be able to:

Apply the DB Navigator
Work with SQL statements and scripts
Edit, debug, and optimize PL/SQL code
Operate the Explain Plan tool
Operate SQL/Modeler to quickly develop complex SQL
Customize SQL/Navigator

Course Audience

Programmers
Software QA Personnel
Database Administrators

Course Prerequisites

Experience using SQL with Oracle and PL/SQL is required

Course Topics

Introduction
- Starting Navigator and Setting Preferences
- Using the SQL Editor
- Statement Recall
- Updateable Query
- Multiple SQL Statements in the Editor
- CRUD Matrix
- Comments
- Working with the Result Grid
- Exporting the Result Grid
- Determining Column Names
- Describe
- Spooling Plain Text
- Fetch All
Scripts, Workspaces and DB Navigator
- Opening a Script File
- Creating a Script File
- Script files with variables
- Scan Define On
- Using Double Ampersand Variables
- Undefine
- DataBase Navigator
- DataBase Details
- Workspaces
SQL Modeler
- Building a Select statement
- Identifying columns
- Generate a where statement
- Adding an Order by
- Global where clause
- Joining tables
- Using a Sub Query
- Null Value Substitution
- Aggregate Functions
- Group By
- Having
Object Utiltities
- Using the Search Feature
- Object Type Menu
- Create a Table, Column Definition
- Viewing Table Data
- Viewing and adding constraints (check, primary key, foreign key, unique)
- Viewing and Creating Indexes
- Create SQL Option
- Clone
- Triggers
- Dependencies
- Table Options
- Describe
- Grant
- Revoke
- Analyze
- Browse Data
- Edit Data
- Views
- Sequences
- Explain Plan
- SQL Navigator Reports
PL/SQL
- Using SQL Editor
- Compile and Execute a function
- PL/SQL Editor features
- Code Assistant, Formatter
- Handling Compiler Errors
- Testing from the Code Window
- Supplying Values
- Commit/Rollback Option
- Debugging PL/SQL
- Activating PL/SQL Debugging
- Testing with the Debugger
- Setting breakpoints
- Viewing and modifying variable contents
- Watch Window
- Creating put_line output
- Testing with put_line output
- Run to Cursor, Step Over, Trace Out
- Conditional Breakpoints
- Auto Trace
- Update Existing Functions
- Stored Procedures
- Just in Time Debugging a Procedure
- Using SQL/Plus as the application
- Debugging an application program that calls a stored procedure
- Triggers: writing and debugging
- Packages: writing and debugging
- Testing a package that returns a cursor
- Debugging a package that returns a cursor
- Just in Time debugging a function