Home » Microsoft Training Courses » Microsoft Database and
Programming Developer .NET
Microsoft Database and Programming Developer .NET
From beginner to high level Microsoft Certifications covering a range of cross-training programming VB and SQL 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: Microsoft Exam 70-536 TS: Microsoft .NET Framework 2.0 - Application Development Foundation VB
Stage 7: Microsoft Exam 70-526 TS: Microsoft .NET Framework 2.0 - Windows-Based Client Development VB
Stage 8: Microsoft Exam 70-529 TS: Microsoft .NET Framework 2.0 - Distributed Application Development VB
Stage 9: Microsoft Exam 70-431 TS: Microsoft SQL Server 2005: Implementation and Maintenance
Stage 10: Microsoft Exam 70-443 PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
Stage 11: Microsoft Exam 70-444 PRO: Optimising and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
Stage 12: Microsoft Exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005
Stage 13: Microsoft Exam 70-442 PRO: Designing and Optimising Data Access by Using Microsoft SQL Server 2005
Course Code:
DPD-8
Course Duration:
12 months
Typical Study Hours:
320 - 340 hours
Course Fees:
See our Fee Guide
Course Demo:
Request an online Course Demo
In addition to the stages specified, we also include:
Study Prerequisite:
Basic computer knowledge, basic programming skills or experience, programming Certifications, or relevant industry experience.
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:
- Microsoft Exam 70-536 TS: Microsoft .NET Framework 2.0 - Application Development Foundation VB
- Visual Basic: System Types and Collections
- Visual Basic: Serialisation and I/O
- Visual Basic: Customised Programming
- Visual Basic: Security
- Visual Basic: Threading, Service Processing, and Application Domains
- Visual Basic: Diagnostics and Management
^top
Additional Information for Stage 7:
- Microsoft Exam 70-526 TS: Microsoft .NET Framework 2.0 - Windows-Based Client Development VB
- Windows Forms Creation and Configuration with Visual Basic 2005
- Data Integration, Database Environments, and XML Handling with Visual Basic 2005
- Windows Forms Controls and Usability with Visual Basic 2005
- Asynchronous Programming and Deployment with Visual Basic 2005
^top
Additional Information for Stage 8:
- Microsoft Exam 70-529 TS: Microsoft .NET Framework 2.0 - Distributed Application Development VB
- Web Services with Visual Basic 2005
- Remoting with Visual Basic 2005
- WSE Implementation with Visual Basic 2005
- Serviced Components and Messaging with Visual Basic 2005
^top
Additional Information for Stage 9:
- Microsoft 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 10:
- Microsoft 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
^top
Additional Information for Stage 11:
- Microsoft 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
^top
Additional Information for Stage 12:
- Microsoft Exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005
- Designing an Application Solution for SQL Server 2005
- Designing Database Objects
- Programming with SQL Server 2005
- Using XML
- CLR Integration
- Database Testing and Code Management
- Developing Applications that Use SQL Server Business Intelligence Services
- Developing Applications that Use SQL Server Support Services
- Database Deployment and Data Distribution
^top
Additional Information for Stage 13:
- Microsoft Exam 70-442 PRO: Designing and Optimising Data Access by Using Microsoft SQL Server 2005
- Designing Access to SQL Server Data
- Designing Efficient Application Access
- Designing Queries in SQL 2005
- Designing a SQL Server 2005 Cursor Strategy
- Designing a SQL Server 2005 Transaction Strategy
- SQL Server 2005 Error Handling Techniques
- Optimising Query Performance and Index Strategies
- Optimising Storage in SQL Server 2005
- Scaling Applications and Resolving Performance Issues
^top
<< back to previous page
|