One of the foundational courses for the Computer Science department at DePaul is learning databases. This class had a large learning curve for me because of how different SQL is as a programming language.

The Relational Model
relational model A.sql

Starting out we had to learn the Relational model to understand how databases work conceptually. The project can be viewed in more detail here .

Simple SQL
simple SQL

After getting used to SQL a little more, this project was meant to show us simple implementations in (technically) real world situations of databases and their uses. The project can be viewed in more detail here .

Intermediate SQL
intermediate sql

This project allowed us to learn about more complex implementations of databases using multiple tables. These tables had various forms of employee information and their jobs. More details into the project and its files can be viewed here .

Advanced SQL
advanced sql code

Here we learned more advanced SQL that implemted recursion in the context of a social network. This brought me back to learning path finding algorithms in my data structures and algorithms classes. More of the project can be seen here .

More Advanced SQL
more advanced SQL

This was one of the hardest assignment projects I've had to do, but it allowed me to see java's uses when working with databases (even if it's an oudated method). The main goal of the assignment was seeing how to inject a database into a java program to add infomration via java. More of the project can be seen here .