Microsoft Visual Basic .NET and Microsoft SQL Programming Consulting - SethMartel.com About News Education Certification Links Contact
Microsoft Visual Basic .NET, Microsoft SQL and Oracle Development Consulting - SethMartel.com


Consulting Services


Visual Basic 6 and .NET Development
Microsoft SQL Development
Data Transformation
Information Security
Software Testing and Documentation

All Certifications On One Long Page

Microsoft Certified IT Professional:

Database Administrator

on SQL Server 2005


The Microsoft Certified IT Professional (MCITP) credentials provide IT professionals with a simpler and more targeted framework to showcase their technical skills in addition to the skills that are required for specific developer job roles. Microsoft Certified IT Professional: Database Administrator (MCITP: Database Administrator) is the premier certification for Microsoft database server administrators. This certification demonstrates that individuals can install and configure Microsoft SQL Server, manage and maintain multidimensional databases, user accounts, database availability, recovery, and reporting. Certified individuals also design and implement security, server automation and monitor and troubleshoot SQL Server activity in mid-size to large organizations.


Exam Number
Exam Title
Status
70–447
UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005
Passed

The exam requirements for the IT Professional: Database Administrator certification overlap some of the exam requirements for Technology Specialist: SQL Server 2005 certification.

Microsoft Certified Technology Specialist:

SQL Server 2005


The Microsoft Certified Technology Specialist: SQL Server 2005 (MCTS: SQL Server 2005) credential highlights skills and knowledge of Microsoft's SQL Server 2005 product. The credential demonstrates in-depth knowledge and expertise in administering, deploying, and maintaining Microsoft SQL Server 2005. Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 implement and maintain databases using specific instructions and specifications. They have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to explore the user interface.


Exam Number
Exam Title
Status
70-431
TS: Microsoft SQL Server 2005—Implementation and Maintenance
Passed

The exam requirements for the Technology Specialist: SQL Server 2005 certification overlap some of the exam requirements for IT Professional: Database Administrator certification.

Microsoft Certified Solution Developer

and

Microsoft Certified Application Developer

on Visual Basic .NET

The Microsoft Certified Solution Developer (MCSD) for Microsoft .NET credential is for lead developers who design and develop leading-edge enterprise solutions with Microsoft development tools, technologies, platforms, and the Microsoft .NET Framework.

The Microsoft Certified Application Developer (MCAD) for Microsoft .NET credential is for developers who use Visual Basic .NET and other Microsoft technologies to build and maintain applications, components, back-end data services, Web and desktop clients.

The MCSD job role includes analyzing business and technical requirements, and defining the solution architecture, as well as the tasks typically conducted by MCADs, implementing the requirements and building, deploying, testing and maintaining the solution. The scope of responsibility of Solution Developer encompasses that of Application Developer and also goes beyond it.

The MCSD for .NET credential demonstrates the skills necessary to lead organizations in the successful analysis, design, implementation, and administration of enterprise solutions. Achieving the MCAD credential demonstrates the skills necessary to build, test, deploy, and maintain applications, components, Web and desktop clients, as well as database and network services.

Exam Number
Exam Title
Status
70-306
Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
Passed
70-305
Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
Passed
70-310
Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
Passed
70-300
Analyzing Requirements and Defining Microsoft .NET Solution Architectures Passed

The exam requirements for the Solution Developer and Application Developer certification overlap some of the exam requirements for Database Administrator and Systems Engineer certifications. In addition, the exam requirements for the Application Developer certification are a subset of the exam requirements for the Solution Developer certification.

Microsoft Certified Solution Developer

on Visual Basic 6

The MCSD is Microsoft's premier certification for software development and demonstrates an individual's ability to create, deploy, maintain and support desktop and distributed applications. This encompasses analyzing customers requirements, conceptual design, creating client applications, COM components, and binding to data sources. The certification includes desktop applications and multi-tier enterprise applications and measures an individual's ability to utilize development skill such as GUI creation, navigational design, data input and validation, as well as to access and manipulate a data source. The certification also tests an individual's ability to assess the impact of potential design elements on performance, maintainability, extensibility, scalability, availability, and security.

Exam Number
Exam Title
Status
70-175
Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0
Passed
70-176
Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0
Passed
70-100
Analyzing Requirements and Defining Solution Architectures
Passed

