Skip to content

obsidian-mkdocs template

Learning MySQL

Initializing search

obsidian-mkdocs template

Notes
AWS
AWS
- API Gateway
  API Gateway
- AWS Serverless APIs
  AWS Serverless APIs
  - Learning AWS Serverless
  - 01 getting started
    01 getting started
    
    What is serverless?
    
    AWS Signup and First serverless API
    
    Why would I use AWS?
    
    Course Structure
  - 02 core serverless services
    02 core serverless services
    
    Overview over the Core Serverless Services
    
    The "Compare Yourself" app
  - 02 core serverless services 2
    02 core serverless services 2
    
    Overview over the Core Serverless Services
    
    The "Compare Yourself" app
  - 03 creating an API gateway and AWS lamda
    03 creating an API gateway and AWS lamda
    
    What is API Gateway
    
    General API Gateway features
    
    API-specific features and options
    
    Request-Response cycle
    
    Creating a new API
    
    What is AWS lamda?
  - 04 data storage with dynamodb
    04 data storage with dynamodb
    
    What is DynamoDB
    
    How DynamoDB organizes data
    
    Creating a table in DynamoDB
    
    Creating and scanning items
    
    Accessing DynamoDB from Lambda
    
    Scanning data in DynamoDB from lambda
    
    Deleting data in DynamoDB from lambda
    
    Mapping responses
  - 04 data storage with dynamodb 2
    04 data storage with dynamodb 2
    
    What is DynamoDB
    
    How DynamoDB organizes data
    
    Creating a table in DynamoDB
    
    Creating and scanning items
    
    Accessing DynamoDB from Lambda
    
    Scanning data in DynamoDB from lambda
    
    Deleting data in DynamoDB from lambda
    
    Mapping responses
  - 05 authenticating users with cognito and api gateway
    05 authenticating users with cognito and api gateway
    
    How to add authorization to API Gateway
    
    Retrieving users from custom authorizers
    
    Creating a cognito user pool
    
    Using Cognito in Apps
    
    Use Cognito to authorize endpoints
    
    What is Cognito
  - 06 hosting a serverless single page application
    06 hosting a serverless single page application
    
    What is S3
    
    Creating an S3 bucket
    
    Uploading the web app to S3
    
    Turning s3 into a static web server
    
    Setting up logging
    
    Optimizing content delivery with CloudFront
    
    Using a custom domain with route 53
  - 07 beyond the basics
    07 beyond the basics
    
    Documenting the API
    
    Other AWS triggers
    
    non-API (MPA) serverless app
    
    Serverless and security
    
    Better development and deployment process
    
    Serverless application model
    
    Testing serverless apps with localstack
    
    Other useful AWS services
- Amazon MQ
  Amazon MQ
  - Amazon MQ
- AppSync
  AppSync
  - AWS AppSync
- Athena
  Athena
- CICD
  CICD
  - CICD
  - Continuous Integration
- CLI
  CLI
- CloudFormation
  CloudFormation
  - CloudFormation
- CloudFront
  CloudFront
  - AWS CloudFront Hands On
  - AWS CloudFront
- CloudTrail
  CloudTrail
  - AWS CloudTrail
- CloudWatch
  CloudWatch
- Cognito
  Cognito
- DynamoDB
  DynamoDB
- EC2
  EC2
  - AWS EC2 Instance Metadata
  - EC2 Introduction
  - EC2 User Data
  - EC2 for Solutions Architects
  - Health Checks
  - Install Apache on EC2
  - Launching an EC2 Instance running Linux
  - AMI
    AMI
    
    AMI Pricing
    
    AMI Storage
    
    Cross Account AMI Copy
    
    EC2 AMI Hands On
    
    EC2 AMIs
  - Elastic LoadBalancer
    Elastic LoadBalancer
    
    Application Load Balancer (v2)
    
    Auto Scaling Group (ASG) For Solution Architects
    
    Auto Scaling Groups
    
    High Availability and Scalability
    
    Load Balancer stickiness
    
    Load Balancing
    
    Network Load Balancer (v2)
  - IP
    IP
    
    Elastic IP
    
    Private IP
    
    Private vs Public vs Elastic IP
    
    Public IP
  - Placement
    Placement
    
    EC2 Cluster Placement Strategy
    
    EC2 Partition Placement Strategy
    
    EC2 Placement Groups
    
    EC2 Spread Placement Strategy
  - SSH
    SSH
    
    EC2 SSH Instance Connect
    
    EC2 SSH Troubleshooting
    
    EC2 SSH Using Windows 10
    
    EC2 SSH Using Windows
    
    EC2 SSH from Linux or Mac
    
    SSH Overview
  - Security Group
    Security Group
    
    Introduction to Security Groups
    
    Security Groups Deep Dive
  - Storage
    Storage
    
    EFS - Elastic File System
    
    EFS Hands on
    
    GP2 (SSD)
    
    Hybrid Cloud for Storage
    
    IOI (SSD)
    
    SCI (HDD)
    
    STI (HDD)
    
    EBS
    EBS
    
    EBS Hands on
    
    EBS Migration
    
    EBS Operations
    
    EBS RAID Options
    
    EBS Snapshot
    
    EBS Volume Encryption
    
    EBS Volume Types
    
    What's an EBS volume?
    
    EBS vs Instance Store
  - Types
    Types
    
    EC2 Dedicated Hosts
    
    EC2 Dedicated Instances
    
    EC2 Instance Launch Types Hands On
    
    EC2 Instance Launch Types
    
    EC2 On Demand Instances
    
    EC2 Reserved Instances
    
    EC2 Spot Instances
