oracle dba online training
TRANSCRIPT
LEAD ONLINE TRAININGLEAD ONLINE TRAINING
About Us• Lead Online training is a brand and providing quality online to
students in world wide. We are giving best online training on ORACLE DBA .Every faculty has Real Time experience .Trained Resources placed in countries like usa, uk, Canada, Malaysia, Australia, India, Singapore etc. Lead Online training classes are conducted every day. Weekend trainings for job goers. Flexible timings in accordance with the resource comfortability.If version related to any Tool is upgraded. Lead Online training will send the upgraded information via email. we will develop the Acquaintance with Production, development and testing environments relating ORACLE DBA. Real time scenarios covered across Software Development Life Cycle. For every 10 hours One hour catered to resolve the doubts. Explaining bugs and critical issues and development activities with 24*7 technical supports services.
Introduction to Oracle
– Prerequisite• Computer Fundamentals, Windows Operating System
– Take Aways• Create database tables.• Manage database objects.• Access and manipulate data in the database using SQL
statements.• Control user access to data.• Oracle 10g : SQL Certification exam readiness
Course ContentsoIntroductionoWriting Basic SQL SELECT StatementsoRestricting and Sorting DataoSingle- Row FunctionsoDisplaying Data from Multiple TablesoAggregating Data Using Group FunctionsoSub queriesoProducing Readable Output with iSQL *PlusoManipulating DataoCreating and Managing TablesoIncluding ConstraintsoCreating ViewsoOther Database ObjectsoControlling User AccessoSQL WorkshopoUsing SET OperatorsoOracle 10g Date time FunctionsoEnhancements to the GROUP BY ClauseoAdvanced Sub queriesoHierarchical RetrievaloOracle10g Extensions to DML and DDL Statements
Oracle Database 10g : Administration Workshop I (1Z0-042)
– Prerequisite• Oracle Database 10g : SQL
– Take Aways• Create Oracle database• Manage database objects, administer user security• Manage schema objects• Perform database backup & recovery• Oracle Database10g :AdminstrationWorskshop I
Certification exam readines
Course Contents• Oracle Database • Oracle Instance • Database Storage Structures • Administering User Security • Schema Objects • Data and Concurrency • Managing Undo Data • Oracle Database Security • Oracle Network Environment • Proactive Maintenance • Performance Management • Backup and Recovery Concepts • Database Backup • Database Recovery • Flashback
• Moving Data
Oracle Database 10g : Administration Workshop II (1Z0-043)
– Prerequisite • Oracle Database 10g : Administration Workshop I
– Take Aways • Use recovery manager• Deal with database corruption • Monitor & manage memory• Manage schema objects• Oracle Database10g :Adminstration Worskshop II
Certification exam readiness
Course Contents
• Recovery Manager • Flashback• Database Corruption• Memory • Storage• Performance Management • Schema objects• Managing storage• Storage management• Resources
• Scheduler
THANK YOU