• Educate
  • Inspire
  • Transform
080 - 41226000 / 01 / 02 / 03
Feedback
Home > Courses > Advanced SQL with Oracle
Skeleton of the Course Advanced SQL with Oracle Training Share/Bookmark
Introduction to Advanced SQL with Oracle Training
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/div>
  • 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/li>
  • 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
  • 4. Joining Tables
  • 5. Enhancing Groups With Rollup & Cube
    • About Group Processing
    • EMP_DETAILS_VIEW
    • Simple GROUP BY /li>
    • ROLLUP Function
    • GROUPING Function
    • Using Cube
  • 6. Using Set Operators
  • 7. Conditional Processing
    • The Case Expression
  • 8. SQL Functions (Character)
  • What Are SQL Functions? /li>
  • Character Functions
  • CONCAT
  • LENGTH
  • INSTR
  • REPLACE
  • UPPER
  • LOWER
  • INITICAP
  • LPAD
  • RPAD
  • TRIM
  • TO_CHAR
  • 9. SQL Functions (Non-Character)
  • 10. SQL Data Manipulation Language
  • The INSERT Statement
  • INSERT Statement Categories
  • The UPDATE Statement
  • The DELETE Statement
  • Transactions
  • 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
  • 13. Database Objects: Overview
  • 14. Database Objects: Views
  • Creating Views
  • Updating View Data
  • INSERT and UPDATE Statements
  • DELETE Statements
  • 15. Database Objects: Indexes
  • 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