- ECS
  ECS
- EMR
  EMR
  - Amazon Elastic MapReduce
- ElastiCache
  ElastiCache
  - ElastiCache for Solutions Architect
  - ElastiCache hands on
  - ElastiCache overview
  - Memcached
  - Redis
  - Pattern
    Pattern
    
    Lazy Loading Pattern
    
    Session Store Pattern
    
    Write through Pattern
- Elastic Beanstalk
  Elastic Beanstalk
- Elastic Transcoder
  Elastic Transcoder
  - AWS Elastic Transcoder
- ElasticSearch
  ElasticSearch
  - ElasticSearch for Solutions Architect
  - ElasticSearch
- Exam
  Exam
  - Solutions Architect Associate
    Solutions Architect Associate
    
    Exam Walkthrough and Signup
    
    Exam tips
    
    Get an extra 30 minutes on your AWS Exam - non native english speakers only
    
    Save 50% on your AWS Exam cost
    
    State of learning checkpoint
- Fundamentals
  Fundamentals
  - AWS Cheat sheet
  - AWS Region
  - AWS Regions and AZs
  - AWS Shared Responsibility Model
  - AWS Whitepapers
  - Availability Zone
  - Choosing the right database
  - Creating an AWS Account
  - High Availability
  - Horizontal scalability
  - Infrastructure as Code
  - Instantiating applications quickly
  - Introduction to Messaging
  - SQS vs SNS vs Kinesis
  - Serverless in AWS
  - Serverless
  - AWS Budget Setup
  - Vertical scalability
  - User cookies
  - Disaster Recovery
    Disaster Recovery
    
    Disaster Recovery All AWS Multi Region
    
    Disaster Recovery Backup and Restore
    
    Disaster Recovery Hot Site Multi Site Approach
    
    Disaster Recovery Pilot Light
    
    Disaster Recovery Warm Standby
    
    Disaster Recovery Tips
    
    Disaster Recovery
  - Encryption
    Encryption
    
    Client Side Encryption
    
    Encryption at rest
    
    Encryption in flight
    
    Encryption
  - Well Architected Framework
    Well Architected Framework
    
    More Architecture Examples
    
    Fifth Pillar: Cost Optimization
    
    Well Architected Framework - Operational Excellence
    
    Fourth Pillar - Performance Efficiency
    
    Third Pillar - Reliability
    
    Second Pillar - Security
    
    Well Architected Framework
    
    Well Architected Tool
- Glue
  Glue
  - AWS Glue
- IAM
  IAM
- KMS
  KMS
- Kinesis
  Kinesis
- Lambda
  Lambda
- Neptune
  Neptune
  - Neptune for Solutions Architect
  - Neptune
- OpsWorks
  OpsWorks
  - AWS OpsWorks
- Organizations
  Organizations
- RDS
  RDS
- Redshift
  Redshift
  - Redshift for Solutions Architect
  - Redshift
- Route 53
  Route 53
- S3
  S3
  - AWS S3 - Consistency model
  - AWS S3 Overview - Buckets
  - AWS S3 CORS
  - AWS S3 Objects
  - AWS S3 Websites
  - Amazon S3
  - S3 Access logs
  - S3 Cross region replication
  - S3 Default encryption
  - S3 For Solutions Architect
  - S3 MFA Delete
  - S3 Pre-signed URLs
  - S3 Security
  - S3 Versioning
  - S3 Versioning
  - Encryption
    Encryption
    
    Encryption in transit
    
    S3 Client Side Encryption
    
    S3 Encryption for objects
    
    SSE C
    
    SSE KMS
    
    SSE S3
  - Snowball
    Snowball
    
    Snowball Overview
    
    Snowball Hands On
  - Storage Gateway
    Storage Gateway
    
    AWS Storage Gateway
    
    File Gateway
    
    Storage Gateway Hands On
    
    Tape Gateway
    
    Volume Gateway
  - Tiers
    Tiers
    
    Amazon S3 Reduced Redundancy Storage (deprecated)
    
    Amazon Glacier
    
    S3 Intelligent Tiering (new)
    
    S3 Lifecycle rules
    
    S3 One Zone Infrequent Access (IA) Tier
    
    S3 Standard Tier (General Purpose)
    
    S3 Standard Infrequent Access (IA) Tier
    
    S3 Storage Tiers
