Chaz's Portfolio

Chaz’s Portfolio Page: SQL & Business Analysis

Here I will showcase some sample independent coding I have done, showing different skills and tools I am able to use in SQL, then I will show a more in depth analysis process from start to finish using SQL.

A sample of some SQL code I wrote independently for an online learning exercise

The ER Diagram for the Database used in this exercise
Using subqueries
More subquerying
Using INNER JOIN
Using NOT IN to find different entries in similar columns of different tables
Using UNION

This is from the same class as the code above, same database, more query types:

The ER Diagram for the Database used in this exercise
Using || operator and UPPER function to modify columns in a single table
Using date times in calculations to create a new column
Using SUBSTR function to create a new column for categorization within a single table
Using the COUNT aggregate function to help analyze customers by region
Using LEFT JOIN to combine all invoice data with appropriate customer data

Peer Reviewed SQL Project

This is the Yelp Reviews database ER diagram used for the project, provided by Coursera