SQL, Python, data visualization, web development, technical writing

SQL

The SQL code examples in my GitHub repository were written for both my introductory and advanced SQL courses at Portland Community College. The introductory course focused on Microsoft SQL Server and T-SQL. The advanced course reviewed the Microsoft environment before plunging into Oracle's PL/SQL. After learning PL/SQL, we returned to T-SQL to apply there the more advanced skills we had learned in the Oracle environment.

Below are two examples of code I wrote in these courses. A more extensive sample of my code is found at my GitHub repository. The first example below is a query written in T-SQL; the second example is part of a larger program written in PL/SQL.

Microsoft T-SQL

The code below was written in my introductory SQL course. It is concerned with information related to the amount of air time given to specific television genres. Below is the original prompt given by the instructor, followed by my code:

"For each genre, calculate the total minutes spent airing shows in that genre. Then, calculate the total percent of time dedicated to that genre. Show the genre formatted to 20 characters wide, the total number of minutes, and the percentage of minutes. Only include rows where the total number of minutes was 1000 or more. Display in descending order by total minutes. In the case of ties, order alphabetically by genre."

The intended outcome was 88 rows, shown truncated below:

Oracle PL/SQL

The following script is part of a larger program that also includes a stored procedure and two triggers. We were also tasked with writing a test script. It was written in my advanced SQL course.

After user input has been validated, the values are passed to a stored procedure. Two triggers then run before any data is modified. The purpose of the program was to mimic how a user might update inventory data based on an order a customer had placed.