Sql Server 2008 & Msbi(Ssis,ssrs,ssas) - Online Training & Job Support

[InfPrasad]

Hi Everybody,

We are providing [b]Online Training[/b] and [b]Job Support[/b] On [b]SQL Server 2008 (SQL & TSQL)[/b]&[b]MSBI(SSIS,SSRS,SSAS).[/b]


[b]I[/b]f Anybody interested please contact me soon. My Contact details are....


Mail:- [b][email protected][/b]

Voice:- [b]+91 929 122 7040, +91 99494 89441.[/b]


[url="http://www.andhrafriends.com/topic/334254-informatica-oracle-sql-server-dot-net-msbi-training-support/page__pid__1302447857#entry1302447857"]http://www.andhrafri...entry1302447857[/url]

[url="http://www.indianclicks.com/DurgaPrasad/DurgaPrasad.html"]http://www.indiancli...urgaPrasad.html[/url]





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


[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]



[center][b]TSQL PROGRAMMING[/b][/center]


[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]SAMPLE 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]