> ## Documentation Index
> Fetch the complete documentation index at: https://rajanand.org/llms.txt
> Use this file to discover all available pages before exploring further.

# Explore

[Home](/) • [About](/about) • [Blog](/blog) • [Certifications](/certifications) • [Contact](/contact)

## [Data](/data)

1. [Types of Data](/data/types-of-data)
2. [Delta Lake](/data/delta-lake)
3. [Delta Lake Protocol](/data/delta-lake-protocol)
4. [Delta table: Insert](/data/delta-table-insert)
5. [Delta table: Update](/data/delta-table-update)
6. [Delta table: Delete](/data/delta-table-delete)

## Data Modeling

1. [Conceptual Data Model](/data-modeling/conceptual-data-model)
2. [Logical Data Model](/data-modeling/logical-data-model)
3. [Physical Data Model](/data-modeling/physical-data-model)
4. [Dimension Table](/data-modeling/dimension-table)
5. [Fact Table](/data-modeling/fact-table)
6. [Star Schema](/data-modeling/star-schema)
7. [Snowflake Schema](/data-modeling/snowflake-schema)
8. [Inmon Data modeling approach](data-modeling/inmon-data-model)
9. [Kimball Data modeling approach](data-modeling/kimball-data-model)

## [Spark](/spark)

1. [Spark: Overview](/spark/overview)
2. [Spark: DataFrames](/spark/spark-dataframe)
3. [Spark: Dataset](/spark/spark-dataset)
4. [Spark: Resilient Distributed Datasets (RDDs)](/spark/spark-rdd)
5. [Spark: Datasets vs DataFrames](/spark/spark-datasets-vs-dataframes)
6. [Spark: Transformations vs Actions](/spark/spark-transformations-vs-actions)
7. [Spark: Collect vs Take](/spark/spark-collect-vs-take)
8. [Spark: Data Types](/spark/spark-datatypes)
9. [Spark: Shuffle Join](/spark/spark-shuffle-join)
10. [Create DataFrames in Spark](/spark/spark-create-dataframe)
11. [How Spark Executes Your Program?](/spark/how-spark-executes-your-program)

### Spark Optimization

1. [Predicate Pushdown](/spark/spark-predicate-pushdown)

## [SQL](/sql)

1. [SQL: Overview](/sql/overview)
2. [SQL Standards](/sql/sql-standards)
3. [SQL Query Order of Execution](/sql/sql-query-order-of-execution)
4. [Qualify Clause in SQL](/sql/sql-qualify-clause)

### SQL-101

1. [Essential Concepts in SQL](/sql/sql-essential-concepts)
2. [Read data in SQL](/sql/read-data-in-sql)
3. [Aggregations in SQL](/sql/aggregations-in-sql)
4. [Understanding Joins in SQL](/sql/joins-in-sql)
5. [Exploring Subqueries in SQL](/sql/subqueries-in-sql)
6. [Working with Data in SQL](/sql/working-with-data)
7. [Creating and Modify Tables in SQL](/sql/creating-and-modifying-tables)
8. [Relationships Between Tables in SQL](/sql/relationships-between-tables)

## [Python](/python)

1. [Python: Guide](/python/python-guide)
2. [Python: List Examples](/python/python-list-examples)
3. [Python: Tuple Examples](/python/python-tuple-examples)
4. [Python: Dictionary Examples](/python/python-dictionary-examples)
5. [Python: Function Examples](/python/python-function-examples)
6. [Python: Simple Programs - Part 01](/python/python-simple-programs-part-01)

## [AI](/ai)

1. [How to install DeepSeek in Windows and run locally?](/ai/how-to-install-deepseek-in-windows)

## [Data Factory](/data-factory)

1. [Azure Data Factory: Parameters vs. Variables](/data-factory/adf-parameters-vs-variables)
2. [SSIS to ADF Migration Questions](/data-factory/adf-migration-questions)

## [Databricks](/databricks)

## Microsoft Fabric

1. [Fabric Security](/fabric/fabric-security-all-you-need-to-know)

## [Certifications](/certifications/index)

