Database Developer Training

 

 

Program Description

 

As a database developer, you probably work in a medium-sized to enterprise-scale organization and use powerful database management and data analysis tools. Your role is to design, develop, and implement complex database systems, tools, and applications. Your specialty might be writing queries and stored procedures, using data modeling tools, designing and optimizing databases, or implementing at the physical level. You must have a thorough understanding of relational databases. You are the Microsoft SQL Server expert whose responsibilities might include supporting and securing critical information systems and providing reliable data that can be used in business-specific software solutions.

Possible Job Titles:

  • Database administrator
  • SQL Server database developer
  • Software engineer
  • Database engineer

 

Skills Gained

 

Skills

  • Write queries
  • Design, program, and implement databases
  • Troubleshoot programming objects
  • Tune and optimize database performance
  • Design and troubleshoot the data access layer of an application
  • Gather business requirements

Responsibility Scope

  • 50 percent developing and testing solutions
  • 25 percent administration and management
  • 25 percent responding to user requests

 

Career Certification

 

MCITP: Database Developer 2008

 

Exams

 

  • Microsoft Exam 70-433 TS: Microsoft SQL Server 2008, Database Development
  • Microsoft Exam 70-451 PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

 

Learning Plan

 

Total Number of Training Days: 18 Days

Course 6231 (5 days)

Maintaining a Microsoft SQL Server 2008 Database

 

Course 6232A (5 days)

Implementing a Microsoft SQL Server 2008 Database

 

Course 2778 (3 days)

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

 

Prep 70-433

Test Prep for 70-433: TS: Microsoft SQL Server 2008, Database Development.

Course 50401 (5 days)

Designing and Optimizing Database Solutions with Microsoft SQL Server 2008

 

Prep 70-451

Test Prep for 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008.

 

Microsoft College Credit