Oracle Database 10g : Introduction to SQL Course SitesPower Training Institute
Price: TBC

    Course details

    Course Overview

     

    This course introduces Oracle Database 10g technology and the relational database concepts and the powerful SQL programming language. This course provides the learners with the essential SQL skills of querying the database, the meta data and creating database objects. In addition, the course also delves into the advanced querying and reporting techniques, data warehousing concepts and manipulating large data sets in different time zones. This is the prerequisite to the OCP DBA and OCP Developer tracks.

     

    Audience:
    Database Administrators, PL/SQL Programmer, Forms Developer, System Analysts, Technical Consultant

     

    Course Objectives:
    Search data using advanced sub queries
    Retrieve row and column data from tables with the SELECT statement
    Employ SQL functions to generate and retrieve customized data
    Run data manipulation statements (DML) to update data in the Oracle Database 10g
    Control user access and manage schema objects

    Course Outline

    • Introduction 
    • Retrieving Data Using the SQL SELECT Statement 
    • Restricting and Sorting Data 
    • Using Single Row Functions to Customize Reports 
    • Reporting Aggregated Data Using the Group Functions 
    • Displaying Data From Multiple Tables 
    • Using Sub queries to Solve Queries 
    • Using the SET Operators 
    • Manipulating Data 
    • Using DDL Statements to Create and Manage Tables 
    • Creating Other Schema Objects 
    • Managing Objects with Data Dictionary Views 
    • Write queries that retrieve information from the dictionary views on the schema objects
    • Controlling User Access 
    • Manage Schema Objects 
    • Manipulating Large Data Sets 
    • Generating Reports by Grouping Related Data 
    • Managing Data in Different Time Zones 
    • Searching Data Using Advanced Sub queries 
    • Hierarchical Data Retrieval 
    • Performing Regular Expression Support and Case Insensitive

     

    About SitesPower Training Institute

    About SitesPower

    Resulting from our proven track record of customer satisfaction, SitesPower has been granted numerous international, elite authorizations and achievements in the short time since launching in 2001, not to mention having our courses Accredited by the Ministry of Education.  As an independent training provider, rather than a franchisee, these are true accomplishments. Authorizations include PMI, ILM (UK), Microsoft, RedHat, EC-Council, ITIL (EXIN), City & Guilds, AutoDesk, Adobe & ICDL.

    See all SitesPower Training Institute courses

    IT, Computing and Technology Related Questions

    Contact information not available.

    Are you from SitesPower Training Institute ? Claim your course!
    Courses you can instantly connect with... ORACLE (Database Administration Track) Jurassic Institute of Management and Technology ORACLE (Application Development Track) Jurassic Institute of Management and Technology Oracle WebLogic Server 12c: Administration I New Horizons Computer Learning Center-Dubai

    Is this the right course for you?

    Rate our content

    Didn't find what you were looking for ?

    or