📝 Topics Covered

1. 1. Public Apps in Shopify
   • 1.1 Distribution Channels
   • 1.2 OAuth 2.0 Flow
2. 2. Development Stores
   • Free developer sandboxes & testing environments
3. 3. The Shopify Developer Ecosystem
   • 3.1 Apps, 3.2 Themes (Liquid), and 3.3 Headless Commerce (Hydrogen)
4. 4. Scaffolding & Creating Apps
   • 4.1 Scaffolding Prerequisites
   • 4.2 What Shopify CLI Automates
5. 5. Resources & Access Control
6. 6. Working with Protected Customer Data
7. 7. Python Integration (Alternative Stack)

📝 Topics Covered

1. 1. GraphiQL for the Admin API
   • Overview, Schema Exploration & Prototyping
2. 2. Executing Queries on Your Shopify Store
   • 2.1 The GraphiQL Cloud App
   • 2.2 Local GraphiQL Instance via Shopify CLI
3. 3. GraphQL Queries Demystified
   • Basic, Standard, Named, and Parameterized Queries
4. 4. GraphQL Mutations
   • Legacy (input object) vs. Modern (direct arguments)
5. 5. Developer Pro Tips & Autocomplete Shortcuts

📝 Topics Covered

• 1. Accessing Shopify Backend Data via API
  • 1.1 Admin API
  • 1.2 Storefront API (GraphQL only)
• 2. REST vs. GraphQL in Shopify
  • 2.1 REST Admin API (Legacy)
  • 2.2 GraphQL Admin API (Recommended)
  • 2.3 API Rate Limits & Cost Systems
• 3. General Steps to Access Shopify Store Data
  • 3.1 App Distribution: Custom vs. Public Apps
  • 3.2 Working with Custom Apps (Single-Store Access)
• 4. Step-by-Step: Creating a Custom App & Getting API Credentials
• 5. Testing Your API Connection (GraphQL Example)

RSA vs ED25519

TL;DR:

• Use ED25519 (if supported)
• Unless you’re targeting legacy systems, prefer ed25519 — it’s more modern, secure, and faster.
• ED25519: Modern, compact, faster — recommended
• RSA: Widely compatible, older, heavier — use if needed for legacy support

📝 Topics Covered

1. 1. What is Database Partitioning?
2. 2. Why Partition Databases?
3. 3. Core Partitioning Methods
   • 3.1 Vertical Partitioning (Normalization)
   • 3.2 Horizontal Partitioning (Sharding)
4. 4. Sharding Routing Strategies
   • 4.1 Key-Based or Hash-Based Partitioning
   • 4.2 Range-Based Partitioning
   • 4.3 Directory-Based Partitioning
5. 5. Understanding Hashing
   • 5.1 Traditional Hashing vs. Consistent Hashing
   • 5.2 Consistent Hashing Mechanics

📝 Topics Covered

1. 1. Memory & Storage Systems
   • 1.1 Volatile Storage: RAM (SRAM vs. DRAM)
   • 1.2 Non-Volatile Storage: ROM, HDD, SSD
2. 2. Database Classifications
3. 3. Database Replication Strategies
   • 3.1 Synchronous vs. Asynchronous Replication
   • 3.2 Single-Master Replication
   • 3.3 Multi-Master Replication
4. 4. RAID (Redundant Array of Independent Disks)
   • 4.1 RAID 0 (Striping)
   • 4.2 RAID 1 (Mirroring)
   • 4.3 RAID 10 (1+0 - Striping + Mirroring)
   • 4.4 RAID 5 (Striping + Distributed Parity)
   • 4.5 RAID 6 (Striping + Double Distributed Parity)

📝 Topics Covered

1. 1. Performance vs. Scalability
2. 2. Key Performance Metrics
   • 2.1 Latency vs. Response Time
   • 2.2 Latency vs. Throughput
   • 2.3 Bandwidth vs. Throughput
3. 3. System Component Performance Indicators
4. 4. Understanding the CAP Theorem
   • 4.1 Consistency (C)
   • 4.2 Availability (A)
   • 4.3 Partition Tolerance (P)
5. 5. The CAP Theorem Trade-Offs
   • 5.1 CP Systems (Consistency + Partition Tolerance)
   • 5.2 AP Systems (Availability + Partition Tolerance)
   • 5.3 CA Systems (Consistency + Availability)
6. 6. Faults, Failures, and Fault Tolerance

📝 Topics Covered

1. 1. What is Scalability?
2. 2. Vertical Scaling (Scale Up)
3. 3. Horizontal Scaling (Scale Out)
4. 4. Load Balancing
   • 4.1 Load Balancing Routing Algorithms
   • 4.2 Sticky Sessions (Session Persistence)
5. 5. Caching Strategies
   • 5.1 Cache Invalidation & Writing Patterns
   • 5.2 Cache Eviction Policies
6. 6. System Asynchronism
   • 6.1 Message & Task Queues (Point-to-Point)
   • 6.2 Message Brokers (Publish-Subscribe)

📝 Topics Covered

1. 1. Introduction to System Design
2. 2. Client-Server Architecture
   • 2.1 Tiered Architectures
   • 2.2 Types of Clients
3. 3. Monoliths vs. Microservices
   • 3.1 Monolithic Architecture
   • 3.2 Microservices Architecture
4. 4. Remote Procedure Calls & gRPC
5. 5. Foundational Network Protocols
6. 6. Proxies: Forward & Reverse

📝 Topics Covered

1. 1. What is UML?
2. 2. Benefits of UML
3. 3. Core Types of UML Diagrams
   • 3.1 Structural Diagrams
   • 3.2 Behavioral Diagrams
   • 3.3 Interaction Diagrams
4. 4. Class Diagram
   • 4.1 Composition vs. Aggregation
   • 4.2 Generalization (Inheritance)
   • 4.3 Multiplicity
   • 4.4 Dependency
   • 4.5 Ancillary Structural Diagrams
5. 5. Use Case Diagram
   • 5.1 Extend vs. Include Relationships
6. 6. State Diagram
7. 7. Activity Diagram
   • 7.1 Core Components
   • 7.2 Synchronization (Fork & Join)
8. 8. Sequence Diagram
9. 9. UML vs. ERD