- SDK
  SDK
  - AWS SDK Overview
- SNS
  SNS
- SQS
  SQS
- SSM
  SSM
  - Parameter Store
    Parameter Store
    
    AWS Parameter Store Hierarchy
    
    SSM Parameter Store Hands On Lambda
    
    SSM Parameter Store hands on CLI
    
    SSM Parameter Store
- SSO
  SSO
  - AWS Single Sign ON (SSO)
- STS
  STS
  - AWS STS - Security Token Service
  - Cross Account Access
- Simple Workflow Service
  Simple Workflow Service
  - Simple Workflow Service
- Solution Architecture Decisions
  Solution Architecture Decisions
- Step Functions
  Step Functions
  - AWS Step Functions
  - Step functions & SWF
- Trusted Advisor
  Trusted Advisor
  - Trusted Advisor
- VPC
  VPC
- WorkSpaces
  WorkSpaces
  - AWS WorkSpaces
- Aws lambda and the serverless framework
  Aws lambda and the serverless framework
  - AWS Lambda and the Serverless Framework
  - 01 getting started
    01 getting started
    
    AWS Lambda Overview
    
    AWS Lambda Console
  - 02 aws lambda and serverless
    02 aws lambda and serverless
    
    The Serverless Framwork
    
    Deploying Hello World Function Using Serverless
    
    Running the function from the CLI
    
    Updating the function from the CLI
    
    Fetching function logs from the CLI
    
    Removing the funciton
    
    Section summary
  - 03 aws lambda and the serverless in depth
    03 aws lambda and the serverless in depth
    
    AWS Functions Timeout and Memory
    
    IAM Permissions for Lambda Functions
    
    Environment Variables in AWS Lambda
    
    VPC for lambda functions
    
    AWS Lambda Pricing
  - 04 real world example s3 thumbnails
    04 real world example s3 thumbnails
    
    Overview of S3 Thumbnail Generator Service
    
    Thumbnail service implementation
    
    Ideas to make our service better
  - 05 real world example rest api
    05 real world example rest api
    
    Overview of the REST API service
    
    Building the REST API
    
    Deploying the REST API
    
    Testing the REST API
    
    REST API next step ideas
  - 06 real world example aws automation ec2 start stop
    06 real world example aws automation ec2 start stop
    
    Overview of EC2 start & stop service
    
    Deploying the EC2 start and stop lambda functions
    
    Next steps and ideas
