CDE‌® Knowledge & Competence Requirements

Code Assessment Component
1 Understanding Database Concepts
  1. Understanding Databases Fundamentals
  2. Understanding Normalization
  3. Types of Databases
2 Understanding DDL (Data Definition Language ) and DML (Data Manipulation Language)
3 Understanding Database Objects
  1. Defining Data types
  2. Creating Tables
  3. Creating Views
  4. Creating Stored Procedures
4 Knowing Databases
  1. Understanding SQL Server 2012
  2. Understanding Oracle
  3. Understanding MySQL
5 Using SQL Server 2012
  1. Installing SQL Server 2012
  2. Configuring SQL Server 2012
  3. Using DDL and DML Statements in SQL Server 2012
  4. Creating Reports
6 Using Oracle Databases
  1. Installing Oracle Databases
  2. Configuring Oracle Databases
  3. Using DDL and DML Statements in Oracle Databases
  4. Creating Reports
7 Using MySQL
  1. Installing My SQL
  2. Configuring MySQL
  3. Using DDL and DML Statements in MySQL
8 Learning Language, Soft Skills, and Developing Recruitment-Readiness
  1. Knowing the Role of Language and Impressive Personality in Career Development
  2. Learning Etiquettes in English to Express Thanks, Gratitude, Responses to Sorry and Thanks
  3. Learning How to Prepare for the Job Interview, Knowing the Do’s and Don’ts
  4. Designing a Resume and a Covering Letter
  5. Understanding the Essence of English Grammar and identifying Common Errors