Enterprise Database Design and Development

The Enterprise Database Design and Development Certifications are for the professionals that gathers the requirements, and designs, models, and develops an enterprise database.

  Certification Objective

PSI certification holders in Enterprise Database Design and Development can expertly design, model, develop, and manipulate an enterprise database.

  Available Certifications

• Professional Level: Certified Professional Enterprise Database Developer
  • The Certified Professional Enterprise Database Developer is a skilled and competent specialist that can gather requirements and design, model, and develop enterprise databases.
• Senior Level: Certified Senior Enterprise Database Engineer
  • The Certified Senior Enterprise Database Engineer is a leader with advanced skills in gathering requirements and designing, modeling, and developing an enterprise database, and can lead enterprise database development teams and projects.
• Master Level: Certified Master Enterprise Database Architect
  • The Certified Master Enterprise Database Architect is a manager or executive with subject mastery in gathering requirements and designing, modeling, and developing an enterprise database, and can manage enterprise database management departments.

  Applicable Careers

The careers applicable to this certification include Database Manager, Database Designer, Data Modeler, Database/SQL Developer, Data Analyst, and Database Support Technician. In addition, the skills of this certification could be included in other roles, such as Database Administrator, Big Data Analyst, Systems Analyst, Software Engineer, Computer Programmer, Database Tester, and Data Scientist.

  Skills and Competencies

The skills and competencies listed below are required for all levels of certification, unless specified otherwise. The skills and competencies needed for the certification in Enterprise Database Design and Development include:

Professional Level:

• Design and model a relational database.
• Normalize a database to the third-normal form.
• Create Data Definition Language (DDL) code from a database model and generate the physical database.
• Develop Structured Query Language (SQL) to insert, update, and delete data from a database.
• Develop SQL to retrieve data from one or more tables in a database.
• Create and use database views.
• Develop SQL to aggregate and summarize data during retrieval using summary queries in a database.
• Properly use SQL sub-queries and convert data from one data type to another.
• Properly use built-in SQL functions.
• Create stored procedures, triggers, events, and custom functions, and properly implement transactions and record locking.
• Implement professional coding, formatting, and internal documentation techniques in developing DDL and SQL.
• Given a database requirements document, design, develop, and generate an enterprise relational database.

Senior Level:

• All competencies at the Professional Level above.
• Research, analyze, and solve complex database problems.
• Design and develop enhancements to existing enterprise databases.
• Lead enterprise database development projects and teams.

Master Level:

• All competencies at the Professional and Senior Levels above.
• Design, plan, and manage an enterprise database management department.

  Phase 1 Eligibility Requirements

To determine your eligibility to apply for certification in Enterprise Database Design and Development your experience and education must meet the minimum requirements below.

Specific Eligibility Requirements:

• Professional Level
  • Must meet one of the following requirements:
    1. Five (5) years of experience
       OR
    2. Four (4) years of experience plus associate degree OR technical/career certificate or diploma
       OR
    3. Three (3) years of experience plus bachelor's degree
  • 25% of required experience must be within the last 5 years
• Senior Level
  • Must meet one of the following requirements:
    1. Eight (8) years of experience
       OR
    2. Seven (7) years of experience plus associate degree OR technical/career certificate or diploma
       OR
    3. Six (6) years of experience plus bachelor's degree
  • 25% of required experience must be within the last 5 years
  • Must have 2 years of project lead or supervisory experience
• Master Level
  • Must meet one of the following requirements:
    1. Twelve (12) years of experience
       OR
    2. Eleven (11) years of experience plus associate degree OR technical/career certificate or diploma
       OR
    3. Ten (10) years of experience plus bachelor's degree
       OR
    4. Nine (9) years of experience plus master's degree
  • 25% of required experience must be within the last 10 years
  • Must have 2 years of project lead or supervisory experience
  • Must have 2 years of managerial experience

Important Eligibility Notes

The following are specific experience and education requirements:

• Experience:
  • Experience must be relevant and verifiable.
  • The experience requirement must come from US-based companies.
  • If you are an independent contractor or consultant that perform project work and not fully employed, you can submit individual industry projects. The project work must equate to the amount of required work experience.
• Education: (college degree, technical/career certificate or diploma)
  • Must be in a relevant field.
  • The education requirement must come from U.S. based institutions.
• At this time we do not accept international applicants. We do not have international offices or staff.

Relevant Fields for Education Requirement

Your college degree or technical/career certificate or diploma must be in one of the following fields or similar fields.

1. Database Engineering, Systems, Management, or Administration
2. Data Management, Information Science (must have one course in database systems)
3. Computer Science or Information Technology (must have one course in database systems)

  Phase 2 Competency Requirements

Once your eligibility has been determined in phase 1, the next step is to verify your work experience and education and complete a Competency-Based "hands on" Assessment in your certification field, Enterprise Database Design and Development. You are given a specific mini project to accomplish and submit for peer evaluation.

Phase 2 Activities

1. Submit Assessment and Certification Fee
   $100 Off Certification Launch Pricing (through the end of November)
   • Professional Level: $295 $195
   • Senior Level: $395 $295
   • Master Level: $495 $395
2. Competency-Based Assessment
   • Complete and Submit the Competency-Based Assessment (Home-Based Assessment)
   • Peer evaluated based on Assessment Rubric
3. Feedback Provided and Recommendation Decision
   • You will be provided feedback for your Competency-Based Assessment submission.
   • The Competency-Based Assessment submission will either be accepted or not accepted.
     • If it is accepted, you will have earned your certification!
     • If it is not accepted, you will be able to re-work and re-submit your Competency-Based Assessment (one time) after the recommendation decision.

Certification Specific Requirements

• The DDL and SQL developed for the Competency-Based Work Project Assessment must be created for one of the following databases: MySQL, MariaDB, SQLite, or PostgreSQL. Open source databases are used to meet the "vendor-neutral" requirement of the certification.

Competency-Based Assessment Brief Overview

Given a set of specific project requirements for a small organizational database, using required skills and competencies the certification applicant will design and model a small enterprise database. The applicant will create the ER diagram and develop the Data Definition Language (DDL) to generate the physical database. In addition, the applicant will develop the Structured Query Language (SQL) to manipulate data within the database.

At the senior and master certification levels, the above tasks are required in addition to applying advanced level skills.

Requirements to Pass the Competency-Based Assessment

• Complete and submit the Competency-Based Assessment.
• Meet or exceed all of the requirements provided for the Competency-Based Assessment project.
• The submitted project work must demonstrate the appropriate level of skills and competencies for the certification.
• The submitted project work must be professional and demonstrate industry quality standards.

  Certification

After you have successfully completed both phases, you will be awarded your certification in Enterprise Database Design and Development! You will receive your certification certificate by mail and documented on your Professional Career Portfolio.