Course Overview
1h 09m | 11 Videos | 80627 Views | 
All Levels What is Toad 12.6 and Oracle?
Toad is short for Tools for Oracle Application Development (TOAD). It is used for application development, business intelligence, database development and help developers deploy Oracle based apps and web services on the Windows platform. The applications are used by developers to create user interfaces, business logic, web services and related things.
Oracle Corp is a leading software company based in Redwood, California who primary business is database products apart from being leading champions of networking. Their relational database products were the first to support SQL language.
About Toad 12.6 for Oracle
Toad 12.6 for Oracle aims to provide training in essential concepts of Toad from fundamentals, installation, schema browser usage, views schema, menu schema tables and menu options, functions and procedures in Toad.. It integrates seamlessly with the Toad World user community, empowering users to get answers from industry experts. Learners will understand developer functions through a tool, functions and procedures in TOAD. It contains 11 lectures with 2 hours of HD video.
Introduction to Toad:
TOAD was developed by Jim McDaniel, practicing Oracle Database Administrator in 1990’s for internal use. Initially developed as shareware, it was converted to freeware, for distribution over internet. With the growth of software, enhancement requests were difficult to meet and it was acquired by Quest Software in 1998 and subsequently by Dell in September 2012.
Toad- is ranked by IDC as the leading database development and optimization software. Improves project management, team collaboration, and system performance. Advantages- implement consistent, repeatable process, support agile database development, delivers high performing DB apps in record time, identifies, resolves DB performance inefficiencies, does DB maintenance tasks programmatically, automates SQL optimization.
Toad Installation:
Downloading freeware installer, installing freeware using freeware installer, installer creates the base install, toad home and installs a number of files not contained in any of the upgrades. Using Subsequent Upgrades to bring it latest version of Free Toad. Subsequent Upgrades- clear browser history, temp files, avoid downloading a cached version of zip file. Down load freeware update, unzip file into toad home dir created by initial installation. Run Toad as normal. Using Toad- when it loads- MDI Screen appears and initial Toad Server Login Window is displayed- prompt for Database, UserName, and Password.
Commercial versions – Dell- don’t install commercial over free ware, install in a separate directory using Wizard. Or else some functions will be affected adversely. Install Toad Bundle with apps SQL Optimiser (SQL Tuning) or Toad Data Modeler from DVD. Complete the wizard. Installing silently-extract MSI file from the Software Installer. Silently install product, or install through command line. Extract MSI file, Command line parameters.
System requirements– 1 GB RAM required for 32-bit, 2 GB RAM for 64 bit, Hard disk space-120 MB –Toad for Oracle 32 bit, 150 MB –Toad for 64 bit, OS- Windows Server 2003, Windows XP, Windows Vista, Windows Server 2008 (32 bit and 64 bit), Windows Server 2008 R2 (64-bit), -2 CPU reqd,
Windows 7 (32 bit, 64 bit), Windows 8 (32 bit, 64 bit), Windows Server 2012 (64 bit). Database Server-Oracle 8.0.06, 8.1.7, 9i, 9i, R2, 10 g, R2, 11 g,11 g R2, 12 c., Cloud Database service- Oracle DB running on Amazon EC2. Additional software- Microsoft Internet Explorer 6.0, Adobe Acrobat Reader 7 above. Before installation- review virtualization support- Application virtualization- Citrix XenAPP 5.0 and 6.5, Desktop virtualization- Dell Vworkspace 7.0 has been tested. Server virtualization- Oracle VM 3.1 tested, VMware ESX Server 3.5 tested.
Understanding Toad:
Schema Browser Usage– allows you to view, add, modify database objects. Displays detailed information about selected object-Available mostly with commercial version of Toad with the DB Admin module. Schema browsers – two panes – to review objects – Left hand side- list of objects to view, it can display additional information about the objects- table space, number of rows, hide leading characters of name. Right hand side- displays same list of objects as on left side- compare details between objects of the same type. When an object is selected on the left hand side, its details are displayed in the right hand side. Drop objects, enable/disable applicable objects, disable triggers for a table or for an entire schema. Customising displays for Schema Browsers. Change object types in the left-hand side. View| Toad Options|Schema Browser.
SQL Editor– lets user edit different types of statement and code, customize Editor behavior. Navigation Panel – displays outline of editor contents in active tab. Navigator displayed on left hand side. Editor- display code in separate tabs, create tabs for different bits of code, or different types of code, SQL, PL/SQL, location of curse, compiling PL/SQL or run SQL. Desktop panels- contains options to display tab, configure panel displays.
Toad Utilities:
Export Utility Wizard– helps transfer data objects between databases using Oracle’s legacy export utility. Interface to Oracle’s Utility, usually named Exp.exe, Exp73.exe, Exp80.exe. Import Utility Wizard- helps transfer data objects between Oracle databases using Oracle’s legacy import utility. Formatting files – Project Manager, Automation Designer- convert scripts, procedures, functions to fit company requirements. Formatting results tab. Comparing files – File Differences Viewer to compare contents of two files from a disk or an object to a file or another object. Compare objects in the Schema browser, compare differing objects from a schema compare.
Creating new actions– Automation Designer-navigation tree- select apps, click Toad App node where you want to create action. Create actions from Toad Window- support actions include a camera button in the status window. Run- apply changes to properties, run action, Apply-changes to properties , Cancel- cancel changes to properties, Rename.
Table Options– Import table data,rebuild table data- import table data without importable table structure- import to existing table. Create Table feature to import to new table. Import table data, truncate table, enable/disable constraints and triggers, AutoMap, mapping manually, field mapping dialog.
Menu Options-Create new tool bars and Menu, Customise toolbars and menus- right click the toolbar and select customize, change order of commands, add commands, rename tool bar, menu or command, remove a command or menu.
Functions and Procedures in Toad:
Functions procedure overview– MySQL– option to create functions and procedures. Functions- programs when called, return a single value- simple or complex values , multiple or single line of code. Called within an SQL statement. Procedures- do more than functions, cannot be run within SQL statements. Creating function similar to creating procedure. Procedure run differently from a function using a call command.
Different Views Schema:
View Table’s data in Schema Browser, split the window to show child or parent tables, how to view parent/child datasets in Schema Browser.
Customise Schema Browser,Change display of objects on left hand side, Schema Browser tool bar, tabbed, tree view.
Menu Schema Browser– Customising schema browser, left hand, right hand side displays, Configure LHS object types, RHS object types. Group Favourite Objects- group objects frequently used in schema, add objects to folder, add scripts, files. Create objects,parameters, generate DDL statement,to create or alter objects. Option – to create or modify object- Create object- use standard tool bar in Schema Browser, copy objects to other schema, create object based on existing one, using query templates, Schema Browser filters, creating browser filters, filter data, Clear Schema Browsers.
Requirements for Toad 12.6 course
Graduates in any discipline with basic computer knowledge, internet connectivity, knowledge of data bases and passion to learn and use TOAD for database applications.
Why learn Toad 12.6 for Oracle
With the increasing use of databases and applications, demand for database administrators well-versed in Oracle DB, MySQL, TOAD, PL/SQL. New opportunities are emerging for Senior Database Developers, Oracle Relational Database Developers, software engineers, SSE-SQL Developer, Oracle PL SQL developers globally.
Frequently Asked Questions (FAQ)
- Is it easy to learn TOAD for beginners?
Yes, the course assumes only basic computer knowledge, database awareness and a desire to learn. All the concepts are introduced in a simple, easy to understand manner and is object oriented. Therefore, less coding and mostly menu-driven.
- Is it certified by any major company or university?
No, it is not affiliated to any Indian or foreign university or IT companies. EduCBA’s experts have prepared the course in tune with the demands of industry.
- Do we need to buy software or install new hardware?
For training purposes it is not required to install any new hardware or software. Toad is available on free and commercial terms and can be installed and used as per user needs.
- How is the course delivered to learners?
This is a 100% online course having lectures and videos to support learning. Moreover, the content is accessible for a life time and learners can continue to refresh the lessons learnt from time to time with a login and password access.
- Who can gain from undertaking this course?
Students, professionals and any keen learner with a basic awareness of computers, database, applications and internet.
- Can we learn at our own pace or is it time bound?
The learner has the facility to learn at his own pace and can continue to access the content even after completion of the course.
- What certificate do we receive at the end of the Course?
EduCBA provides course completion certificate to all students who successfully complete the program.
- Is classroom support available for this program?
No , this is an online training program which is self-contained and self-explanatory. It doesn’t require class room support.
Testimonials
Erik Hatfield:
EduCBA has opened up a whole new range of opportunities for professionals and students in technology and management. I am really impressed by the course content. Toad 12.6 for Oracle was really informative and provided hand-on guidance in how to create and manage databases and applications. Toad available through open source and commercial basis has transformed the use of database applications, web services using Oracle. Database architects and SQL developers will greatly benefit from specializing in TOAD. I am glad to recommend this course to prospective learners.
Shawn Truesdell:
I had only rudimentary knowledge of database and programming, but EduCBA’s Toad 12.6 for Oracle truly opened my eyes to the tremendous possibilities in database administration, deployment and web services. It gives a comprehensive view of the features of Toad, how it functions, various components that go into it and the database and server platforms they work on. The free ware and commercial version provides opportunities for beginners to first try out free version and migrate to commercial versions with more functionalities. Understanding the tools used is one of the pre-requisites for climbing up the career ladder and database is no exception. I wish more database administrators and SQP/PL developers undergo this course for career advancement.
Alex Kollar:
The whole world now survives on databases and its management. Oracle, MySQL have all become indispensable for the globalized market players. Toad has emerged as an inexpensive and effective tool for management of databases and hence there is rising demand for experts in Toad. I have immensely benefited from Toad 12.6 for Oracle as it has equipped me with the knowledge, understanding and expertise in managing databases and web services. It is relatively easier to install and work, also supports cloud. This course is must for anyone in database management to provide better services to customers.
Romana Robinson:
Databases, relational databases can all benefit mankind only when various applications are developed for it. Software developers are constantly looking for tools to make their job better. Toad is a relatively new tool having been developed twenty years ago and now finding increasing acceptance in industry. Therefore, consultants, developers, software engineers stand to gain by grasping new tools. I am really happy to have undergone the Toad 112.6 for Oracle course which was simple, easy to understand and delivered using modern technology. The video content and lectures were of high quality. It is boon for industry professionals as well as students looking towards upgrading and specialization in various IT and management domains. I am very happy to recommend this course to anyone interested in databases, database management and web services. Lifetime access to course content is also a major attraction.
| Where do our learners come from? |
| Professionals from around the world have benefited from eduCBA’s Toad 12.6 for Oracle courses. Some of the top places that our learners come from include New York, Dubai, San Francisco, Bay Area, New Jersey, Houston, Seattle, Toronto, London, Berlin, UAE, Chicago, UK, Hong Kong, Singapore, Australia, New Zealand, India, Bangalore, New Delhi, Mumbai, Pune, Kolkata, Hyderabad and Gurgaon among many. |
