Oracle (Sql-Pl/sql) Demo On 12Th Feb At 8 Am (Ist)

[training4u]

[color=#282828][font=helvetica, arial, sans-serif][size=5][b][color=#0000FF]Email: [email protected]

Contact: +91 – 90 36 298 699[/color][/b][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif] [/font][/color]

[b][b][color=#FF0000][size=5]Oracle (Sql-Pl/sql) demo On 12Th Feb At 8 AM (IST) || 11th Feb at 9.30 PM (EST)[/size][/color][/b][/b]


[color=#282828][font=helvetica, arial, sans-serif]ORACLE (SQL,PLSQL) ONLINE TRAINING .[/font][/color]
[u]DBMS:[/u][color=#282828][font=helvetica, arial, sans-serif] [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Concepts of DBMS [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Introduction [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Importance and Need [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Database Models and Normalization [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Models [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Hierarchical [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Network [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Relational [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Object [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Normalization Techniques [/font][/color]
[u]Introduction to RDBMS:[/u][color=#282828][font=helvetica, arial, sans-serif] [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Concepts of RDBMS [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Introduction [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Comparison with DBMS [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· CODD rules [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Normalization Revisited [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Concepts of ORDBMS & OODBMS [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Introduction to ORDBMS [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Introduction to OODBMS [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]· Comparison and analysis [/font][/color]
[u]Structured Query Language[/u][color=#282828][font=helvetica, arial, sans-serif] [/font][/color]

[indent=1][color=#282828][font=helvetica, arial, sans-serif]· Introduction to SQL[/font][/color][/indent]

[indent=1][color=#282828][font=helvetica, arial, sans-serif]· Predefined Data Types[/font][/color][/indent]

[indent=1][color=#282828][font=helvetica, arial, sans-serif]· Introduction to database Objects[/font][/color][/indent]

[indent=1][color=#282828][font=helvetica, arial, sans-serif]· Table, view[/font][/color][/indent]

[color=#282828][font=helvetica, arial, sans-serif][u]Commands in SQL[/u] [/font][/color]


[indent=1][color=#282828][font=helvetica, arial, sans-serif]· Data definition language (DDL)[/font][/color][/indent]

[indent=1][color=#282828][font=helvetica, arial, sans-serif]· Data manipulation language (DML)[/font][/color][/indent]

[indent=1][color=#282828][font=helvetica, arial, sans-serif]· Data control language (DCL)[/font][/color][/indent]

[indent=1][color=#282828][font=helvetica, arial, sans-serif]· Transaction control language (TCL)[/font][/color][/indent]

[indent=1][color=#282828][font=helvetica, arial, sans-serif]· Database security and privileges (DCL)[/font][/color][/indent]

[color=#282828][font=helvetica, arial, sans-serif][u]Working with DDL, DML,TCL Commands[/u]
· Operators
· Conditional
· Logical
· Comparison
· SET
· Functions
· Date
· Number
· Character
· String
· Group
· Group by ,Having clause
· Transformation function:-
DECODE, TRANSLATE
· NVL ,NVL2(9i)
· Aggregate Functions
· Integrity Constraint
· Different Types of Integrity Constraint
· Use of Integrity constraint in table
· Joins
· Usage of joins
· Different Types of joins
§ Equip join, Cartesian join
§ Self join, outer join
· Sub queries
· Need of sub queries
· Nested sub queries
· Co-related sub quires
· Flashback queries (9i)
· View
· Importance of views
· Creating, manipulating views
· Materialized views(9i)
· Working with database objects
o Sequences and synonyms
o Index, cluster, creating cluster table
· Using external tables(9i)
o System privileges
o Table privileges
· Locks and SQL plus editor commands
[u]PL/SQL[/u] [/font][/color]
[list]
[*][color=#282828][font=helvetica, arial, sans-serif]Introduction to PL/SQL[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Advantages of PL/SQL[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Data types in PL/SQL[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Variable and constants[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Assignments and constants[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Referencing NON-PL/SQL Variable[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Using built in functions[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Conditional and Iterative statements[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]SQL in PL/SQL[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Composite data types[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Cursors[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Exception:-predefined, user-defined[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Records and PL/SQL table types[/font][/color]
[/list]
[color=#282828][font=helvetica, arial, sans-serif][u]Advanced PL/SQL[/u] [/font][/color]
[list]
[*][color=#282828][font=helvetica, arial, sans-serif]Introduction to Triggers[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Types of triggers:-row levels, statements level[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Before and after, instead of triggers[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Procedures, functions in PL/SQL[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Argument modes[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]User defined packages[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Dropping triggers, procedures, functions[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Reference cursors[/font][/color]
[*][color=#282828][font=helvetica, arial, sans-serif]Usage of ref cursors in procedures, functions, packages[/font][/color]
[/list]