- Developer associate
  Developer associate
  - Learning AWS Certified Developer Associate Course
  - 02 getting started with aws
    02 getting started with aws
    
    AWS Cloud Overview - Regions & AZ
  - 03 iam and aws cli
    03 iam and aws cli
    
    IAM Policies Hands On
    
    IAM MFA overview
    
    AWS Access keys, CLI and SDK
    
    AWS Setup
    
    AWS CLI Hands on
    
    IAM Roles for Services
    
    IAM Roles Hands On
    
    IAM Summary
    
    AWS CloudShell
  - 04 ec2 fundamentals
    04 ec2 fundamentals
    
    AWS Budget Setup
    
    EC2 Basics
    
    Create an EC2 instance with EC2 user data to have a webiste hands on
    
    Security Groups & Classic Ports Overview
    
    Security Groups Hands On
    
    SSH Overview
    
    SSH troubleshooting
    
    EC2 Instance Connect
    
    EC2 Instance Roles Demo
    
    EC2 Instance Launch Types
    
    EC2 Instance Types Overview
  - 05 ec2 instance storage
    05 ec2 instance storage
    
    EBS Hands On
    
    EBS Snapsots
    
    EBS Snapshots hands on
    
    AMI Overview
    
    AMI Hands on
    
    EBS Volume Types
    
    EBS Multi-Attach - io1/io2 family
    
    EFS hands on
    
    EBS vs EFS
    
    EBS Overview
    
    EC2 Instance Store
    
    EFS Overview (Elastic File System)
    
    Img
    Img
    
    High Availability and Scalability
  - 06 elb asg
    06 elb asg
    
    Scalability & High Availability
    
    Elastic Load Balancing (ELB) Overview
    
    Classic Load Balancers (v1)
    
    Application Load Balancer (v2)
    
    Network Load Balancer (NLB)
    
    Elastic Load Balancer - Sticky Sessions
    
    Elastic Load Balancer - Cross Zone Load Balancing
    
    Elastic Load Balancer - SSL Certificates
    
    Elastic Load Balancer - Connection Draining
    
    Auto Scaling Groups Overview
    
    Auto Scaling Groups - Scaling Policies
  - 07 rds aurora elasticache
    07 rds aurora elasticache
    
    AWS RDS Overview
    
    RDS Read Replicas vs Multi AZ
    
    Amazon RDS Hands On
    
    RDS Encryption & Security
    
    Amazon Aurora
    
    Aurora Hands On
    
    Amazon ElastiCache Overview
    
    ElastiCache Hands On
    
    ElastiCache Strategies
    
    ElastiCache Redis Cluster Modes
  - 08 route 53
    08 route 53
    
    What is DNS?
    
    Route 53 Overview
    
    Registering a domain
    
    Creating our first records
    
    EC2 Setup
    
    Route 53 - Records TTL (Time to Live)
    
    Route 53 - CNAME vs Alias
    
    Route 53 - Health Checks
    
    Health Checks Hands On
    
    Route 53 - Routing Policies - Geoproximity
    
    Route 53 - Traffic Flow
    
    Route 53 - 3rd Party Domains
  - 09 vpc fundamentals
    09 vpc fundamentals
    
    VPC Fundamentals - Section Introduction
    
    VPC, Subnets, IGW and NAT
    
    Network ACL, Security Groups
    
    VPC Peering
    
    VPC CheatSheet
    
    Three Tier Architecture
  - 10 amazon s3 introduction
    10 amazon s3 introduction
    
    Section Introduction
    
    S3 Buckets and Objects
    
    S3 Buckets and Objects hands on
    
    Amazon S3 - Versioning
    
    AWS S3 Versioning
    
    Amazon S3 - Encryption
    
    S3 Encryption Hands On
    
    S3 Security & Bucket Policies
    
    S3 Bucket Policies Hands On
    
    S3 Websites
    
    S3 CORS
    
    S3 CORS Hands On
    
    Amazon S3 - Consistency Model
  - 11 aws cli sdk iam roles policies
    11 aws cli sdk iam roles policies
    
    IAM Roles and Policies Hands On
    
    AWS Policy Simulator
    
    AWS CLI Dry Runs
    
    AWS CLI STS Decode Errors
    
    AWS EC2 Instance Metadata
    
    AWS CLI Profiles
    
    AWS CLI with MFA
    
    AWS SDK Overview
    
    Exponential Backoff & Service Limit Increase
    
    AWS Credentials Provider & Chain
    
    Signing AWS API requests
  - 12 advanced s3 athena
    12 advanced s3 athena
    
    S3 MFA Delete
    
    S3 MFA Delete Hands On
    
    S3 Default Encryption vs Bucket Policies
    
    S3 Access Logs
    
    S3 Access Logs Hands On
    
    S3 Replication (CRR & SRR)
    
    S3 Replication Hands On
    
    S3 Pre-signed URLs
    
    S3 Pre-signed URLs hands on
    
    S3 Storage Classess
    
    S3 Storage Classes Hands On
    
    S3 Lifecycle Rules
    
    S3 Lifecycle Rules Hands On
    
    S3 Performance
    
    S3 & Glacier Select
    
    S3 Event Notifications
    
    S3 Event Notificaitons Hands On
    
    Athena Overview
    
    Athena Hands On
  - 13 cloudfront
    13 cloudfront
    
    CloudFront Hands On
    
    CloudFront Caching & Caching Invalidations
    
    CloudFront Caching And Invalidations Hands On
    
    CloudFront Security
    
    CloudFront Signed URL / Cookies
    
    CloudFront Signed URL - Key Groups + Hands On
    
    CloudFront Advanced Concepts
    
    AWS CloudFront
  - 14 ecs ecr fargate docker in aws
    14 ecs ecr fargate docker in aws
    
    Dock Introduction
    
    Amazon ECS
    
    ECS Cluster - Hands On
    
    Creating ECS Service - Hands On
    
    ECS Service Auto Scaling
    
    ECS Rolling Updates
    
    ECS Solutions Architectures
    
    Amazon ECS - Task Definitions
    
    Task Definitions - Hands On
    
    ECS Task Placements
    
    Amazon ECR
    
    Amazon ECR
    
    Amazon EKS Overview
  - 15 aws elastic beanstalk
    15 aws elastic beanstalk
    
    Elastic Beanstalk Overview
    
    Beanstalk First Environment Hands On
    
    Creating a second environment
    
    Elastic Beanstalk Deployment Modes
    
    Elastic Beanstalk CLI
    
    Beanstalk lifecycle policy
    
    Elastic Beanstalk Extensions
    
    Beanstalk & CloudFormation
    
    Elastic Beanstalk Cloning
    
    Beanstalk Migrations
    
    Beanstalk with Docker
    
    Beanstalk Advanced Concepts
  - 16 aws cicd
    16 aws cicd
    
    CICD - Introduction
    
    CodeCommit Hands On Part 1
    
    CodeCommit Hands On Part 2
    
    CodePipeline Hands On
    
    CodeBuild Hands On Part 1
    
    CodeBuild Hands On Part 2
    
    CodeDeploy Hands On
    
    CodeDeploy for EC2 and ASG
    
    CodeStar Overview
    
    CodeStar Hands On
    
    CodeArtifact Overview
    
    CodeGuru Overview
    
    CodeBuild Overview
    
    CodeCommit Overview
    
    CodeDeploy Overview
    
    CodePipeline Overview
  - 17 cloudformation
    17 cloudformation
    
    CloudFormation Overview
    
    CloudFormation Create Stack Hands On
    
    CloudFormation Update and Delete Stack Hands On
    
    CloudFormation Resources
    
    CloudFormation Parameters
    
    CloudFormation Mappings
    
    CloudFormation Outputs
    
    CloudFormation Conditions
    
    CloudFormation Intrinsic Functions
    
    CloudFormation Rollbacks
    
    CloudFormation ChangeSets, Nested Stacks, StackSet
    
    CloudFormation Drift
  - 18 monitoring audit cloudwatch xray cloudtrail
    18 monitoring audit cloudwatch xray cloudtrail
    
    Monitoring Overview in AWS
    
    CloudWatch Metrics
    
    CloudWatch Custom Metrics
    
    CloudWatch Logs
    
    CloudWatch Logs Hands On
    
    CloudWatch Agent & CloudWatch Logs Agent
    
    CloudWatch Logs Metric Filters
    
    CloudWatch Alarms
    
    CloudWatch Alarms Hands On
    
    CloudWatch Events
    
    Amazon EventBridge
    
    Amazon EventBridge Hands On
    
    X-Ray Hands On
    
    X-Ray Instrumentation and Concepts
    
    X-Ray Sampling Rules
    
    X-Ray APIs
    
    X-Ray with Beanstalk
    
    X-Ray and ECS
    
    CloudTrail Hands On
    
    CloudTrail vs CloudWatch vs X-Ray
    
    X-Ray Overview
    
    CloudTrail
  - 19 aws integration messaging sqs sns kinesis
    19 aws integration messaging sqs sns kinesis
    
    Introduction to Messaging
    
    Amazon SQS Standard Queues Overview
    
    SQS Standard Queue Hands On
    
    SQS Queue Access Policy
    
    SQS Message Visibility Timeout
    
    SQS - Dead Letter Queues
    
    SQS - Delay Queue
    
    SQS - Certified Developer Concepts
    
    Amazon SQS - FIFO Queue
    
    SQS FIFO Queues Advanced
    
    Amazon SNS
    
    SNS + SQS: Fan Out
    
    SNS Hands On
    
    Kinesis Overview
    
    Kinesis Data Streams
    
    Kinesis Producers
    
    Kinesis Data Streams Consumers
    
    Kinesis Data Streams Hands On
    
    Kinesis Client Library (KCL)
    
    Kinesis Operations
    
    Kinesis Data Firehose
    
    Kinesis Data Firehose Hands On
    
    Kinesis Data Analytics
    
    Ordering data into Kinesis
  - 20 aws serverless lambda
    20 aws serverless lambda
    
    Serverless introduction
    
    AWS Lambda Overview
    
    AWS Lambda - First Hands On
    
    Lambda - Synchronous Invocations
    
    Lambda Synchronous Invocations Hands On
    
    Lambda Integration with ALB
    
    Lambda & Application Load Balancer Hands On
    
    Lambda@Edge Overview
    
    Lambda Asynchronous Invocations & DLQ
    
    Lambda Asynchronous Invocations Hands On
    
    Lambda & CloudWatch Events / EventBridge
    
    Lambda & CloudWatch Events / EventBridge Hands On
    
    Lambda & S3 Event Notifications
    
    Lambda & S3 Event Notifications - Hands On
    
    Lambda Event Source Mapping
    
    Lambda Event Source Mapping Hands On
    
    Lambda - Destinations
    
    Lambda Destinations Hands On
    
    Lambda Permissions - IAM Roles & Resources Policies
    
    Lambda Permissions - IAM Roles & Resource Policies - Hands On
    
    Lambda Environment Variables
    
    Lambda Environment Variables Hands On
    
    Lambda Monitoring & X-Ray Tracing
    
    Lambda Monitoring & X-Ray Tracing Hands On
    
    Lambda in VPC
    
    Lambda in VPC Hands On
    
    Lambda Function Performance
    
    Lambda Function Performance Hands On
    
    Lambda Concurrency
    
    Lambda Concurrency Hands On
    
    Lambda External Dependencies
    
    Lambda External Dependencies Hands On
    
    Lambda and CloudFormation
    
    Lambda and CloudFormation Hands On
    
    Lambda Layers
    
    Lambda Layers Hands On
    
    Lambda Container Images
    
    Lambda Versions and Aliases
    
    Lambda Versions and Aliases Hands On
    
    Lambda & CodeDeploy
    
    Lambda Limits
    
    Lambda Best Practices
  - 21 aws serverless dynamodb
    21 aws serverless dynamodb
    
    DynamoDB Overview
    
    DynamoDB Basics - Hands On
    
    DynamoDB - Write Capacity Units & Read Capacity Units - Throughput
    
    DynamoDB WCU & RCU - Hands On
    
    DynamoDB - Basic APIs
    
    DynamoDB Indexes (GSI + LSI)
    
    DynamoDB Indexes (GSI + LSI) - Hands On
    
    DynamoDB - PartiQL
    
    DynamoDB - Optimistic Locking
    
    DynamoDB Accelerator (DAX)
    
    DynamoDB DAX - Hands On
    
    DynamoDB Streams Hands On
    
    DynamoDB - Time To Live (TTL)
    
    DynamoDB - Good to Know
    
    DynamoDB Transactions
    
    DynamoDB as Session State Cache
    
    DynamoDB Write Sharding
    
    DynamoDB Conditional Writes, Concurrent Writes & Atomic Writes
    
    DynamoDB - Patterns with S3
    
    DynamoDB Operations
    
    DynamoDB - Security & Other Features
    
    DynamoDB Streams
