Oracle SQL& PL SQL online training

/Oracle SQL& PL SQL online training
Oracle SQL& PL SQL online training 2018-05-21T00:10:09+00:00

Oracle SQL & PL SQL online training:

Oracle 11g is an enterprise software company that develops and sells a relational database management system (RDBMS). Oracle is considered as a “Data ware house system”, which can manage data, store data & BAR (BACKUP, ARCHIVE &RESTORE) data.

Oracle11g online training shares the knowledge of gathering the data from multiple sources and makes it available for the analysis.

Oracle11g training masters the learners in using the tool for business analysis, storage of data in the offsite recovery center and its retrieval.

Teradata training provides a full range of capabilities that allow you to:

  • Oracle 11g database Installation
  • Introduction to RDBMS
  • All Components implementation
  • Structured Query Language(SQL)
  • Commands in SQL
  • Working with DDL,DML,TCL Commands
  • Integrity Constraints, joins, Views
  • Working with database objects
  • Locks and SQL Plus editor commands PL/SQL
  • Advanced PL/SQL
  • PL/SQL with Multiple real-time scenarios
  • Migration from One instance to another instance
  • Oracle11g Administration concepts
  • Oracle 11g Real-time issues trouble shooting and solution providers.

Oracle11g course is designed for those certified professionals who are looking for Great career as Architect in DWH Technology.

SQL-PL-SQL Online Training
Course Duration : 40 Hours

  • Reviewing basic architecture concepts, Oracle 10g Architecture,Main features of 9i and 10g
  • Writing the statement  in sqlplus, Running the SELECT statement
  • Single Column, Descending order, Multiple column sort
  • Working with complex conditions, AND OR NOT ,,,, LIKE BETWEEN
  • Pseudo Columns, Rownum, Sysdate, User & UID, the Dual Table
  • Working with character functions
    UPPER, LOWER, INITCAP,  RPAD(), TRIM(), SUBSTR(), INSTR(),  TRANSLATE(), REPLACE(),  GREATEST(), LEAST(),
  • Working with date functions
    TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY()
  • ROUND(), TRUNC(), SIGN(), Working with multiple tables,
    Different type of Joins, Writing Outer Joins
  • Union, Intersect, Minus
  • Single Row subqueries, Multiple row Subqueries
  • Rollback, Commit, Savepoint
  • Creating the Tree structure, LEVEL, CONNECT BY
  • INSERT, UPDATE, DELETE
  • CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE
  • Not Null Constraint, Check Constraint, Unique Constraint, Primary Key Constraint, References Constraint, On Delete Cascade, On Delete Set Null
  • Views, Sequences, Synonyms, Indexes
    USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS
  • Object Privileges, Granting access to objects
PL -SQL
  • Structure, Writing Anoyomous Blocks
  • Oracle Datatypes, TYPE and ROWTYPE declarations, Value assignments
  • IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, LOOP END , LOOP statement, WHILE condition, FOR condition
  • Implicit and Explicit Cursors, Cursor Manipulation statements, OPEN FETCH CLOSE EXIT WHEN
  • Predefined Exceptions, Non-Predefined Excecptions, User Defined Exceptions
  • Creating and Calling Procedures
  • Creating and Calling Functions
  • Package Header, Package Body
  • Format of standard packages in an application, Spec and Body, NOCOPY hint ————- thoery
  • Database triggers, CALLing procedures from triggers
  • EXECUTE IMMEDIATE, DBMS_SQL package
  • DBMS_OUTPUT, UTL_FILE
  • Associative Arrays, Nested tables, VARRAYs
  • 12+ Years of Real-time BI architect Experience in IT Industry
  • Worked on OBIA certified professional with various Great MNC’s
  • Real-time project oriented training with step-by-step Scenarios.
  • Technical and functional and migrations and security design Documentation approaches
  • Covering the Pre-requisites for learning PL SQL
  • Completed 250+ coaching Assignment around 800 students

The Oracle PL SQL training contains all real time industry standards with ERP and multiple domains.

Quick Enquiry