Knowledge Assessment

Evaluate your database and SQL skills across different areas.

📋 Assessment Categories

SQL Fundamentals Assessment

Time: 10-15 minutes

Answer these questions to assess your SQL knowledge:

1. Basic Queries

   • Can you write a SELECT query with WHERE and ORDER BY?
   • Do you understand GROUP BY and aggregate functions?
   • Can you write INNER and LEFT joins?

2. Advanced Queries

   • Can you use CTEs (WITH clauses)?
   • Do you understand window functions?
   • Can you optimize query performance?

3. Data Modification

   • Do you know INSERT, UPDATE, DELETE syntax?
   • Can you handle transactions?
   • Do you understand constraints and foreign keys?

Your Level:

• Beginner (1-2 correct)
• Intermediate (3-4 correct)
• Advanced (5-6 correct)

---

Database Administration Assessment

Time: 10-15 minutes

1. PostgreSQL/MySQL Knowledge

   • Have you installed a database server?
   • Can you set up users and permissions?
   • Do you know backup procedures?

2. Performance & Optimization

   • Can you read query execution plans?
   • Do you understand indexing?
   • Have you tuned database configuration?

3. High Availability

   • Do you understand replication?
   • Have you set up backups?
   • Do you know about failover?

Your Level:

• Beginner (new to databases)
• Intermediate (hands-on experience)
• Advanced (production systems)

---

NoSQL & Caching Assessment

Time: 10-15 minutes

1. MongoDB/Document Databases

   • Do you know document model basics?
   • Can you write find() queries?
   • Do you understand embedding vs referencing?

2. Redis & In-Memory

   • Do you know data structures?
   • Have you used Redis?
   • Can you design caching strategies?

3. Scaling & Sharding

   • Do you understand horizontal scaling?
   • Have you worked with distributed data?
   • Do you know about CAP theorem?

Your Level:

• Beginner (theory only)
• Intermediate (some projects)
• Advanced (production scale)

---

Data Analysis Assessment

Time: 10-15 minutes

1. Analytical Queries

   • Can you write complex aggregations?
   • Do you use window functions?
   • Can you do cohort analysis?

2. Statistical Analysis

   • Do you calculate percentiles?
   • Can you detect outliers?
   • Do you understand correlation?

3. Dashboard Data

   • Have you prepared data for BI tools?
   • Do you know dimensional modeling?
   • Can you optimize analytical queries?

Your Level:

• Beginner (basic SQL)
• Intermediate (analytical queries)
• Advanced (complex analysis)

---

Data Engineering Assessment

Time: 10-15 minutes

1. Data Warehousing

   • Do you know star schema?
   • Can you design fact and dimension tables?
   • Do you understand slowly changing dimensions?

2. ETL/ELT

   • Have you built data pipelines?
   • Do you understand incremental loads?
   • Can you handle data quality?

3. Big Data & Scaling

   • Do you work with large datasets?
   • Have you designed partitioning?
   • Do you know cloud data services?

Your Level:

• Beginner (learning)
• Intermediate (some pipelines)
• Advanced (enterprise systems)

---

Business Intelligence Assessment

Time: 10-15 minutes

1. Metrics & KPIs

   • Can you define business metrics?
   • Do you calculate complex KPIs?
   • Do you version metrics?

2. Dimensional Modeling

   • Do you understand fact tables?
   • Can you design dimensions?
   • Do you know conformed dimensions?

3. Dashboards & Reporting

   • Have you designed dashboards?
   • Do you optimize BI queries?
   • Can you tell data stories?

Your Level:

• Beginner (learning BI)
• Intermediate (some dashboards)
• Advanced (strategic BI)

---

Database DevOps Assessment

Time: 10-15 minutes

1. CI/CD for Databases

   • Have you set up database CI/CD pipelines?
   • Do you use schema migration tools (Flyway, Liquibase)?
   • Can you implement zero-downtime migrations?

2. Infrastructure as Code

   • Do you manage databases with Terraform/Pulumi?
   • Can you provision cloud databases (RDS, Cloud SQL)?
   • Do you version control infrastructure?

3. Monitoring & Reliability

   • Have you set up database monitoring?
   • Do you configure automated backups?
   • Can you implement disaster recovery?

Your Level:

• Beginner (manual operations)
• Intermediate (some automation)
• Advanced (full GitOps workflow)

---

📊 Assessment Results

Based on your answers above:

Your Skill Profile

SQL Fundamentals:      ████░░░ (57%)
Database Admin:        ██░░░░░ (29%)
NoSQL & Caching:       ███░░░░ (43%)
Data Analysis:         █████░░ (71%)
Data Engineering:      ██░░░░░ (29%)
Business Intelligence: ███░░░░ (43%)
Database DevOps:       ██░░░░░ (29%)

Recommended Learning Path

Priority 1 (Start Here):

• If SQL < 50%: /browse-agent sql-fundamentals
• If Database Admin < 50%: /browse-agent postgresql-dba

Priority 2 (Next Steps):

• If Data Analysis < 50%: /browse-agent data-analyst
• If BI < 50%: /browse-agent bi-analyst

Priority 3 (Advanced):

• If Data Engineering < 50%: /browse-agent data-engineer
• For specific areas: Choose MongoDB, Redis agents

---

🎯 Self-Assessment Tips

1. Be honest about your actual skills
2. Focus on hands-on experience, not theory
3. Consider production use, not just learning projects
4. Update periodically as you progress

📝 Certification Path

After completing assessments:

1. Bronze Level - Complete any 2 agents
2. Silver Level - Complete 4 agents
3. Gold Level - Complete all 8 agents
4. Platinum - Build 3+ production projects

---

🚀 Next Steps

1. Take Assessment: Answer questions above
2. Review Results: See your skill profile
3. Choose Agent: Start with recommended path
4. Work Through Skills: Study each skill document
5. Try Projects: /projects for hands-on practice

Questions answered? You're ready to start learning!