Group Client Project: ILT Academy Learning Portal

Client: Nick Tietz, CEO/Founder ILT Academy

ILT Academy Learning Portal

Solo Capstone Project: ...Where To Next?

Try it out for yourself!

...where to next?

My Film Collection - student project demo

Jurassic Gallery - student project demo

I had to solve the problem of unknown SQL query parameters depending on which destination features the user selects while using Where to Next.

an image of a function created to count placeholders for a SQL query

I learned a lot about SQL while creating Where to Next. This is one of my three queries depending on if the user selects international, domestic, or both.

an image of SQL query text which selects destinations based on internationa and domestic both being true, as well as the preferences the user selected

my database design for my scope document for Where to Next

an image of a database design