About Me
I started in February 2017 at the Warsaw University of Technology, where I studied for 1.5 years. From November 2017, I also worked part-time for over 1.5 years as a junior C++ developer.
Since October 2023, I have been running my own business, within which I teach IT tools; I have also completed several projects for companies using Excel/VBA. I have additionally completed various online courses, the list of which is provided below.
Databases:
- SQL (all Create, Read, Update, Delete concepts)
- Constraints, indexes, transactions, JSONB (PostgreSQL)
- Normalization, diagrams
- Connecting via client applications as well as Python libraries
- Using databases on servers
I offer particular support with PostgreSQL, but I also have teaching experience with SQLite, SQL Server, and MySQL. I have also helped students prepare for exams.
Python:
- Language fundamentals: loops, variables, data types, data structures, conditional statements, algorithms, classes, exceptions, debugging
- Data analysis libraries: Pandas, NumPy, Matplotlib using Jupyter Notebooks
- Basics of testing, documentation, and logging
- Git for version control
- Database connections
- Django framework
- Linux automation scripts (subprocess)
- Virtual environments: venv, pipenv, conda, anaconda
Networking:
(Everything needed to create and publish a website on a VPS)
- HTTPS, Let’s Encrypt
- Apache & Nginx configuration
- Django deployment
- Linux server basics, SSH
- Domain registration
Linux:
- Installation
- Bash, filesystem, apt
- Many command line tools: network, processes, permissions, files
- Python automation scripts
Statistics:
- Probability
- Basics of descriptive statistics
- Basics of inferential statistics
- Linear regression
Completed Online Courses
Google Advanced Data Analytics Professional Certificate (ongoing, almost finished)
Data Science, Exploratory Data Analysis, Data Visualization Software,Feature Engineering, Python Programming, Object Oriented Programming (OOP), Tableau Software, Data Storytelling, Descriptive Statistics, Statistical Analysis, Regression Analysis, Logistic Regression, Statistical Hypothesis Testing, Sampling (Statistics), Model Evaluation, Machine Learning
Python for Everybody Specialization Dr. Charles R. Severance (University of Michigan)
Programming Principles, Data Structures, Web scraping, Web Services, Restful API, Interactive Data Visualization, Relational Databases: SQL & Design, Network Protocols, XML, JSON, Data Analysis, Data Processing, Data Cleansing
PostgreSQL for Everybody Specialization Dr. Charles R. Severance (University of Michigan)
Database Design, Database Architecture and Administration, Application Deployment, Natural Language Processing, Text Mining, Database Management, Database Systems SQL, Stored Procedure, Distributed Computing, JSON, Cloud Applications, Cloud Deployment, Data Modeling, NoSQL
Excel Skills for Data Analysis & Visualization Prof Prashan Karunaratne & Nicky Bull (Macquarie University)
Data Visualization Software, Dashboard, Data Presentation, Power BI, Excel Macros, Data Manipulation, Infographics, Data Storytelling, Data Transformation, Data Sharing
Excel/VBA for Creative Problem Solving Dr. Charlie Nuttelman (University of Colorado Boulder)
Programming Principles, Excel Macros, Visual Basic for Applications(Programming Language), Automation, User Interface (UI), Simulations, Code Review, File I/O, Debugging, Data Validation, Algorithms, Data Cleansing, Data Management, Data Import/Export
The Ultimate Git Course Mosh Hamedani
Branching, Merging, Rebasing, Pull Requests, GitHub collaboration, Visual diff tools