Complete Modern Python 3 and PostgreSQL Essentials

Install Python on Windows using the official python.org installer and add Python to path. Restart the command line, verify with python --version, and use the Python interpreter.

Choose between Visual Studio Code and PyCharm Community Edition, configure Python 3.13/3.11, and create a project with a venv, sample files, and run simple scripts.

Learn command line basics across macOS, Linux, and Windows, including navigation, file and directory management, and essential commands like pwd, cd, ls, touch, cat, rm, mkdir, mv, cp, and chmod.

Explore tuples in Python and learn how to create and access them. Discover their immutability, and see how fixed data like coordinates benefit from it, with len to count items.

Master dictionaries in Python by learning key-value pairs, creating and updating with curly braces, safe retrieval with get, and deleting entries with pop, while noting dictionaries preserve order.

Explore the basics of while loops in Python, counting down from five, iterating through a list with an index, and using break and continue to control flow.

Learn to use for loops in python to iterate through lists, strings, ranges, and dictionaries, with practical examples like fruits and a message, and understand range steps and break logic.

Master Python functions by defining with def, passing parameters, returning values, using default arguments, and unpacking multiple results across successive calls.

Explore advanced function techniques in Python, including arbitrary arguments and keyword arguments, plus unpacking and passing complex data like lists and dictionaries.

Master robust Python error handling with try and except, handle zero division and value errors, and use else, finally, and custom errors for reliable user input and file operations.

Explore lambdas in Python, learning anonymous one-off functions you can use with sorted, map, and filter to perform concise operations on numbers, tuples, and lists.

Explore object oriented programming in Python by learning how classes serve as blueprints, objects hold attributes and methods, and how modular, reusable code models real-world systems for larger projects.

Create a Python class with a constructor, attributes, and methods to model a person, then instantiate objects and use greet and half_birthday methods.

Explore advanced concepts in object oriented programming, including inheritance, encapsulation with private and public attributes in Python, polymorphism across classes, and abstraction with abstract methods.

Explore advanced object oriented programming in Python, focusing on inheritance, encapsulation, and polymorphism with concrete examples like vehicle and bank account classes, plus animal-based polymorphism with dog and cat.

Explore abstraction and interfaces in Python by creating abstract base classes with the ABC module, implementing abstract methods in concrete subclasses, and using shape contracts to define area calculations.

Learn SQL, the structured query language for relational databases, and how tables, rows, and relationships enable retrieval, manipulation, and analysis of large data sets.

Learn to install postgres on Windows, Mac, or Linux using the official installer, set up the Postgres server, pgadmin four, stack builder, and configure ports and superuser password.

Create your first Postgres database and a customer_orders table with pgadmin and sql, defining id, customer name, email, order date, product, quantity, price, and status, then insert data.

Master the select statement to retrieve data from the customer orders table, using select, distinct, where, and order by price for sorted, filtered results.

Insert data into a Postgres table using the insert statement, including single and multi-row inserts, proper single quotes, now for dates, and the returning clause to fetch generated IDs.

Learn to update data in Postgres with the update statement, using set and where clauses to modify single or multiple records and optionally return updated values.

Delete data safely in Postgres with delete from and a where clause to remove single or multiple rows, using the returning clause to fetch deleted data.

Create a customers table and an orders table with a foreign key that references the customers table, enabling joins and enforcing referential integrity, with serial primary keys and sample data.

Explore how to use inner, left, right, and full joins in PostgreSQL to combine data from customers and orders, with practical examples and best practices.