Seed Certified Professional in RDBMS Concepts and Oracle 9i

Programming Technique

Computer Architecture (Basic Building Block of Computer)
Physical and Logical architecture
Types of Computers
Software and Types of Software
Operating System
Programming Language paradigms
Program and its environment
Variables and Best Practices
Operators, Expressions and Statements
Modular programming
Algorithms
Flowcharts
Good Programming Practice RDBMS Concepts and Oracle 9i RDBMS Concepts, Basic SQL SELECT statement, Restricting and sorting data, Single row functions Displaying data from multiple tables, Group functions, Sub-queries SQL DML, Creating tables, Constraints, Views, Synonyms, sequences, DCL SET operators, Date time functions, enhancements to group by clause, advanced sub-queries Hierarchical retrieval, Oracle9i extensions to DML and DDL statements Declaring variables,, writing executable statements, SQL in PL/SQL, Control statements Composite data types, explicit cursors, Exception handling Creating procedures and functions, Managing subprograms Creating packages, Oracle supplied packages, Manipulating LOBs Database triggers, Managing dependencie