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

# Welcome!

export const CertificationList = [{
  id: 'microsoft',
  label: 'Microsoft',
  items: [{
    id: 'microsoft-certified-solutions-expert-data-management-and-analytics',
    title: 'Microsoft Certified Solutions Expert: Data Management & Analytics',
    icon: 'https://mintlify-assets.b-cdn.net/tail-icon.svg',
    image: '/assets/certifications/microsoft-certified-solutions-expert-mcse-data-management-and-analytics-badge.png',
    href: '/certifications/microsoft#microsoft-certified-solutions-expert%3A-data-management-and-analytics',
    isActive: true,
    tags: ['Microsoft', 'Data', 'Analytics']
  }, {
    id: 'microsoft-certified-solutions-associate-database-development',
    title: 'Microsoft Certified Solutions Associate: Database Development',
    icon: 'https://mintlify-assets.b-cdn.net/smart-light.svg',
    image: '/assets/certifications/microsoft-certified-solutions-associate-mcsa-sql-2016-database-development-badge.png',
    href: '/certifications/microsoft#microsoft-certified-solutions-associate%3A-database-development',
    isActive: true,
    tags: ['Microsoft']
  }, {
    id: 'microsoft-certified-solutions-associate-bi-reporting',
    title: 'Microsoft Certified Solutions Associate: BI Reporting',
    icon: 'https://mintlify-assets.b-cdn.net/broom-light.svg',
    image: '/assets/certifications/microsoft-certified-solutions-associate-mcsa-business-intelligence-reporting-badge.png',
    href: '/certifications/microsoft#microsoft-certified-solutions-associate%3A-bi-reporting',
    isActive: true,
    tags: ['Microsoft']
  }, {
    id: 'microsoft-certified-azure-data-engineer-associate',
    title: 'Microsoft Certified: Azure Data Engineer Associate',
    icon: 'https://mintlify-assets.b-cdn.net/tail-icon.svg',
    image: 'https://raw.githubusercontent.com/rajanand/rajanand-ilangovan/refs/heads/master/certifications/microsoft-certified-azure-data-engineer-associate-badge.png',
    href: '/certifications/microsoft#microsoft-certified%3A-azure-data-engineer-associate',
    isActive: true,
    tags: ['Microsoft']
  }, {
    id: 'microsoft-certified-fabric-data-engineer-associate',
    title: 'Microsoft Certified: Fabric Data Engineer Associate',
    icon: 'https://mintlify-assets.b-cdn.net/broom-light.svg',
    image: 'https://raw.githubusercontent.com/rajanand/rajanand-ilangovan/refs/heads/master/certifications/microsoft-certified-fabric-data-engineer-associate-badge.png',
    href: '/certifications/microsoft#microsoft-certified%3A-fabric-data-engineer-associate',
    isActive: true,
    tags: ['Microsoft']
  }, {
    id: 'microsoft-certified-fabric-analytics-engineer-associate',
    title: 'Microsoft Certified: Fabric Analytics Engineer Associate',
    icon: 'https://mintlify-assets.b-cdn.net/smart-light.svg',
    image: 'https://raw.githubusercontent.com/rajanand/rajanand-ilangovan/refs/heads/master/certifications/microsoft-certified-fabric-analytics-engineer-associate-badge.png',
    href: '/certifications/microsoft#microsoft-certified%3A-fabric-analytics-engineer-associate',
    isActive: true,
    tags: ['Microsoft']
  }, {
    id: 'microsoft-certified-power-bi-data-analyst-associate',
    title: 'Microsoft Certified: Power BI Analyst Associate',
    icon: 'https://mintlify-assets.b-cdn.net/tail-icon.svg',
    image: 'https://raw.githubusercontent.com/rajanand/rajanand-ilangovan/refs/heads/master/certifications/microsoft-certified-power-bi-data-analyst-associate-badge.png',
    href: '/certifications/microsoft#microsoft-certified%3A-power-bi-data-analyst-associate',
    isActive: true,
    tags: ['Microsoft']
  }]
}, {
  id: 'databricks',
  label: 'Databricks',
  items: [{
    id: 'databricks-certified-data-engineer-associate',
    title: 'Databricks Certified Data Engineer Associate',
    desc: 'Designing and implementing data engineering solutions using Databricks',
    icon: 'https://mintlify-assets.b-cdn.net/neural-light.svg',
    image: 'https://raw.githubusercontent.com/rajanand/rajanand-ilangovan/refs/heads/master/certifications/databricks-certified-data-engineer-associate-badge.png',
    href: '/certifications/databricks#databricks-certified-data-engineer-associate',
    isActive: true,
    tags: ['Databricks']
  }]
}, {
  id: 'snowflake',
  label: 'Snowflake',
  items: [{
    id: 'snowpro-associate-platform-certification',
    title: 'SnowPro Associate: Platform Certification',
    desc: 'Understanding Snowflake data platform and its features',
    icon: 'https://mintlify-assets.b-cdn.net/neural-light.svg',
    image: 'https://raw.githubusercontent.com/rajanand/rajanand-ilangovan/refs/heads/master/certifications/snowflake-snowpro-associate-platform-certification-badge.png',
    href: '/certifications/snowflake#snowpro-associate:-platform-certification',
    isActive: true,
    tags: ['Snowflake']
  }]
}, {
  id: 'google',
  label: 'Google',
  items: [{
    id: 'google-cloud-certified-associate-cloud-engineer',
    title: 'Google Cloud Certified Associate Cloud Engineer',
    desc: 'Deploying applications, monitoring operations, and managing enterprise solutions on Google Cloud',
    icon: 'https://mintlify-assets.b-cdn.net/neural-light.svg',
    image: 'https://raw.githubusercontent.com/rajanand/rajanand-ilangovan/refs/heads/master/certifications/google-cloud-associate-cloud-engineer-badge.png',
    href: '/certifications/google#google-cloud-certified-associate-cloud-engineer',
    isActive: true,
    tags: ['Google']
  }]
}, {
  id: 'tableau',
  label: 'Tableau',
  items: [{
    id: 'tableau-desktop-specialist',
    title: 'Tableau Desktop Specialist',
    desc: 'Able to connect to Tableau desktop and prepare, explore and analyze data, and share insights.',
    icon: 'https://mintlify-assets.b-cdn.net/neural-light.svg',
    image: 'https://raw.githubusercontent.com/rajanand/rajanand-ilangovan/refs/heads/master/certifications/tableau-desktop-specialist-badge.png',
    href: '/certifications/tableau#tableau-desktop-specialist-certification',
    isActive: true,
    tags: ['Tableau']
  }]
}, {
  id: 'oracle',
  label: 'Oracle',
  items: [{
    id: 'oracle-autonomous-database-cloud-2019-certified-specialist',
    title: 'Oracle Autonomous Database Cloud 2019 Certified Specialist',
    desc: 'Specialized in Oracle Autonomous Database Cloud services',
    icon: 'https://mintlify-assets.b-cdn.net/tail-icon.svg',
    image: 'https://raw.githubusercontent.com/rajanand/rajanand-ilangovan/refs/heads/master/certifications/oracle-autonomous-database-cloud-2019-specialist-badge.png',
    href: '/certifications/oracle',
    isActive: true,
    tags: ['Oracle']
  }, {
    id: 'oracle-cloud-infrastructure-2019-certified-architect-associate',
    title: 'Oracle Cloud Infrastructure 2019 Certified Architect Associate',
    desc: 'Architecting and managing Oracle Cloud Infrastructure solutions',
    icon: 'https://mintlify-assets.b-cdn.net/smart-light.svg',
    image: 'https://raw.githubusercontent.com/rajanand/rajanand-ilangovan/refs/heads/master/certifications/oracle-cloud-infrastructure-2019-certified-architect-associate-badge.png',
    href: '/certifications/oracle#oracle-cloud-infrastructure-2019-certified-architect-associate',
    isActive: true,
    tags: ['Oracle']
  }, {
    id: 'oracle-cloud-infrastructure-2019-certified-cloud-operations-associate',
    title: 'Oracle Cloud Infrastructure 2019 Certified Cloud Operations Associate',
    desc: 'Managing and operating Oracle Cloud Infrastructure services',
    icon: 'https://mintlify-assets.b-cdn.net/broom-light.svg',
    image: 'https://raw.githubusercontent.com/rajanand/rajanand-ilangovan/refs/heads/master/certifications/oracle-cloud-infrastructure-2019-cloud-operations-certified-associate-badge.png',
    href: '/certifications/oracle#oracle-cloud-infrastructure-2019-certified-cloud-operations-associate',
    isActive: true,
    tags: ['Oracle']
  }, {
    id: 'oracle-cloud-infrastructure-foundations-2021-certified-associate',
    title: 'Oracle Cloud Infrastructure Foundations 2021 Certified Associate',
    desc: 'Foundational knowledge of Oracle Cloud Infrastructure services',
    icon: 'https://mintlify-assets.b-cdn.net/neural-light.svg',
    image: 'https://raw.githubusercontent.com/rajanand/rajanand-ilangovan/refs/heads/master/certifications/oracle-cloud-infrastructure-foundations-2021-associate-badge.png',
    href: '/certifications/oracle#oracle-cloud-infrastructure-foundations-2021-certified-associate',
    isActive: true,
    tags: ['Oracle']
  }, {
    id: 'oracle-cloud-infrastructure-foundations-2020-certified-associate',
    title: 'Oracle Cloud Infrastructure Foundations 2020 Certified Associate',
    desc: 'Foundational knowledge of Oracle Cloud Infrastructure services',
    icon: 'https://mintlify-assets.b-cdn.net/neural-light.svg',
    image: 'https://raw.githubusercontent.com/rajanand/rajanand-ilangovan/refs/heads/master/certifications/oracle-cloud-infrastructure-foundations-2020-associate-badge.png',
    href: '/certifications/oracle#oracle-cloud-infrastructure-foundations-2020-certified-associate',
    isActive: true,
    tags: ['Oracle']
  }]
}, {
  id: 'github',
  label: 'Github',
  items: [{
    id: 'github-foundations-certification',
    title: 'GitHub Foundations Certification',
    desc: ' GitHub basics like repositories, commits, branching, markdowns, and project management.',
    icon: 'https://mintlify-assets.b-cdn.net/smart-light.svg',
    image: 'https://raw.githubusercontent.com/rajanand/rajanand-ilangovan/refs/heads/master/certifications/github-foundations-badge.png',
    href: '/certifications/github#github-foundations-certification',
    isActive: true,
    tags: ['Github']
  }]
}, {
  id: 'microstrategy',
  label: 'MicroStrategy',
  items: [{
    id: 'microstrategy-certified-analyst',
    title: 'MicroStrategy Certified Analyst',
    icon: 'https://mintlify-assets.b-cdn.net/tail-icon.svg',
    image: 'https://raw.githubusercontent.com/rajanand/rajanand-ilangovan/refs/heads/master/certifications/microstrategy-certified-analyst-badge.png',
    href: '/certifications/microstrategy#microstrategy-certified-analyst',
    isActive: false,
    tags: ['MicroStrategy']
  }, {
    id: 'microstrategy-certified-application-architect',
    title: 'MicroStrategy Certified Application Architect',
    icon: 'https://mintlify-assets.b-cdn.net/smart-light.svg',
    image: 'https://raw.githubusercontent.com/rajanand/rajanand-ilangovan/refs/heads/master/certifications/microstrategy-certified-application-architect-badge.png',
    href: '/certifications/microstrategy#microstrategy-certified-application-architect',
    isActive: false,
    tags: ['MicroStrategy']
  }]
}];

