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)