Jump to content

Oracle 11G (Sql&plsql),sql Server 2008(Sql&tsql)--$225 Each Course


InfPrasad

Recommended Posts

Hi All,

I am providing [b]Online Training[/b] and [b]Job Support[/b] on [b]Oracle 11G ( SQL & PLSQL) and 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]ORACLE 11g COURSE CONTENT[/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]PLSQL PROGRAMMING[/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]





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

[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]TSQL PROGRAMMING[/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]

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...