SQL 2005 In Class Training Needed

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Newbies » SQL 2005 In Class Training Needed

SQL 2005 In Class Training Needed

Rate Topic

Display Mode

Topic Options

Author

Message

dmilton

Posted Wednesday, March 18, 2009 8:18 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 15, 2010 4:09 PM
Points: 4, Visits: 13

Hello! I am trying to find a good source for getting some additional training in using SQL. I can develop in SAS and in SQL but I need to learn how to do some advanced SQL as well as learn how to create Stored Procedures and Views. Does anyone have any advice on any good companies that offer in class training? Ermm

Post #678515

Henry Treftz

Posted Wednesday, March 18, 2009 12:58 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:51 PM
Points: 175, Visits: 327

One way is to find a couple of good SQL Server programing blogs and just read them.

Also the SQL for smarties books are a good source even though they are not SQL Server specific.

Post #678820

kstjacques

Posted Thursday, March 19, 2009 12:03 PM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 6:50 PM
Points: 51, Visits: 352

I took a SQL course from HOTT and it was worth every penny.

Not only was the course useful, but when they cancelled the class that was being held in my area (rochester, ny), they paid for my flight and hotel to take the same course they were offering in Chicago.

Here a link to their site:

http://www.traininghott.com/

-Kim

Post #679753

dmilton

Posted Monday, March 23, 2009 9:01 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 15, 2010 4:09 PM
Points: 4, Visits: 13

Thanks. Which SQL training did you take from HOTT?

Post #681508

kstjacques

Posted Monday, March 23, 2009 9:16 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 6:50 PM
Points: 51, Visits: 352

I took the SQL Server 2005 Dev and Admin course. It was a very high level introduction to 2005 (I know at the time, they offered courses that covered specfic topics in more depth). it was a week long course where there was lecture and labs. The labs had the following topics:

-installing SQL Server 2005
-Creating and managing databases
-SQL Management Objects
-Creating Stored procedures and Views
-working with XML data
-Implementing Full-Text indexes
-implementing security
-Database backups and mirroring
-Monitoring SQL servers
-Configuring replication
-working with SQL server integration services
-using analysis services
-creating reports and report models
-creating a notification service
-working with service broker

Post #681529

dmilton

Posted Monday, March 23, 2009 9:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 15, 2010 4:09 PM
Points: 4, Visits: 13

kstjacques,

Those you have listed do sound pretty intense but I looked on their website and they have a SQL Programming and Microsoft Transact SQL Programming courses that will I believe show me what I need. I am trying to definitely get some advanced programming skills, learn how to create views and stored procedures to fine tune my coding abilities.

Again thanks for the info. Smile

Post #681590

Steve Jones - SSC Editor

Posted Monday, March 23, 2009 10:13 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 3:26 PM
Points: 31,425, Visits: 13,738

Are you looking in a particular location?

End to End Training (www.endtoendtraining.com) offers custom training in Orlando.

Disclaimer: I am a part owner of the company.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #681616

« Prev Topic | Next Topic »

Permissions