- Locations: Al Danah
- Duration: 5 Days
- Timings 8:00 AM - 4:00 PM
This course helps the participants to write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions.
Who is this course for?
Application Developers Business Analysts Data Warehouse Administrator Developer Forms Developer PL/SQL Developer System Analysts.
Lesson 1: Introduction to Oracle Database
Lesson 2: Retrieve Data using the SQL SELECT Statement
Lesson 3: Learn to Restrict and Sort Data
Lesson 4: Usage of Single-Row Functions to Customize Output
Lesson 5: Invoke Conversion Functions and Conditional Expressions
Lesson 6: Aggregate Data Using the Group Functions
Lesson 7: Display Data From Multiple Tables Using Joins
Lesson 8: Use Sub-queries to Solve Queries
Lesson 9: The SET Operators
Lesson 10: Data Manipulation Statements
Lesson 11: Use of DDL Statements to Create and Manage Tables
Lesson 12: Other Schema Objects
Lesson 13: Control User Access
Lesson 14: Management of Schema Objects
Lesson 15: Manage Objects with Data Dictionary Views
Lesson 16: Manipulate Large Data Sets
Lesson 17: Data Management in different Time Zones
Lesson 18: Retrieve Data Using Sub-queries
Lesson 19: Regular Expression Support
About New Horizons Computer Learning Center-Abu Dhabi
As changes in technology have accelerated, it’s become even more essential for people to master technology to be productive, invaluable employees who optimize, program and invent solutions—and even grow companies of their own. For 30 years, New Horizons has provided more than 30 million students with industry-leading technical training that delivers the most relevant and intuitive computer courses and certifications. We’re now the world’s largest independent IT training company, and we continue to lead:
- 300 computer training centers in 70 countries (and counting)
- Largest Guaranteed-to-Run course schedule in the world
- Ranked in the top 5% of the industry for training quality and customer satisfaction
- Official training partner for technology leaders such as Microsoft, Cisco, CompTIA and VMware
- Microsoft’s largest training provider, delivering more than 40% of all authorized Microsoft training worldwide
- World’s largest Cisco-authorized training partner
New Horizons is an authorized partner to the top technology providers. For students that means training with the highest quality source materials and the latest products and technologies. For businesses it means getting the highest return on their training investment.
Invest in courses and certifications that advance careers:
The largest Guaranteed-to-Run course schedule in the world includes an extensive array of vendor-authorized IT training and all the in-demand Microsoft, Cisco, CompTIA and VMware certifications.
Learn in your own way:
All of New Horizons’ award-winning learning methods deliver the same comprehensive content—in online and traditional classroom settings, at your worksite, and self-paced with one-on-one support.
Continuously upgrade the people who drive your business:
We’ll create innovative training solutions that work for your business and we’ll account for the results—whether your company is small, mid-sized or a global enterprise. New Horizons training yields a 4:1 benefit-to-cost ratio, based on manager surveys of the improved performance and productivity immediately following our training.See all New Horizons Computer Learning Center-Abu Dhabi courses