SQL Advanced Techniques 3

Evisions helps higher education organizations work better. Our software eases your administrative load—so you can get back to the process of learning and discovery. Built and optimized for administrators, our solutions help you stay on top of your many tasks and responsibilities, reduce hassle and waste, and work more efficiently.

Evisions

SQL Advanced Techniques 3 for Argos users.

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 3 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 &amp; Part 2) 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 3) Training is conducted remotely over three days.
The general agenda is as follows:
SQL Advanced Techniques (Part 3) Training 
Days 1-3 (5 hrs. each day, 11:00am-4:00pm ET)
•	Joins: inner, outer right, outer left
•	Create joins in the visual designer
•	Add joins to data dictionary
•	Create joins with free type
•	Subqueries: Scalar, Noncorrelated, Correlated, In line view
•	Subqueries with in, not in, exist, not exist
•	With clause
•	Insert, Update and Delete using SQL Variables and Banner Letter Generation

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

SQL Advanced Techniques 3

More events from Evisions

Follow organizers to get events picked for you

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.

SQL Advanced Techniques 3

More events from Evisions

Follow organizers to get events picked for you

You might also like...

Sign-In for personalized recommendations

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.