Developer Documentation
Comprehensive guides for cloud services, databases, and development best practices
Welcome to the Developer Documentation hub! Find everything you need to build scalable applications with modern cloud infrastructure and database technologies.
Documentation Sections
AWS for Developers
Complete AWS developer services guide with CLI references
SQL for Developers
Query optimization, indexing strategies, and database fundamentals
AWS Services
Master Amazon Web Services with comprehensive guides covering core infrastructure, databases, networking, and DevOps.
Core Services
IAM
Identity and access management, policies, roles, and users
EC2
Elastic Compute Cloud instances, types, and security groups
S3
Simple Storage Service, buckets, and storage classes
Lambda
Serverless functions, triggers, and concurrency
Database Services
DynamoDB
NoSQL database, tables, indexes, and streams
RDS
Relational Database Service for managed databases
Networking & API
Messaging
Containers
DevOps & Monitoring
CloudFormation
Infrastructure as Code templates
CodePipeline
CI/CD pipeline automation
CodeBuild
Build and test automation
CloudWatch
Monitoring, logging, and alerts
Secrets Manager
Secure secrets and credentials storage
SQL & Databases
Master SQL across PostgreSQL, MySQL, and SQL Server with performance optimization techniques.
SQL Fundamentals
SELECT Statements
Data retrieval, filtering, and sorting
JOINs
Combining data from multiple tables
Aggregations
GROUP BY, HAVING, and aggregate functions
Subqueries
Nested queries and correlated subqueries
CTEs
Common Table Expressions and recursive queries
Window Functions
Analytics and ranking functions
Data Modification
INSERT, UPDATE, DELETE, UPSERT operations
Performance & Optimization
Query Optimization
EXPLAIN plans and performance tuning
Indexing Strategies
B-Tree, Hash, GIN, GiST indexes
Anti-patterns
Common SQL mistakes to avoid
Database Platforms
PostgreSQL
PostgreSQL-specific features and extensions
MySQL
MySQL storage engines and optimization
SQL Server
T-SQL and SQL Server features
Database Design
Transactions & ACID
Isolation levels, locking, and concurrency
Database Design
Normalization, relationships, and schema patterns
Quick Start
Choose Your Path
Select based on your current project needs:
- Building on AWS? Start with AWS CLI Setup
- Optimizing queries? Jump to Query Optimization
- Learning SQL? Begin with SQL Fundamentals
Follow the Guides
Each section includes:
- Conceptual explanations with diagrams
- Code examples for multiple platforms
- CLI commands and best practices
- Common patterns and anti-patterns
Practice and Build
Apply what you learn to your projects with hands-on examples and real-world patterns.
Features
What's Included
- Multi-platform examples: PostgreSQL, MySQL, SQL Server, and AWS services
- Visual diagrams: Mermaid flowcharts and ER diagrams
- CLI references: Complete command references for AWS CLI and database tools
- Best practices: Security, performance, and architectural patterns
- Anti-patterns: Common mistakes and how to avoid them