Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Posts
    31

    Unanswered: Any Good SQL Server Intermediate Training Courses?

    Quick question. I am in the NYC area (Westchester) and I am using Cognos DecisionStream to build my SQL Server 2000 Enterprise Data Warehouse.

    I want to learn more about complex SQL, specifically for SQL Server.

    What do you reccommend? Should I go for strictly an advanced SQL course, or should I go for SQL Server training.

    Does anyone know of a really good site where I can find Advanced SQL training?

    Also, I want to learn more about scripting and VB. Can anyone reccommend a place where I can get this beginner training.

    Sorry to take up your time, but to sum up:

    1. Advanced SQL training in NYC area
    2. Beginner VB training in NYC area.

    Cost is not necessarily an issue.

    Thanks!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You are asking for recommendations, which mean you want other people's opinions. I've always got at least one of those to spare!

    For VB and Microsoft SQL Server, I'd recomment Quilogy. in my opinion, Alan Groh is one of the best teacher/mentor types in the business.

    For the really, really interesting SQL, I'd recomment Joe Celko. Joe was on the committee that defined what SQL ought to do, and he has been a consultant for years teaching and helping folks figure out just what the existing SQL engines really do, especially when that deviates from the standard. If nothing else, he's fun to listen to when he discovers a new "feature" in one of the SQL dialects!

    -PatP

  3. #3
    Join Date
    Mar 2004
    Posts
    31
    Thank you very much, I will look them up! I really appreciate it!

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Logon to these forums daily and look at what people are asking and try to figure the problems out...

    kinda like a pop quiz every day...

    Oh and read the solutions...

    Do you have access to sql server and client side tools?

    What do you consider "complex sql" to be?

    Theta joins always give me a moment to pause....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Mar 2004
    Posts
    31
    I consider complex SQL to be anything other than the simple select statement, like sub-queries, and transformation/alterations on fields like date conversions, etc.

    Do you suggest any books with good amounts of source code and puzzles, that is up to date?

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Yeah...Celko's SQL for Smarties should blow your mind...it's not really platform specific


    Ken Hendersons Book The Guru's Guids to SQL Server, Stored Procedures, XML and HTML is, and it's outstanding...AND comes with a cd loaded with code...

    And there's also

    http://www.sqlteam.com/store.asp
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •