What Is SharePoint?
SharePoint is Microsoft's browser-based platform for storing files, organizing structured data, and publishing intranet pages, and it ships as part of the Microsoft 365 subscription alongside Teams, Outlook, and OneDrive. Every file you upload and every list row you create lives in an underlying SQL-based content database that SharePoint manages for you, so users interact only through the web interface, the SharePoint mobile app, or the REST and Graph APIs, never touching the database directly.
Cricket analogy: SharePoint is like the BCCI's central scoring and records system: individual stadiums (departments) enter match data through a web portal, but the actual ball-by-ball database lives on a central server nobody touches by hand.
Core Building Blocks
Everything in SharePoint is organized around sites, which act as the top-level container for a team, project, or department. Inside a site you create document libraries to hold files and lists to hold structured, tabular data, and both libraries and lists support custom columns, views, and metadata so you can filter and sort content the way a spreadsheet would, but with permission controls and version history built in.
Cricket analogy: A SharePoint site is like a franchise's home ground in the IPL, such as Wankhede Stadium for Mumbai Indians — everything specific to that team, from player rosters to match schedules, is organized under one venue.
Document Libraries and Lists
A document library stores actual files — Word docs, PDFs, spreadsheets — and automatically tracks version history, check-in/check-out status, and custom metadata columns like 'Department' or 'Status' that you can add without touching a database schema. A list, by contrast, holds no files by default; it behaves like a lightweight, web-based table with typed columns (text, choice, person, date, lookup) and is commonly used for trackers such as issue logs, employee directories, or approval queues.
Cricket analogy: A document library is like the BCCI's archive of official match scorecards with version history for each revision, while a list is like a simple squad-selection table with columns for player name, role, and fitness status.
GET https://contoso.sharepoint.com/sites/TeamSite/_api/web/lists/getbytitle('Tasks')/items?$select=Title,Status,DueDate&$filter=Status eq 'In Progress'
Accept: application/json;odata=verbose
Authorization: Bearer {access_token}Because SharePoint is the storage engine behind Microsoft Teams' Files tab and OneDrive's shared-library sync, learning SharePoint's site and library model also explains how file sharing works across the rest of Microsoft 365.
How Organizations Use SharePoint
In practice, organizations use SharePoint for three overlapping purposes: team collaboration sites where a project group stores working documents, communication sites that function as a polished intranet homepage or news portal, and structured business processes such as leave-request or purchase-approval workflows built with Power Automate on top of SharePoint lists. A single tenant typically contains hundreds of sites, each with its own permissions, so governance and naming conventions matter as usage scales.
Cricket analogy: It's like how a national cricket board runs three different operations under one roof: team dressing-room logistics (team sites), public match-day announcements (communication sites), and player-contract approval chains (workflows), all coordinated centrally.
Because any user with edit rights can create a new site with a single click, tenants that don't set governance policies quickly accumulate hundreds of abandoned or duplicate sites, a problem known as 'site sprawl' that makes content hard to find and audit.
- SharePoint is a browser-based Microsoft 365 platform for document storage, collaboration, and intranet publishing.
- All content lives in a managed content database accessed via the web UI, mobile app, or REST/Graph APIs.
- Sites are the top-level container; document libraries hold files, and lists hold structured tabular data.
- Document libraries add version history, check-in/check-out, and custom metadata columns to files.
- Lists behave like lightweight web tables with typed columns, used for trackers and logs.
- Organizations typically run team sites, communication sites, and Power Automate-driven workflows on SharePoint.
- Unchecked site creation leads to site sprawl, so governance policies matter as usage scales.
Practice what you learned
1. What is the top-level container for content in SharePoint?
2. Which SharePoint object is best suited for storing structured tabular data without files?
3. What automatically tracks revision history and check-in/check-out status for uploaded files?
4. Which Microsoft 365 tools rely on SharePoint's storage engine behind the scenes?
5. What problem occurs when a tenant lacks governance over who can create new sites?
Was this page helpful?
You May Also Like
SharePoint Online vs On-Premises
A comparison of cloud-hosted SharePoint Online against self-managed SharePoint Server, covering hosting, updates, licensing, and hybrid scenarios.
Sites and Site Collections
How SharePoint organizes content into sites, subsites, and site collections, and how the modern hub-site model replaced the classic hierarchy.
Navigating SharePoint
A practical guide to SharePoint's navigation elements — the app launcher, site navigation, search, and the Quick Edit and list views users rely on daily.
Related Reading
Related Study Notes in Programming
Browse all study notesApache Spark Study Notes
Programming · 30 topics
ProgrammingApache Flink Study Notes
Programming · 30 topics
ProgrammingHadoop Study Notes
Programming · 30 topics
ProgrammingSnowflake Study Notes
Programming · 30 topics
ProgrammingApache Airflow Study Notes
Programming · 30 topics
Programmingdbt (Data Build Tool) Study Notes
Programming · 30 topics