Sql Server (Sql-T/sql) & Oracle (Sql-Pl/sql) Online Training

[training4u]

[color=#282828][font=helvetica, arial, sans-serif]Hi All,[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]We are providing online training & Job Support for [/font][/color][b][color=#0000FF]SQL SERVER 2008(SQL-T/SQL) & ORACLE (SQL-PL/SQL).[/color][/b][color=#282828][font=helvetica, arial, sans-serif]If anyone interested, please contact us.[/font][/color]

[b][color=#FF0000]Email: [email protected]

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

[color=#282828][font=helvetica, arial, sans-serif][u]Commands in SQL[/u] [/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]

[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]
[*]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]
[color=#282828][font=helvetica, arial, sans-serif][u]Advanced PL/SQL[/u] [/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]