export const ProductTiles = ({categories: initialCategories, hideButtons = false, showInactive = false, filterByCategory = null}) => {
  if (!initialCategories || initialCategories.length === 0) {
    return null;
  }
  const activeAndFilteredCategories = initialCategories.map(category => ({
    ...category,
    items: category.items.filter(item => {
      const isActive = item.isActive === undefined ? true : item.isActive;
      return isActive || showInactive;
    })
  })).filter(category => category.items.length > 0);
  const categoriesToShow = filterByCategory ? activeAndFilteredCategories.filter(cat => cat.id === filterByCategory) : activeAndFilteredCategories;
  const [activeCategory, setActiveCategory] = useState(categoriesToShow[0]?.id || null);
  const [activeSubTab, setActiveSubTab] = useState(categoriesToShow[0]?.items[0]?.id ?? null);
  const currentCategory = categoriesToShow.find(cat => cat.id === activeCategory);
  const currentSub = currentCategory?.items.find(item => item.id === activeSubTab);
  if (categoriesToShow.length === 0) {
    return <p className="text-sm text-gray-500 dark:text-gray-400">
            No items available to display.
        </p>;
  }
  return <div className="not-prose space-y-6">
      {!hideButtons && !filterByCategory && <div className="flex flex-wrap gap-2">
          {categoriesToShow.map(cat => <button key={cat.id} onClick={() => {
    setActiveCategory(cat.id);
    setActiveSubTab(cat.items[0]?.id ?? null);
  }} className={`px-4 py-2 text-sm rounded-full font-medium transition-colors ${activeCategory === cat.id ? 'bg-[#0A0B0D] text-white dark:bg-white dark:text-[#0A0B0D] border-black' : 'bg-gray-100 dark:bg-white/10 text-black dark:text-white'}`}>
              {cat.label}
            </button>)}
        </div>}

      <div>
        {currentCategory?.items?.length ? <div className="flex flex-col lg:flex-row gap-6 bg-gray-100 dark:bg-[#141414] rounded-2xl">
            <div className="flex flex-col w-full lg:w-1/2 space-y-2 p-4">
              {currentCategory.items.map(item => <a key={item.id} href={item.href} onMouseOver={() => setActiveSubTab(item.id)} className={`flex items-start gap-1.5 text-left px-5 py-3 rounded-2xl transition-all ${activeSubTab === item.id ? 'bg-white dark:bg-white/5' : ''}`}>
                  <div className="text-xl mr-3 mt-1"><img src={item.icon} alt={item.title} className="w-8 h-8" /></div>
                  <div className="flex-1">
                    <h3 className="font-medium text-base text-black dark:text-white">
                      {item.title}
                    </h3>
                    <p className="text-sm text-gray-600 dark:text-gray-400">{item.desc}</p>
                  </div>
                  <div className={`flex items-center justify-center min-w-[24px] self-center ${activeSubTab === item.id ? 'opacity-100' : 'opacity-0'}`}>
                    <div className="hidden dark:block">
                      <Icon icon="chevron-right" size="14" color="#FFF" />
                    </div>
                    <div className="block dark:hidden">
                      <Icon icon="chevron-right" size="14" color="#0A0B0D" />
                    </div>
                  </div>
                </a>)}
            </div>
            <div className="group w-full h-fit lg:w-1/2 rounded-2xl flex items-center justify-center  overflow-hidden min-h-[320px] p-4">
              {currentSub?.image ? <>
                  <img src={currentSub.image.light} alt={currentSub.title} className="block dark:hidden w-[350px] h-[350px] object-contain rounded-xl" />
                  <img src={currentSub.image.dark} alt={currentSub.title} className="hidden dark:block w-[350px] h-[350px] object-contain rounded-xl" />
                </> : <p className="text-gray-400 dark:text-gray-500 p-8">No preview available</p>}
            </div>
          </div> : <p className="text-sm text-gray-500 dark:text-gray-400">
            No items available for this category.
          </p>}
      </div>
    </div>;
};

