Introduction to Oracle SQL Etisalat Academy
  • Locations: Dubai
  • Duration: 5 Days
  • Call: +971 4 2753240

    Course details

    In a world where business units are becoming more self sufficient and knowledgeable about managing their overall processes through the use of technology, it becomes extremely important to identify the value of data and its interaction. Raw data needs to be manipulated into information that can be used for checking performance, setting strategies and for decision making. SQL is a data definition and data manipulation language for relational databases. By using SQL it is possible to create a database, load it with data and read ft update both data and data definitions.

    Expected Accomplishments

    • Create and maintain Oracle tables
    • Insert, update, delete data from Oracle tables
    • Produce complex queries
    • Format queries in to Reports

    Course Outline

    • Introduction to SQL
    • Data Dictionary
    • The SELECT statement
    • Substitution variables
    • Functions
    • Sub-queries
    • Joining tables
    • Report formatting
    • Views
    • Users, privileges and synonyms, security
    • Data manipulation
    • Table bcking
    • Nested functions
    • Advanced SQL *Plus techniques
    • SQL *P!us performance tuning, using Explain Plan

    Who Can Benefit

    • Anyone who handles large volumes of data.

    Related Training

    • Oracle DBA: Administration Workshop I
    • Oracle DBA: Program with PL/SQL

    mode

    • Consultant led classes including theory and lab practicals.

    Prerequisites

    • Knowledge of the basic concepts and terminology of relational database management system and operating system

    Course Location

    About Etisalat Academy

    We_They is the largest single-source business and telecom training solutions provider in the Middle East. For 30 years we have been providing training consultancy and human capital development services to telecoms, government agencies, oil & gas companies, financial institutions and organizations across all industries and business sectors.

    We provide training and development programs ranging from cutting-edge technology courses in 3G, WiMAX, VoIP or IPTV, to career-changing leadership masterclasses, strategy workshops and business management seminars.

    Based in the UAE and operating a 1.2 Million square feet training facility in Dubai, our partner network spans two continents and delivers world class training solutions to customers in over 28 countries in GCC and MENA regions.

    We help organisations to:

    • Develop effective leaders, managers and team members
    • Discover and overcome competency gaps
    • Measure and improve performance
    • Build teams and improve communication
    • Recruit and retain talent
    • Build a knowledge culture
    • Create an organisation-wide competency framework
    • Stay competitive by using cutting-edge technology
    See all Etisalat Academy courses

    SQL Server Related Questions

    Contact information not available.

    Are you from Etisalat Academy ? Claim your course!
    Courses you can instantly connect with... Oracle PL/SQL Rolla Computer and Management Training

    Is this the right course for you?

    Rate our content

    Didn't find what you were looking for ?

    or