Jump to content

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


InfPrasad

Recommended Posts

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