Course Overview
This course teaches you SQL and Python for backend development, using real-world examples to help you build practical, job-ready skills. You’ll learn how to model data relationships, work with relational databases like PostgreSQL, and build fully functional REST APIs using Flask.
As you progress, you'll also explore advanced programming techniques such as concurrent and parallel programming to write faster, more efficient backend code.
We start from the basics, covering how to install and set up your development environment for both SQL and Python.
You'll write actual queries, manipulate data, connect databases to Python, and build APIs that mirror real-world applications. You’ll also learn to use Postman to test your APIs and VSCode as your coding environment.
In addition, the course will introduce essential web security techniques, including HTTPS for secure communication, JSON Web Tokens (JWT) for authentication, and bcrypt for password hashing—giving you a strong foundation in protecting
websites and backend systems.
You’ll also learn how to monitor your PostgreSQL databases using Grafana, gaining insight into performance metrics and system health—an essential skill for maintaining and scaling production systems.
Why SQL Matters in Backend Development:
SQL (Structured Query Language) is the standard language used to interact with relational databases—one of the most critical components in any backend system.
As a backend developer, you're constantly working with data: storing it, retrieving it, securing it, and analyzing it.
SQL allows you to design efficient data models, write optimized queries, and enforce rules to ensure data accuracy and integrity.
From simple data lookups to complex joins and transactions, SQL gives you the tools to manage the backend's most valuable asset—its data.
Why This Course is Unique
This course gives you two essential skills in one:
SQL – to master data handling, querying, and database design.
Python – to build the backend logic, APIs, and integrations that bring your applications to life.
By learning SQL and Python together, you'll understand not only how to build backend systems but also why each part matters—from data storage to API delivery.
This combination makes you a more complete, capable, and confident backend developer.
The course emphasizes clean, modular design and encourages good practices from day one. Whether you're a beginner or looking to transition into backend development, this course is structured to guide you step-by-step.
No prior backend experience required—just motivation and curiosity. Let’s get started!
FAQ
FAQ area empty
Course curriculum
Chương 1 Introduction 1 bài
Chương 2 SQL Setup 3 bài · 8 phút
- Installing PostgreSQL Học thử 4:49
- Interacting with PostgreSQL Shell Học thử 1:45
-
Using pgAdmin for GUI-based SQL 1:42
Chương 3 Mastering SQL for Backend 14 bài · 26 phút
- Creating Tables Học thử 3:20
- Inserting Data Học thử 1:42
-
Updating Data 1:29
- Filtering Data Học thử 2:20
- Deleting Data Học thử 1:05
-
Using ILIKE 1:05
-
GROUP BY Clause 3:11
-
ORDER BY Clause 1:00
-
LIMIT Results 0:56
-
Using COALESCE 1:08
-
Using CASE Statements 1:54
-
Sub queries 1:05
-
Common Table Expressions (CTEs) 3:27
-
ROLLBACK and SQL Transactions for safer queries 2:46
Chương 4 Database Relationships Explained 2 bài · 11 phút
-
One-to-Many Joins 6:24
-
Many-to-Many Joins 4:52
Chương 5 Python Setup 6 bài · 6 phút
-
Download Python 0:59
-
Using Python Package Manager (pip) 0:36
-
Install VSCode and Python Extension 1:09
-
Creating and executing a Python script in Visual Studio Code 1:04
-
Configuring settings, themes, and fonts in Visual Studio Code for comfortable de 1:38
-
Using libraries in Python with Visual Studio Code 0:25
Chương 6 Core Python Programming 11 bài · 17 phút
-
Variables and Data Types 1:15
-
Working with Lists 1:46
-
Working with Dictnioaries 1:49
-
Using for loops 1:35
-
While loops explained 1:25
-
If statements 1:10
-
Try and except 0:59
-
String Concatenation 0:37
-
Functions 1:43
-
Global variables 2:00
-
*Args and **Kwargs 3:03
Chương 7 Advanced Python: Concurrency and Parallelism 3 bài · 23 phút
-
What Are Threads and Processes ? 5:37
-
What Is a Race Condition? 2:00
-
Parallel and Concurrent Programming 15:09
Chương 8 REST API Setup (Postman) 1 bài · 1 phút
-
Postman Installation 1:29
Chương 9 Network Fundamentals 1 bài · 2 phút
-
DNS Explained: How Your App Finds Its Way Online 1:46
Chương 10 Building REST APIs with Flask and PostgreSQL 2 bài · 38 phút
-
Python REST API Development: Flask + SQL 31:17
-
Non-Blocking API Calls with Threading and Concurrency in Python 7:06
Chương 11 Docker Fundamentals for Development 4 bài · 15 phút
-
Dockerizing Our API: Run Anywhere, Anytime 4:38
-
Deploy Anywhere: Uploading Docker Images to Docker Hub 5:02
-
Save Docker Images to USB: Offline Backup with Docker Save & Load 1:21
-
Managing Multi-Container Apps with Docker Compose 3:37
Chương 12 The Course Project 10 bài · 58 phút
-
Course Project Introduction 1:11
-
Implementing User Registration & Login 16:57
-
Generating JWT Tokens for Authentication 1:30
-
Securing Routes with JWT Middleware 3:27
-
Building GET and POST Endpoints for Books 8:55
-
Updating and Deleting Books (CRUD Operations) 4:43
-
Handling User Permissions 3:55
-
Blocking Unauthorized Access to Book Data 13:21
-
Implementing Error Handling in the API 1:39
-
Dockerizing the Project for Production Deployment 2:30
Chương 13 Kubernetes for Deployment and Scaling 6 bài · 18 phút
-
What is Kubernetes? The Engine Behind Modern Deployments 1:07
-
Set Up Minikube: Your Local Kubernetes Playground 1:57
-
Nodes, Pods, and Namespaces Explained 0:45
-
Creating Pods and Deployments 4:02
-
Kubernetes Services, Communication, and Ingress 9:08
-
Kubernetes on Cloud Platforms and Rancher 0:59
Chương 14 Linux for Developers 1 bài · 27 phút
-
Working with Linux: Commands, Services, and Functionality 26:31
Chương 15 Git and Version Control 5 bài · 13 phút
-
Installing Git and Setting Up Your Environment 1:12
-
Configuring Git with GitHub 1:02
-
Cloning Repositories and Pushing Code to GitHub 4:42
-
Working with Git Branches 4:46
-
Essential Git Commands: Status, Log, and More 1:02
Chương 16 Microservices and API Gateway 1 bài · 2 phút
-
What Is an API Gateway and Why It Matters 2:08
Chương 17 The requests library 1 bài · 6 phút
-
Making HTTP requests directly from Python 5:38
Chương 18 Using Grafana For Real-Time Monitoring 1 bài · 4 phút
-
Monitoring PostgreSQL in Grafana 3:56
Chương 19 Core Principles of Web Security (Bonus Section) 3 bài · 21 phút
-
Securing Websites with HTTPS: The Foundation of Web Safety 3:00
-
How Modern Websites Stay Secure: JWT, Encryption & More 6:14
-
Defending Websites from Timing Side-Channel Attacks 12:10
Chương 20 Web & API Hosting Essentials 1 bài · 3 phút
-
Types of Hosting Explained: Shared, VPS, Cloud & More 3:23
Requirment
-
No programming experience required — we’ll teach you everything from the ground up.
Outcomes
-
Master the fundamentals of writing clean, efficient, and scalable server-side code using Python, Flask, and best practices in backend development.
-
Develop backend expertise by mastering SQL and gaining a deep understanding of relational data systems
-
Design and implement a modern REST API using Python frameworks and PostgreSQL for data storage.
-
Gain expertise in advanced backend development techniques, with a strong focus on modern concurrent and parallel programming practices.
-
Gain practical SQL skills including data insertion, querying (e.g., LIKE, GROUP BY, ORDER BY), filtering, and managing complex joins and transactions
-
Set up and manage PostgreSQL databases, learning to create tables, handle shell commands, and use advanced SQL features like CTEs, COALESCE, and CASE statements
-
Master essential backend development tools such as Python, pip, Postman, and pgAdmin, setting the foundation for robust API and database interaction.
-
Develop Strong Python Programming Skills, Understand and implement key programming concepts like loops, conditionals, functions, and error handling in Python
-
Learn how to containerize applications using Docker, including creating Dockerfiles, building images, and managing containers
-
Understand key security features such as HTTPS for encrypted communication, JWT for stateless authentication, and bcrypt for secure passwords
-
Learn how to connect PostgreSQL to Grafana, visualize metrics, and set up dashboards to monitor your infrastructure
-
Understand various web hosting options such as shared hosting, VPS (Virtual Private Server), dedicated hosting, and cloud hosting. Learn how each type works
0 Student
1 Course
0 review