The exam requirements for the Solution Developer certification overlap some of the exam requirements for Database Administrator and Systems Engineer certifications.

Microsoft Solution Framework Practitioner


An MSF Practitioner is an IT professional or developer that brings the added skills of project, risk and team management together with an in-depth understanding of software development methodology and the knowledge needed to successfully deploy solutions. The MSF Practitioner is an individual who can manage people, important projects, and use the MSF approach and tools - a key credential for anyone that manages large-scale development and deployment projects.

Many companies use MSF Practitioners to help them improve team effectiveness and the business impact of their technology projects. MSF Practitioners are typically consultants and/or IT professionals, developers, and managers that lead organizations in the adoption of MSF proven practices to be more successful delivering technology solutions. Microsoft recognizes MSF Practitioners as "people and process" experts and points customers to MSF Practitioners for MSF services including training, mentoring and project leadership. Practitioners share one primary goal: improve business success through the successful delivery of high-quality, customer-driven, technology solutions.

The Microsoft Solutions Framework (MSF) is an adaptable approach for successfully delivering technology solutions faster, with fewer people and less risk, while enabling higher quality results.

MSF helps teams directly address the most common causes of technology project failure-- improving success rates, solution quality, and business impact.

MSF describes, among other things:

  • Aligning business and technology goals
  • Establishing clear project goals, roles, and responsibilities
  • Implementing an iterative, milestone-driven process
  • Managing risk proactively
  • Responding to change effectively

MSF is a deliberate and disciplined approach to technology projects based on Microsoft internal practices, the experiences of Microsoft Services working with customers and partners, and industry best practices.

Also, it should be noted that the MSF Practitioner is an endorsement and not a certification.

Exam Number
Exam Title
Status
74-100
Microsoft Solution Framework Practitioner Exam
Passed

Microsoft Certified Database Administrator

on SQL Server 2000


The Microsoft Certified Database Administrator on Microsoft SQL Server 2000 credential is for professionals who implement and administer Microsoft SQL Server databases. The certification covers creating physical database designs, developing logical data models, creating physical databases, creating data services by using Transact-SQL, managing and maintaining databases, configuring and managing security, monitoring and optimizing databases, installing and configuring SQL Server.


Exam Number
Exam Title
Status
70-229
Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
Passed
70-228
Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
Passed

The exam requirements for the Database Administrator certification overlap some of the exam requirements for Solution Developer and Systems Engineer certifications.

Oracle9i Database Administrator Certified Professional

and

Oracle9i Database Administrator Certified Associate


Oracle9i DBA OCPs manage the industry's most advanced information systems and have a combination of training and skills, which allow them to manage critical, database functions and work on mission-critical projects. Required skills include network administration, extensive backup and recovery experience and practical experience tuning an Oracle database, all of which are essential to managing an enterprise-level information system.


The Oracle 9i OCA has a firm foundation in the basic skills Oracle database administration.


Exam Number
Exam Title
Status
1Z0-007
Introduction To Oracle9i: SQL
Passed
1Z0-031
Oracle9i Database: Fundamentals I
Passed
1Z0-099
Hands-On Course Requirement
Passed
1Z0-032
Oracle9i Database: Fundamentals II
Passed
1Z0-033
Oracle9i Database: Performance Tuning
Passed


Microsoft Certified Systems Engineer

on Windows 2003

and

Microsoft Certified Systems Administrator

on Windows 2003


The Microsoft Certified Systems Engineer (MCSE) credential is for professionals who analyze the business requirements and design and implement the infrastructure for business solutions. Implementation responsibilities include installing, configuring, and troubleshooting network systems in addition to deploying new networks and systems.

The Microsoft Certified Systems Administrator (MCSA) credential is for professionals to demonstrate the skills to successfully manage and troubleshoot system environments running on the Windows 2003 operating system.

Both certifications validate knowledge and proficiency with Microsoft products and technologies The MCSA is a direct subset of the requirements of the MCSE since the Systems Engineer job tasks incorporate all the Systems Administrator job tasks and takes them further. The major distinction is that the Systems Administrator certification focuses heavily on how to perform various job task while the Systems Engineer certification focuses on why to perform various tasks to reach a solution.


