Certified SQL Intelligence Professional – (CDIP-SQ)

The CDIP-SQ is a professional certification examination designed to validate an individual’s applied proficiency in SQL-based analytics, data modeling, and intelligence reporting. It confirms mastery of relational database querying, transformation, and governance standards — enabling professionals to build reproducible, insight-driven data pipelines.

This certification ensures that holders can efficiently extract, transform, and analyze data using SQL while applying data governance, documentation, and analytical reasoning consistent with the Council of Certified Data Intelligence Professionals (CDIPS) framework.

---

🧭 Modules, Projects, and Examinations

The Certified SQL Intelligence Professional – (CDIP-SQ) certification is structured into five modules and a comprehensive capstone project designed to assess both technical fluency and governance-aligned data intelligence capability.

Component	Purpose	Evaluation Method	Weight
Module Assignments	Evaluate applied SQL analytics, database querying, and schema design capabilities.	Submission of completed deliverables from 2 of 4 case study options per module.	45%
Module Examinations	Assess theoretical and applied SQL competency across syntax, optimization, and governance.	Timed online examinations with multiple-choice and scenario-based SQL questions.	25%
Capstone Project	Measure end-to-end SQL workflow from data extraction to insight documentation.	Full project submission with query files, visual outputs, and governance report.	25%
Professional Conduct & Documentation	Assess reproducibility, compliance, and adherence to CDIPS governance standards.	Review of methodology notes, query efficiency, and data lineage documentation.	5%

Passing Requirement: Minimum overall score of 70%.
Reassessment Policy: Candidates may retake individual modules or the capstone within 60 days of result issuance.

---

🧩 Module Overview

Module	Focus Area
Module 1	SQL Fundamentals & Data Extraction
Module 2	Data Transformation & Cleaning
Module 3	Data Modeling & Joins
Module 4	Analytical Functions & Reporting Queries
Module 5	Query Optimization & Governance
Final Project	SQL BI Capstone Project

---

📂 Study Guides

Each module is supported by an optional Study Guide that includes practical exercises and workflow examples for structured preparation.

Contents Include:

• Verified dataset source links (e.g., AdventureWorks Database – Kaggle Verified Source)
• Guided tasks and query practice samples
• Recommended SQL workflow documentation templates
• Step-by-step optional walkthroughs for completing analytical tasks

Note: Study Guides are optional and designed to support the project phase, offering additional practice and guidance for building reproducible SQL workflows.

---

🧠 Capstone Project Overview

The CDIP-SQ Capstone Project evaluates candidates’ ability to design, execute, and document an end-to-end data intelligence solution using SQL. Candidates will:

1. Extract and clean datasets from relational tables.
2. Build a normalized schema to support analytical queries.
3. Write analytical SQL queries to calculate metrics and dimensions.
4. Document data lineage, transformations, and quality governance.
5. Produce an insight summary or report illustrating analytical conclusions.

Dataset sources such as AdventureWorks, Northwind, or other verified relational datasets may be used for the project.

---

🏅 Certification Issuance

Upon successful completion of all modules, examinations, and the final capstone project — and after verification of governance compliance — candidates are awarded:

🎖️ CDIP-SQ Certificate (PDF Format)
🧾 Digital Badge (CDIPS Registry-Verified)

This credential confirms professional proficiency in SQL-based analytics and intelligence reporting, recognizing the holder as a Certified SQL Intelligence Professional capable of developing efficient, governed, and reproducible data workflows aligned with global CDIPS standards.