export const Title = ({children}) => {
  return <div className="text-gray-900 dark:text-gray-200 text-2xl tracking-tight">
      {children}
    </div>;
};

export const Container = ({children}) => {
  return <div className="max-w-8xl w-[90%] mx-auto px-4 lg:px-10 py-14">
      {children}
    </div>;
};

<Container>
  <div className="flex flex-col items-center justify-center py-16">
    <h1 className="text-4xl font-medium text-center text-gray-900 dark:text-zinc-50 tracking-tight">
      Rajanand Ilangovan
    </h1>

    <div className="mt-2 text-lg text-center text-gray-200 dark:text-zinc-200">
      Data Architect
    </div>

    <div className="mt-4 max-w-2xl text-center text-gray-300 dark:text-gray-300">
      Experienced in designing and building scalable data platforms and cloud solutions.
    </div>

    <a href="/about" className="mt-6 px-6 py-2 rounded-full bg-[#F54E00] text-white font-semibold hover:bg-blue-700 transition">
      About Me
    </a>
  </div>
</Container>

<Container>
  <Title>Articles</Title>

  <ul className="list-decimal ml-6 mt-4 space-y-2">
    <li><a href="/sql/how-to-generate-numbers-table-in-sql">How to generate numbers table in SQL?</a></li>
    <li><a href="/sql-server/sql-server-performance-tuning-and-troubleshooting-checklist">SQL Server Performance tuning and troubleshooting checklist</a></li>
    <li><a href="/sql/useful-sql-queries">How to concatenate multiple rows into a single string in SQL?</a></li>
    <li><a href="/sql-server/how-to-enable-dark-mode-in-ssms">How to enable dark mode in SSMS?</a></li>
    <li><a href="/data/delta-table-insert">How DML operations works in delta table?</a></li>
    <li><a href="/data/delta-lake-protocol">Delta Lake Protocol: Overview</a></li>
  </ul>
