help_outline Skip to main content
HomeEventsPDX: SQL 101 - An Introduction

Events - Event View

This is the "Event Detail" view, showing all available information for this event. If the event has passed, click the "Event Report" button to read a report and view photos that were uploaded.

PDX: SQL 101 - An Introduction

When:
Tuesday, September 13, 2016, 11:30 AM until 1:00 PM
Where:
Banfield Pet Hospital - Vancouver Campus Community Room
18101 SE 6th Way
Vancouver, WA  
Additional Info:
Event Contact(s):
Julie Harroun
Category:
Lunch & Learn
Registration is required
Payment In Full In Advance Only
$15.00
No Fee

Session Summary:

Provide a basic overview of SQL queries and related database concepts.  The objective is to help those that are new to SQL or use it infrequently to get a better understanding of how to construct a query and how Oracle is processing a query and returning results.  This learning session should help users increase their confidence that their queries are going to return accurate results in a timely manner.

Target Audience:

Business analysts or application users that write reports or ad hoc queries from time to time.

Topics:

  1. SQL Structure - SELECT, FROM , WHERE, GROUP BY, ORDER BY
  2. Table vs Synonym vs View - definitions
  3. Constructing a SQL statement
  4. SQL Tuning - how Oracle is processing a query (indexing, statistics)

Miguel Martinez has focused on Oracle applications development and systems analysis for the past 14 years. His background includes supporting Xerox with their Oracle applications as a Developer/BSA, and eventually Delivery Manager, beginning in 2010. He has been a valued expert as part of the OnPlan team since 2011, helping customers get over the hurdles related to converting complex business requirements into suitable, efficient solutions in a timely manner.