Python EVENINGS Course

Python Data Types and Variables:
Primitive types; Characters & Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python.
Operators and Expressions:
Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators.

Decision Making:
If statement; If - else statement; If- elif - else statement; Nested if - else.

Using Loops:
The while, while-else.
For loop;
Jump statements: break, continue;
Nesting loops.

Lists.
Tuples.
Sets.
Dictionary. Nested Dictionary.
Json Files.

Using Built-in modules and functions:
Strings Functions.
Pattern matching with Regex.
Maths Functions.
Random Functions.
Python Date functions.

Creating and using custom Functions.
Creating functions;
Using parameters and return values;

Introduction to Classes and Objects:
Creating a Class;
Creating an Object; Using an Object;
Adding Instance variables; Controlling accessibility; Naming conventions for class members.
Class Constructors; Parameterized Constructors.
Inheritance. Overload.

Connection details: Connect to a database using access codes.
Select Queries: Retrieving records and iterating results sets, using variables and parameters in queries.
Working with DDL comands: Create a database, drop a database. Create a table, alter tables, drop a table.
Working with DML Commands: Insert, delete, update records.

Getting data into a dataframe:
Dict to Dataframe, Dataframe to Dict.
Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets.
Dataframe basics:
Slicing Dataframes,
Getting information about the dataframe,
Filter, sort and query a Dataframes,
Duplicate values,
Working with null-values,
Sampling,
Group by,
Join.