Jordan Valdespino

July 1, 2019

Structured Query Language Basics

Structured Query Language (SQL) is the standard language used for retrieving and manipulating database information. Today’s blog, I will be focusing on how we can use this language to simply get an organized result set back that answers a specific question. This will be accomplished by using the Select, From, Where, Group By, Having, and Order By clauses We will be using the EMPLOYEES table in the HR schema from Oracle live as our practice table. You can find the structure of the table in the image below. This can be accessed for free. All you need is an oracle […]
April 4, 2019

Oracle Certified Professional Exam Prep

How I prepared for (and passed) the Oracle Certified Professional exam.