Oracle Database: Introduction to SQL New Horizons Computer Learning Center-Abu Dhabi
Price: AED 8,100
  • Duration: 5 Days
  • Timings: 8:00 AM - 4:00 PM

    Course details

    Course Overview
    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.

    Outline
    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

    Updated on 15 August, 2016

    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
    Are you from New Horizons Computer Learning Center-Abu Dhabi ? Claim your course!
    Courses you can instantly connect with... Do an online course on IT, Computing and Technology starting now. See all courses

    Is this the right course for you?

    Didn't find what you were looking for ?

    or