Exam Number
Exam Title
Status
70-296
Planning, Implementing, and Maintaining a Microsoft® Windows® Server 2003 Environment for an MCSE Certified on Windows 2000
Passed
70-292
Managing and Maintaining a Microsoft® Windows® Server 2003 Environment for an MCSA Certified on Windows 2000
Passed

Microsoft Certified Systems Engineer

on Windows 2000

and

Microsoft Certified Systems Administrator

on Windows 2000


The Microsoft Certified Systems Engineer (MCSE) credential is for professionals who analyze the business requirements and design and implement the infrastructure for business solutions. Implementation responsibilities include installing, configuring, and troubleshooting network systems in addition to deploying new networks and systems.

The Microsoft Certified Systems Administrator (MCSA) credential is for professionals to demonstrate the skills to successfully manage and troubleshoot system environments running on the Windows 2000 operating system.

Both certifications validate knowledge and proficiency with Microsoft products and technologies The MCSA is a direct subset of the requirements of the MCSE since the Systems Engineer job tasks incorporate all the Systems Administrator job tasks and takes them further. The major distinction is that the Systems Administrator certification focuses heavily on how to perform various job task while the Systems Engineer certification focuses on why to perform various tasks to reach a solution.


Exam Number
Exam Title
Status
70-210
Installing, Configuring, and Administering Microsoft Windows 2000 Professional
Passed
70-215
Installing, Configuring, and Administering Microsoft Windows 2000 Server
Passed
70-216
Implementing and Administering a Microsoft Windows 2000 Network Infrastructure
Passed
70-218
Managing a Windows 2000 Network Environment
Passed
70-217
Implementing and Administering a Microsoft Windows 2000 Directory Services Infrastructure
Passed
70-221
Designing a Microsoft Windows 2000 Network Infrastructure
Passed
70-219
Designing a Microsoft Windows 2000 Directory Services Infrastructure
Passed
70-220
Designing Security for a Microsoft Windows 2000 Network
Passed
70-223
Installing, Configuring, and Administering Microsoft Clustering Services by Using Microsoft Windows 2000 Advanced Server
Passed
70-227
Installing, Configuring, and Administering Microsoft Internet Security and Acceleration (ISA) Server 2000, Enterprise Edition
Passed
70-224
Installing, Configuring, and Administering Microsoft Exchange 2000 Server
Passed

Cisco Certified Network Associate


The Cisco Certified Network Associate certification (CCNA) indicates foundation knowledge of networking. CCNA certified professionals can install, configure, and operate LAN, WAN, and dial access services for networks, including the use of these technologies: IP, IGRP, Serial, Frame Relay, IP RIP, VLANs, RIP, Ethernet, and Access Lists. The certification covers that the individual has important knowledge and skills necessary to select, connect, configure, and troubleshoot various Cisco networking devices.


Exam Number
Exam Title
Status
640-607
Cisco Certified Network Associate Exam
Passed

Security Certified Network Professional

The Security Certified Network Professional program validates the knowledge and skills required to plan and implement security on an enterprise network. This focuses on awareness of security related issues and the ability to take appropriate steps to mitigate risk.

The areas of knowledge and skills measured by the certification include:

  • Advanced TCP/IP
  • IP Packet Structure and Analysis
  • Routing and Access Control Lists
  • Securing Windows Computers
  • Securing Linux Computers
  • Security on the Internet and the World Wide Web
  • Attack Techniques
  • Network Defense Fundamentals
  • Designing and Configuring Firewall Systems
  • Configuring VPNs
  • Designing and Configuring an IDS
  • Analyzing Intrusion Signatures
  • Performing a Risk Analysis
  • Creating a Security Policy

Exam Number
Exam Title
Status
SC0-401
Network Security Fundamentals (NSF)
Passed
SC0-402
Network Defense and Countermeasures (NDC)
Passed

CompTIA IT Project+

The CompTIA IT Project+ certification validates the knowledge and abilities required as an IT project manager. IT Project+ certification is proof of the critical knowledge of business practices, interpersonal skills and project management processes, in addition to the ability to effectively plan, implement and complete IT projects on time and within budget. CompTIA's IT Project+ certification is a vendor-neutral credential.

The four categories that the IT Project+ exam tests on include:

