# ConsoleFlare

## ConsoleFlare

- [Python Installation](https://docs.consoleflare.com/python/python-installation.md): Installation guide
- [Pandas and SQL](https://docs.consoleflare.com/python/pandas-and-sql.md)
- [Data Analytics Project](https://docs.consoleflare.com/projects/data-analytics-project.md)
- [Courier Analytics Challenge](https://docs.consoleflare.com/projects/data-analytics-project/courier-analytics-challenge.md)
- [Solution](https://docs.consoleflare.com/projects/data-analytics-project/solution.md)
- [Skytrax Airline Review Analysis Pipeline](https://docs.consoleflare.com/projects/skytrax-airline-review-analysis-pipeline.md)
- [Setting up Azure SQL Database](https://docs.consoleflare.com/projects/skytrax-airline-review-analysis-pipeline/setting-up-azure-sql-database.md)
- [SkyTrax Web Scraping](https://docs.consoleflare.com/projects/skytrax-airline-review-analysis-pipeline/skytrax-web-scraping.md)
- [Power BI](https://docs.consoleflare.com/reporting/powerbi.md): Overview
- [Installation](https://docs.consoleflare.com/reporting/powerbi/installation.md)
- [Data Sources](https://docs.consoleflare.com/reporting/powerbi/data-sources.md)
- [Important Links](https://docs.consoleflare.com/reporting/powerbi/important-links.md): Microsoft learn courses
- [Spark vs Hadoop](https://docs.consoleflare.com/pyspark-and-databricks/spark-vs-hadoop.md): In this document we will try to understand why spark is better than hadoop
- [Cluster Computing](https://docs.consoleflare.com/pyspark-and-databricks/cluster-computing.md): In this document we will try to understand what is cluster computing
- [PySpark](https://docs.consoleflare.com/pyspark-and-databricks/pyspark.md): Introduction
- [Databricks Introduction](https://docs.consoleflare.com/pyspark-and-databricks/databricks-introduction.md): In this page we will look at a brief introduction about Databricks
- [PySpark in Databricks](https://docs.consoleflare.com/pyspark-and-databricks/pyspark-in-databricks.md): In this tutorial, we will see how we can get started with Databricks
- [Reading Data with PySpark](https://docs.consoleflare.com/pyspark-and-databricks/reading-data-with-pyspark.md): In this tutorial we will see how we can read data in PySpark
- [PySpark Transformation Methods](https://docs.consoleflare.com/pyspark-and-databricks/pyspark-transformation-methods.md): In this tutorial, we will try to explore some of the common data transformation methods in PySpark
- [Handling Duplicate Data](https://docs.consoleflare.com/pyspark-and-databricks/handling-duplicate-data.md): In this tutorial, we will see some common methods for how we can handle duplicate data.
- [PySpark Action Methods](https://docs.consoleflare.com/pyspark-and-databricks/pyspark-action-methods.md): In this tutorial we will try to look at some of the common action methods in PySpark
- [PySpark Native Functions](https://docs.consoleflare.com/pyspark-and-databricks/pyspark-native-functions.md): In this tutorial we will explore some common PySpark native functions
- [Partitioning](https://docs.consoleflare.com/pyspark-and-databricks/partitioning.md): In this tutorial we will learn about Partitioning strategy in PySpark
- [Bucketing](https://docs.consoleflare.com/pyspark-and-databricks/bucketing.md): In this tutorial we learn about Bucketing strategy in PySpark
- [Partitioning vs Bucketing](https://docs.consoleflare.com/pyspark-and-databricks/partitioning-vs-bucketing.md): In this tutorial we will try to understand the difference between Partitioning and Bucketing
- [Spark Streaming](https://docs.consoleflare.com/live-data-streaming/master.md): A to-the-point Instruction/Guide for any Spark enthusiast
- [Installation Issues](https://docs.consoleflare.com/live-data-streaming/master/installation-issues.md): This page addresses some common errors and issues that you might have while installing Spark on your system.
- [Jupyter Notebook Setup](https://docs.consoleflare.com/live-data-streaming/master/jupyter-notebook-setup.md): In this guide you will see how to setup jupyter notebook as a default editor for PySpark
- [Azure Data Factory](https://docs.consoleflare.com/data-pipeline/azure-data-factory.md)
- [Smart Contract Guide](https://docs.consoleflare.com/blockchain/smart-contract-guide.md): A simple guide for developing and deploying smart-contracts for Blockchain Beginners inspired by the OpenZeppelin Guide
- [Setting up a Node project](https://docs.consoleflare.com/blockchain/smart-contract-guide/setting-up-a-node-project.md): Setting up a Node project for smart-contracts
- [Developing smart contracts](https://docs.consoleflare.com/blockchain/smart-contract-guide/developing-smart-contracts.md): This guide will let you get started writing Solidity contracts
- [SQL Interview Questions](https://docs.consoleflare.com/interview-questions/sql-interview-questions.md): In this document, you can find the list of some commonly asked SQL interview questions.
- [Power BI Interview Questions](https://docs.consoleflare.com/interview-questions/power-bi-interview-questions.md): This document will try to highlight some of the most common interview questions asked in Power BI
- [Exercise 0](https://docs.consoleflare.com/t-sql-exercises/exercise-0.md): Function in SQL
- [Exercise 1](https://docs.consoleflare.com/t-sql-exercises/exercise-1.md)
- [Exercise 2](https://docs.consoleflare.com/t-sql-exercises/exercise-2.md)
- [Exercise 3](https://docs.consoleflare.com/t-sql-exercises/exercise-3.md)
- [Ultimate SQL Server Cheat Sheet](https://docs.consoleflare.com/cheat-sheet/ultimate-sql-server-cheat-sheet.md): This ultimate SQL Server cheat sheet is designed to be a quick reference guide for database administrators, developers, and data analysts. It covers fundamental commands, concepts, and best-practices.