Events: SQL 101 Lunch & Learn

Events: SQL 101 Lunch & Learn

Join us!

OnPlan is proud to sponsor NWOUG Lunch & Learn session "SQL 101" lead by our own Miguel Martinez  Reserve your seat today! This event is free for NWOUG members, and also open for non-members for $15 per person.

Event:

SQL 101 - An Introduction

When:

Tuesday, September 13th - 11:30 AM to 1:00 PM

Where:

Banfield Pet Hospital - Vancouver Campus Community Room
18101 SE 6th Way, Vancouver, WA

(Columbia Tech Center - off of Mill Plain between 164th and 192nd)

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)

About the Speaker:

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.