Oracle Database 11g: SQL Fundamentals


This Course guide people who want to administer the operation of an Oracle Database system, referred as database administrators (DBAs), they are responsible for creating Oracle Database, ensuring its smooth operation, and monitoring its use. Additionally the Hands-on-practice exercises help the students to know about new features and capabilities in Oracle Database 11g


Oracle Fundamental

SSDN Technologies offers training according to your requirement, either you want Oracle dba Training at your organization or instructor-led online training for yourself or classroom training at our location. We are best known for the Corporate Training for the Oracle Database Administrator in India.


After completing, participants should be able to:

  • Identify major structural components of Oracle Database 11g.
  • Create& administer Oracle Database 11g
  • Configure database for a live application.
  • Employ standard monitoring procedures.
  • Implement backup and recovery strategy in Oracle Database.
  • Appear in Oracle Online certification Exam:IZO-051

Audience:

  • Database Developers.
  • Technical Administrators.
  • Support Engineer.
  • Software Developers like JAVA, .NET, PHP.

Prerequisites:

  • Participant of this course are assumed to be familiar with relational database concepts SQL and PL/SQL.
  • They are also assumed to be familiar with the operating system environment under which they are running Oracle Database

Next Course:

  • Oracle 11g OCP - 1Z0-052 Oracle Database 11g: Administration II.
  • Oracle Database 11g: SQL Tuning Workshop

Relevant Certification:

  • Oracle 11g – Oracle Certified Associate 1Z0-051.

Duration: 40 Hours

  • Oracle Database 11g: Using SQL to Query Your Database

    • Using SQL in Oracle Database 11g
    • Retrieving, Restricting and Sorting Data
    • Using Single-Row Functions
  • Oracle Database 11g: Conversion Functions, Group Functions, and Joins

    • Conversion Functions and Conditional Expressions
    • Group Functions and Joins
  • Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation

    • Using Subqueries and Set Operators
    • Manipulating Data
  • Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms

    • Using DDL Statements to Create and Manage Tables
    • Creating Other Schema Objects

Duration: 40 Hours

  • Oracle Database 11g: Controlling User Access and Managing Schema Objects

    • Controlling User Access
    • Managing Schema Objects
  • Oracle Database 11g: Data Dictionary Views and Large Data Sets

    • Managing Objects with Data Dictionary Views
    • Manipulating Large Data Sets
  • Oracle Database 11g: Managing Data in Different Time Zones

    • Using Time Zones and Datetime Functions
  • Oracle Database 11g: Using Subqueries and Regular Expressions

    • Retrieving Data Using Subqueries
    • Using Regular Expressions
Batch Date Course Duration
Citrix Authorize Learning Center Microsoft Partner Network Summer Training Training Center Amcat Partner Network
Testimonials
Enquiry Button
x

Fill this form to Enquiry us


       7 + 2   =
L G Y