Certificate Authentication

1. Creating Project:

- Configuring pyCharm and virtual environment

- Creating project structure (directories and packages)

- Repeating knowledge about program structure syntax (if, for, while)

- Working with pythonism code (onelinecode)

2. Working with Files

- Accessing different types of files and file handling principles

- Creating, reading, updating and deleting files (including regular text files, csv, as well as Microsoft Word and Microsoft Excel files) -> some topics are optional (client needs)

- Extracting data from text files using Regular Expressions

3. Accessing Databases

- Generic database API based on SQLite 3, PostgreSQL and MySQL, or SQL Server

- Using numpy, pandas to exctracting data from data sources like databases and files into dataframe or dataseries

- Working with NoSQL databases (mongodb) -> optional

4. SQL Language

- Selecting data with SQL Syntax (select, where, group by, having, join, union, window, etc)