Scope Definition
This section requires that the candidate have the knowledge to identify and define high-level business-related requirements, outcomes, and criteria for success, identify stakeholders’ low-level needs and expectations including boundaries for project budget, duration, and risk. This section will also require the knowledge to define a manager role/authority, to create a scope document that accurately represents the project size and specifics and to build stakeholder consensus, and obtain written approval from stakeholders.

Preliminary planning/Project planning
This section requires the knowledge and skills to create a project plan, requirements analysis, risk management and budgeting. This section also requires knowledge on how to create a schedule, a work breakdown structure (WBS), a project cost estimation, a communication plan and organization of a comprehensive project plan and close out the planning phase.

Project Execution
This section requires the knowledge and skills in project and issue tracking, change control, quality management, team management and resource management.

Closure
This section requires the knowledge and skills to recognize and explain the value of conducting a comprehensive review process that evaluates the planning, organizing, directing, controlling, execution, and budget phases of the project, identifying both the positive and negative aspects in a written report.

Exam Number
Exam Title
Status
PK0-001
IT Project+
Passed

CompTIA Security+

The Security+ examination measures a foundation-level of skill and knowledge in general security concepts, communication security, infrastructure security, basics of cryptography and operational / organizational security. The exam covers access control models, types of authentication, recognizing specific types of attacks, assessing vulnerabilities and mitigating risk, social engineering, auditing, VPN security, IPSEC, and Security Zones like DMZs / VLANS / NAT.

Exam Number
Exam Title
Status
SY0-101
Security+
Passed

CompTIA Linux+

The Linux+ examination is designed to measure the competencies of an individual with the Linux operating system and requires demonstration of skills in basic installation, operation, administration and troubleshooting services on workstations and servers. The exam covers the different distributions, file systems, services, and configuration options available on the Linux platform.

The seven categories tested by the Linux+ exam include:

  • Planning the Implementation
  • Installation
  • Configuration
  • Administration
  • System Maintenance
  • Troubleshooting
  • Identify, Install, and Maintain System Hardware

Exam Number
Exam Title
Status
XK0-001
Linux+
Passed

CompTIA Server+ Certified Technician

The Server+ examination essentially picks up where the A+ examination leaves off. While the A+ covers essential basic tasks for desktop computer configuration and support, the Server+ covers essential basic tasks for server configuration and support like multiprocessor setup, RAID array installation, and multiple NIC configuration.

The seven categories tested by the Server+ exam include:

  • Installation
  • Configuration
  • Upgrading
  • Proactive Maintenance
  • Environment
  • Troubleshooting and Problem Determination
  • Disaster Recovery

Exam Number
Exam Title
Status
SK0-001
Server+
Passed

CompTIA Network+

Network+ verifies that individuals know the layers of the OSI model, can describe the features and functions of network components and have the skills needed to install, configure, and troubleshoot basic networking hardware peripherals and protocols.

The exam has four categories which cover:

  • Media & Topologies
  • Protocols & Standards
  • Network Implementation
  • Network Support.

Exam Number
Exam Title
Status
N10-002
Network+
Passed

CompTIA A+ Certified Technician

The A+ exams measure essential competencies for a desktop computer hardware service technician and require demonstration of basic knowledge of installing, configuring, upgrading, troubleshooting, and repairing desktop computer systems. The A+ exams deal with the basics of desktop computer hardware and software operation. The A+ provides a strong foundation in a wide range of nitty-gritty elements like IRQ settings, hardware setup, and BIOS configuration. The A+ exams cover DOS and Windows 95/98/ME/2000.

The six categories of the Core Hardware exam tests on include:

  • Installation, Configuration and Upgrading
  • Diagnosing and troubleshooting
  • Preventive Maintenance
  • Motherboard/Processors/Memory
  • Printers
  • Basic Networking

The four categories that the Operating Systems exam tests on include:

  • OS Fundamentals
  • Installation, Configuration and Upgrading
  • Diagnosing and Troubleshooting
  • Networks

Exam Number
Exam Title
Status
220-221
A+ Core Hardware
Passed
220-222
A+ OS Technologies
Passed

©2002 Seth Martel, Manchester Connecticut USA - Legal - Privacy Policy - Site Map