1. [Microsoft Certifications](/certifications/microsoft)
2. [Databricks Certifications](/certifications/databricks)
3. [Snowflake Certifications](/certifications/snowflake)
4. [Tableau Certifications](/certifications/tableau)
5. [Google Certifications](/certifications/google)
6. [GitHub Certifications](/certifications/github)
7. [Oracle Certifications](/certifications/oracle)
8. [AWS Certifications](/certifications/aws)

## [Notes](/notes)

### DeepLearning.ai Data Engineering

#### Introduction to Data Engineering

1. [Introduction to Data Engineering: Overview](/notes/intro-to-data-engineering/intro-to-data-engineering)
2. [Data Engineering Lifecycle](/notes/intro-to-data-engineering/data-engineering-lifecycle)
3. [Data Engineering Undercurrents](/notes/intro-to-data-engineering/data-engineering-undercurrents)
4. [Data Architecture](/notes/intro-to-data-engineering/data-architecture)
5. [Choose the Right Technology](/notes/intro-to-data-engineering/choose-right-technology)
6. [Requirements Gathering](/notes/intro-to-data-engineering/requirements-gathering)

#### Source Systems, Ingestion, and Data Pipelines

1. [Source Systems](/notes/source-systems-data-ingestion-and-pipelines/source-systems)
2. [Data Ingestion](/notes/source-systems-data-ingestion-and-pipelines/data-ingestion)

## [Glossary](/glossary)

<Icon icon="circle-a" iconType="duotone" size="20" /> [ACID Properties](/glossary/acid-properties)
• [ADLS](/glossary/adls)
• [Apache Airflow](/glossary/apache-airflow)
• [Apache Arrow](/glossary/apache-arrow)
• [Apache Hadoop](/glossary/apache-hadoop)
• [Apache Hudi](/glossary/apache-hudi)
• [Apache Iceberg](/glossary/apache-iceberg)
• [Apache ORC](/glossary/apache-orc)
• [API](/glossary/api)
• [Artificial Intelligence](/glossary/artificial-intelligence)
• [Authentication](/glossary/authentication)
• [Authorization](/glossary/authorization)
• [Availability](/glossary/availability)

<Icon icon="circle-b" iconType="duotone" size="20" /> [Batch Processing](/glossary/batch-processing)
• [Big Data](/glossary/big-data)
• [Business Intelligence](/glossary/business-intelligence)

<Icon icon="circle-c" iconType="duotone" size="20" /> [CAP Theorem](/glossary/cap-theorem)
• [Change Data Capture (CDC)](/glossary/change-data-capture)
• [Cloud Computing](/glossary/cloud-computing)
• [Cloud data warehouse](/glossary/cloud-data-warehouse)
• [Cloud native](/glossary/cloud-native)
• [Cloud object storage](/glossary/cloud-object-storage)
• [Compute engines](/glossary/compute-engines)
• [Consensus Algorithms](/glossary/consensus-algorithms)
• [Consistency](/glossary/consistency)
• [CPU](/glossary/cpu)
• [CSV file format](/glossary/csv)

<Icon icon="circle-d" iconType="duotone" size="20" /> [Data Lake](/glossary/data-lake)
• [Data Lakehouse](/glossary/data-lakehouse)
• [Data Transformation](/glossary/data-transformation)
• [Data Warehouse](/glossary/data-warehouse)
• [Distributed System](/glossary/distributed-system)

<Icon icon="circle-e" iconType="duotone" size="20" /> [ELT](/glossary/elt)
• [ETL](/glossary/etl)

<Icon icon="circle-f" iconType="duotone" size="20" /> [Fault Tolerance](/glossary/fault-tolerance)

<Icon icon="circle-l" iconType="duotone" size="20" /> [Lazy Evaluation](/glossary/lazy-evaluation)

<Icon icon="circle-o" iconType="duotone" size="20" /> [OLAP](/glossary/olap)
• [OLTP](/glossary/oltp)

<Icon icon="circle-r" iconType="duotone" size="20" /> [Reliability](/glossary/reliability)

<Icon icon="circle-s" iconType="duotone" size="20" /> [Scalability](/glossary/scalability)