• Educate
    		•
  • Inspire
    		•
  • Transform
    		•
    		080 - 41226000 / 01 / 02 / 03
    Home Register Corporate Training Feedback Contact Us
    Home > Courses > Advanced SQL with Oracle
    Introduction to Advanced SQL with Oracle Training Share/Bookmark

    Advanced SQL with Oracle Training Overview

    • This Oracle SQL training class helps students master SQL using an Oracle database and prepares students for a PL/SQL course. Note that this course is an Oracle SQL course, not a PL/SQL course.
    Advanced SQL with Oracle Training Class Goals
    • Learn to create Users and Schemas.
    • Learn to use pseudo-columns and functions.
    • Learn to write simple and correlated subqueries.
    • Learn to write simple and complex joins.
    • Learn to use ROLLUP and CUBE.
    • Learn to use SET operators.
    • Learn to use character and non-character SQL functions.
    • Learn to write INSERT, UPDATE, and DELETE statements.
    • Learn to create tables.
    • Learn to use keys and constraints to protect data integrity.
    • Learn to use views, indexes, sequences, and synonyms.
    Advanced SQL With Oracle Courseware
    • Users and Schemas
      • Introduction to Users and Schemas
      • Definitions and Client Tools
      • SQL Developer Login
      • About the HR Schema
      • Sample Schemas
      • HR Schema Entities
      • Creating An Application Schema
      • Exercise: Create a User
    • Pseudo Columns & Functions
      • Using The Dual Table
      • Functions
      • Exercise: Use the SYSCONTEXT function
      • Pseudo-Columns
      • Using Rowid
      • Using Rownum
      • Exercise: Use ROWNUM
    • Using Subqueries
      • Simple Subqueries
      • Definition
      • Nested Subquery
      • Inline Views
      • Subquery in the HAVING clause
      • Correlated Subqueries
      • Scalar Subquery
      • Exercise: Subqueries
    • Joining Tables
      • Review of Joins
      • Equijoins
      • Inner Joins
      • Outer Joins
      • Cross Joins
      • Reflexive Join
      • Non-Key Join
      • Natural Joins
      • Semijoins and Antijoins
      • Using Named Subqueries
      • Exercise: Join Exercises
    • SQL Functions (Character)
      • What Are SQL Functions?
      • Character Functions
      • Regular Expressions
      • Exercise: Character Functions
    • SQL Functions (Non-Character)
      • Numeric Functions
      • The TO_CHAR Function with numbers
      • Date/Time Functions
      • Date Format Functions
      • Date Arithmetic Functions
      • Null Value Functions
      • Exercise: SQL Non-Character Functions
    • SQL Data Manipulation Language
      • The INSERT Statement
      • INSERT Statement Categories
      • The UPDATE Statement
      • The DELETE Statement
      • Transactions
      • Complex Table References
      • The MERGE statement
      • Exercise: Data Manipulation Language (DDL)
    • SQL Data Definition Language
      • About SQL DDL
      • Create Table Statement
      • Populate the table
      • Alter Table Statement
      • Drop Table Statement
      • CREATE TABLE using SELECT
      • Truncate Table Statement
    • Data Integrity Using Constraints
      • About Constraints
      • Unique Key
      • Primary Key
      • Referential Integrity
      • Check Constraint
      • Defining Constraints On Existing Tables
      • Enabling & Disabling Constraints
      • Renaming & Dropping Constraints
      • Validate New Transactions Only
      • Constraint Exceptions
    Ph: +91- 080 - 41226000 / 01 / 02 / 03
    Email: infoschool.in@gmail.com
    Login
    E-Mail:*
    Password:*
      register
    Contact counselors
    Training @ infoschool
    Success stories
    I got the opportunity of getting a practical experience on SAS couse from InfoSchool. It helped me in learning new analytical tools and their applications, today I am in my dream job. Thanks to InfoSchool for giving this opportunity.

    By Vidya,
    SAS Developer, PowerSoft Technologies,
    Copyright 2009 infoschool.in © All right reserved