Architecture
Architecture
- Service Oriented Architecture (SOA)
  Service Oriented Architecture (SOA)
Business
Business
- Idea generation
  Idea generation
  - Idea Generation
  - 01 jumpstart strategies
    01 jumpstart strategies
    
    Problem-based business ideas
    
    Wouldn't it be great if
    
    Imagine the future
    
    Idea List Builder
  - 02 laying the groundwork
    02 laying the groundwork
    
    The idea equation
    
    Reverse imagination
    
    Areas to isolate and target
    
    Cater to power users
    
    5 types of innovation
    
    Disintermediation
  - 03 making it fit
    03 making it fit
    
    The Fit Quadrant: Hobbies and Passions
    
    The Fit Quadrant: Skills and Experience
    
    Activity: Hobbies, Passions, Skills & Experience
    
    Reposition Good / Fast / Cheap
    
    Strategy: Adding technology to an offline industry
    
    Activity: List out your goals
    
    The 3 Business types: pick yours
    
    Make it eco-friendly
    
    How good does my idea have to be?
    
    Strategy: The Fit generator
    
    The Eureka Myth
  - 04 ways of coming up with ideas
    04 ways of coming up with ideas
    
    Essential reading for those focusing on startups
    
    Strategy: Bloated Margins
    
    Strategy: Trends in outsourcing
    
    Strategy: Robin Hooding
    
    Strategy: Good idea, bad timing
    
    Strategy: Information Asymmetry
    
    Strategy: Hobby Lobbyist
    
    Strategy: The Enabler
    
    Strategy: Molding a user
    
    Strategy: Economies of Service
    
    Strategy: Sloppy Duct Tape
    
    Strategy: Privacy and the blind eye
    
    Strategy: Spotting market inefficiencies
    
    Strategy: Vertical Integration
    
    Strategy: One Step Strategy
  - 05 business models
    05 business models
    
    A Comprehensive list of business models and who uses them
    
    SaaS: Software as a Service
    
    Subscriptions & Memberships
    
    Pay what you want
    
    The sharing economy
    
    Marketplaces
    
    On demand
    
    Currated boxes
    
    Direct to Consumer
    
    Crowdsourced catalogs and inventory
  - 06 evaluate and test
    06 evaluate and test
    
    Matching Fit
    
    Pain to Payment
    
    Sustainability
    
    Path to validation
    
    Unfair advantages
  - 07 idea advice commentary
    07 idea advice commentary
    
    The value of ideas
    
    Red oceans, blue oceans
    
    Idea frameworks & unreasonable people
    
    West coast, east coast
    
    Avoid threshold ideas
