Implementing a Microsoft SQL Server 2005 Database
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.
This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for implementing a database.
Before attending this course, students must have:
• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of Transact-SQL.
• Working knowledge of relational databases.
• Some experience with database design.
For more information, please contact Teri Turner at 512.432-4103 or terit@seupec.com.
Five days? I had no trouble figuring out how to do that the first time, all on my own, in a few hours with Oracle, DB2, Informix, Sybase, PostgreSQL or MySQL... And that usually included setting up the server and installing the software. I wouldn't even consider myself a database expert, let alone a qualified DBA, I'm just a lowly developer. Given the pre-requisites, what all are they covering? Clustering, load balancing, schema development tools?
Your point is valid about the pre-req's, but I think you are really way ahead of the pack if you get all these concepts in a few hours. The average IT guy doesn't read books/websites like you ;) Instructor-lead 5 day training is pretty much reading a book aloud + hands on demo.
A lot of above-average people benefit from such training. Easy to overlook some important things. A good instructor can point you in the right direction and help you pack your bag for the full journey.
The course is a certified Microsoft course covering:
• Create databases and database files.
• Create data types and tables
• Use XML-related features in Microsoft SQL Server 2005.
• Plan, create, and optimize indexes.
• Implement data integrity in Microsoft SQL Server 2005 databases by using constraints.
• Implement data integrity in Microsoft SQL Server 2005 by using triggers.
• Implement views.
• Implement stored procedures.
• Implement functions.
• Implement managed code in the database.
• Manage transactions and locks.
• Use Service Broker to build a messaging-based solution.
• Use Notification Services to generate and send notifications.
The actual course outline can be found at: http://www.microsoft.com/learning/syllabi/en-us/2779bfinal.mspx
Teri
Sounds like a reasonably complete entry level DBA class. Do you have plans to offer something similar for other RDBMS platforms like the ones I mentioned or do you only do Microsoft platform? Is there an advanced class that covers subjects like capacity planning, clustering, load balancing and other enterprise level issues? I guess that most MS-SQL Server users don't run into those issues as much, but the concepts would be of use to users of the higher end databases.
Sorry for my delayed reply. There are many optional courses depending on your specific interests. I came up with 11 courses that could fit your needs, however, we do not have plans to offer anything for other RDBMS platforms. One course in particular, MS7033, Microsoft SQL Server 2005 for Expreienced DBAs.
The purpose of this 4-day instructor-led course is to teach Oracle DBAs how to leverage their skills and experience as an Oracle DBA to manage a SQL Server system. This course provides a quick start for the Oracle DBA to map, compare and contrast the realm of Oracle database management to SQL Server database management. This course is intended for experienced database professionals currently implementing and administering non Microsoft enterprise database management systems who need to expand their database skill-set to SQL Server 2005.
Let me know if you want speifics of any any of the other courses that might work for you.
Teri
It is the platform that is the problem. Classes specific to Windows and MS-SQL Server just aren't that useful to me because I work mainly in a UNIX/Linux environment. If you had classes for Oracle, DB2 or something else that is multi-platform it would be more interesting to me.
Is it just me, or is this not mentioning the price/cost? as 5 day course I doubt is free. Seems like event spam to me when you don't fully disclose the cost.
There are tons of places offering certification training for a cost, what's special here?
So far, I haven't insisted that the event be free to be posted on door64's calendar. If things get out of hand, I may. But so far I haven't felt the need to do so.
Why are the hiding the cost? Does one caller get quoted $899 and another caller get quoted $699?
Just find it odd that the price is not fully disclosed. The "call now" kind of crap with a hard sale is what I expect.
I've been around too long, jaded.
If anything, it's my fault for not making the stipulation that any cost needs to be stated up front. I'll fix that. But at the same time, let's not start calling shenanigans on calendar posts via the comments; otherwise people will be reluctant to post their events lest the community starts lynching the poster online.
Ok, thanks for the constructive improvements.
Now when submitting a calendar event, the poster is asked to submit the cost, if applicable. Hopefully this will reduce any confusion about what is free versus what isn't.
Great! As i posted earlier, I am somewhat of a jaded (and + occasionally mellon collie) person. Trying to somewhat fit in on this new media way where anyone can comment on anything on a site.
No offense to the original announcement poster, I wish them good luck in their course. I have been a teacher for similar, it is difficult work.
Sorry I haven't been able to clarify sooner. I have been out of touch for a week. It honestly didn't dawn on me to put a price on there since it was just a calendar posting announcing the course was available, not to hard sell anyone. It is not my style. I am happy to add the list price on any future postings if required. However, RoundSparrow, you are correct in the fact there is different pricing available to different people. There is a discount to State employees, discounted pricing if one had multiple training and there could be corporate discounts if there is a group looking for that particular training. It is easier to have a logical discussion with an interested individual and give them the appropriate pricing than to lead everyone to believe it is one price fits all.
Thanks for the note. Hope the first session went well last night!
Matt
--