oracle training

 ORACLE DATABASE ORACLE or ORACLE DATABASE is Object Relational Database Management System created and marketed by Oracle Corporation. Oracle is fully reliable and scalable Relational Database Architecture, which is used to manage local and wide area network and is used by top global enterprises. It is one of the most trusted Relational Database engines used worldwide. The main benefits of ORACLE Database are:
  • It provides the Centralized Management System.
  • It provides Standardization and Consistency so that it becomes easy for technician to solve the problem.
  • It provides reliability and security in the storage of data.
  • Better Data Design and Mining.
  • Simplified Data Administration.
Working With SQL
  1. Data Information, Database, Data Processing vs. Management, Disadvantages of File Oriented Approach, View of data, Data abstraction

  2. Data independence language, data dictionary, database user, database administrator, DBMS structure, Database schema, Database instance

  3. Data models, ANSI/SPARC 3-level architecture, entity-relation models, Relational model, Network model, Hierarchical model, comparison of three model

  4. Entity relationship model, entity set, attributes, type of attributes, relationship set, Degree of a relation, mapping cardinality, different types of keys,

  5. E-R Diagram Strong entity, Weak Entity, specialization, Aggregation, Generalization, Design constraint

  6. Converting E-R Diagram into a Relation schema, Normalization concept Functional dependency, Trivial dependency, Concept of Normalization, 1NF, 2NF, 3NF

  7. Problem solving using Normalization BCNF, Loss less join Decomposition

  8. Closure of Fd’s and Closure of Attribute, Cannonical cover. 4NF, 5NF, join dependency, Multivalue Dependency.

  9. Domain key Normal Form, Revision of Normalization Definition of Relation, Properties of Relation, Codd’s 12 rule, Integrity rule

  10. Inline functions: Use and restrictions Macro Vs inline functions

  11. Classes and objects: Definition and concept, Public and private data, member functions: accessing private members

  12. Object initialization: Constructors, Overloading the constructor function, copy constructor and it’s difference with Assignment operator Constructor with default argument, Destructor (LIFO)

  13. Relational Algebra, Selection, Projection, Set Operation Using Relational Algebra Cross Product, Different types of Joins using Relational Algebra, Division

  14. Use of group function and Aggregate function in Relational AlgebraDML and DDL operation using relational algebra

  15. Query solving using relational algebraTuple Relational Calculus, Domain Relational Calculus

  16. Introduction To SQL, SQL Standard, Data type In SQL, Creation Of Table In SQLConstraint In SQL, Adding, Modifying, Deleting Constraints In SQL, Creating View In SQL

  17. Adding TupleModifying Tuple, Deleting Tuple

  18. Select Statement, From Clause, Different Operator In Sql, Where ClauseDifferent Set Relational Operator, Different Type of Join

  19. Concept Of Nested Sub query, Types Of Nested Sub query, From Clause Sub queryAggregate Function, Group by Clause, Order by Clause

  20. Different SQL FunctionQuery Solving using SQL

  21. Limitation Of SQL, Embedded SQL, Basic of PL-SQL, Data TypeSelection Construct and Iteration Construct in PL-SQL

  22. Cursor Concept, Implicit Cursor, Explicit Cursor, Cursor AttributePL-SQL Records, Tables

  23. Exception, Types Of Exception, Handling of ExceptionProcedure In SQL

  24. Function In SQLPackage Concept In SQL

  25. Trigger Concept In SQL Storage Structure, Different Storage Type

  26. Transaction Concept, ACID Property, Transaction State, Concurrency Control SchemeLocking Scheme, Time Stamp based ordering Scheme

  27. Deadlock detection And recoveryProtecting Data In Database, Granting And Revoking Privileged