Clean Code
Clean Code
- 3 Rules of TDD
- Clean architecture
- Kent Beck's game
- TDD example
- Uncle Bob Clean Code Checklist Architecture
- Uncle Bob Clean Code Checklist Comments, Naming
- Uncle Bob Clean Code Checklist Functions
- Uncle Bob Clean Code Checklist Rules
- Uncle Bob Clean Code Checklist Test Driven Development
- Uncle Bob's clean code checklist
- Design Pattern
  Design Pattern
- Design Smell
  Design Smell
- Refactoring
  Refactoring
- SOLID
  SOLID
  - SOLID Principles
  - SOLID architecture and design
  - Software Design
  - Dependency Inversion Principle
    Dependency Inversion Principle
    
    Constructor Injection
    
    Data Centric Model
    
    Dependency Injection Techniques
    
    Dependency Injection
    
    Dependency Inversion Principle Common Smells and Violations
    
    Dependency Inversion Principle Demo
    
    Dependency Inversion Principle Refactorings Dependency Injection
    
    Dependency Inversion Principle
    
    Dependency Inversion Rules
    
    Dependency Investion Principle Architectural implications
    
    Dependency
    
    Enlarged Domain Centric Model
    
    Inversion Of Control (IoC)
    
    IoC Container
    
    Method injection
    
    Property Injection
    
    Pure Dependency Injection
  - Interface Segregation Principle
    Interface Segregation Principle
    
    Interface Segregation Principle Common smells and Related Design Patterns
    
    Demo of the problem
    
    Interface Segregation Principle Refactorings
    
    Interface Segregation Principle
  - Liskov Substitution Principle
    Liskov Substitution Principle
    
    Contracts
    
    Covariance
    
    Liskov Substitution Principle Demo
    
    Liskov Substitution Principle Rules
    
    Liskov Substitution Principle Violations
    
    Liskov Substitution Principle
    
    Liskov Substitution Princple Common Smells
  - Metaprinciples
    Metaprinciples
    
    Command Query Separation Principle
    
    DRY - Don't repeat yourself
    
    Duplicate logic in multiple locations
    
    Encapsulation
    
    General principles building APIs
    
    KISS - Keep it simple, stupid
    
    Law of Demeter
    
    Magic value (number, string, etc)
    
    Open Closed Principle vs YAGNI
    
    Principle of least astonishment
    
    Reused Abstraction Principle
    
    SOLID vs YAGNI
    
    SoC - Separation Of Concerns
    
    Simplicity
    
    Single Responsiblility Principle vs Interface Segregation Principle
    
    YAGNI You ain't gonna need it
  - Open Closed Principle
    Open Closed Principle
    
    Common smells of OCP violations
    
    Demo of the problem
    
    Open Closed Principle Refactorings
    
    Open Closed Principle Related Patterns
    
    Open Closed Principle
    
    Open Closed Princple Rules
    
    Protected Variation Pattern
  - Single Responsibility Principle
    Single Responsibility Principle
    
    Demo of the problem
    
    Single Responsibility Principle Refactoring
    
    Conclusion
    
    More examples of SRP violations
    
    SRP Definition. Problem Statement
    
    SRP Related patterns
