Learn SQL online - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Learn SQL online

Author

Topic

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2011-07-20 : 01:02:53

Hi,
My knowledge in SQL I believe is average.
Is there a good website you can refer me to which can take me through tutorials to learn more advanced SQL?
I have checked out a few sites but they are all for beginners.
Thanks

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-07-20 : 01:13:58

there are some tutorials in the MSDN, you can check it out.
http://msdn.microsoft.com/en-us/library/ms365303.aspx

KH
[spoiler]Time is always against us[/spoiler]

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2011-07-20 : 01:23:12

Thanks for the link.
I have seen this before and it seems easy for me as I know these statements.
I am more interested in starting to learn complex sql from from ground up.
such as where to use correlated queries or somethink like:
select field1, field2, ...
from (select fielda, fieldb, ...)
and more on CTE and these sort of complex queries.
Thanks

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-07-20 : 01:49:42

Just hang around this site. There are lots of opportunity to learn and for you to practice

KH
[spoiler]Time is always against us[/spoiler]

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2011-07-20 : 02:30:35

The area where you have something like:
select field1, field2, ...
from (select fielda, fieldb, ...)

What is this kind of sql called?
And where is it used?
Thanks

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2011-07-20 : 09:02:19

Is this kind of sql i.e.
select field1, field2, ...
from (select fielda, fieldb,... from tablename ...)

called correlated query?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-07-20 : 09:05:53

nope. its called derived table.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2011-07-20 : 09:25:31

What is correlated query?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-07-20 : 09:29:52

it will be something like


SELECT column
FROM Table1
WHERE EXISTS (SELECT 1 FROm table2 where column3=table1.column5)

or even

SELECT Col1,
(SELECT Col2 FROM Table2 WHERE Col4=t1.Col1)
FROM Table1 t1

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2011-07-20 : 09:30:59

I see.
Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-07-20 : 09:32:36

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources