...

• Oracle User Guide
  • Logical SQL Reference
    • This appendix provides syntax and usage information for the Logical SQL statements understood by the Oracle BI Server. Oracle BI Server Logical SQL includes standard SQL, plus special functions (SQL extensions) such as AGO, TODATE, EVALUATE, and others.

Regular Expressions

• Tutorial
• Cheat sheet

SQL

• W3Schools SQL tutorial and reference

• Skillport e-Learning Professional Development Courses, Videos, and E-Books

  • Access through your campus portal or CSYou and use the search box

  • Courses average 1 hour in length

  • Search for "PL/SQL" - Procedural Language/SQL is the flavor used by Oracle while Transact SQL (T-SQL) is used by Windows SQL server.
  • Courses
    • Introduction to SQL, By: Aaron Sampson
    • Generic Database Fundamentals: Relation Algebra, SQL, and Concurrency Concepts, By: Aaron Sampson
    • Oracle Database 12c - Introduction to SQL: Working with Joins and Subqueries 
  • e-books
    • Oracle PL/SQL For Dummies, By: Michael Rosenblum, Paul Dorsey  (Includes handy syntax and code example cheat sheets)
    • Introduction to SQL and PL/SQL, By: Sharad Maheshwari, Ruchin Jain
    • Beginning Oracle PL/SQL, Second Edition By: Donald J. Bales
    • Oracle and PL/SQL Recipes: A Problem-Solution Approach, By: Josh Juneau, Matt Arena

...