I've recently finished learning the basics of Python and SQL and want to move toward intermediate topics. Before I continue, I'd like some guidance on using GitHub effectively. How should I begin building a profile and portfolio that demonstrates my skills? Are there specific kinds of projects, habits, or mistakes I should keep in mind as I get started?
3 Answers
A good way to gain practical experience is to contribute to an open-source project. It will teach you how Git workflows, branches, pull requests, code reviews, and collaboration work in real projects. Start with beginner-friendly issues and read the project’s contribution guidelines before making changes.
Hackathons and programming competitions can be useful for practicing under realistic constraints and meeting other developers. You don’t need to be an expert before joining—beginner events are a good place to learn, and even an unfinished project can become a useful portfolio piece.
Competitions feel intimidating because many participants seem very experienced, but starting with a beginner-friendly event could help me get more comfortable.
You can also build a few small, complete projects of your own, such as a Python command-line tool, a data-cleaning script, or a SQL analysis project. Keep each project focused, write a useful README, include setup and usage instructions, and commit your work regularly so your progress is easy to follow.

That makes sense. I’ll look for beginner-friendly projects and start by reading their contribution instructions.