• final-year-project-training-php
  • php-training-job-placement
  • joomla-wordpress-magento

Oracle

  • SQL Plus
    • Define database
    • Explain basic SQL statements
    • Describe the various types of functions available in SQL
    • Describe and use the different types of joins
    • Describe subqueries
    • Describe the process of producing readable output with iSQL*Plus
    • Explain data manipulation using SQL statements
    • Describe constraints and views
    • Describe the various database objects
    • List and explain Oracle 9i extensions to DML and DDL statements
  • PL-SQL
    • Describe the features and syntax of PL/SQL
    • Explain writing executable statements
    • Explain the control structures
    • Describe and use composite data types
    • Explain the process of writing explicit cursors
    • Describe subprogrammes
    • Describe the use of functions
    • Describe packages in PL/SQL
    • List and explain Oracle server-supplied packages
    • Describe triggers