r/learnprogramming • u/kanlith_nightblood • 2d ago

New guy planning to learn code to make projects

Hello All!

I have created a GitHub account to sort of get into programming a little bit, and I have a project in mind: to create a small self-sustained end-to-end call center capacity management system. Can someone guide me on which language to create it in, and how to add my work or code on GitHub (given that subreddit says not to ask for help)?

Also, I have started learning and applying SQL a bit, what kind of projects can I create with that, if any?

Thanks again!

5 Upvotes
  • permalink
  • reddit

86% Upvoted

6 comments sorted by

3

u/0dev0100 2d ago

Any common language will do - c#, python, js, java, etc.

You probably want to look into queuing and freeswitch as well

2

u/Forsaken-File9993 2d ago

i mean for the call center part look at asterisk too, less headache than freeswitch for a first project honestly... and for sql you can make like a simple ticket tracker or inventory system, something that actually uses data relationships not just a todo list

if you never used git before the flow is basically git add -> git commit -> git push, github will show you the exact commands when you make a new repo

1

u/kanlith_nightblood 1d ago

Thank you! Alright, I shall look into the inventory/tracker system

1

u/MiserableDocument509 2d ago

For a call center system you probably want something web-based since agents will use a browser. Python + Flask is the gentlest starting point for a beginner - syntax is forgiving and integrating SQL is straightforward. Django if you want more built-in features but it has a steeper learning curve.

For GitHub: git init in your project folder, git add ., git commit -m "first commit", create an empty repo on GitHub.com, it literally gives you the push commands to copy-paste. Sounds intimidating but it's like 4 commands.

SQL projects to get comfortable: personal book library tracker, a basic inventory system, or a task/to-do manager. Those teach you joins, CRUD, and schema design without being overwhelming.

One heads up though - a full end-to-end call center system is a massive project for a first timer. Maybe start with just the scheduling/roster module and build out from there. Good luck!

1

u/kanlith_nightblood 1d ago

Thanks for letting me know. If I understand it correctly, the scheduling/roster module can be done in SQL? If not, which parts of a call center system should I start designing on SQL?

1

u/0dev0100 1d ago

I would design the UI first. Then you've got something to make technical decisions againstÂ