1,000+ topics are planned, and we are starting with these 100 tools and topics. Every topic is planned as one short chapter in the same format: Part 1 has the most important interview questions with clear answers, and Part 2, at the very end, has short tricks and formulas to remember. Each topic book is planned at 30 to 40 pages.
Business Intelligence and Analytics
- Power BI
- DAX
- Power Query
- Tableau
- AWS QuickSight
- Looker
- Excel for Analysts
- Advanced Excel Formulas
- Data Visualization
- Statistics for Analysts
Programming
- Python
- Pandas
- NumPy
- PySpark
- Java
- JavaScript
- TypeScript
- C#
- Scala
- Shell Scripting
Databases and Data Modelling
- SQL
- Advanced SQL and Window Functions
- PostgreSQL
- MySQL
- Oracle SQL and PL/SQL
- SQL Server and T-SQL
- MongoDB
- Redis
- Snowflake
- Data Modelling
AWS
- AWS Glue
- Amazon S3
- AWS Lambda
- Amazon Redshift
- Amazon Athena
- Amazon EMR
- AWS Step Functions
- Amazon Kinesis
- AWS IAM
- Amazon EC2 and VPC
Azure
- Azure Data Factory
- Azure Synapse Analytics
- Azure Databricks
- Azure Data Lake Storage
- Azure Functions
- Azure SQL Database
- Azure Event Hubs
- Azure DevOps
- Microsoft Entra ID
- Azure Monitor
Data Engineering
- Apache Spark
- Apache Kafka
- Apache Airflow
- Hadoop and Hive
- dbt
- ETL and ELT Concepts
- Data Warehousing
- Data Lakes and Lakehouse
- Delta Lake
- Data Quality and Governance
DevOps and Cloud Tools
- Git and GitHub
- Docker
- Kubernetes
- Jenkins
- CI/CD Pipelines
- Terraform
- Ansible
- Linux Commands
- Monitoring and Logging
- Cloud Cost Basics
Testing and QA
- Manual Testing
- Selenium
- API Testing and Postman
- Test Automation Frameworks
- Cypress and Playwright
- JMeter and Performance Testing
- SQL for Testers
- Agile Testing
- BDD and Cucumber
- Test Case Design
AI and Machine Learning
- Machine Learning Basics
- Scikit-learn
- Deep Learning
- Natural Language Processing
- Generative AI and LLMs
- Prompt Engineering
- MLOps
- Feature Engineering
- Model Evaluation Metrics
- Time Series Forecasting
Core Fundamentals
- Data Structures
- Algorithms
- System Design
- REST APIs
- Microservices
- OOP and Design Patterns
- Agile and Scrum
- Networking Basics
- Operating Systems
- Cybersecurity Basics
Chapter format
- What the tool is and where it is used
- Important interview questions: basic, intermediate, advanced
- Common mistakes and how to avoid them
- Short tricks and formulas to revise before the interview
Chapters are published as they are completed. Start with the Power BI chapter, our model for all the others.