SQL Portfolio Project Part 2: Create a Context File

In this second installment of my SQL Portfolio Project series, I show you how to create a context file that transforms GitHub Copilot from a generic code suggester into a project-aware assistant. You'll learn how to give Copilot the information it needs to understand your project's goals, structure, and conventions — so it can generate code, documentation, and file organization that actually fits what you're building. In this video, you'll learn: ✅ What a context file is and why it matters for AI-assisted coding ✅ How to structure a context file so Copilot understands your project's scope and goals ✅ How to reference your context file when prompting Copilot in VS Code ✅ Tips for keeping Copilot's suggestions aligned with your portfolio project as it grows ✅ How this sets up a cleaner, more maintainable project framework This is part of an ongoing series where I document the full process of building a SQL portfolio project from scratch — perfect for anyone learning SQL, building a portfolio for job applications, or looking to use AI tools more effectively in their development workflow. 📌 Missed Part 1?    • SQL Portfolio Project Part 1: Choosing You...   📌 Next up, Part 3 - Generating Data: Coming Soon! 💬 Got questions or suggestions for the series? Drop them in the comments — I read every one! 🔔 Subscribe for the rest of the series and more SQL/data projects. #SQL #GitHubCopilot #VSCode #DataAnalytics #SQLPortfolio #AIcoding #LearnSQL #DataEngineering #DevWorkflow