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.
| Author |
Topic |
|
Darts75
Starting Member
27 Posts |
 Posted - 2014-09-17 : 21:44:20
|
| Hi Everyone,I am relatively new to writing SQL queries, and do not consider myself to be a natural. Late last year I studied a Unit called 'Introduction to Database Design' at Deakin University. This unit reflected the broad ANSI standard SQL (during theoretical studies), and Oracle SQL Plus (during practical studies). I did quite well in the unit, and now have a thorough understanding of the basic SQL concepts such as JOINs, UNIONs, etc.This year I find myself working specifically with Microsoft SQL Server 2008 R2, and related T-SQL syntax within my occupation. More specifically the company that I work for uses SAP Business One, and the underlying infrastructure at my work is MS SQL Server 2008 R2.I would like to study some more SQL formally! My boss will probably back me in attending a one / two day course that deals specifically with T-SQL.I am ideally looking to learn some 'intermediate' skills, such as CTEs, and Pivots. However performance of the SQL Server itself (such as Load Balancing, and Tuning) does not interest me.I live in the Melbourne (Australia) and would like to find a suitable course in the CBD or surrounding suburbs.If anybody can suggest any courses / course providers that are very good at teaching in my area can you please share. Finally my budget would probably be somewhere between $600 to $1000 for the course, but if the course comes with high recommendations I might be able to budget a little higher.Any help and or recommendations will be greatly appreciated.Kind Regards,David |
|
|
Arun Babu N
Starting Member
26 Posts |
Posted - 2014-09-18 : 07:38:08
|
| suggest u to learn through websites..http://www.w3schools.com/sql/http://www.codeproject.com/Articles/690340/Querying-SQL-Server-Part-IMSDNarunbabu |
 |
|
|
ScottPletcher
Aged Yak Warrior
550 Posts |
Posted - 2014-09-18 : 15:29:54
|
| For the basics, use online courses or a book on intro to writing TSQL.To get into more advanced TSQL, get Itzik Ben-Gan's book(s): he's exceptionally good. |
|
|
|
Darts75
Starting Member
27 Posts |
Posted - 2014-09-18 : 17:30:59
|
| Thanks guys for your suggestions. |
|
|
|
|
|
|
|
|
Looking for intermediate skill level short course