Updating your database development skills to

The "Programmer" term is somewhere below that, but the "DBA" is extremely variable.I have seen shops where a person was called a DBA and filled a relatively constrained role closer to IT or operations (routine tasks, no real programming) and other shops where a person with the DBA title was basically the Architect. Development experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0. NET This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers. Knowledge of SQL Server 2000/7.0:  Database and server architecture. After completing this course, students will be able to:  Use the Development Tools provided with SQL Server 2005.  Build Administrative Applications with SQL Management Objects (SMO).

These titles tend to be somewhat variable from shop-to-shop, but generally the "Architect" term indicates the highest level of skill combined with considerable management responsibilities.There is an entire set of skills for those who actually create and maintain these systems, but that is not something that will be treated in this blog.If you have never so much as typed a single SQL command, or seen a table diagram, or anything like that, then it is worth a few minutes to go through the basics of what a database does, which is to organize atomic values into tables.Because of this high variability in what titles mean, I am not going to waste time categorizing skills as belonging to one job title or another, I am simply going to list them all out.The various levels of skills are these: As long as that list is, it only covers those of us who use database systems.I’m passionate about security, and the new version of SQL Server is really impressive in its solutions for so many security issues.

973

Leave a Reply