Backend Development Roadmap – SQL, Python, APIs, Docker, Kubernetes, Linux, Git & More
00:00:00 - Introduction
00:00:54 - Installing PostgreSQL on Windows
00:03:09 - Setting Up psql Shell and Logging In
00:04:43 - Introduction to pgAdmin GUI
00:05:44 - Basic PostgreSQL Shell Commands (Databases, Tables)
00:06:22 - Creating Databases and Tables in SQL
00:09:08 - Creating a Todos Database and Table
00:12:00 - Inserting Data into Tables
00:14:11 - Updating Data in Tables
00:15:43 - Selecting and Filtering Data (WHERE Clause)
00:18:06 - Deleting Data from Tables
00:19:11 - Using ILIKE Operator for Case-Insensitive Searches
00:20:15 - Grouping Data with GROUP BY and Aggregate Functions (COUNT, SUM, AVG)
00:23:26 - Sorting Data with ORDER BY
00:24:31 - Limiting Results with LIMIT
00:25:23 - Handling NULL Values with COALESCE
00:26:31 - Conditional Logic with CASE
00:28:26 - Using Subqueries
00:29:29 - Common Table Expressions (CTE)
00:33:00 - Using Transactions (BEGIN, ROLLBACK, COMMIT)
00:35:43 - One-to-Many Relationships with Joins
00:42:12 - Many-to-Many Relationships with Junction Tables
00:47:04 - Installing Python and PIP
00:47:37 - Installing VS Code and Python Extension
00:48:37 - Setting Up a Python Project in VS Code
00:50:35 - Basic Python: Printing and Running Scripts
00:52:26 - Python Extensions and Themes in VS Code
00:52:54 - Python Variables and Data Types
00:54:12 - Python Lists and Operations
00:55:59 - Python Dictionaries and Key-Value Pairs
00:58:00 - Python Loops (For, While)
01:00:45 - Python If-Else Statements
01:01:56 - Python Try-Except for Error Handling
01:03:02 - String Formatting in Python
01:03:37 - Python Functions and Parameters
01:05:21 - Global Variables in Functions
01:07:20 - Variable Arguments (*args, **kwargs)
01:10:04 - Concurrency and Parallelism (Threading, Multiprocessing)
01:13:28 - Measuring Execution Time with Threading
01:17:52 - Multiprocessing for Parallel Execution
01:19:16 - Sharing State with Mutexes in Threading
01:24:25 - Using Threading for Background Tasks in APIs
01:25:32 - Installing Postman for API Testing
01:26:33 - Creating Collections in Postman
01:27:00 - Networking Basics: Ports and DNS
01:28:51 - Building a REST API with Flask and PostgreSQL
01:32:29 - Connecting to PostgreSQL in Flask
01:35:47 - Error Handling in API Routes
01:37:38 - Creating API Routes (GET, POST, DELETE, PATCH)
01:42:01 - Preventing SQL Injection in Queries
01:49:57 - Updating Entities with PATCH
01:53:04 - Background Processing with Threading in APIs
01:58:50 - Dockerizing the Flask API
02:02:04 - Pushing Docker Images to Docker Hub
02:09:49 - Saving and Loading Docker Images Offline
02:10:59 - Using Docker Compose for Multi-Container Apps
02:14:59 - User Authentication: Register and Login with Hashing
02:18:01 - JWT Tokens for Authentication
02:23:04 - Protecting Routes with JWT Middleware
02:23:30 - Role-Based Access (Admin vs Guest)
02:37:53 - Basic Book Management API Routes (CRUD)
02:43:56 - Enforcing Admin-Only Routes
02:46:54 - Attaching Books to Users (Relationships)
02:58:16 - Admin Routes for User-Book Management
03:03:23 - Permission Checks for Book Access
03:08:23 - Error Handling in Production vs Development
03:10:31 - Dockerizing for Production Optimization
03:12:59 - Kubernetes Basics: Installing Minikube
03:15:55 - Creating Pods and Deployments in Kubernetes
03:18:01 - Kubernetes Services for Internal Communication
03:23:02 - Exposing Services with NodePort and Ingress
03:26:25 - Linux Commands: Navigation, Files, and Permissions
03:38:39 - Linux Processes, Users, and Networking
03:45:04 - Git and GitHub: Setup, Commits, and Branches
03:58:33 - Using Requests Library for API Interactions
04:17:25 - HTTPS and Certificates for Security
04:25:03 - Hashing vs Encryption in Authentication
04:33:28 - Fixing Side-Channel Attacks in Login Timing
04:43:34 - Hosting Types: Shared, VPS, Dedicated, and Cloud
En esta página del sitio puede ver el video en línea Backend Development Roadmap – SQL, Python, APIs, Docker, Kubernetes, Linux, Git & More de Duración hora minuto segunda en buena calidad , que subió el usuario archery 08 noviembre 2025, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 5,166 veces y le gustó 229 a los espectadores. Disfruta viendo!
