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

[training4u]

[size=5][b][color=#0000FF]Email: [email protected]

Contact: +91 – 90 36 298 699[/color][/b][/size]
[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]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]· Introduction to SQL[/font][/color][/indent]

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

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

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

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

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

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

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

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

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

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