Oracle 10g DBA
Training/Coaching/Tuition by IANT (Institute of Advance Network Technology)
Vadodara, Ahmedabad, Jaipur, New Delhi, Indore, Pune, Gandhinagar, Anand, Bhavnagar, Bhuj, Deesa, Gandhidham View More +
|
Request Info |
| Eligibility: (Pre-requisites) | Familiarity with Data Processing Concepts & Techniques, Ability to use a graphical user interface (GUI) |
| Medium of instruction: | English |
Oracle Database 10g - Introduction to SQL (40 hours) Exam Code 1z0-047
Audience:
-
Database Administrators
-
Forms Developer
-
Portal Developer
-
Business Intelligence Developer
-
End Users
-
Application Developers
-
PL/SQL Developer
Required Prerequisites:
-
Familiarity with Data Processing Concepts & Techniques, Ability to use a graphical user interface (GUI)
Course Topics:
-
Introduction
-
Writing SQL SELECT Statements
-
Restricting and Sorting Data
-
Using Single-Row Functions to Customize Output
-
Reporting Aggregated Data Using the Group Functions
-
Displaying Data from Multiple Tables
-
Using Sub Queries to Solve Queries
-
Using the SET Operators
-
Manipulating Data
-
Using DDL Statements to Create and Manage Tables
-
Creating Other Schema Objects
-
Managing Objects with Data Dictionary Views
-
Controlling User Access
-
Manage Schema Objects
-
Manipulating Large Data Sets
-
Generating Reports by Grouping Related Data
-
Managing Data in Different Time Zones
-
Searching Data Using Advanced Sub Queries
-
Hierarchical Retrieval
Oracle Database 10g : Administration 1 (40 Hrs) Exam Code 1z0-042
Audience:
-
Database Administrators
-
Sales Consultants
-
Support Engineer
-
Project Manager
-
Database Designers
-
Technical Consultant
-
Required Prerequisites:
-
Working Knowledge of SQL
Course Topics:
-
Introduction (Database Architecture)
-
Installing Oracle Database Software
-
Creating an Oracle Database
-
Managing the Oracle Instance
-
Managing Database Storage Structures
-
Administering User Security
-
Managing Schema Objects
-
Managing Data and Concurrency
-
Managing Undo Data
-
Implementing Oracle Database Security
-
Configuring the Oracle Network Environment
-
Proactive Maintenance
-
Performance Management
-
Backup and Recovery Concepts
-
Performing Database Backups
-
Performing Database Recovery
-
Performing Flashback
-
Moving Data
Oracle Database 10g : Administration – II (40 hrs) Exam Code 1z0-043
Audience:
-
Technical Consultants
-
Sales Consultants
-
Database Administrators
-
Support Engineer
Required Prerequisites:
-
Oracle Database 10g: Administration Workshop I
-
Oracle Database 10g: Fundamentals I
-
Oracle Database 10g: SQL and PL/SQL Fundamentals
Course Topics:
-
Using Globalization Support
-
Securing the Oracle Listener
-
Configuring Recovery Manager
-
Using Recovery Manager
-
Diagnostic Sources
-
Recovering from Non-Critical Losses
-
Database Recovery
-
Flashback Database
-
Recovering from User Errors
-
Dealing with Database Corruption
-
Automatic Database Management
-
Monitoring and Managing Storage
-
Automatic Storage Management
-
Monitoring and Managing Memory
-
Managing Resources
-
Automating Tasks with the Scheduler
| Classroom - Regular | ||||
| When | Duration | Where | Remarks | Price |
| Not Specified | Not Specified | All Venues | Not Specified | Price On Request |
Vadodara, Subhanpura (Corporate Office):- 204,205, Pujer Complex Opp. Golden Silver Appt Subhanpura, Vadodara - 390 023, Gujarat, India
Ahmedabad, Paldi (Regional/Local Office):- 4th Floor, Murlidhar Complex, Fatehpura Cross Rd. Opp. Ankur School Paldi, Ahmedabad - 380 007, Gujarat, India
Jaipur, Sindhi Camp (Regional/Local Office):- 1st Floor, A-135, 136, 137, City Center, Sansar Chandra Road Sindhi Camp, Jaipur, Rajasthan, India
New Delhi, Pitampura (Regional/Local Office):- 366, Kohat Enclave Pitampura, New Delhi - 110088, Delhi, India
Indore, A. B. Road (Regional/Local Office):- 203, 2nd Floor, Saket Tower, Ratlam Kothi, Opp. Rukmani Motors Gitabhavan Square Nr. IDBI Bank A. B. Road, Indore, Madhya Pradesh, India
Pune, Shivaji Nagar (Regional/Local Office):- 1st Floor, Laxmi Sadan Apartments, Opp. Kalmadi Petrol Pump J.M. Road Shivaji Nagar, Pune - 411001, Maharashtra, India
Ahmedabad, Maninagar (Branch):- 4th Floor, Nikunjchhaya Complex Nr. Sankalp Restaurant, Krishnabaug Maninagar, Ahmedabad - 380 008, Gujarat, India
Ahmedabad, Ashram Road (Branch):- 2rd, Floor, Dhanlakshmi Complex, Opp. Jet Airways Office Income Tax - Cross Road Ashram Road, Ahmedabad, Gujarat, India
Gandhinagar, Chandkheda (Branch):- 208 Sarjan II, Above Punjab National Bank New C.G.Road Chandkheda, Gandhinagar, Gujarat, India
Ahmedabad, Naranpura (Branch):- B-408, Shivalik Yash, 132ft Ring Road Opp Shastri Nagar BRTS Bus stand, Naranpura cross road Naranpura, Ahmedabad, Gujarat, India
Anand, Vallabh Vidyanagar (Branch):- Lotos Complex, Nr. R .K. Cycle Store, B/h. Ambassy Centre Mota Bazar Vallabh Vidyanagar, Anand - 390023, Gujarat, India
Bhavnagar, Waghawadi Road (Center):- Waghawadi Road, Bhavnagar, Gujarat, India
Bhuj, Jubily Mandvi Road (Center):- Jubily Mandvi Road, Bhuj, Gujarat, India
Deesa, Gayatri Mandir (Center):- Gayatri Mandir, Deesa, Gujarat, India
Gandhidham, Tagore Road (Center):- Tagore Road, Gandhidham, Gujarat, India
Godhra, Anandnagar (Center):- Ankleswer Mahadev Raod Anandnagar, Godhra, Gujarat, India
Jamnagar, Sunnair Club Road (Center):- Sunnair Club Road, Jamnagar, Gujarat, India
Junagadh, Vnazari Garbi Chowk (Center):- Vnazari Garbi Chowk, Junagadh, Gujarat, India
Mahesana, Nagalpur (Center):- Nr. Nagalpur Khadiya Collage Nagalpur, Mahesana, Gujarat, India
Palanpur, Zilla Parishad (Center):- Zilla Parishad, Palanpur, Gujarat, India
Patan, Sidhpur Cross Road (Center):- Sidhpur Cross Road, Patan, Gujarat, India
Surat, Race Course Road (Center):- Bhulka Bhavan Race Course Road, Surat, Gujarat, India
Valsad, Avabai School Road (Center):- Avabai School Road, Valsad, Gujarat, India
Veraval, Tower Chowk (Center):- Tower Chowk, Veraval, Gujarat, India
Visnagar, Station Road (Center):- Station Road, Visnagar, Gujarat, India
Ujjain, Dewas Gate (Center):- Dewas Gate, Ujjain, Madhya Pradesh, India
Bhopal, M. P. Nagar (Center):- M.P. Nagar Zone 2 M. P. Nagar, Bhopal, Madhya Pradesh, India
Jabalpur, Home Science College Road (Center):- Home Science College Road, Jabalpur, Madhya Pradesh, India
Ratlam, Station Road (Center):- Station Road, Ratlam, Madhya Pradesh, India