Data Science
Data Science
- Recapping data science
- 01 introduction
  01 introduction
  - Installing anaconda
- 02 statistics and probability refresher
  02 statistics and probability refresher
- 03 predictive models
  03 predictive models
- 04 machine learning with python
  04 machine learning with python
- 05 recommender systems
  05 recommender systems
  - User-based collaborative filtering
  - Item-Based Collaborative Filtering
- 06 more data mining and machine learning techniques
  06 more data mining and machine learning techniques
- 07 dealing with real world data
  07 dealing with real world data
- 08 apache spark machine learning on big data
  08 apache spark machine learning on big data
- 09 experimental design ml in real world
  09 experimental design ml in real world
- 10 deep learning and neural networks
  10 deep learning and neural networks
Data Structures And Algorithms
Data Structures And Algorithms
- Index
- Big O Algorithm Complexity
- 01 introduction
  01 introduction
- 02 recursion
  02 recursion
- 03 algorithm runtime analysis
  03 algorithm runtime analysis
- 04 arrays
  04 arrays
- 05 linked lists
  05 linked lists
- 06 stack
  06 stack
- 07 queue
  07 queue
- 08 binary tree
  08 binary tree
- 09 binary search tree
  09 binary search tree
  - What is a binary search tree
  - Binary search tree operations
- 10 AVL tree
  10 AVL tree
  - What is an AVL tree
  - AVL implementation
- 11 binary heap
  11 binary heap
  - What is a binary heap
  - Binary heap operations
- 12 trie
  12 trie
  - What is a Trie?
  - Implementation of Trie
- 13 hashing
  13 hashing
  - What is Hashing
- 14 sorting
  14 sorting
- 15 graphs
  15 graphs
- 16 magic framework
  16 magic framework
  - What is a Magic Framework?
- 17 greedy algorithm
  17 greedy algorithm
- 18 divide and conquer
  18 divide and conquer
- 19 dynamic programming
  19 dynamic programming
Databases
Databases
- MariaDB
  MariaDB
  - JSONOBJECTAGG() alternative in MariaDB
