MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Oracle SQL 11g + Oracle Apps R12 DBA

Course Summary

Learn Oracle SQL 11g,Oracle Apps R12 Architecture & Installations, Patching, Cloning,Administration and Troubleshooting


  • +

    Course Syllabus

    • Oracle SQL 11g : Introduction to SQL
      • Introduction to SQL
      • SQL Statements
      • Introduction to SQL *Plus
      • Tables used in the Course
      • Demonstration
      • Quiz
    • Oracle SQL 11g : Creating and Managing Tables
      • Database Object: Table
      • Data Types
      • Creating, Altering, Renaming, Truncating, Dropping a Table
      • Demonstration
      • Quiz
    • Oracle SQL 11g : Writing Basic SQL SELECT Statements
      • SQL SELECT Statements
      • Expressions
      • Null Value
      • Column Alias
      • Concatenation Operator
      • Literal Character Strings
      • Duplicate Rows
      • Demonstration
      • Quiz
    • Oracle SQL 11g : Restricting and Sorting Data
      • Limiting the rows
      • Other Comparison Conditions
      • Logical Conditions
      • Precedence
      • Sorting the Data
      • Demonstration
      • Quiz
    • Oracle SQL 11g : Single Row Functions
      • SQL Functions
      • Character Functions
      • Number Functions
      • Date Functions
      • Conversion Functions
      • RR Date Format and Nesting Functions
      • Demonstration
      • Quiz
    • Oracle SQL 11g : Aggregating Data Using Group Functions
      • Group Functions
      • Creating Groups of Data
      • Excluding Group Results
      • Demonstration
      • Quiz
    • Oracle SQL 11g : Constraints
      • Introduction to Constraints
      • Applying Constraints
      • Adding,Dropping,Viewing, Enabling, Disabling a Constraint, Cascading Constraints
      • Demonstration
      • Quiz
    • Oracle SQL 11g : Displaying Data from Multiple Tables
      • Cartesian Product
      • Proprietary Joins
      • Compliant joins
      • Demonstration
      • Quiz
    • Oracle SQL 11g : Sub-Queries
      • Sub-query
      • Types of Sub queries
      • Demonstration
      • Quiz
    • Oracle SQL 11g : Producing Readable Output with iSQL*Plus
      • Substitution Variable and System Variables
      • Format Commands used in SQL*Plus
      • Demonstration
      • Quiz
    • Oracle SQL 11g : Manipulating Data
      • Inserting, Deleting, Updating and Merging Data
      • Database Transactions and TCL Statements
      • Locks
      • Demonstration
      • Quiz
    • Oracle Apps DBA : Introduction to Oracle Applications ERP
      • Oracle Applications Overview
      • Oracle Applications Components
      • Quiz
    • Oracle Apps DBA : Oracle Applications Architecture & Installations
      • Oracle Applications Architecture
      • Oracle Applications Directory Structure
      • Oracle Applications Database
      • Oracle Applications Installations
      • Quiz
    • Oracle Apps DBA : Oracle Applications Administration
      • Concepts and Explain AD Utilities
      • AD Administration
      • FND Utilities
      • Quiz
    • Oracle Apps DBA : Patch Administration
      • Need of the Applications Patch
      • Types of Applications Patches
      • Pre-requisites to Apply Patch
      • Patch Options and Modes
      • Applying Patch
      • Post Patch Steps
      • Patch Tracking Utilities
      • Reduce Patching Downtime
      • Quiz
    • Oracle Apps DBA : Cloning
      • Cloning Concepts
      • Pre-Clone Steps
      • Cloning
      • Quiz
    • Oracle Apps DBA : System Administration Fundamentals
      • Oracle Applications security
      • Concurrent Manager’s Administration
      • Printer configuration
      • Quiz
    • Oracle Apps DBA : Monitoring and Troubleshooting
      • Operating System Monitoring
      • Database Monitoring
      • Applications Monitoring
      • Tracing Techniques
      • Quiz


Course Fee:
USD 299

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top