Python Higher Tutorial
Functions
Local scope of variables
Global scope of variables
Interaction of scopes
The nuances of working with scopes
Passing variables by value
Passing variables by reference
Passing primitives by parameters
Passing objects by parameters
Function as a variable
Callback functions
Passing multiple parameters to a function
Combination of normal parameters and *args
Named parameters as a dictionary
Combining parameters
Output of function documentation
Lambda functions
map function for iteration
The filter function for filtering
Global instruction
Function in function
nonlocal instruction
Nuances when working with an internal function
Short circuits
Recursion
Inclusions
Introduction to List Compositions
Operations with elements in list comprehensions
Generate from list
Conditions in list inclusion
Multiple loops in list comprehension
Multiple loops with condition in list comprehension
Generating a two-dimensional list
Generating a dictionary using inclusion
Regular expressions
Introduction
Repetition operators
Grouping brackets
Escaping special characters
Braces
Limiting Greed
Character groups
Character sets
Inverting character sets
Special characters within sets
Character groups within sets
Special characters-exceptions within sets
Hat symbol inside sets
Features of hyphens within sets
Beginning and end of line
Word boundary
Multiline
Team 'or either'
Search method
Position of the found
Pockets in the search method
Pockets via group method
All pockets in the form of a cortege
Named pockets in the search method
Pockets in the replacement line
Unscreening of pocket number
findall method
Pockets in findall method
finditer method
Pockets in finditer method
Named pockets in finditer method
Fullmatch method
Pockets in the fullmatch method
The match method
Pockets in the match method
subn method
Split method
Non-preserving parentheses
Positive and negative viewing
Flags for strings
Exceptions
Introduction to Exceptions
Catching exceptions
Basic types of exceptions
Catching different types of exceptions
else block when catching exceptions
The finally block when catching exceptions
Throwing your own exception types
Custom Exceptions in Conditions
Function with exception
Modules
Introduction to Import
Renaming a module
Importing a part of a module
Import all contents of a file
pip package installer
Installing the library
Checking for library availability
Updating the library version
Removing a library
Virtual environment
Virtual environment
Creating a virtual environment
Activating the virtual environment
Closing the virtual environment
Installing the library into a virtual environment
Transferring a project in a virtual environment
SQl databases
Introduction to Databases
phpMyAdmin
Test table users
Preparatory manipulations
Sending queries to the database
Output all records as a dictionary
Selecting records
Logical operations
Output of one record
Selection fields
Inserting records
Inserting records when columns are missing
Updating records
Deleting records
Renaming a field
Selecting records by specific values
Quantity limit
Sorting records
Minimum value sampling
Maximum value sampling
Sum of field values
Counting the quantity
Grouping the result
Addition of strings during selection