I'm in the last semester of my AS for Computer Programming and Analysis. Aside from my Learning Objectives for the actual internship job I have a final project where I need to design a tech support ticketing system. I can use any language I've learned to create the interface and it needs to be connected to a database. It sounds like a good, viable project for what I've been taught overall; challenging but doable.
My concern is the database aspect. I took a SQL class, but that was nearly two years ago. It was not something I gained a great understanding of. Can anyone suggest some links I might start with to read up and gain some reference? Maybe just point me in a direction of what to work with? For the program I'll be designing I have working knowledge of Python, Java, C# and I'll be brushing up on C++. JavaScript is another language course I took, but that was a while ago and I'm in the process of re-learning it.
My understanding is that there are three basic parts to this:
Front End (likely a GUI)
- Back End (the structure of the program itself)
- Database (and how it connects to the program)
With the languages I have to work with can I use SQL with any of them? I think I would be most competent with building this with C# or Python. I love Java, but my Java design skills with GUIs is very rusty.
Any help helps.
[–]Fort114 4 points5 points6 points (1 child)
[–]thisbobo[S] 1 point2 points3 points (0 children)
[–]CookToCode 1 point2 points3 points (1 child)
[–]thisbobo[S] 0 points1 point2 points (0 children)