|
Microsoft Database and Programming Developer .NET
From beginner to high level Microsoft Certifications covering a range of cross-training programming and database skills.
 
Course Contents:
Stage 1: Software Programming Fundamentals
Stage 2: Programming Best Practices
Stage 3: Software Development Principles
Stage 4: Systems and Database Design
Stage 5: Managing Information Systems
Stage 6: Exam 70-305 Developing and Implementing Web Applications with MS VB.NET and MS Studio .NET
Stage 7: Exam 70-306 Developing and Implementing Windows-based Apps with MSVB .NET and MS Studio .NET
Stage 8: Exam 70-310 Developing XML Web Services and Server Components with MS VB .NET and the MS .NET Framework
Stage 9: Exam 70-300 Analysing Requirements and Defining MS .NET Solution Architectures
Stage 10: Exam 70-229 Designing and Implementing Databases with MS SQL Server 2000 Enterprise
Stage 11: Exam 70-228 Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
Stage 12: Exam 70-290: Managing and Maintaining a Microsoft Windows Server 2003 Environment
Stage 13: Exam 70-431 TS: Microsoft SQL Server 2005: Implementation and Maintenance
Stage 14: Exam 70-443 PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
Stage 15: Exam 70-444 PRO: Optimising and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
Course Code:
DPD-4
Course Duration:
12 months
Typical Study Hours:
500 - 520 hours
Course Fees:
See our Fee Guide
In addition to the stages specified, we also include:
Additional Information for Stage 1:
- Software Programming Fundamentals:
- Getting Started
- Designing Programs
^top
Additional Information for Stage 2:
- Programming Best Practices:
- Programming Techniques and Strategies
- General Coding Best Practices
- Object-oriented Coding Best Practices
- Maintaining Quality Code
^top
Additional Information for Stage 3:
Software Development Principles:
- Developing a User-Centred Software Design Approach
- Introducing User-Centered Design
- Developing an Application Using User-Centered Design
- The Iterative Process in User-Centered Design
- Practical Examples of User-Centered Design
^top
Additional Information for Stage 4:
Systems and Database Design:
- Database Design
- An Overview of Database Design
- The Database Design Methodology
- Database Fundamentals
- An Introduction to Database Systems
- Relational Databases
- Database Data Management
- Systems Analysis Fundamentals
- Data Flow Diagrams
- Entity Relationship Diagrams
- Data Dictionaries
- Completing the Logical Model
- Relational Principles
- Database Fundamentals
- Fundamentals of Database Design
- Normalisation and Physical Database Design
- Database Management
- Web and Database Integration
- Database Technologies
- Object-Relational DBMSs
- Characteristics
- Mechanisms and Implementation
- Data Warehousing
- Fundamentals
- Building, Using, and Managing
- SQL Programming
- Database Queries
- Data Handling Techniques
^top
Additional Information for Stage 5:
Managing Information Systems:
- The Software Development Process
- Principles
- Management Practices
- Open Systems Standards I
- Open Systems Standards II
- Client/Server Fundamentals
- Client/Server Technology
- Client/Server Implementation
- Internet, Intranet, and Extranet Technologies
- Software Engineering
- Personal Software Process I
- Personal Software Process II
- Client/Server Technologies
- The Client/Server Model
^top
Additional Information for Stage 6:
- Exam 70-305 Developing and Implementing Web Applications with MS VB.NET and MS Studio .NET:
- Introducing Microsoft .NET
- Visual Basic NET for the VB6 Developer
- Foundations of ASP.NET with VB.NET
- ADO.NET with VB.NET
- Configuration and Security with VB.NET
- Testing, Debugging, and Maintaining Web Applications in VB.NET
- Mastering ASP.NET with VB.NET
- Web-based Application Deployment
^top
Additional Information for Stage 7:
- Exam 70-306 Developing and Implementing Windows-based Apps with MSVB .NET and MS Studio .NET:
- Creating User Services for Windows Applications with VB.NET Testing, Debugging, and Maintaining Windows Applications in C#
^top
Additional Information for Stage 8:
- Exam 70-310 Developing XML Web Services and Server Components with MS VB .NET and the MS .NET Framework:
- Building XML Web Services
- Building Server Components with VB.NET
^top
Additional Information for Stage 9:
- Exam 70-300 Analysing Requirements and Defining MS .NET Solution Architectures:
- Analysing Requirements and Defining Solution Architectures
^top
Additional Information for Stage 10:
- Exam 70-229: Designing and Implementing Databases with MS SQL Server 2000 Enterprise:
- Designing and Implementing Databases with Microsoft SQL Server 2000
- Overview of SQL Server 2000
- SQL Server 2000 Databases
- Designing and Implementing Security
- The Logical Data Model
- Transact-SQL
- Indexes
- Programming Business Logic
- Transactions and Distributed Data
- Analysing and Optimising Queries
- Transferring and Transforming Data
- SQL Server 2000, XML and the Web
^top
Additional Information for Stage 11:
- Exam 70-228 Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition:
- Administering Microsoft SQL Server 2000
- Overview of SQL Server 2000
- Installing, Configuring and Upgrading SQL Server 2000
- SQL Server 2000 Databases
- Transferring and Transforming Data Security
- Managing SQL Server 2000 Databases
- Backing up Databases
- Restoring Databases
- Replication
- Monitoring SQL Server 2000 Performance
- SQL Server 2000 High Availability
- SQL Server 2000, XML and the Web
^top
Additional Information for Stage 12:
- Exam 70-290 Managing and Maintaining a Microsoft Windows Server 2003 Environment:
- Basic Concepts
- Managing Users, Groups and Computers
- Managing Resource Access
- Managing Hardware, Disks and Logical Devices
- Managing the Server Environment
- Managing Disaster Recovery
^top
Additional Information for Stage 13:
- Exam 70-431 TS: Microsoft SQL Server 2005: Implementation and Maintenance
- Installing SQL Server 2005
- Configuring SQL Server 2005
- Creating and Implementing Database Objects in SQL Server 2005
- Retrieving Data and Running Queries in SQL Server 2005
- SQL Server 2005 Messaging and Querying Tools
- Managing and Maintaining SQL Server 2005 Databases
- SQL Server 2005 Database Performance and Optimisation
- Monitoring and Diagnosing Database Problems in SQL Server 2005
- SQL Server 2005 High Availability and Disaster Recovery
- SQL Server 2005 Backup and Restores
^top
Additional Information for Stage 14:
- Exam 70-443 PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
- Designing a Database Server Infrastructure for SQL Server 2005
- Designing Security for a Database Server Infrastructure for SQL Server 2005
- Designing the Physical Database for SQL Server 2005
- Designing a Database Server High Availability Solution for SQL Server 2005
- Designing a Database Failover Solution for SQL Server 2005
- Designing a Database Server Data Recovery Solution for SQL Server 2005
Additional Information for Stage 15:
- Exam 70-444 PRO: Optimising and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
- Optimising SQL Server 2005 Performance
- Optimising a Database Data Recovery Plan for SQL Server 2005
- Monitoring and Maintaining a Database in SQL Server 2005
- Managing Database Data in a SQL Server 2005 Environment
- Managing Data Between Servers and Databases
- Managing and Maintaining Database Security in SQL Server 2005
<< back to previous page
|
 |
 |
|
Pass - or we'll buy your training back!
Enhanced Online Support to ensure you complete your training and get certified even faster!
24/7 Online Mentoring from certified instructors
Access to the Virtual University
Daily Training Emails
Access to 400+ titles in our Technical Library
Web links
Hands on Interactive Exercises
Hundreds of practice test questions
VB Compiler
|
 |
 |
 |
|
Microsoft Certified Applications Developer MCAD .NET
Microsoft Certified Solutions Developer MCSD .NET
Microsoft Certified Database Administrator MCDBA 2003
Microsoft Certified Technology Specialist MCTS SQL Server 2005
Microsoft Certified IT Professional MCITP Database Administrator |
 |
"So far I am enjoying the course. The material does exactly what it says on the tin and I am impressed with it. I sailed through getting started and designing programs." A Swift
|