ADEAcademy of
Design Excellence
Explore
Explore ADE
Discover the wider ADE ecosystem beyond courses.
About ADE→

Who we are, why ADE exists and where the ecosystem is heading.

ADE for Business→

Talent, team capability and business collaboration through ADE.

Community→

Connect with learners, professionals, instructors and collaborators.

Events→

Workshops, conversations, showcases and live ADE experiences.

Insights / Articles→

Practical ideas across technology, careers, business and learning.

YouTube & Media→

Videos, interviews, explainers, sessions and stories from ADE.

Partnerships→

Build programs, experiences and shared opportunities with ADE.

Success Stories→

See the people, projects and progress behind real outcomes.

Careers→

Explore ways to help build the next version of ADE.

What’s New→

New launches, platform updates, programs and announcements.

Not sure where to start?Open finder →
Learn
ADE Learn
Choose the learning format that fits your goal, time and stage.
All Courses→

Browse every published ADE course, program and learning experience.

Career Programs→

Deeper programs designed to build career-ready capability and proof.

Work
ADE Work
Find opportunities where skills, projects and proof can move you forward.
All Opportunities→

Browse every open job, internship, freelance role and project on ADE Work.

Full-time Jobs→

Career opportunities for professionals ready to apply verified capability.

Showcase
ADE Showcase
Explore projects and portfolios that make practical capability visible.
All Showcase→

Browse public projects, portfolios, case work and evidence from the ADE community.

Projects→

Focused pieces of work showing the problem, approach, outcome and skills used.

Resources
ADE Resources
Useful tools, trusted recommendations and practical guidance for everyday work and growth.
Tools→

Useful day-to-day utilities for documents, careers, productivity and practical work.

Software & Services→

Curated software and services, including future affiliate-supported recommendations.

Business
ADE for Business
Hire, develop and understand talent through capability, evidence and opportunity.
Overview→

See how ADE connects talent, learning, evidence and opportunity for organizations.

Hire Talent→

Discover people through projects, skills, credentials and public evidence.

ExploreLearnWorkShowcaseResourcesBusiness
SQL for Data Analysis course
Data & Analytics • Beginner

SQL for Data Analysis

Learn to query relational data and turn business questions into reproducible analysis.

15 estimated hours6 modules12 lessonsGraded ADE certificate
ENROLLMENT
Start with one ADE identity

Sign in before enrollment so progress, graded assessments and credentials remain connected to you.

Sign in to enroll
CURRICULUM

Sequential learning structure

Each lesson unlocks only after the previous required step is completed. Module assessments are gates: a failed checkpoint or capstone keeps the following module locked until the pass mark is achieved.

01
Relational data and SELECT
Read relational tables and retrieve only the rows and columns needed.
Understand table grain and keysWrite SELECT statementsFilter and sort safely
Relational tables, grain and keys45 min
SELECT, WHERE and ORDER BY50 min
02
Aggregation and business metrics
Summarise transactional data into useful business measures.
ADE INDIVIDUAL PLANS
Free. Standard. Pro.

Start at $0, step up to Standard for higher usage, or unlock ADE Full Access with Pro.

Compare plans →
ADE

Learn. Build. Prove. Grow. A skills-to-opportunity ecosystem built around practical learning and trusted evidence.

PLATFORM
ExploreLearningShowcaseADE PassportPlans & Pricing
OPPORTUNITY
ADE WorkBusinessPartnersVerify credential
ACCOUNT
WorkspaceMy planSettingsNotificationsSecurity
ADE V2 beta review build • Subscription catalogue live • Payments disabled during testing
Short Courses→

Focused learning for a specific skill, tool or practical outcome.

Free Learning→

Open sessions and accessible learning experiences to start exploring.

Upcoming Workshops→

Live workshops, masterclasses and hands-on learning sessions.

Certifications→

Assessment-led routes that can lead to recognized ADE credentials.

Learning Paths→

Structured sequences that connect related skills into a clear progression.

Browse by subject, format and level.Open finder →
Internships→

Early-career opportunities to build experience, evidence and industry context.

Freelance & Contract→

Flexible client work, contract roles and independent assignments.

Projects & Gigs→

Short applied projects where practical skills matter more than job titles.

Remote Opportunities→

Roles and projects designed for remote or location-flexible work.

Entry-Level Opportunities→

Roles designed for emerging talent with strong evidence and potential.

Browse by role type, field and work mode.Open finder →
Portfolios→

Collections of selected work that show range, craft and professional identity.

Verified Work→

Projects with an active ADE verification record attached to the evidence.

Featured Work→

High-signal work surfaced for quality, evidence and practical relevance.

Student Work→

Projects and portfolios from learners building their first body of evidence.

Professional Work→

Public work from practicing professionals across the ADE ecosystem.

Browse by work type, field and evidence.Open finder →
Guides→

Practical ADE guides, checklists and templates for skills, projects, careers and business.

Tools for doing. Guidance for deciding.Explore resources →
Post Opportunities→

Publish jobs, internships, freelance work and project opportunities.

Train Your Team→

Build workforce capability through courses, workshops and custom learning.

Verify Skills→

Use evidence-aware assessment and verification to understand demonstrated capability.

Business Solutions→

Combine talent, learning and verification into a solution for your organization.

Partnerships→

Collaborate with ADE on programs, events, technology, community and talent initiatives.

Business Workspace→

Manage your organization, opportunities and applicants in the ADE workspace.

Build a stronger talent and capability system with ADE.Open workspace →
Use aggregate functions
Group at the correct level
Filter groups with HAVING
Aggregate functions and GROUP BY55 min
HAVING, CASE and conditional metrics55 min
03
Joining business data
Combine related tables without accidentally changing analytical grain.
Use inner and outer joinsChoose correct join keysDetect duplicate amplification
INNER and LEFT JOIN60 min
Protect analytical grain when joining55 min
04
Subqueries, CTEs and set logic
Break complex analysis into readable, testable query steps.
Use subqueries appropriatelyBuild readable CTEsCombine compatible result sets
Subqueries for focused logic55 min
Readable analysis with CTEs and set operations55 min
05
Window functions and data quality
Perform ranked, cumulative and comparative analysis while checking data quality.
Use common window functionsWork with dates and textBuild data quality checks
Window functions for ranking and comparison65 min
Dates, text and data quality checks55 min
06
SQL analysis capstone
Answer a realistic set of business questions with a documented SQL query pack.
Write reproducible analysisValidate query resultsCommunicate findings with evidence
Capstone brief: business query pack45 min
Validate and communicate SQL findings40 min
CERTIFICATE GRADING

Your result is not just “completed”.

Checkpoint scores and the reviewed capstone produce a weighted final result. The certificate displays both the grade and classification.

A+ · High Distinction95–100%
A · Distinction90–94%
B+ · High Merit85–89%
B · Merit80–84%
C+ · Credit75–79%
C · Pass70–74%
Below 70% is not eligible for the course certificate. A failed gated assessment must be passed before progression.
ADE PROOF

How learning becomes evidence

Learning progress is attached to your ADE identity
Assessment attempts retain scored or reviewed outcomes
Applied work contributes to the course result
The certificate records final score, grade and classification
Professional ADE Skill Verification remains a separate, stronger process
INSTRUCTORS

Instructor assignments will appear here when academic operations connects the course to faculty records.