data-analysis-sql
SQL for data analysis with exploratory analysis, advanced aggregations, statistical functions, outlier detection, and business insights. 50+ real-world analytics queries.
Découvrez les skills Contenu et médias, comparez leurs dépôts et consultez leurs instructions.
SQL for data analysis with exploratory analysis, advanced aggregations, statistical functions, outlier detection, and business insights. 50+ real-world analytics queries.
BI fundamentals with metric definition, KPI calculation, dimensional modeling, dashboard optimization, and data storytelling. 40+ metric examples and calculation patterns.
PostgreSQL administration and setup including installation, configuration, backup/recovery, replication, and high-availability. Learn production PostgreSQL operations.
Data warehouse design mastery with star schema, dimensional modeling, fact/dimension tables, slowly changing dimensions, and enterprise best practices. Complete schema examples included.
Master SQL fundamentals including SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP operations. Learn data types, WHERE clauses, ORDER BY, GROUP BY, and basic joins.
MongoDB fundamentals including document model, CRUD operations, querying, indexing, and aggregation framework for NoSQL database applications.
Build cloud-native microservices - service discovery, config server, API gateway, resilience patterns
Build production-ready REST APIs with Spring MVC - controllers, validation, exception handling, OpenAPI
Comprehensive guide to Spring Boot fundamentals - auto-configuration, starters, properties, and profiles
Master Spring Data JPA - repositories, queries, relationships, transactions, and performance
Build reactive applications - WebFlux, Mono/Flux, R2DBC, backpressure, reactive streams
Test Spring Boot applications - MockMvc, TestContainers, test slices, integration testing
Secure Spring Boot applications - authentication, authorization, OAuth2, JWT, CORS/CSRF protection
Identify, implement, and teach GoF design patterns
Apply and validate SOLID principles in object-oriented design
Design, evaluate, and document software architecture patterns
Detect code smells and apply safe refactoring techniques
Analyze and improve code quality, readability, and maintainability
Model business domains using DDD tactical and strategic patterns
Guide TDD workflow, design tests, and create mocking strategies
Prompt injection attack prevention and defense
Reasoning and Acting patterns for agentic LLM workflows
Prompt testing, metrics, and A/B testing frameworks
Reusable prompt templates for common tasks and optimization patterns
Le classement utilise les étoiles du dépôt GitHub indexé. Plusieurs skills peuvent partager ce nombre : ce n’est ni un nombre d’installations ni une note de qualité.