To offer comprehensive training on Oracle 10g and at the end of the course students will able to use Oracle 10g as a back End tool in their applications. This course will form a basis for oracle certification exam preparation.

• Introduction to database, Introduction to Oracle 10g, Introduction to SQL, Basics of Select statement, Arithmetic Expressions, operator precedence, null values
• Select statement, column alias, concatenation operator, Character and string operations, restricting and sorting
• Introduction to iSQL*Plus, Substitution variables, Functions Working with dates, Nesting functions, NVL, Case statement, decode, Grouping – group by, having, group by with roll up and cube, Joining tables, all types of joins, Subqueries Using group functions, Retrieving data from multiple tables Using set operators
• Manipulating data ( insert, update, insert into multiple tables), Delete and truncate, Transactions, Create, alter, drop
• Sequences, indexes, synonyms, Data dictionary, creating users
• User system privileges, granting privileges, creating and granting roles, object privileges, Managing schema objects and indexes, Oracle database architecture, PL/ SQL outline, Triggers
• Cursors, Visual basic, Visual Basic, Summarization, Summarization, Evaluation Test, Mini project – details