Oracle 11G (Sql&plsql) And Sql Server 2008(Sql&tsql)

[InfPrasad]

Hi All,

I am providing [b]Online Training[/b] and [b]Job Support[/b] on [b] Oracle 11G ( SQL & PLSQL) and [/b][b] SQL Server 2008 (SQL & TSQL).[/b]




If anybody interested in any of these technologies please contact me soon.

You can reach me @ ------------------> [b][email protected][/b]


Course Content:-

[b][u]ORACLE 11g COURSE CONTENT[/u][/b]




[b]--WHAT IS DATABASE? [/b]
[b]--WHAT IS DATABASE MANAGEMENT SYSTEM?[/b]
[b]MODELS OF SATABASE:[/b]
[b]FILE MANAGEMENT SYSTEM [/b]
[b]HIERARCHICAL DATA MODEL[/b]
[b]NETWORK MODEL[/b]
[b]RELATIONAL MODEL[/b]
[b]COMPONENTS OF SQL:[/b]
[b]DATA MANIPULATION LANGUAGE(DML)[/b]
[b]DATA DEFINITION LANGUAGE (DDL)[/b]
[b]DATA CONTROLE LANGUAGE (DCL)[/b]
[b]TRANSACTION CONTROLE LANGUAGE (TCL)[/b]
[b]CREATING AND MANAGING TABLES[/b]
[b]DATA TYPES[/b]
[b]DIFFERENT TYPES OF DATA TYPES.[/b]
[b]WORKING WITH INTEGRITY CONSTRAINTS.[/b]
[b]DISPLAYING DATA FROM MULTIPLE TABLES[/b]
[b]CASCADING RULES[/b]
[b]DATA RETRIEVAL LANGUAGE[/b]
[b]BUILT IN FUNCTIONS[/b]
[b]SINGLE ROW FUNCTIONS [/b]
[b]GROUP FUNCTIONS[/b]
[b]MATHEMATICAL FUNCTIONS[/b]
[b]STRING FUNCTIONS[/b]
[b]DATE AND TIME FUNCTIONS[/b]
[b]CONVERSION FUNCTIONS[/b]
[b]SYSTEM FUNCTIONS[/b]
[b]CASE[/b]
[b]GROUP FUNCTIONS[/b]
[b]DIFFERENT TYPES OF OPERATORS[/b]
[b]SET OPERATORS[/b]
[b]CLAUSES[/b]
[b]WHERE [/b]
[b]HAVING [/b]
[b]GROUP BY[/b]
[b]ORDER BY[/b]
[b]SUB QUERY[/b]
[b]CORRELATED SUB QUERIES[/b]
[b]USING SET OPERATOE[/b]
[b]CONTROLLING USER ACCESS[/b]
[b]JOINS[/b]
[b]DIFFERENT TYPES OF JOINS[/b]
[b]TRANSACTION CONTROLE LANGUAGE[/b]
[b]COMMIT[/b]
[b]ROLL BACK[/b]
[b]SAVE POINT[/b]
[b]WORKING WITH VIEWS[/b]
[b]PSEUDO COLUMNS[/b]
[b]OLAP FEATURES IN ORACLE[/b]
[b]LOCK TABLE STATEMENT[/b]
[b]INDEXES[/b]
[b]INDEXED VIEWS[/b]


[b] [u]PLSQL PROGRAMMING[/u][/b]
[b]Variable Declaration[/b]
[b]CASE FUNCTIONS[/b]
[b]CONDITIONAL STATEMENTS[/b]
[b]LOOPS,BREAK,CONTINUE STATEMENTS[/b]
[b]COMMENTS IN TSQL[/b]
[b]CURSORS[/b]
[b]SUB PROGRAMES[/b]
[b]EXCEPTION HANDLING[/b]
[b]PROCEDURES[/b]
[b]USER DEFINED FUNCTIONS[/b]
[b]TRIGGERS AND INSTEAD OF TRIGGERS[/b]
[b]CODD RULES[/b]
[b]RULES OF DATA NORMALIZATION[/b]

-------> [b]QUERIES FOR PRACTICING[/b]





[b][i][u]SQL SERVER 2008 COURSE CONTENT[/u][/i][/b]

[b]Introduction To DataBase[/b]
[b]Different types of data types.[/b]
[b]Different Types of sublanguages in SQL.[/b]
[b]1.DML 2.DDL 3.DRL 4.DCL 5.TCL[/b]
[b]Data Manipulation Language.[/b]
[b]1.INSERT 2. UPDATE 3.DELETE [/b]
[b]--Different Types Of Integrity Constraints[/b]
[b]Data Definition Language.[/b]
[b]1.CREATE 2.ALTER 3.DROP 4.TRUNCATE 5.RENAME[/b]
[b]Data Retrieval Language.[/b]
[b]1.SELECT[/b]
[b]FUNCTIONS[/b]
[b]-Single Row Functions[/b]
[b]-Group Functions.[/b]
[b]-Different Types Of Operators.[/b]
[b]CLAUSES[/b]
[b]1.Where 2.Having 3.Order By 4.Group By[/b]
[b]SUBQUERIES[/b]
[b]CORRELATED SUB QUERIES[/b]
[b]TYPES OF JOINS[/b]
[b]1.Equi-Join 2.Non Equi-Join 3.Self Join 4.Cartesion Join[/b]
[b]5.Left Outer Join 6.Right Outer Join 7.Full Outer Join[/b]
[b]TRANSACTION CONTROLE LANGUAGE.[/b]
[b]1.COMMIT 2.ROLLBACK 3.SAVE TRANSACTION[/b]
[b]CREATING DUMMY TABLES.[/b]
[b]WORKING WITH VIEWS.[/b]
[b]1.Simple View 2.Complex View[/b]
[b]CREATING INDEXES.[/b]
[b]CREATING SEQUENCES.[/b]

[b][u]TSQL PROGRAMMING[/u][/b]

[b]ANONYMOUS BLOCKS[/b]
[b]SUB PROGRAMME BLOCKS.[/b]
[b]DECLARING VARIABLES AND ASSIGNING VALUES TO VARIABLES.[/b]
[b]CONDITIONAL STATEMENTS.[/b]
[b]LOOPING CONTROLE STRUCTURES.[/b]
[b]CURSORS.[/b]
[b]SUB-PROGRAMS[/b]
[b]-STORED PROCEDURES[/b]
[b]EXCEPTION HANDLING[/b]
[b]-FUNCTIONS[/b]
[b]TRIGGERS[/b]
[b]-AFTER TRIGGERS[/b]
[b]-INSTEAD OF TRIGGERS.[/b]
[b]-DDL TRIGGERS -DML TRIGGERS.[/b]
[b]PACKAGES[/b]



[b]SALPLE TABLES.[/b]
[b]QUERIES FOR PRACTICING.[/b]





[b]Thanks & Regards,[/b]
[b]Durgaprasad.[/b]
[b]+91 929 122 7040.[/b]
[b]+91 99494 89441.[/b]