• Educate
  • Inspire
  • Transform
080 - 41226000 / 01 / 02 / 03
Feedback
Home > Cources > Oracle Advanced SQL
Advanced SQL with Oracle Share/Bookmark
Advanced SQL with Oracle Training Overview
The primary objective of this Oracle training class is to provide an introduction to the PL/SQL database programming language, based upon the latest features available in Oracle 10g.
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
1 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
2.Pseudo Columns & Functions
  • Using The Dual Table
  • Functions
  • Exercise: Use the SYSCONTEXT function
  • Pseudo-Columns
  • Using Rowid
  • Using Rownum
  • Exercise: Use ROWNUM
3.Using Subqueries
  • Simple Subqueries
  • Definition
  • Nested Subquery
  • Inline Views
  • Subquery in the HAVING clause
  • Correlated Subqueries
  • Scalar Subquery
  • Exercise: Subqueries
4.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
5.Enhancing Groups With Rollup & Cube
  • About Group Processing
  • EMP_DETAILS_VIEW
  • Simple GROUP BY
  • ROLLUP Function
  • GROUPING Function
  • Using Cube
  • Exercise: Practice GROUP BY, ROLLUP and CU
6.Using Set Operators
  • Set Operators Defined
  • Relationship to Mathematical Set Theory
  • Restrictions on Set Operators
  • Exercise: Set Operators Exercise
7.Conditional Processing
  • The DECODE Function
  • The Case Expression
  • Exercise: Conditional Processing
8.SQL Functions (Character)
  • What Are SQL Functions?
  • Character Functions
  • CONCAT
  • LENGTH
  • INSTR
  • REPLACE
  • UPPER
  • LOWER
  • INITICAP
  • LPAD
  • RPAD
  • TRIM
  • TO_CHAR
  • SOUNDEX
  • Regular Expressions
  • Exercise: Character Functions
9.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
10.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)
11.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
  • Exercise: Data Definiton Language (DDL)
12.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
  • Deferred Enforcement
  • Constraint Exceptions
  • Constraints And Views
  • Exercise: Create Constraints Exercise
13.Database Objects: Overview
  • Database Objects
  • Exercise: All Object Types
14.Database Objects: Views
  • Creating Views
  • Updating View Data
  • INSERT and UPDATE Statements
  • DELETE Statements
  • Exercise: Creating a View
15.Database Objects: Indexes
  • Types of Indexes
  • Index Characteristics
  • Index Usage
  • Exercise: Index Exercise
16.Other Database Objects
  • Sequences
  • Synonyms
  • Stored Procedures, Functions and Triggers
  • Exercise: Sequence and Synonym Exercise
Ph: +91- 080 - 41226000 / 01 / 02 / 03
Email:
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
Disclaimer | Sitemap | Contact Us