SQL Server 2008
On this page:
SQL Server Technology Specialists
A SQL Server Technology Specialist is defined as a technology expert interested
in assessing, improving, and validating his or her knowledge, skills, and
experience in a given technology area of SQL Server 2008.
The following are typical characteristics of this audience:
| – |
They value and may be working toward an extensive, deep technical knowledge in
a given technology area of SQL Server 2008. |
| – |
They are interested in drilling down into the details of SQL Server 2008
technologies. |
| – |
They want to learn or assess that they know and can apply existing concepts,
practices, procedures, policies, and guidelines. |
| – |
They work in roles where most questions have clear right and wrong answers. |
| – |
Their focus is primarily on the “how to” skills associated with a given
technology area, and they are interested in drilling down into the technical
details. |
| – |
On the job, they receive functional specifications, defined
polices/conventions/standards, and documented operational procedures from
superiors. |
A database technology specialist is a technology specialist who would be
interested in learning, assessing skills, using reference products, or taking
exams to prove his or her knowledge/skills/experience related to Microsoft’s
database technologies.
| 70-432 - MCTS: Microsoft SQL Server 2008, Implementation and Maintenance |
| MOC |
Course |
Exam Nr. |
Duration Days |
Price |
Certification Saving |
Payment Option |
International Certification |
| 2778 |
Writing Queries Using Microsoft® SQL Server 2008 Transact-SQL |
70-432 |
5 Days |
Theory: 3 Days
Labs: 2 Days |
Sign up for a FREE account and view the
Course fees @your convenience.
|
 |
| 6231 |
Maintaining a Microsoft® SQL Server 2008 Database |
8 Days |
Theory: 3 Days
Labs: 2 Days |
| 6232 |
Implementing a Microsoft® SQL Server 2008 Database |
11 Days |
Theory: 3 Days
Labs: 2 Days |
| 70-433 - MCTS: Microsoft SQL Server 2008, Database Development |
| MOC |
Course |
Exam Nr. |
Duration Days |
Price |
Certification Saving |
Payment Option |
International Certification |
| 2778 |
Writing Queries Using Microsoft® SQL Server 2008 Transact-SQL |
70-433 |
5 Days |
Theory: 3 Days
Labs: 2 Days |
Sign up for a FREE account and view the
Course fees @your convenience.
|
 |
| 6231 |
Maintaining a Microsoft® SQL Server 2008 Database |
8 Days |
Theory: 3 Days
Labs: 2 Days |
| 6232 |
Implementing a Microsoft® SQL Server 2008 Database |
11 Days |
Theory: 3 Days
Labs: 2 Days |
| 70-448 - MCTS: Microsoft SQL Server 2008 Business Intelligence
Development & Maintenance |
| MOC |
Course |
Exam Nr. |
Duration Days |
Price |
Certification Saving |
Payment Option |
International Certification |
| 6234 |
Implementing and Maintaining Microsoft® SQL Server 2008 Analysis
Services |
70-448 |
5 Days |
Theory: 3 Days
Labs: 2 Days |
Sign up for a FREE account and view the
Course fees @your convenience.
|
 |
| 6235 |
Implementing and Maintaining Microsoft® SQL Server 2008
Integration Services |
8 Days |
Theory: 3 Days
Labs: 2 Days |
| 6236 |
Implementing and Maintaining Microsoft® SQL Server 2008 Reporting
Services |
11 Days |
Theory: 3 Days
Labs: 2 Days |
» Back to top
Database Administrator
Database Administrators use database software to store and manage information.
They will often set up database systems and are responsible for making sure
those systems operate efficiently. They also make sure that the data they store
is backed up regularly, stored effectively, and that the data is secure from
unauthorized access. Ensuring the data is available, by maximizing database
uptime, is also an important function of the database administrator.
Their primary responsibilities include:
- Defining high availability solutions
- Automating administrative tasks
- Defining security solutions
- Monitoring and troubleshooting the database server
- Designing and executing deployments
- Defining the infrastructure (storage, hardware, and number of servers or
instances, etc.)
Note that they are NOT a database operator just doing rote,
by-the-book work. They are creating the specs, creating requirements, and
creating the run book (when power goes out, what do you do, etc.).
| MCITP: Database Administrator 2008 (MCTS Requirements
Included) |
| Course |
Exam Nr. |
Duration Days |
Price |
Certification Saving |
Payment Option |
International Certification |
| TS: Microsoft SQL Server 2008, Implementation and Maintenance |
70-432 |
24 Days |
Theory: 14 Days
Labs: 10 Days |
Sign up for a FREE account and view the
Course fees @your convenience.
|
 |
