SQL Advanced Techniques 2

About this Event

Designed to expand beyond the learner's basic knowledge of SQL to leverage the functionality of their Oracle database and develop custom Argos applications. The learner will create custom functions and tables on the database using inserts, deletes and updates. Attendees will work on guided exercises throughout the class to apply the concepts in both SQL Developer and Argos. (This is part 2 of a 4-part class.)

Audience

Employees with a good grounding in how to create basic SQL and are looking to expand their knowledge to optimize SQL and leverage Oracle functionality to create custom functions and tables. This class does not cover basics of SELECT, FROM, WHERE.

Prerequisites

Completed Argos Advanced – DataBlock Designer training (or have similar familiarity with the tool).

Completed SQL Advanced Techniques (Part 1) training.

Strong novice, with a good understanding of basic SELECT FROM WHERE statement and joins.

Attendees will also need:

• Strong internet connection

• Dual monitors

• Headset (for better audio and interaction)

• Once registered, print out all materials sent by trainer

Agenda

SQL Advanced Techniques (Part 2) Training is conducted remotely over three days.

The general agenda is as follows:

SQL Advanced Techniques (Part 2) Training

Days 1-3 (5 hrs. each day, 11:00am-4:00pm ET)

• Use a column number in the order by clause

• Distinct – when to use.

• Max, min, average, count, sum

• Group by: Describe and use

• Create SQL for chart

• Describe and use the pivot function

• Unions: Describe the 4 types of unions: union, union all, intersect and minus

• Describe when to use them Unions

• Create and use a union operator

• Having Datasets in Banded and Extract reports

 

Fee : 1000 USD

Registration Link :  sql-advanced-techniques-2