Course Content :
-
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
|
