Backend Bootcamp 2026: Python, Flask, REST API, Docker, SQL

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.

Learn to use pgAdmin, the official Postgres GUI, to run queries via the query tool, customize themes and fonts, and enhance readability for efficient database work.

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.

Learn to filter data by selecting columns and applying where clauses with and/or conditions to return only records that match specified criteria.

Learn to delete data in sql using the delete keyword, delete from todos where id = 3, and verify with select all from todos; you can delete by other columns.

Learn how to filter data with the ILIKE operator to find names starting with a letter sequence, such as Ali, in a case-insensitive way.

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 how to limit rows in a database using the limit keyword to fetch only three rows, improving read speed when dealing with millions of records.

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 how to model many-to-many relationships in SQL with a junction table, linking students and courses via student_id and course_id, and use inner joins to display courses alongside student names.

Install Visual Studio Code on Windows, a lightweight modern IDE for Python; download, create a desktop icon, install the Python extension, then start using Python in VS Code.

Create a new folder named scripts in Visual Studio Code, add my script.py, print hello world, and run it in the terminal with Python my script.py.

Install and switch themes in VSCode via extensions and the gear menu, and adjust font size and zoom for comfortable editing, then add the VSCode icons extension.

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.

Explore Python dictionaries by storing key value pairs in a grades example, access values by keys like history, print dictionary types, and retrieve items from a list of dictionaries.

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.

Use if statements to act on a score, printing outcomes like 'You have passed the test' or 'You have not passed the test', using else and elif for additional conditions.

Learn to use try and accept to catch errors, print them, and keep a large-scale application running without termination.

Learn to organize code by defining and calling Python functions with def, create multiple functions, pass parameters like name, and print their outputs.

Learn how to access and modify a variable outside a function within its scope using the global keyword, with an example that increments a global number from inside the function.

Learn to flexibly pass data into functions with *args and **kwargs, packing varying items into a single parameter and unpacking lists and key-value pairs.

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.

Explore building a Flask REST API that talks to a Postgres database to perform CRUD on todos, using routes and HTTP methods tested with Postman.

Learn how to implement non-blocking API calls in Python by using threading to run heavy backend tasks in the background without delaying responses.