Scribd Logo
Upload

Welcome to Scribd!

  • 68 views

    Brochure-Oracle 12c Introduction To SQL

    Uploaded by

    Chew Yong Soon
    This 5-day Oracle Database: Introduction to SQL training course teaches participants how to write SQL queries, combine queries, report aggregated data, and use advanced SQL features through hands-on exercises. The course covers retrieving, restricting, and sorting data; single-row functions; joins; subqueries; set operators; data manipulation; data definition; data dictionary views; sequences, synonyms, and indexes; and controlling user access. Upon completion, participants will be able to refine code, create reports, manipulate data, control database access, manage schema objects, and retrieve and manage data using SQL.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Brochure-Oracle 12c Introduction To SQL

    Uploaded by

    Chew Yong Soon
    68 views2 pages
    This 5-day Oracle Database: Introduction to SQL training course teaches participants how to write SQL queries, combine queries, report aggregated data, and use advanced SQL features through hands-on exercises. The course covers retrieving, restricting, and sorting data; single-row functions; joins; subqueries; set operators; data manipulation; data definition; data dictionary views; sequences, synonyms, and indexes; and controlling user access. Upon completion, participants will be able to refine code, create reports, manipulate data, control database access, manage schema objects, and retrieve and manage data using SQL.

    Original Description:

    Brochure-Oracle 12c Introduction to SQL

    Original Title

    Brochure-Oracle 12c Introduction to SQL

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This 5-day Oracle Database: Introduction to SQL training course teaches participants how to write SQL queries, combine queries, report aggregated data, and use advanced SQL features through hands-on exercises. The course covers retrieving, restricting, and sorting data; single-row functions; joins; subqueries; set operators; data manipulation; data definition; data dictionary views; sequences, synonyms, and indexes; and controlling user access. Upon completion, participants will be able to refine code, create reports, manipulate data, control database access, manage schema objects, and retrieve and manage data using SQL.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    68 views2 pages

    Brochure-Oracle 12c Introduction To SQL

    Uploaded by

    Chew Yong Soon
    This 5-day Oracle Database: Introduction to SQL training course teaches participants how to write SQL queries, combine queries, report aggregated data, and use advanced SQL features through hands-on exercises. The course covers retrieving, restricting, and sorting data; single-row functions; joins; subqueries; set operators; data manipulation; data definition; data dictionary views; sequences, synonyms, and indexes; and controlling user access. Upon completion, participants will be able to refine code, create reports, manipulate data, control database access, manage schema objects, and retrieve and manage data using SQL.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    Contact Us:

    76, Jalan Teluk Sisek, 25000 Kuantan, Pahang


    Tel: 09-5143498 Fax: 09-5133608
    [email protected]

    Duration: 5 Days

    Intro:
    This Oracle Database: Introduction to SQL training
    helps you write subqueries, combine multiple
    queries into a single query using SET operators
    and report aggregated data using group functions.
    Learn this and more through hands-on exercises.

    Program Overview:
    Benefits to You
    Ensure fast, reliable, secure and easy to manage
    performance. Optimize database workloads, lower
    IT costs and deliver a higher quality of service by
    enabling consolidation onto database clouds.
    Learn Advanced Features of SQL
    This course will help you understand the advanced
    features of SQL. Learning these features will help
    you query and manipulate data within the
    database, use the dictionary views to retrieve
    metadata and create reports about their schema
    objects. Some of the date-time functions available
    in the Oracle Database are also covered. This
    course also discusses how to use the regular
    expression support in SQL through expert
    instruction.
    Use Development Tools
    The main development tool used in this training is
    Oracle SQL Developer. SQL*Plus is available as
    an optional development tool. This is appropriate
    for a 10g, 11g and 12c audience.

    Course Content:
    Introduction
    Retrieving Data using the SQL SELECT Statement
    Restricting and Sorting Data

    Using Single-Row Functions to Customize Output


    Using Conversion Functions and Conditional
    Expressions
    Reporting Aggregated Data Using the Group
    Functions
    Displaying Data from Multiple Tables Using Joins
    Using Subqueries to Solve Queries
    Using the SET Operators
    Managing Tables using DML statements
    Introduction to Data Definition Language
    Introduction to Data Dictionary Views
    Creating Sequences, Synonyms, Indexes
    Creating Views
    Managing Schema Objects
    Retrieving Data by Using Subqueries
    Manipulating Data by Using Subqueries
    Controlling User Access
    Manipulating Data
    Managing Data in Different Time Zones

    Programme Outcome:
    Understand the basic concepts of relational
    databases ensure refined code by developers.
    Create reports of sorted and restricted data.
    Run data manipulation statements (DML).
    Control database access to specific objects.
    Manage schema objects
    Manage objects with data dictionary views.
    Retrieve row and column data from tables.
    Control privileges at the object and system level.
    Create indexes and constraints; alter existing
    schema objects.
    Create and query external tables.

    Contact Us:
    76, Jalan Teluk Sisek, 25000 Kuantan, Pahang
    Tel: 09-5143498 Fax: 09-5133608
    [email protected]

    You might also like