PDF Add to WishList
Increase productivity and maximize the potential of SQL to formulate intricate queries for Oracle databases. In this training course, you learn to solve business problems easily, efficiently, and elegantly with only a few lines of SQL code, and gain the practical skills to choose the best query method — ensuring accuracy and avoiding common errors or pitfalls.
The uses of SQL queries
Enhancing query performance
Extending the use of aggregates
Defining sliding window boundaries
Creating inner and outer joins
How and when to use self-joins
Applying the ANSI standard join syntax
Manipulating the set operators
Handling correlated subqueries
Subqueries in the FROM clause
Subqueries as expressions
Overcoming obstacles with views
Temporary tables as alternatives to views
Course Tuition Includes:
After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.
Free Course Exam
You can take your Learning Tree course exam on the last day of your course or online any time after class.
Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm