Agent skill

databases-sql

SQL database querying, optimization, and data management for analytics

View SKILL.md on GitHub Repository
Stars 1
Forks 0

Install this agent skill to your Project

npx add-skill https://github.com/pluginagentmarketplace/custom-plugin-data-analyst/tree/main/skills/databases-sql

SKILL.md

Databases & SQL Skill

Overview

Master SQL and database concepts essential for data analysts, from basic queries to advanced optimization and data warehousing.

Core Topics

SQL Fundamentals

  • SELECT, FROM, WHERE, ORDER BY
  • JOINs (INNER, LEFT, RIGHT, FULL)
  • GROUP BY and aggregate functions
  • Subqueries and CTEs

Advanced SQL

  • Window functions (ROW_NUMBER, RANK, LAG, LEAD)
  • Recursive queries
  • Query optimization and execution plans
  • Index strategies

Database Concepts

  • Relational database design principles
  • Normalization and denormalization
  • Data warehousing concepts (star schema, snowflake)
  • ETL processes

Popular Platforms

  • PostgreSQL
  • MySQL
  • SQL Server
  • BigQuery, Redshift, Snowflake

Learning Objectives

  • Write efficient SQL queries for data extraction
  • Understand database design and optimization
  • Work with cloud data warehouses
  • Implement ETL processes for analytics pipelines

Error Handling

Error Type Cause Recovery
Syntax error Invalid SQL Validate query syntax before execution
Timeout Long-running query Add indexes, optimize query
Connection failed Network/auth issue Retry with exponential backoff
Permission denied Access rights Request appropriate permissions
Deadlock Concurrent transactions Retry transaction

Related Skills

  • foundations (for data concepts)
  • programming (for SQL with Python/R)
  • advanced (for big data processing)

Recommended Agent Skills

Expand your agent's capabilities with these related and highly-rated skills.

pluginagentmarketplace/custom-plugin-data-analyst

business-intelligence

BI tools, dashboards, and enterprise analytics platforms

1 0
Explore
pluginagentmarketplace/custom-plugin-data-analyst

visualization

Data visualization design, tools, and storytelling for impactful analytics presentations

1 0
Explore
pluginagentmarketplace/custom-plugin-data-analyst

data-analytics-foundations

Core data analytics concepts, Excel/Google Sheets fundamentals, and data collection techniques

1 0
Explore
pluginagentmarketplace/custom-plugin-data-analyst

advanced-analytics

Advanced analytics including machine learning, predictive modeling, and big data techniques

1 0
Explore
pluginagentmarketplace/custom-plugin-data-analyst

statistics

Statistical analysis methods, hypothesis testing, and probability for data analytics

1 0
Explore
pluginagentmarketplace/custom-plugin-data-analyst

career-development

Data analyst career development, portfolio building, and professional growth strategies

1 0
Explore

Didn't find tool you were looking for?

Be as detailed as possible for better results