- MySQL
  MySQL
- PostgreSQL
  PostgreSQL
Docker & Kubernetes
Docker & Kubernetes
- Learning Docker
- Delete docker images & clear up space
- Disable buildkit while building images
- Docker command without sudo
- ERR NETWORK CHANGED chrome
- Kubernetes
- Kill all instances
- 01 intoduction
  01 intoduction
- 02 manipulating containers with docker client
  02 manipulating containers with docker client
- 03 building custom images with docker server
  03 building custom images with docker server
- 04 making real projects with docker
  04 making real projects with docker
- 05 docker compose with multiple local containers
  05 docker compose with multiple local containers
- 06 creating a production grade workflow
  06 creating a production grade workflow
- 07 ci and deployments with aws
  07 ci and deployments with aws
- 08 building a multicontainer application
  08 building a multicontainer application
- 09 dockerizing multiple services
  09 dockerizing multiple services
- 10 CI integration workflow for multiple images
  10 CI integration workflow for multiple images
- 11 multi container deployments to AWS
  11 multi container deployments to AWS
- 12 kubernetes
  12 kubernetes
- 13 maintaining sets of containers with deployments
  13 maintaining sets of containers with deployments
- 14 a multi container app with kubernetes
  14 a multi container app with kubernetes
- 15 handling traffic with ingress controllers
  15 handling traffic with ingress controllers
- 16 kubernetes production deployment
  16 kubernetes production deployment
- 17 HTTPS with kubernetes
  17 HTTPS with kubernetes
- 18 kubernetes cleanup
  18 kubernetes cleanup
  - Google Cloud cleanup
  - Local Environment Cleanup
Elixir
Elixir
Frontend
Frontend
- React
  React
  - Setting up for React development
Git
Git
Golang
Golang
GraphQL
GraphQL
Graphics
Graphics
- Unity
  Unity
  - 2D
    2D
    
    2D graphics with Unity
    
    01 introduction and setup
    01 introduction and setup
    
    Download Unity and Visual Studio
    
    Your first code
    
    Notes for mac users
    
    02 number wizard
    02 number wizard
    
    Game description
    
    Print To Console With Debug.Log
    
    Introducting variables
    
    Respond to player input
    
    Using if, else if, else
    
    Calculate guess variable
    
    Functions and encapsulating
    
    03 text101
    03 text101
    
    Game design
    
    Creating sprites in Unity
    
    UI canvas & text
    
    Update text component
    
    Game states
    
    Scriptable objects
    
    State Story Implementation
    
    Creating an array
    
    Manage states
    
    Game State Story Design
    
    Organize state files
    
    Text Mest Pro and Polish
    
    For loop
    
    Publish game via WebGL
Javascript
Javascript
- Bind click to document
Linux
Linux
- Enable numlock on startup
- Get current linux version
- IPTables
- Increase Battery Life
- Increase swap
- Learning cUrl
- tmux cheatsheet
- `xterm-termite`: unknown terminal type error fix
- Archlinux
  Archlinux
- Dolphin
  Dolphin
  - Fix mismatched background in Dolphin
- Mint
  Mint
  - Post Installation for Linux Mint
- Networking
  Networking
  - ERR NETWORK CHANGED
- Scripts
  Scripts
  - Pull script
- Xen Server
  Xen Server
  - Add new VM to Xen Server
OS X
OS X
- Fresh install mac os
- Patch PHPStorm to to use OSX case sensitive file system
PHP
PHP
- Template IFs in string
- Laravel
  Laravel
  - PHPUnit and faker feature test escapes
  - Storage mocking on older laravel versions
- Wordpress
  Wordpress
  - Adding a custom field in Ninja Forms 3
Resources and tools
Resources and tools
Rust
Rust
Terms
Terms
- Stale data
Testing
Testing
- Test Layers
Tools
Tools
- Brandmark Logo Maker
- Chrome
  Chrome
  - Chrome save pinned tabs
- Home
  Home
  - MiTemperature2
- Keyboard
  Keyboard
  - Colemak
- Microservices
  Microservices
  - Tilt
- Monitoring
  Monitoring
  - Prometheus
    Prometheus
    
    MQTTGateway for Prometheus
- Screenshot
  Screenshot
  - Shutter
- Testing
  Testing
  - Httpie
  - Postman
Vim
Vim
- Configuring VIM as IDE
- Vim motions
Windows
Windows
- Backup iOS devices from iTunes on Windows

Learning MySQL¶

Sources:

mysqltutorial.org
https://medium.com/@avishwakarma/mysql-scaling-and-how-to-do-it-d7f5b8dbd5b9

Previous JSONOBJECTAGG() alternative in MariaDB

Next Export all databases into separate .gz files

Made with Material for MkDocs