Python 3 Programming from Basics to Pro, JSON SQL – MySQL MongoDB PostgreSQL Python Database – PDF, Image , GUI Tkinter
What you will learn
+10 Courses in One | 60 Hours + Multiple Projects | Easily and Deeply learn the Python!
Python Basics – Advance -Pro | SQL in Python | MySQL in Python | MongoDB in Python | PostgreSQL in Python | JSON in Python | PDF by PyPDF3| GUI Apps by Tkinter
Using Python, Pycharm, Selenium, pillow image processing, Face detection, Modules, Flow controls, loops, functions, file & folders, Debugging, PIP, Collections
Install & customize Python and Pycharm
Basics to Advance topics of Python coding
MS SQL – MySQL – PostgreSQL – MongoDB – JSON in Python
Create Basic GUI Apps by Tkinter
Introduction to PyQt 6 GUI
Image processing & manipulation by pillow image library
Face detection, makeup … in image
Web automation in Python and selenium
Using PDF file in Python by PyPDF3, PyPDF2, PyPDF4
String Methods (lower, replace, find,…)
Operators and functions in Python
Python Statements – Flow Control
Files and Folders in Python
Debugging and Error Handling
Collections in Python
PIP and Packages
Description
Hi There!
With my 23 years programming skills I’m with you to share my knowledge with you.
In dead this course is based on my teaching skills in the real world classes and how to teach the students in the unique and simple method.
So the only thing you need is your inner motivation for learning the Python. Then you can start learning it after watching the tutorial.
The main purpose of this course is only to teach you the basics and how to start learning the Python.
So
If you try you will be a Python programmer!
If you wanna start learning Python programming!
If you are beginners or student looking for a tutorial that teach Python with real project in simplest way!
If you want really to be a Python programmer so it’s best place that you can start to learn Python.
This is what you will get in this Python Programming course:
- Python Basics , Advance, Pro
- SQL in Python
- MySQL in Python
- MongoDB in Python
- PostgreSQL in Python
- JSON in Python
- Basic GUI Apps by Tkinter
- Introduction to PyQt 6
- Using PDF file in Python by PyPDF3, PyPDF2, PyPDF4
- Web automation in Python and selenium
- Using Python, Pycharm
- Working with Variables
- Using Flow controls, loops
- Using functions
- Collections in Python
- PIP , packages and modules
- Image processing & manipulation by pillow image library
- Face detection, makeup … in image
- Install & customize Python and Pycharm
- String Methods (lower, replace, find,…)
- Operators and functions in Python
- Python Statements
- Files and Folders in Python
- Debugging and Error Handling
- …
Don’t hesitate to start learning Python!
Every thing will be discussed with sample project and you will have lot of fun within my course.
Say Hi Python world and let’s go !!!
English
language
Content
Introduction
Introduction
Installing Python 3.9.5 &Pycharm
What do we need for Python?
Installing Python 3.9.5
Installing Pycharm 2021.1 on Windows 10
Start using Python and IDLE
Python 3.10.1 & Pycharm Update
Installing Python 3.10.1 & Pycharm 2021.3 on Windows 10
Basics – Start Python in Pycharm
Create first Python project in Pycharm
Run first Python code in Pycharm
Customize settings & environment of Pycharm
Project 1: Drawing shapes in Python
Basics – Python Coding Basics
Comments in Python
Variables in Python ( string, int, float, bool)
Variables – Naming rules & assigning values
Get the data type of variables
Type casting and conversion
Getting inputs from users
Project 2: Simple calculator in Python
Basics – Strings in Python
Working with Strings
String Methods
String slicing
String formatting in Python
Basics – Operators &Functions in Python
What are basic operators in Python?
Arithmetic operators
Precedence of operators
Assignment operators
Identity operators
Membership operators
Numeric functions
Project 3: Age calculator
Advance – Modules in Python
What is Module in Python?
Using modules with “Import” keyword
Project 4: Math module in Python
Project 5: Degree to Radian convertor
Project 6: Area of circle calculator
Using Platform module in Python
Using datetime module in Python
Using dir() function in Python
Advance – Python Statements – Flow Control
Simple if statement => simple condition
Comparison operators
else statement => to create advance if
elif => Multiple if statements
Logical operators
while loop => Simple method
String splitter by while loop
break statement in while loop
continue statement in while loop
Simple for loop structure in Python
break statement with for loop
continue , pass statements with for loop
Nested for loop
range function with for loop
Project 7: String & List splitter
Advance – Two Projects in Python
Project 8: Number Guessing Game in Python
Project 9: Animal Guessing Game in Python
Advance – Files and Folders in Python
What is a file and steps to use it in Python?
Reading the file by: open(), read(), readline(), …
Writing the file by: open(), write(), writelines(), …
Append values and create a file
Using “r+” to read and write text file
Using “a+” to read and append text file
Protect data inside text file & change the folder of it
Check if the file exist by os module?
Rename a file by os module
Delete a file by os module
Folder functions: create folder, rename, delete, exist …
Project 10: Customer info with save and search
Advance – Functions in Python
Create and call the function in Python
docstring in function
Arguments or parameter in functions
Keyword arguments in function
*args : Variable-length arguments
**kwargs : Variable-length keyword arguments
Return value of function – pass statement
Recursion function
Scope of variables
Pro – Debugging and Error Handling
. What are Bug and Debug & line numbers?
Breakpoints and debugging Python code
“try structure” : error handling in Python code
Pro – Collections in Python
List Basics
List Advance
Tuple
Set Basics
Set advance methods
Dictionary in Python
: Pro – PIP and Packages
Start using PIP & Pypi
Find and install packages
SQL – Quick Review of SQL Server
Who should watch this section?
Download & install SQL 2014 on Windows 10 and Windows 7
Start using SQL server and SSMS
Working with SQL database
Using SQL Server configuration manager
Using SQL Server Table
SQL Numeric Data types
SQL English Text Data types
SQL Unicode Text Data types
GUID datatype in SQL
How to Attach, Detach and offline the SQL database
Identity and Auto Increment Column in SQL Server
SQL Date Time Data types
Project => Create “Phone Book” database in SQL
Select Query In SQL
Search data in SQL
SQL – Using MS SQL in Python
Structure of Database Apps in Python
Installing pyodbc module on Python
Create Sample SQL Server Database
Connect to SQL Database in Python
Load SQL Server data & show in Python
MySQL – Quick Review of MySQL
Who should watch this section!
Download the Oracle MySQL
Install MySQL on Windows 10-64 Bit
Install .Net framework 4.5.2 on Windows 7-64 Bit
Install MySQL on Windows 7- 64 Bit
Various features of MySQL
Create the MySQL Connection for connecting to it
Using main parts on MySQL Workbench
What is MySQL Database?
Create the Database in MySQL
Edit- delete and configure My SQL database?
What is Charset in My SQL Database?
What is the Collation in My SQL Database?
Utf8mb4 Charset and Collation in MySQL Database
introduction to My SQL Table
Add Simple table to the MySQL Database
Create Multi-Column table in MySQL
How to edit and configure the table in MySQL?
Add sample data to MySQL table
What is MySQL data type?
What is MySQL Numeric data types?
Various Decimal Data Types in MySQL
Various Date Time Data types in MySQL
Various Text & Char data types in MySQL
What is Auto-Increment column in MySQL?
Add Auto-Increment column in MySQL
Reset Auto Increment value in MySQL
Create Phone Book Database in MySQ
Add Personal columns to “Customer List” table
Add Contact columns to “Customer List” table
Add auto increment to “ID” column
Add sample data and test our MySQL table
What is Select Query in MySQL?
Use Select query with (*) to show all columns
Writing our first Select query
Sort the records with Select query
Limit number of rows with Select Query
MySQL – Using MySQL in Python
Structure of using MySQL in Python
Installing MySQL module on Python
Create Sample MySQL Database – Introduction
Create Phone Book Database in MySQL
Add Personal columns to “Customer List” table
Add Contact columns to “Customer List™ table
Add auto increment to “ID” column
Add sample data and test our MySQL table
Connect to MySQL database in Python
Load MySQL data and show in Python
Postgres – Quick review of PostgreSQL
Download & install Postgres on Windows
Start using PostgreSQL Admin or pgAdmin
Adding PostgreSQL Server to pgAdmin
Creating database in PostgreSQL
What is the table?
Add schema in Postgres database
Add table in to database
Add columns in table in Postgres
Add data to table and load it – Primary key in table
Auto increment for identity columns & using ‘Truncate’ query
Integer => ( smallint, integer, bigint, smallserial , serial , bigserial )
Fix-Point decimal => ( numeric or decimal )
Floating-Point decimal => ( real, double precision)
Monetary => money
Character => ( character(n) , character varying(n) , text )
Boolean => (boolean )
Date/Time => ( date, time, Date Time, time + zone, DateTime + Zone )
Postgres – Using PostgreSQL in Python
Structure of using Postgres in Python
Installing Postgres module on Python (psycopg2)
Create Sample Postgres Database
Create a connection to Postgres in Python
Protect the codes by try structure
Close the connection
Create a Cursor object
Read the data by SQL Select query
Show the data in Python by cursor object
Show all data in Python by fetchall() method
Show custom data in Python by fetchmany() method
Show one record in Python by fetchone() method
Sort the records & customize columns
Close the cursor
JSON – Using JSON in Python
Working with JSON files
Import JSON data in Python and use it
Export Python data to JSON
MongoDB – Quick Review of MongoDB
SQL vs NoSQL : Introduction to MongoDB
Download MongoDB, Compass and MongoDB Shell
Install MongoDB and start using it
Install MongoDB Compass and start using it
Install MongoDB Shell (Mongosh) and start using it
Using Compass to add Database and Collection to MongoDB
Using document to add data in MongoDB
MongoDB – Using MongoDB in Python
Structure of Using MongoDB in Python
Install MongoDB module in Python
Create Sample MongoDB database in Compass
Using Client object to connect to MongoDB
Create Database & Collection object
Load data from MongoDB by Cursor object
Search the documents
Basics: GUI in Python by Tkinter
Start adding GUI to Python by Tkinter
Common properties of Window
Using attributes of a Window
Widget options
Label widget and common options
Using Button widget
Using Entry widget
Using Frame widget
Tkinter Geometry Manager
What is the geometry manager?
Using Pack() to design apps
GUI Projects in Tkinter
Design ‘Find & Replace’ Window in Tkinter
Celsius to Fahrenheit convertor
Basics: Using PyQt6 to GUI apps in Python by PyQt
What is PyQt6 in Python?
Installing PyQt6
Project Types of PyQt6
First PyQt6 app to show Window by code
Displaying a widget ( label, Push Button) on the Window by code
Running Qt Designer for first time
Running Qt Designer inside Pycharm
Quick start using Qt designer
What is ‘ui’ file?
Simple method to load ‘ui’ file in Python
Create a class to load ‘ui’ file in Python
Pillow – Image processing with pillow library
Section intro: Image processing with pillow in Python
What is pillow image in Python?
Download and install pillow in Python?
Open and show an image with pillow?
Save image in pillow with different formats
Get attributes of images like: size, format, color mode..
Resize image by pillow
Rotate image with rotate method
Create thumbnail image
Crop image by pillow
Rotate and Flip image by transpose method
Adding Blur, BoxBlur, GaussianBlur filter by pillow
Adding Contour filter by pillow
Adding Detail filter by pillow
Adding Edge Enhance filter by pillow
Adding Emboss filter by pillo
Adding Find Edge filter by pillow
Adding Smooth filter by pillow
Adding Sharpen filter by pillow
Add simple text ( watermark) to image
Add text (Watermark) with custom font to image
Split image bands ( Color Channels)
Merge Color Channels to create image
Pillow: Face detection in image by dlib, cmake &face recognition
Create face recognition project in PyCharm
Install cmake, dlib, face-recognition, pillow libraries
Check if everything is installed correctly
Load image to Numpy array
Find location of faces in image
Load pillow image from Numpy array
Draw rectangle around detected faces & show it
Split and save each face in dedicated image file
Detecting face landmarks ( facial features )
Add rouge makeup on the lips
Add thicker eyebrows
Add eyeliner around the eyes
4. Add sparkle on eyes or overlay color
PDF : Using PDF in Python by: PyDF2 , PyPDF3 , PyPDF4
How to download and install PyPDF3, PyPDF2, PyDPF4
Create the PDF project in Pycharm
Extracting Pdf document information (Title, Author,..)
Rotating PDF pages
Merging PDF files
Splitting PDF pages in PDF file
Adding password to PDF file
Adding watermark to PDF pages
Selenium: Web automation in Python selenium
What is the Selenium and its structure?
Install the Selenium in Python project
Install web driver for Chrome and edge
Load the Web driver from Windows Path
Load the Web driver from specific folder in project
Project 1: Load title and url of website
Using browser’s inspector to find elements by Name, ID ,
Send text to browser and search it by selenium
Searching a word in Google by selenium and Python
Introduction to stackoverflow website
Load stackoverflow login page by Selenium
Using implicit wait to add delay to Selenium
What is Explicit wait in Selenium
What is Xpath to find element in Website
Using Explicit wait in Selenium