Our Latest Offers

Oracle 10g Database Administrator


About Oracle 10g Database Administrator

Oracle 10g is a new version of database management system. Ascent It Services provides oracle 10g dba training according to the current requirement of IT industry. The Oracle Database 10g is a relational database management system (RDBMS) produced and marketed by Oracle Corporation. The specialty of this new version is the inclusion of grid computing capability, represented by 'g' in the name 10g. The term 10g DBA is often used for 10g Database Administrator, which represents a person or a group of people responsible for creation and maintenance of an Oracle 10g Database. Oracle Corporation offers a certification programme for DBAs under which a DBA can appear for an examination to test his DBA skills.

Oracle 10g Database provides efficient, reliable, secure data management for high-end applications such as high-volumeon-line transaction processing (OLTP) environments, query-intensive data warehouses, and demanding Internet applications. Our faculty provide how the student will learn and how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.

This course is designed to give you a firm foundation in basic database administration and advances your success as an Oracle professional in the area of database administration. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding oracle Certified Associate exam. Oracle continues to dominate the database industry. Several versions of Oracle are being used in the industry. Oracle is usually conducted on Microsoft Window Server platform. If you prefer, you can opt for Oracle on Linux/Ubuntu.

Before you continue, you should have a basic understanding of the following:

1. Knowledge of SQL.
2. Knowledge of Basic understanding of database.

Benefits of Courses:

1. Oracle Developer.
2. Oracle Developer.
3. Oracle Discoverer Services Developer.

Projects

1. We will provide real time project training with code explanation and implementation.
2. Our training modules are completely designed according to current IT market.
3. After completion of 75% of course, student will go through Major Project Training, Live Project Training, Interview Preparation and
     Recruitment process in IT Industry.
4. Student will go through the training of HTML, CSS and JavaScript as a complimentary package before starting of SQL Server.
5. We offer regular, fast track and weekend training in SQL Server course.
6. Study material is provided with the course which consist of concepts, examples and real time examples.

SQL
Relational Database Concepts Using SQL*Plus Using SQL Developer
1. What is an Oracle Database 1. What is SQL*Plus 1. What is Oracle SQL Developer
2. Relational Database Structures 2. Getting Started 2. Starting SQL Developer
3. Tables, Rows and Columns 3. Entering and Executing SQL Statements 3. Configure a Connection
4. Indexes, Primary Keys and Foreign Keys 4. Editing SQL Statements 4. Navigation Tabs
5. Supported Datatypes 5. Creating, Editing and Executing SQL Files 5. SQL Worksheet
6. The Data Dictionary    
Retrieving Data with the SELECT Statement Aggregate Functions Joining Tables
1. The SELECT Statement 1. Overview of Built In Aggregate Functions 1. Overview of Table Joins
2. The SELECT and FROM Clauses 2. The GROUP BY Clause 2. Inner Joins
3. Conditions and the WHERE Clause 3. The HAVING Clause 3. Table Aliases
4. Other Conditional Operators   4. Outer Joins
5. Logical Operators   5. Self Joins
6. The ORDER BY Clause   6. ANSI Standard Joins
7. Column Aliases   7. Set Operators
8. Arithmetic Expressions    
9. Precedence of Operators    
Numeric, Character and Date Functions Conversion and Miscellaneous Functions SQL*Plus Parameters
1. Function Types 1. Conversion Functions 1. Command Line Substitution Parameters
2. Using the Table dual to try out Functions 2. The NVL and NVL2 Functions 2. The Accept Command
3. Numeric Functions 3. The DECODE Function 3. The Define and Undefine Commands
4. Character Functions 4. CASE Expressions  
5. String Concatenation 5. The COALESCE and NULLIF Functions  
6. Date Arithmetic and Date Functions    
Using Subqueries Managing Data Managing Tables
1. Overview of Subqueries 1. Inserting Rows 1. Creating Tables
2. In-Line Views 2. Updating Rows 2. Specifying Constraints
3. Top-N Queries 3. Deleting Rows 3. Altering Tables, Columns and Constraints
4. Complex Subqueries 4. Verifying Updates 4. Dropping Tables, Columns and Constraints
5. Multi Column Subqueries 5. Transaction Control 5. Copying Tables
6. Correlated Subqueries 6. Commit and Rollback  
7. Subquery Rules 7. Savepoints  
8. Using the ANY, ALL and SOME Operators 8. Commits and Constraints  
  9. Amending Data in SQL Developer  
Managing Indexes and Views Managing Sequences and Synonyms  
1. Creating Indexes 1. Create a Sequence  
2. Dropping Indexes 2. View Sequence Details  
3. Listing Indexes 3. Create a Synonym  
4. Creating and Using Views 4. List Synonyms  
5. Dropping Views    
6. Listing Views    
 
DBA-I DBA-II Performance and Tuning
1. Installing and Configuring Oracle 1. Plan a Backup Strategy 1. Self monitoring architecture
2. Creating and Managing an Oracle database 2. Plan a Disaster Recovery Strategy 2. Disk tuning - Temporary storage, undo segments
3. Administering an Oracle database 3. Alter a Database to Archivelog and NoArchivelog Modes 3. Memory tuning - Buffer cache, shared pool, redo log buffer; locks
4. Configuring the Oracle Network Environment 4. Online and Offline Backups 4. Statistics management
5. Configuring Shared Servers 5. Complete and Incomplete Database Recovery 5. Oracle Advisors
6. Creating and Managing Database Storage Structures 6. Recover a Database from Non-Critical Losses USERS, ROLES AND PROFILES
7. Managing Redo Log Files and Control Files 7. Perform Logical Backups with Export and Import Utilities 1. User creation and management
8. Managing Schema Objects 8. Use RMAN to Perform Backups And Restore 2. Profiles
9. Managing Users, Profiles, Privileges and Roles 9. Use Flashback Technology to Recover a Database 3. System privileges
10. Managing Undo Data and Temporary Segments 10. Database Corruption 4. Object privileges
11. Monitoring and Resolving Lock Conflicts 11. Load Data into a Database 5. Roles
12. Maintaining Database Security 12. Diagnostic Sources 6. Security and Auditing
13. Monitoring the Performance of the Database 13. Use Automatic Database Management BACKUP AND RECOVERY
14. Loading and Unloading Data 14. Monitor and Manage Storage 1. Cause of data loss
15. Backing up and Recovering the Database 15. Use Automatic Storage Management 2. Structures used
  16. Monitor and Manage Memory 3. Offline backups
  17. Control Database Resources Using Resource Manager 4. Archiving redo logs
  18. Automate Management Tasks with the Scheduler 5. Online backups
  19. Secure the Oracle Listener 6. Complete recovery principles
  20. Use Globalization Support 7. Incomplete recovery principles
    8. Oracle Flashback overview
ORACLE NET SERVICES ORACLE UTILITIES ADVANCED TOPICS OVERVIEW
1. Client/Server architecture - Connection and Naming methods (Easy, Local, Directory, External) 1. Data Pump - Export and Import 1. Performance - Table compression, indexing choices
2. Local Networking and Internet-Working 2. SQL*Loader 2. OLAP processing - Materialized views, ETL solutions Programming
3. Files - TNSNAMES.ORA / LISTENER.ORA / SQLNET.ORA / CMAN.ORA /OID (LDAP) 3. Log Miner 3. Programming options - PL/SQL vs Java
4. Advanced Features - Load Balancing and Failover   4. Content Management - XML, LOBs, Ultra Search
    5. Globalization - time zone, language, date and number formats
    6. Debug PL/SQL Server Page problems