</Container>

<Container>
  <Title>Datasets</Title>

  <div className="mt-4 max-w-2xl text-left text-gray-300 dark:text-gray-300">
    These are some of the public datasets I have curated and made available on <a href="https://www.kaggle.com/rajanand" target="_blank" rel="noopener noreferrer" className="dark:text-blue-400 font-bold">Kaggle</a>.
  </div>

  <Columns cols={3}>
    <Card title="Crime in India" icon="house-fire" href="https://www.kaggle.com/datasets/rajanand/crime-in-india" horizontal />

    <Card title="Rainfall in India" icon="cloud-sun-rain" href="https://www.kaggle.com/datasets/rajanand/rainfall-in-india" horizontal />

    <Card title="Education in India" icon="books" href="https://www.kaggle.com/datasets/rajanand/education-in-india" horizontal />

    <Card title="Accidents in India" icon="car-burst" href="https://www.kaggle.com/datasets/rajanand/accidents-in-india" horizontal />

    <Card title="Suicides in India" icon="capsules" href="https://www.kaggle.com/datasets/rajanand/suicides-in-india" horizontal />

    <Card title="Prison in India" icon="user-police-tie" href="https://www.kaggle.com/datasets/rajanand/prison-in-india" horizontal />
  </Columns>
</Container>

<Container>
  <Title>Contact</Title>

  <div className="mt-2 text-gray-300 dark:text-gray-300">
    Send me a message on <a href="https://www.linkedin.com/in/irajanand/" target="_blank" rel="noopener noreferrer" className="dark:text-blue-400 font-bold">LinkedIn</a> or book a <a href="/meeting" className="dark:text-blue-400 font-bold">meeting</a>.
  </div>
</Container>