Joins and Procedures

Posted by Gayathri under Sql Server on 10/27/2009 | Views : 2001 | Status : [Member] | Replies : 11
Can anyone suggest me a good site where i can practice Sql joins? whether Oracle or Sql objective is to train myself in writing complex joins also if possible stored procedures.

I know ofcourse only realtime experience can do that. but still , perhaps if there is any tech website that could help more.

Thanks




Responses

Posted by: Sriramnandha on: 5/21/2012 [Member] Starter | Points: 25

Up
0
Down
HI,

look sqlblogauthority

look this blog its very usefull...


regards


sriram

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajkatie on: 6/1/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
You can also refer following links
http://msdn.microsoft.com/en-us/library/ms191517%28v=sql.105%29.aspx
http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/

Rajesh Patel
.Net Trainer(MSCD | MCT | MS)
Brainbench (Asp.Net 4.5 and C# 5.0)

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Gayathri on: 6/1/2012 [Member] Starter | Points: 25

Up
0
Down
thank u ... very useful

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 6/8/2012 [Member] Bronze | Points: 25
Posted by: Gsm_Gsv on: 6/8/2012 [Member] Starter | Points: 25

Up
0
Down
Refer the below site.. It is just excellent. You will get from simple to more complex, with online query results.
Also, you will find complex schemas (more than 10 tables)

http://sqlzoo.net/
http://sqlzoo.net/3.htm


---------------------------------------
Live the life you've dreamed

Regards
MADHU

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 6/11/2012 [Member] Silver | Points: 25
Posted by: CGN007 on: 6/23/2012 [Member] Silver | Points: 25

Up
0
Down
Mark as Answer if its helpful to you,that motivates...

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muralidosscm on: 6/25/2012 [Member] Starter | Points: 25

Up
0
Down
http://www.w3schools.com/sql/sql_join.asp

Regards
Muralidoss M

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 10/28/2009 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
Good Morning Gayathri

This site can do for you
http://www.w3schools.com/Sql/sql_join.asp

But to my opinion the best way to learn is to buy a Book and Practice. There are other scenarios that does not exists in books but exists in our work place, in that case books cannot help us but they can push us in the direction of answers. So reading a Book and practicing is the best way to go. Go to Forums only when you don't understand something about it or if the book is not explaining clearly to you.

Thank you for posting at Dotnetfunda

Vuyiswa Maseko

Thank you for posting at Dotnetfunda
[Administrator]

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Preetpal on: 10/29/2009 [Member] Starter

Up
0
Down
Hi

jsr solution the software developing company is going to organize an entrance test for free

software training. the test is held on 14 November 2009 at quest institute of Chandigarh

mohali (landra) . this test is absolutely free.and the students
who will pass out this examination will get free software training.He/She will get jobs also

for the registrations please visit following link:-

[url=http://training.jsrsolutions.com/registration.aspx] bca training [/url]

Thanks

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sagarp on: 10/30/2009 [Member] Bronze

Up
0
Down

hiiiiii friend

use this site here all join with proper example



http://programming.top54u.com/post/Types-of-Joins-in-Sql-Server-2005.aspx

thanks
sagarP

Thanks
SagarP
http://www.emanonsolutions.net
http://emanonsolutions.blogspot.com/

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response