query-optimization
SQL query optimization and performance tuning
Découvrez les skills Bases de données, comparez leurs dépôts et consultez leurs instructions.
SQL query optimization and performance tuning
Database schema migrations and version control
Redis data structures and commands including strings, lists, hashes, sets, sorted sets, streams, and transactions for high-performance caching and real-time applications.
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
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é.