FB

Introduction to Toad for Oracle


This course will teach you how to get started using Toad for Oracle.


You'll learn:

  • How to download and install Toad for Oracle
  • Work with files and projects to organise your information
  • Using the Schema Browser and other Toad features to work with objects
  • Compare tables, objects, and schemas
  • Data import and export
  • Formatting code, debugging
  • Saving time with Code Snippets and Code Completion

Course Length: 2h 26m

Get Access to All Courses Now

Access this course and all other courses (and more) in Database Star Academy instantly:

Course Topics:

Introduction

  • What is Toad
  • Download and Install
  • Create and Edit Database Connections

Editor

  • Work with multiple SQL statements
  • Save and load files
  • Desktops and Jump Search
  • Bookmarks
  • Find in Files, and Find and Replace

Browsers and Objects

  • Schema Browser, Database Browser, Session Browser
  • Describe Objects
  • Object Search
  • Create, Modify, and View Objects

Copy and Compare

  • Copy Data to Another Table
  • Compare Data Wizard
  • Compare Objects, Schemas, and Files
  • Export and Import Data

Editor Features

  • Working with the Data Grid
  • Code Completion
  • Code Snippets
  • Using the Code Formatter
  • Srip Code and Make Code
  • SQL Recall and Saved SQL

PL/SQL and Debugging

  • Refactoring - Extract Procedure
  • DBMS Output
  • Debugging
  • Breakpoints
  • Watches and Smart Watches

© 2019 Database Star | Privacy | Terms of Service