
Welcome to the course! ?
Before diving in, here are a couple of tips to help you get the most out of your learning experience:
✅ Feel free to watch the lessons at 1.25x or 1.5x speed — many students find this helps keep the pace engaging while still absorbing everything clearly.
✅ Focus on understanding the concepts, not just memorizing steps – real learning happens when you know why, not just how.
✅ I'm here to help! If you have any questions, don’t hesitate to reach out. I’m happy to clarify anything or point you in the right direction.
Good luck, enjoy the journey, and let’s get started! ?
Learn to install Postgres on Windows, set up the data directory and password, keep the default port, and use pgadmin to run simple sql queries.
Create a do's db and a todos table with id serial primary key, title not null, and description text, using pgadmin query tool and the execute script command.
Write a targeted update query for the todos table, set the title and description, and use a where id clause to modify a specific record only.
harness the order by clause to sort data by a column, retrieving latest or oldest records with descending or ascending order, illustrated with todos and messages
Learn to use the case keyword to output results based on data, classifying workers by years of experience as senior, mid-level, or junior.
Learn to check installed libraries with pip list and import and use libraries like requests in Python, enabling you to make API calls.
Declare a variable named name with Omri as the value, and create status as boolean and number as integer, then print the trio to show Python infers types.
Master Python for loops to iterate over lists and dictionaries, print each website, access dictionary keys and values, and extract url and status code from the list of dictionaries.
Learn Python while loops that run on a condition, including an infinite loop with while true and a timed pause using time.sleep before stopping when status becomes false.
Explore concurrency and parallelism in Python, using threading and multiprocessing to speed up HTTP requests across URLs. Learn to measure time and manage shared data with mutexes and locks.
Install postman, sign in with Google, and interact with a sample API by sending a get request, then create a to do list collection to save routes for cross-device use.
Explore how domain names map to IP addresses through DNS, enabling users to reach services without memorizing numbers, and learn about ports like 80, 443, and 4000 for online access.
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!