The Complete Python Bootcamp from Zero to Expert

Explore how to output variables in Python using print, concatenation, f-strings, and the format method, with examples showing a name and age.

Learn string formatting in Python using the format method to embed and format values inside strings. Create dynamic messages and format numeric values with precision using placeholders and format specifiers.

Explore escape characters in Python, using backslashes to include non-printable or special symbols within strings. See common sequences like new lines and tabs and learn to print them correctly.

Explore essential string methods in Python, including upper, replace, and isalpha/isnumeric, to search, manipulate, and format text with practical examples.

Tackle practical Python string exercises to reverse strings and count vowels. Apply these techniques to sample text such as 'Python programming' and 'Python is amazing' to reinforce string manipulation.

Master Python list comprehensions to create concise lists with expressions over iterables, include filters and nested structures, and flatten a matrix while appreciating readability and efficiency over traditional loops.

Learn to sort lists in Python using list.sort for alphanumeric and numeric orders, apply reverse for descending, and customize sorting with a key function to prioritize closeness to 50.

Copy lists in Python using slicing, the list constructor, and the copy method to create shallow copies and avoid reference pitfalls from assignment.

Learn how to join lists in Python through concatenation with the plus operator, extend, and in-place plus equal, while exploring list creation, repetition with the star operator, and merging methods.

Master joining sets in Python by uniting with the union method and or operator. Identify common elements via the intersection method and and operator.

Learn to loop a Python dictionary by iterating keys, values, and key value pairs with for loops and the items method to navigate and manipulate data.

Explore methods to duplicate Python dictionaries with precision, including basic assignment, copy method, and dictionary constructor, and handle nested dictionaries with shallow copies to avoid side effects.

Explore data visualization with the matplot library in Python, creating 2D plots and publication-ready figures. Learn to import matplotlib.pyplot, build a basic line plot, and customize colors, labels, and titles.

Explore how lines connect data points in Python plots using Matplot. Create line plots, customize line style and color, and compare multiple lines on a plot to reveal trends.

Master the art of levels in Python plots by adding axis levels, titles, and legends, and learn to customize positioning, styling, and multiple data series.

Explore how grids in Python plots improve readability by using the Matplot library to enable, customize, and apply grids to subplots for clearer figures.

Master scatter plots in Python with Matplotlib to visualize the relationship between two numerical variables and customize markers, colors, size, and edge color to uncover data insights.

Explore bar plots in Python using the matplot library to visualize and compare categorical data, and learn to create vertical and horizontal bars with labels, titles, colors, and edge colors.

Learn to create and connect to a MySQL database with Python. Use the MySQL connector, set host and root, create a database, show databases, and use a cursor.

Learn to create tables in MySQL with Python using mysql-connector, establish a localhost connection, create a customers table with name, address, and email, and verify via show tables.

Learn to insert data into a MySQL table with Python by establishing a connection, creating a cursor, and executing single and multiple inserts into the customers table.

Learn to retrieve data from a MySQL table with Python by connecting via the MySQL connector, creating a cursor, executing select queries, and fetching all or single rows.

Learn to connect Python to MySQL, create a cursor, and filter data with where and like clauses, while preventing SQL injection and retrieving results.

Sort data with the order by statement in Python using MySQL, learning to select from the customers table and sort results ascending and descending with a cursor.

Learn to delete records with the delete from statement in Python using MySQL, deleting from the customers table by address, committing changes, and using placeholders to prevent SQL injection.

Learn how to drop a table in Python using MySQL workbench, with the drop table statement and if exists checks, to keep your database clean.

Learn to join multiple MySQL tables in Python using inner, left, and right joins, based on a common column, and execute queries to fetch and display results.

Connect to MongoDB using PyMongo in Python, create a new database on localhost, verify existing databases, and print a confirmation that the new database was created.

Delete documents in MongoDB with Python by performing single and bulk deletions through delete operations, crafting a delete query, and validating results in the database and collection.

Drop a collection in MongoDB with Python using the drop method and the Mongo client, returning true when successful and removing the customers collection.

Learn to update documents in MongoDB with Python, using update_one for single items and update_many for multiple, with $set to modify fields like city and status to active.

Master MongoDB queries by applying the limit method to restrict documents and using skip for pagination. Learn dynamic limiting with user input and print retrieved documents from Python.