| PRO: Design, Optimize & Maintain a Database Admin Solution - Ms
SQL Server 2008 |
70-450 |
11 Days |
Theory: 8 Days
Labs: 3 Days |
» Back to top
Database Developer
Database Developers are experienced users whose focus is on database solutions.
These are people who work on solving business problems (sometimes called use
cases). They are able to take their technical expertise and their product
expertise and merge it with problem-solving abilities to create solutions to
business problems. This person is already proficient in database technologies
and proficient at applying many of them at a professional job role level.
Their primary responsibilities include:
- Writing Transact-SQL queries (select, update, insert, delete)
- Designing and implementing programming objects
- Troubleshooting programming objects (stored procedures, triggers, user defined
functions [UDFs], user defined types [UDTs], and queries)
- Doing database performance tuning and optimization
- Designing databases, at both the conceptual and logical levels
- Implementing databases at the physical level (that is, physical implementation
of database objects; for example, table and index creation)
- May be involved in designing and troubleshooting the data access layer of the
application
- Gathering business requirements
| MCITP: Database Developer 2008 (MCTS Requirements
Included) |
| Course |
Exam Nr. |
Duration Days |
Price |
Certification Saving |
Payment Option |
International Certification |
| TS: Microsoft SQL Server 2008, Database Development |
70-433 |
24 Days |
Theory: 14 Days
Labs: 10 Days |
Sign up for a FREE account and view the
Course fees @your convenience.
|
 |
| PRO: Design Database Solutions and Data Access Using Ms SQL Server
2008 |
70-451 |
8 Days |
Theory: 6 Days
Labs: 2 Days |
» Back to top
Business Intelligence Developer
The BI developer does a blend of server development and server administration
tasks, but spends the majority of his or her time modeling and developing
storage solutions. BI developers make it possible for terabytes of data to be
read quickly by applications. The BI developer is responsible for designing,
troubleshooting, and tuning the server or back-end business intelligence
solution.
Their primary responsibilities include:
- Designing and implementing cubes
- Designing reporting services solutions
- Troubleshooting data transforms
- Doing storage performance tuning and optimization
- Designing Star and Snowflake schemas and cubes, at both the conceptual and
logical levels
- Implementing cubes at the physical level (that is, physical implementation of
cubes and dimensions)
- Gathering business requirements
- May be involved in designing and troubleshooting the application.
- Writing MDX for customization and querying
- Exposure to or familiarity with:
- Using ETL technologies to extract, transform, and load.
- Using reporting tools
- Integrate the results of data mining to a reporting solution
| MCITP: Business Intelligence Developer 2008 (MCTS Requirements
Included) |
| Course |
Exam Nr. |
Duration Days |
Price |
Certification Saving |
Payment Option |
International Certification |
| TS: Microsoft SQL Server 2008 Business Intelligence Development &
Maintenance |
70-448 |
15 Days |
Theory: 6 Days
Labs: 9 Days |
Sign up for a FREE account and view the
Course fees @your convenience.
|
 |
| PRO: Design a Business Intelligence Infrastructure Using Ms SQL
Server 2008 |
70-451 |
16 Days |
Theory: 10 Days
Labs: 6 Days |
» Back to top