In my college career, I learned about database design and how they are implemented. Most of this work was done through Microsoft Excel and Access in SQL format. This involved learning relationships between tables and how to manage them appropriately, along with creating diagrams related to the database schemas. Below are links to the SQL queries and database schemas that I created in the database design class. They involve scenarios such as a database for a repair company and a doctor’s office for treatment. The relevant files are within the links per query name on GitHub.

• SQL #1 (CIS 310 – Database Design) – For this assignment, I was tasked with running different queries to pull database information. This included mainly the use of SELECT TOP 1000 queries to pull column data.
• SQL #2 (CIS 310 – Database Design) – In this assignment, I had to run combinations of SELECT, FROM, WHERE queries to pull refined data. This included the use of ‘WHERE FIRST_NAME LIKE ‘S%” to display only names that started with the letter S.
• SQL #3 (CIS 310 – Database Design) – Within this assignment, I ran different types of queries to filter the desired data. This involved setting range, finding the minimum value, generate sum values, and more.
• SQL #4 (CIS 310 – Database Design) – For this assignment, I completed queries that utilized INNER JOIN commands to connect two tables together. I also used a query to display invoice numbers matching a specific name in the table after the INNER JOIN.
• SQL #5 (CIS 310 – Database Design) – Finally, this assignment took into account our previous work and applied most aspects. This involved the use of SELECT DISTINCT, JOIN, and SUM queries.