100% Satisfaction Guarantee

100% Satisfaction Guarantee

We know that starting lessons is a big step and we want you to feel confident booking with us. If you are not completely satisfied, we'll help you find a new teacher or you can receive a refund for any unused lessons within the first year from the date of purchase.

Lesson Details

See all subjects

Jake teaches

SQL
Loading-circle

About

Jake passed a background check that includes a SSN verification, national criminal record check, and sex offender registry search. Learn More
Jake delivers an exceptional lesson experience and ranks in the top 15% of our teachers nationwide.
Teaches students:
and Ages 5+

Teaching since:
2010

My experience was born from necessity and includes:
• Data mapping
• Data normalization
• Data reconciliation
• Database documentation (ERD and Data Dictionary)
• Database architecting
• Database development (Oracle and SQL Server)
• "Old school" ETL development
• Code converting from and to SQR, PL/SQL, T-SQL, all flavors of SQL, and VB(-A, -S, -.Net)
• Solution architecting
• Troubleshooting existing databases, their data, and related process.
• Troubleshooting the noted languages above as well as C#
• Teaching ANSI SQL, Oracle SQL, SQL Server SQL and MS Access

The industries that I gained this experience from were:
• Finance (lease and purchase)
• Legal (compliance with law)
• HRIS

I've worked in environments as small as a single database to as large as a single environment that contained 12 servers with thousands of schema and over a 1100+ clients; each client having their own HR, Payroll, Benefit and Leave of Absence data source. These clients also had anywhere between 5,000 and 200,000 employees.

In short, I understand and have experience with small tasks like building an automated process with MS Access to medium tasks of migrating and/or integrating newly acquired companies' HRIS to large tasks like querying, and if necessary transforming, billions of records with terabytes of data in a timely and efficient manner.

+ Read More

Experience

Product Advisor
Sep 2017 - Present
ADP

Product Support III
Feb 2016 - Sep 2017
ADP

HRIS Team Lead
Sep 2015 - Feb 2016
Acosta Sales and Marketing

HRIS Analyst II
Dec 2014 - Sep 2015
Acosta Sales and Marketing

HRIS Analyst I
Dec 2013 - Dec 2014
Acosta Sales and Marketing

Sr QA Analyst
Apr 2012 - Dec 2013
CIT Financial

Languages

English
Fluent / Native Proficiency

Certifications

A+
Jun 2017
Comptia

Awards

Certified Healthcare Reform Specialist
Feb 2016
Healthcare Reform Center & Policy Institute

1 Review

Write a Review
Christopher Wilson, Dec 4, 2017
SQL · In studio

I had the pleasure of working with Jake Riley when I was brought on board at the same company he was working for at the time. Part of my background had been in Business Intelligence so I had an understanding of relational databases but I had never written SQL code. As part of my duties documenting Access databases, Jake saw in me a potential I myself didn't realize - that being the ability to write SQL. Over time, Jake guided me through basic SQL syntax and helped me build my SQL repertoire into more complex and powerful queries - with my doubting my abilities along the way. Over the years, I've come to appreciate even more how lucky I was to work with a professional who not only has exceptional depth in the world of SQL but also has the ability to communicate that knowledge to beginners, intermediate and advanced users alike. And by the way, I am now not only a hardcore SQL junkie but it's the focus of my current position. - Chris Wilson, Master Data Analyst

+ Read More

You may want to revisit

Previously viewed teachers: