Oracle 10g DBA
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
IANT (Institute of Advance Network Technology)
India's No.1 Hardware and Networking Institute. IANT is emerging as a prospectiveleader in IT education and headed to establish a landmark in Education Industry.Quality thoughts & quality trend is driving the organization to adapt latest technology& techniques. Technological growth of students is perforated with personality traits,which make them an asset for any organization.
As far as IT industry is concerned, old is obsolete. we are proactive to our vendorsto launch their latest technology to be the first ones in country to introduce.