A curated, searchable resource library for SQL, Data Analytics, AI, Excel, Power BI, Python, GitHub, and lifelong learning.
The Data Nerd Library began as a personal Google Sheet to organize the best learning resources I discovered while transitioning from healthcare operations into data analytics.
What started as a bookmark collection quickly became hundreds of carefully organized resources—including SQL tutorials, GitHub repositories, newsletters, AI tools, books, YouTube channels, certifications, podcasts, and interactive learning games.
Instead of losing great resources in browser bookmarks, I wanted a single place to organize everything and eventually build a searchable application around it.
This repository documents that journey.
- Build the ultimate personal knowledge library
- Organize high-quality learning resources
- Track learning progress
- Store personal notes and ratings
- Practice SQL using real-world data
- Eventually replace the spreadsheet with a relational database
- Build a full-stack web application
✅ Google Sheets Resource Library
Current features include:
- Hundreds of curated resources
- Clickable official URLs
- Categories
- Resource descriptions
- Tags
- Organized tabs
- Regular updates
Google Sheets MVP
- Resource collection
- Categorization
- Official URLs
- Searchable spreadsheet
Database Design
- SQL schema
- Tables
- Relationships
- Normalization
Web Application
- Search
- Filters
- Favorites
- Ratings
- Notes
- Learning Progress
AI Features
- Resource recommendations
- Personalized learning paths
- Duplicate detection
- Smart tagging
Community Edition
- User accounts
- Shared collections
- Community recommendations
- Public API
- 📖 Books
- 🎥 YouTube
- 🎓 Courses
- 🎮 Interactive Games
- 💻 GitHub Repositories
- 🤖 AI Tools
- 📰 Newsletters
- 📝 Blogs
- 🎙 Podcasts
- 📊 Datasets
- 📄 Documentation
- 💬 Communities
- 📱 Apps
- 🧩 Coding Challenges
- 🏆 Certifications
- Resource ID
- Title
- Description
- URL
- Category
- Difficulty
- Cost
- Resource Type
- Author
- Platform
- SQL
- Excel
- Python
- Power BI
- Tableau
- AI
- Git
- GitHub
- Statistics
- Data Visualization
- Healthcare Analytics
- Compliance
- Machine Learning
Examples:
- Luke Barousse
- Alex the Analyst
- Kendra Little
- Lisa Hitch
- Bruno Aziza
- Leila Gharani
- Not Started
- In Progress
- Completed
- Reviewed
Store:
- Favorite lessons
- Helpful tips
- Personal insights
- Follow-up ideas
⭐ 1–5 stars
Would recommend?
Difficulty
Estimated completion time
Frontend
- React
- Tailwind CSS
Backend
- Node.js
- Express
Database
- PostgreSQL
ORM
- Prisma
Authentication
- Clerk
Hosting
- Vercel
Learning data analytics can feel overwhelming.
Resources are scattered across:
- YouTube
- GitHub
- Blogs
- Books
- Podcasts
- Newsletters
- Documentation
The goal of this project is to organize everything into one searchable system while serving as a practical SQL and full-stack development project.
This project is helping me practice:
- SQL
- Database Design
- Data Modeling
- Git
- GitHub
- React
- PostgreSQL
- Full-Stack Development
- API Design
- UI/UX
- Project Planning
Current Stage:
🟢 Active Development
Current Focus:
Building Version 2 (SQL Database)
This project is currently a personal learning project.
Suggestions, feedback, and ideas are always welcome.
MIT License
Hi! I'm Linnette Garcia.
I'm a healthcare compliance and Medicaid specialist transitioning into data analytics.
I'm documenting my learning journey by building real projects that solve problems I actually have.
Follow along as I learn SQL, databases, analytics, and software development—one project at a time.
- 🌐 Linnette Builds Portfolio
- 💼 LinkedIn Profile & Resume
- ✍️ Linnette Builds Newsletter
- 📰 Substack
- 💻 GitHub
-
📚 Data Nerd Library
Curated SQL, AI, Excel, Power BI, Python, GitHub, and data analytics learning resources. -
🏥 LTC Medicaid Analytics
SQL database project inspired by long-term care Medicaid workflows and healthcare analytics. -
⭐ Review Manager Tracker
AI-assisted review management application for organizing products, capturing notes, generating review drafts, and tracking review completion.
Building in public. Learning out loud. Solving real problems—one query at a time. 🤓