Python Programming and SQL: Beginners to Advanced
his book is for beginners and experienced user to learn and understand easily Python and SQL in step by step. It is easy
269 40 3MB
English Pages 205 Year 2023
Table of contents :
Introduction to Python
What is Python
Python is easy to connect to other components:
Python is a languague that can run on multiple platforms.
Python is very simple and easy to learn
Python is an open source language
Install Python on Windows
What is Python
Download Python
Install Python
Start with Python
Install PyDev for Eclipse
What is PyDev
Requirements
Installing PyDev
Conventions and Grammar versions in Python
Conventions in Python
Some naming rules in Python
The keywords in Python
List of special words
The common functions
Statement and Block
The rule of writing a statement on multiple lines
The rules of writing multiple statements on a line
Rule writing a string
Comment
Grammar Versions in Python
Python Tutorial for Beginners
Requirements
Create Project
Create your first module
Branching statements in Python
Comparison operators
if-else statement
Python Loops Tutorial with Examples
Overview of the loops in Python
while loop
for loop with range
Use for loop and array
Use the break statement in the loop
Use the continue statement in the loop
Use the pass statement in the loop
Use the 'else' statement with a loop
Python Function Tutorial with Examples
Python Function
Function examples
Function with required parameters
Function with default parameters
Function with Variable-Length parameter
Anonymous function
Class and Object in Python
Object Oriented in Python
Create class in Python
Constructor with default parameters
Compare objects
Attributes
Function Attributes
Built-In Class Attributes
Class's Variables
List members of a class or object
Inheritance and polymorphism in Python
Introduction
Inheritance in Python
Override method
Abstract Method
Multiple inheritance
issubclass and isinstance function
Polymorphism with function
Python exception handling Tutorial with Examples
What is Exception
Exception Hierarchy
Handling exception with try-except
try-except-finally
Re-throw exception
Exception Wrapping
Python String Tutorial with Examples
Python String
Access values in string
String is immutable
Escape Characters
String operators
Python Lists Tutorial with Examples
Python List
Access the elements of the list
Update List
Delete the elements in the list
Operators
Functions of List
Methods of List
Python Tuples Tutorial with Examples
Python Tuples
List vs Tuple
Access the elements of Tuples
Update Tuples
Operators for Tuples
Functions for Tuples
Methods
Python Dictionary Tutorial with Examples
Python Dictionary
Update Dictionary
Delete dictionary
Functions for Dictionary
Python Date Time Tutorial with Examples
Overview
The concept of Ticks
time module
datetime module
datetime.timedelta
datetime.date
Connect to MySQL Database in Python using PyMySQL
What is PyMySQL
Install PyMySQL
Sample Database
Connect MySQL from Python with PyMySQL
Query Example
Insert Example
Update Example
Delete Example
Call Procedure
Call Function
Introduction to Python
What is Python
Python is easy to connect to other components:
Python is a languague that can run on multiple platforms.
Python is very simple and easy to learn
Python is an open source language
Install Python on Windows
What is Python
Download Python
Install Python
Start with Python
Install PyDev for Eclipse
What is PyDev
Requirements
Installing PyDev
Conventions and Grammar versions in Python
Conventions in Python
Some naming rules in Python
The keywords in Python
List of special words
The common functions
Statement and Block
The rule of writing a statement on multiple lines
The rules of writing multiple statements on a line
Rule writing a string
Comment
Grammar Versions in Python
Python Tutorial for Beginners
Requirements
Create Project
Create your first module
Branching statements in Python
Comparison operators
if-else statement
Python Loops Tutorial with Examples
Overview of the loops in Python
while loop
for loop with range
Use for loop and array
Use the break statement in the loop
Use the continue statement in the loop
Use the pass statement in the loop
Use the 'else' statement with a loop
Python Function Tutorial with Examples
Python Function
Function examples
Function with required parameters
Function with default parameters
Function with Variable-Length parameter
Anonymous function
Class and Object in Python
Object Oriented in Python
Create class in Python
Constructor with default parameters
Compare objects
Attributes
Function Attributes
Built-In Class Attributes
Class's Variables
List members of a class or object
Inheritance and polymorphism in Python
Introduction
Inheritance in Python
Override method
Abstract Method
Multiple inheritance
issubclass and isinstance function
Polymorphism with function
Python exception handling Tutorial with Examples
What is Exception
Exception Hierarchy
Handling exception with try-except
try-except-finally
Re-throw exception
Exception Wrapping
Python String Tutorial with Examples
Python String
Access values in string
String is immutable
Escape Characters
String operators
Python Lists Tutorial with Examples
Python List
Access the elements of the list
Update List
Delete the elements in the list
Operators
Functions of List
Methods of List
Python Tuples Tutorial with Examples
Python Tuples
List vs Tuple
Access the elements of Tuples
Update Tuples
Operators for Tuples
Functions for Tuples
Methods
Python Dictionary Tutorial with Examples
Python Dictionary
Update Dictionary
Delete dictionary
Functions for Dictionary
Python Date Time Tutorial with Examples
Overview
The concept of Ticks
time module
datetime module
datetime.timedelta
datetime.date
Connect to MySQL Database in Python using PyMySQL
What is PyMySQL
Install PyMySQL
Sample Database
Connect MySQL from Python with PyMySQL
Query Example
Insert Example
Update Example
Delete Example
Call Procedure
Call Function
- Similar Topics
- Computers
- Programming
