Oracle 10g/11g Online Training

Oracle 10g/11g Online Training

  • ABOUT THE COURSE
    • Course Duration

      6 hours of live training by qualified professionals with more than 5 years of experience

      Training Materials

      1. High quality recorded video lectures of every session
      2. Access to remote server to practice assignments
      3. Soft copy of the course material
      4. 24*7 guidance by faculty

      What’s Needed To Join This Course?

      Students must have little knowledge about SQL and must be familiar with basics of Oracle.

      Who Are Ideal Candidates?

      Freshers or professionals with little knowledge on database and willing to see themselves in higher positions by enhancing their skills.

      Course Info

      We introduce you to oracle in our module I, module II will assist you with oracle database management products, etc. Each and every session is well planned beforehand and is executed in the same manner.

      Highlights Of The Course

      1. Perfection in oracle based courses
      2. Hands experience with practical examples and real time projects
      3. Overview of different application of Oracle 10g and 11g
      4. Complete set of course material and life time access to course recordings

      Why NORTH TECH SYSTEMS?

      Our institute is one of the leading platforms in producing experts in oracle database domains. We provide free demo classes so that you can understand the format of teaching and join the institute based on your convenience. Our qualified and experienced faculty will teach all aspects of oracle to give you complete understanding of it and to prepare you for the job. Some of the notable features of our institute include:

      1. Live training by experienced professionals in the field
      2. Expert lectures by professionals serving the IT industries in Oracle domain
      3. Affordable fee structure
      4. Career guidance
      5. Quizzes to help students enhance their knowledge
      6. Certificate on course completion
  • CURRICULUM
    • Oracle 10g/11g Course Details

      The Oracle database environment

      Reviewing basic architecture concepts Oracle 10g Architecture Main features of 9i and 10g

      Basic SQL*PLUS commands

      Using script files, START, @, GET, SAVE, LIST, PROMPT, PAUSE, ACCEPT, DEFINE, SPOOL

      Basic SELECT Statement

      Writing the statement in sql plus, Running the SELECT statement

      Ordering the output

      Single Column, Descending order, multiple column sorts

      Conditional retrieval of data

      Working with complex conditions, AND OR NOT LIKE BETWEEN

      Working with variables

      Creating and using variables, Command substitution

      Pseudo columns and functions

      Pseudo Columns, Row num, Sys date, User & UID, the Dual Table Working with character functions UPPER, LOWER, INITCAP, RPAD(), RTRIM(), SUBSTR(), INSTR(), TRANSLATE(), REPLACE(), GREATEST(), LEAST(), DECODE Working with date functions TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY()

      Using non-character function

      ROUND (), TRUNC (), SIGN (), Working with multiple tables, Different type of Joins, Writing Outer Joins

      Using the SET operators

      Union, Intersect, minus

      Aggregating data using group functions

      GROUP BY, HAVING

      Creating Sub queries

      Single Row sub queries, Multiple row Sub queries

      Enhancing groups function

      ROLLUP, CUBE

      Transaction Control Languag

      Rollback, Commit, save point

      Processing hierarchies

      creating the Tree structure, LEVEL, CONNECT BY

      Data Manipulation Language

      INSERT, UPDATE, DELETE

      Data Definition Language

      CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE

      Using Declarative Constraints

      Views, Sequences, Synonyms, Indexes, USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS, USER_IND_COLUMNS, USER_UPDATEABLE_COLUMNS, Materialized Views, Other Data dictionary views

      Database Security

      Object Privileges, Granting access to objects

      Improving query performance

      Planning and managing the tuning process, Employing tuning tools, Running EXPLAIN PLAN and auto trace, SQL Trace and TKPROF output, Optimizer concepts, Fundamentals of access paths, Gathering object and system statistics with DBMS_STATS, Utilizing hints and optimizer mode, Specifying first-rows optimization, Determining the driving table Other Concepts

      The Relational Database Model, The system Development Lifecycle, Overview of normalization

      PL/SQL Blocks

      Structure, Writing Anonymous Blocks

      Variables

      Oracle Data types, TYPE and ROWTYPE declarations, Value assignments

      Control structures

      IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, LOOP END , LOOP statement, WHILE condition, FOR condition

      Cursors

      Implicit and Explicit Cursors, Cursor Manipulation statements, OPEN FETCH CLOSE EXIT WHEN

      Printing Values to ScreenProcedures

      Creating and Calling Procedures

      Functions

      Creating and Calling Functions

      Package

      Package Header, Package Body

      Design Tips and Techniques

      Format of standard packages in an application, Spec and Body, NOCOPY hint

      Triggers

      Database triggers, calling procedures from triggers

      Dynamic SQL

      EXECUTE IMMEDIATE, DBMS_SQL package

      Oracle Supplied packages

      DBMS_OUTPUT, UTL_FILE

      Collection data types

      Associative Arrays, Nested tables, VARRAYs

  • ROADMAP
    • Oracleonline_training

  • REVIEWS
    • “Your courses are outstanding. I cannot even imagine anyone doing better than this.” – Peter B
      “The demonstrations were most valuable since there isn’t an option to use free software where I work.” – Dana Bolender
  • FAQ's
    • Content will be coming soon

Copyrights @2018-All rights reserved