ORACLE Training

The training activity at iSAAC has been initiated to strengthen its focus on Database Administration. The advantage being the unique ability to interlink theoretical learning and practical implementation there by benefiting both training and support activity. As most of the faculty is involved in support activities when they are free from training, they are able to bring in the on site experience and share it with the students.

The training activity at iSAAC is focused on Database Administration and related skill sets; so that a student can acquire skill sets that go on to make a Complete DBA. This includes training on Oracle DBA. The training center provides the students round the clock access to lab facilities.

MODULE DETAILS

(A) Oracle Database 11g: SQL Fundamentals I

  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Subqueries to Solve Queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects to DML and DDL Statements

(B) Oracle Database 11g: Administration I

  • Exploring the Oracle Database Architecture
  • Preparing the Database Environment
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Data and Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Database Maintenance
  • Performance Management
  • Intelligent Infrastructure Enhancements
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data

(C) Oracle Database 11g: Administration II

  • Database Architecture and ASM
  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Configuring Backup Specifications
  • Using RMAN to Create Backups
  • Performing User-Managed Backup and Recovery
  • Using RMAN to Perform Recovery
  • Using RMAN to Duplicate a Database
  • Performing Tablespace Point-in-Time Recovery
  • Monitoring and Tuning RMAN
  • Using Flashback Technology
  • Additional Flashback Operations
  • Diagnosing the Database
  • Managing Memory
  • Managing Database Perormance
  • Space Management
  • Managing Resources
  • Automating Tasks with the Scheduler
  • Administering the Scheduler

CISCO-CCNA

CISCO, as is well-known, is the world leader in networking and internetworking technologies with a global market share exceeding 96% (source:NASSCOM). CISCO Networking Academies transform IT students into certified professionals with considerable expertise in the areas of designing, managing and upgrading global and local networks.

iSAAC now teaches basic as well advanced internet technologies and also trains students to undertake industry standard certification. These programs include CISCO Certified Network Associate (CCNA), CISCO Certified Network Professional (CCNP) and other industrial Certifications.

  • Operation of IP Data Networks
  • LAN Switching Technologies
  • IP Addressing (IPV4/IPV6)
  • IP Routing Technologies
  • IP Services
  • Network Device Security
  • Troubleshooting
  • WAN Technologies

SCJP

  • JAVA SE 8 Programmer I
  • JAVA Basics
  • Working with JAVA data types
  • Using Operators & Decision Constructs
  • Creating & Using Arrays
  • Using Loop Constructs
  • Working with methods & Encapsulation
  • Working with Inheritance
  • Handling Exceptions
  • Working with Selected classes from the Java API
  • Java SE 8 Programmer II
  • Java Class Design
  • Advanced Java Class Design
  • Generics and Collections
  • Lambda Built-in Functional Interfaces
  • Java Stream API
  • Exceptions and Assertions
  • Use Java SE 8 Date/Time API
  • Java I/O Fundamentals
  • Java File I/O (NIO.2)
  • Java Concurrency
  • Building Database Applications with JDBC
  • Localization

Other Courses

Certificate Course in C and C++

C

  • Programming Essentials
  • Getting Started with C
  • Control Structures
  • Arrays
  • Functions
  • Strings
  • Pointers
  • Structures and Unions
  • Console I/O
  • File Handling
  • Graphics

C++

  • Principals of OOPs
  • Classes and Objects
  • Constructors and DSrstructors
  • Operator Overloading
  • Inheritance
  • Polymorphism
  • Pointers, Virtual functions
  • Working with files
  • Templates and Exception Handling

Data structures with C++

  • Linked List
  • Stack
  • Queue
  • Trees
  • Graphs
  • Project

Certificate Course in Object Oriented Programming (with C++ or Java) • C++

  • Principles of OOPs
  • Classes and Objects
  • Constructors and Destructors
  • Operating Overloading
  • Inheritance
  • Polymorphism
  • Pointers, Virtual functions
  • Working with files.
  • Templates and Exceptions
  • Linked List
  • Stack, Queue
  • Trees, Graphs
  • Project

Java

  • Concepts of OOPs
  • Inroduction to Java
  • Programming essentials
  • Java interfaces and packages
  • Arrays, Strings and buffers
  • Exceptions
  • AWT and Graphics
  • Multithreading and Animations
  • Applets
  • Networking

Advanced Java

  • JDBC
  • Servelts
  • Java Beans
  • Inner Classes, Runtime and Printing
  • Introspection, Reflection and ZIP streams.
  • Session Tracking
  • JSP
  • Project

Certificate Course in Visual Basic • Visual Basic

    - VB Overview - VB Language - Working with files - Designing Menus - Basic ActiveX Tools - Windows Common Dialog Controls - Drawing with Visual Basic - Advanced ActiveX Data Objects - Windows API - OLE Automation - Project

Certificate Course in Web Programming  HTML

    - Internet Basics - Itroduction to HTML - Lists - Adding Graphics to HTML Documents - Tables - Linking Documents - Frames - Forms

• DHTML

    - Cascading Style Sheets - Class - Span Tag - External Style - Sheets - DIV Tags - Inflow Layers

• JavaScript

    - Introduction to JavaScript - Writing JavaScript into HTML - Programming Essential - Programming Constructors - Functions - Dialog Boxes - Built In Objects

• ASP

    - Introduction to ASP - Programming Basics - Objects and Components - Introduction to SQL - ADO: Database Connectivity - Client Server Application - Network Security C Donts Object Models - Projects

Certificate Course in Web Designing

    - Computer Fundamentals/ Internet - Concepts of designing - Illustrator - Photoshop - Flash - FrontPage - Project

Certificate Course in Desktop Publishing

    - Concepts of Designing - Corel Draw - Photoshop - Pagemaker - Project

Certificate Course in AutoCad

    - Starting up AutoCad - Basic Commands - Coordinate System - Completing Box - Working with hatches and files - Grouping objects into Blocks - Using layers to organize the drawing - 3D Modeling - Printing

Certificate Course in Business Computing

    - Internet Concepts - Networking fundamentals - Concepts - Programming in Visual Basic - HTML, DHTML, JavaScript, ASP - Project