Syllabus for Oracle

Post date: Jan 9, 2012 11:06:12 AM

Unit – 1

  • Fundamentals of RDMS, normalization, CODD'sPrinciples
  • Introduction to SQL syntax
  • Creation, updation and access of relation tables using SQL
  • Command: create, insert, pdate, delete, se.ect,alter, drop
  • Data constraints: column level, table level,NULL level, primary key, unique key, foreign key
  • check Integrity Constraints
  • Range Searching Pattern Matching

Unit -2

  • Inbuilt functions:
    • AVG, MIN, COUNT, MAX,SUM, ABS, POWER, ROUND,SQRT, LOWER, INITCAP, UPPER, SUBSTR, RPAD, LENGTH, LPAD,LTRIM, RTRIM,LENGTH,TO_NUMBER, TO_DATE, TO_CHAR
  • Group of data, data manipulation, joining multiple table, joining a table to itself
  • Subqueries: UNION, Intersect, MINUS Clause
  • Indexes: CREATE, DROP
  • Views: CREATE, UPDATE, DESTROY
  • Sequences: Create, Alter, Drop
  • Granting and Revoking Permissions

UNIT -3

  • Introduction of PLSQL
  • Iterative Control: While, For, GOTO
  • Oracle Transaction: LOCKS
  • CURSORS: Opening, closing, %NOTFOUND, %FOUND,%ISOPEN, %ROWCOUNT
  • Stored procedures, STORED functions
  • Database triggers: Creating Deleting

UNIT-4

  • Databases in Bioinformatics