JAVA Course

Eligibility/Duration/Course Fee

Eligibility

Graduate

Duration

4 – 6 Months

Course Fees

INR 30000.00

Payment Instructions:

  • GST 18 % applicable from 1st July
  • All payment should be in favor of “ICR India Certifications Private Limited” payable at Meerut.

Curriculum

Java

Java technology is a high-level programming and a platform independent language. Its designed to work in the distributed environment on the Internet.

1.Core Java

The Core Java technologies and application programming interfaces (APIs) are the foundation of the Java Platform, Standard Edition (Java SE). They are used in all classes of Java programming, from desktop applications to J2EE applications.

The Java Environment

  • Installation
  • Java Program Development
  • Java Source File Structure
  • Compilation & Executions
  • Eclipse Tool Usage
  • Basic Language Elements
  • Java Tokens, Identifiers , Keywords, Literals , Comments , Primitive Data types
  • Operators
  • Condition Statements
  • Control Statements
  • Command line Arguments

Object Oriented Programming

  • OOPS Fundamentals
  • Class & Object
  • Function Models
  • Array of Objects
  • Static Members
  • Encapsulation
  • Constructors , Parameterized Constructors, Constructor Overloading
  • Method Overloading
  • Access Specifiers& Access Modifiers.
  • Design of Accessor and Mutator Methods.
  • Inheritance – Types of Inheritance, Method Overriding, super keyword
  • Polymorphism
  • Abstract Class – Interfaces
  • Objects Cloning
  • Singleton class
  • String Handling
  • String , StringBuffer&StringBulider
  • Packages
  • Organizing Classes and Interfaces in Packages
  • Introduction to all pre-defined Packages
  • Defining Package
  • Making JAR Files for Library Packages
  • Import and Static Import
  • Exception Handling
  • Exceptions & Errors
  • Types of Exception
  • Control Flow In Exceptions
  • Use of try, catch, finally, throw, throws in Exception Handling
  • In-built and User Defined Exceptions
  • Checked and Un-Checked Exceptions
  • Inner Classes
  • Introduction
  • Member Inner Class
  • Static Inner Class
  • Local Inner Class
  • Anonymous Inner Class
  • Multi Threading
  • Understanding Threads
  • Needs of Multi-threaded Programming
  • Thread Life-Cycle
  • Multiple Threads in a program
  • Thread Priorities
  • Synchronizing Threads
  • Input/Output Operation in Java(java.io Package)
  • Streams and the new I/O Capabilities
  • Understanding Streams
  • The Classes for Input and Output
  • The Standard Streams
  • File
  • FileReader
  • FileWriter
  • FileOutputStream
  • FileInputStream
  • BufferredInputStream
  • BufferredOutputStream
  • DataInputStream
  • DataOutputStream
  • SequenceInputStream
  • ObjectInputStream
  • ObjectOutputStream
  • Working with File Object
  • File I/O Basics
  • Reading and Writing to Files
  • Serialization & Deserialization
  • Collections Framework & Utility Classes
  • Introduction to Collection Framework
  • Date & Time
  • Utility Methods for Arrays
  • StringTokenizer
  • List interface & its classes
  • ArrayList
  • LinkedList
  • Set interface & its classes
  • HashSet
  • LinkedHashSet
  • TreeSet
  • Map interface & its classes
  • HashMap
  • LinkedHashMap
  • TreeMap
  • Iterator & List Iterator & Enumeration Interfaces
  • Using Scanner
  • Properties class
  • Calendar class
  • GUI Programming- Swings
  • Designing Graphical User Interfaces in Java
  • Components and Containers
  • Basics of Components
  • JLabel
  • JFrame
  • JTextField
  • JPasswordField
  • JRadioButton
  • JCheckbox
  • ButtonGroup
  • Font
  • Color
  • JButton
  • JMenubar
  • JMenu
  • JMenuItem
  • JTextArea
  • JOptionPane
  • Event Handling Programming
  • Java New Features

2.Advance Java

Advanced Java is the next advanced level concept of Java programming. This high level java programming basically uses two Tier Architecture i.e Client and Server.Advanced Java is used for developing the web based application and enterprise application. Advanced Java has complete solution for dynamic processes which has many frameworks design patterns servers mainly JSP.

JDBC

      • What is JDBC?
      • What is Driver? And Types of Drivers.
      • Basic commands of MySQL(DDL,DML,DRL)
      • How to load Driver class.
      • How to establish Connection b/w Java & Data base s/w.
      • How to get Statment or PrepareStatement or CallableStatement Objects and its role.
      • How to perform INSERT,DELETE,UPDATE operations from JDBC in JAVA.
      • HOW to perform SELECT Operations from JDBC in JAVA.
      • How to execute pL/SQL functions & Procedures from JDBC in JAVA.
      • How to perform DATE INSERTION from JDBC in JAVA.
      • How to perform DATE SELECT from JDBC in JAVA.
      • DatabaseMetaData and ResultSetMetaData Interfaces

SERVLET

      • What is CGI& its Drawbacks.
      • What is SERVLET.
      • How many to develop Servlet.
      • Servlet Life Cycle.
      • what is URL-Pattern. Types of URL-Patterns.
      • xml importance and its tags.
      • How to develop form pages with Html.
      • Integration of Form pages & Servlet.
      • How to read the form pages information from servelet.
      • Integration of Form pages, Servelet& JDBC Application.
      • Information about ServletConfig&ServletContext,ServletRequest,ServletResponse.
      • Servlet Chaining(Forward &Include operations).
      • sendRedirect concept.
      • Session Tracking.
      • What is Attribute & types of Attributes.

JSP(JAVA SERVER PAGE)

      • Drawbacks of servlet.
      • Jsp phases.
      • Jsp life cycle.
      • Jsp tags
      • Scripting tags. (Declaration tags, Expression tags, Scriplets)
      • Directive tags (Include , Page, Taglib)
      • Action tags. (include , forward , useBean , setProperty , getProperty , params , plugin)
      • Custom tags
      • Integration of Jsp,Servlet,Jdbc example application.
      • Creating War and deploying in Web Server

 

WORKING WITH TOMCAT SERVER.

ECLIPSE IDE

      • Introduction to Java Concepts of JDBC and SQL Drivers
      • Basic SQL Queries of MySQL Database
      • JDBC Programming with CRUD operations (Insert , Update , Delete, Create, Drop)
      • JDBC Programming to retrieve data from database using ResultSet Interface
      • JDBC Programming with CRUD operations using PreparedStatement Interface
      • JDBC Programming using Batch Executions ,DatabaseMetaData and ResultSetMetaData Interfaces.
      • Introduction to Web technologies architecture , Apache Tomcat web server, Eclipse IDE
      • Client Side Programming basics : HTML Tags
      • Java Servlet Life Cycle and develop sample Java Servlet Program
      • Request Processing using getParameter() and getParameterNames()
      • Redirection of response and Request Dispatching to another resource
      • HttpSession interface , ServletConfig&ServletContext interfaces
      • Java Servlets integration with JDBC concept and DAO design pattern
      • Drawbacks of Servlet and Life cycle of a Java Server Page (JSP) – Basics of JSP declaration & expression tag.
      • JSP Implicit Objects and JSP Scriplets with Examples
      • JSP Directives – include , page , taglib
      • JSP Custom tag creation & JSP Action Elements ( forward , include , params)
      • POJO Class definition & JSP Action Elements(useBean , setProperty , getProperty)
      • JSP integration with JDBC concepts
      • WAR File creation and deploying the WAR file in Tomcat Web Server

3.Oracle

Oracle Database Architecture. An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.

Introduction To DBMS

      • Approach to Data Management
      • Introduction to prerequisites
      • File and File system
      • Disadvantages of file
      • Review of Database Management Terminology
      • Database Models
      • Hierarchal Model
      • Network Model
      • Relational Model

Introduction to RDBMS

      • Feature of RDBMS
      • Advantages of RDBMS over FMS ad DBMS
      • The 12 rules (E.F Codd’s Rules –RDBMS)
      • Need for Database Design
      • Support of Normalization Process for Data Management
      • Client server Technology
      • Oracle Corporation Products
      • Oracle Versions
      • About SQL&SQL*PLUS

Sub Language Commands

      • Data Definition Language (DDL)
      • Data Retrieval Language (DRL)
      • Data Manipulation Language (DML)
      • Transaction Control Language (TCL)
      • Database Security and Privileges (DCL)

Introduction to SQL Database Object

      • Oracle Pre Defined Data types
      • DDL Commands
      • Create, Alter (add, modify, rename, drop)Columns, Rename, truncate, drop
      • DML-Insert, update, delete
      • DQL-SELECT Statements using WHEREclause
      • Comparison and Conditional Operators
      • Arithmetic and Logical Operators
      • Set Operators (UNION, UNION ALL, INTERSECT, MINUS)
      • Special Operators – IN (NOT IN), BETWEEN (NOT BETWEEN), LIKE (NOTLIKE), IS NULL (IS NOT NULL)
      • Working with DML, DRL Commands
      • Operators Support

Built in Functions

      • Arithmetic Functions, Character Functions, Date Functions, Conversion Functions
      • Aggregate Functions, OLAP Functions & General Functions

Grouping the Result of a Query

      • Using Group by and Having Clause of DRL Statement
      • Using Order by clause

Working with Integrity Constraints

      • Importance of Data Integrity
      • Support of Integrity Constraints for Relating Table in RDBMS
      • NOT NULL constraint
      • UNIQUE constraint
      • PRIMARY KEY constraint
      • FOREIGN KEY constraint
      • CHECK constraint
      • Working with different types of integrity Constraints

REF constraint

      • Working with composite constraint
      • Applying DEFAULT option to columns
      • Working with multiple constraints upon a column
      • Adding constraints to a table
      • Dropping of constraints
      • Enabling / Disable constraints
      • Querying for constraints information

Querying Multiple Tables (Joins)

      • Equi Join/Inner Join/Simple Join
      • Cartesian Join
      • Non-Equi Join
      • Outer Joins
      • Self Join

Working with Sub Queries

      • Understanding the practical approach to Sub Queries/Nested Select/Sub Select/Inner Select/Outer Select
      • What is the purpose of a Sub Query?
      • Sub Query Principle and Usage
      • Type of Sub Queries
      • Single Row
      • Multiple Row
      • Multiple Column
      • Applying Group Functions in Sub Queries
      • The impact of Having Clause in Sub Queries
      • IN, ANY/SOME, ALL Operators in Sub Queries
      • PAIR WISE and NON PAIR WISE Comparison in Sub Queries
      • Be … Aware of NULL’s
      • Correlated Sub Queries
      • Handling Data Retrieval with EXISTS and NOT EXISTS Operators

Working with DCL, TCL Commands

      • Grant, Revoke
      • Commit, Rollback, Savepoint
      • SQL Editor Commands
      • SQL Environment settings

Maintaining Database Objects and VIEWS in Oracle

      • Understanding the Standards of VIEWS in Oracle
      • Types of VIEWS
      • Relational Views
      • Object Views
      • Prerequisites to work with views
      • Practical approach of SIMPLE VIEWS and COMPLEX VIEWS
      • Column definitions in VIEWS
      • Using VIEWS for DML Operations
      • In-Line View
      • Forced Views
      • Putting CHECK Constraint upon VIEWS
      • Creation of READ ONLY VIEWS
      • Understanding the IN LINE VIEWS
      • About Materialized Views
      • View Triggers

Working with Sequences

      • Working with Synonyms
      • Working with Index and Clusters
      • Creating Cluster Tables, Implementing Locks, working with roles
      • Pseudo Columns in Oracle
      • Understanding Pseudo Columns in Oracle
      • Types of Pseudo Columns in Oracle
      • CURRVAL and NEXTVAL
      • LEVEL
      • ROWID
      • ROWNUM

Data Partitions & Parallel Process

      • Types of Partitions
      • Range Partitions
      • Hash Partitions
      • List Partition
      • Composite Partition
      • Parallel Query Process

Locks

      • Row level Locks
      • Table Level Locks
      • Shared Lock
      • Exclusive Lock
      • Dead Lock

SQL * Loader

      • SQL * Loader Architecture
      • Data file (Input Datafiles)
      • Control file
      • Bad file
      • Discard file
      • Log file
      • .txt to base table
      • .csv to base table
      • From more than one file to single table

PL-SQL (Procedure Language – SQL)

      • Introduction to Programming Languages
      • Introduction to PL/SQL
      • The Advantages of PL/SQL
      • PL/SQL Architecture
      • PL/SQL Data types
      • Variable and Constants
      • Using Built_in Functions
      • Conditional and Unconditional Statements
      • Simple if, if… else, nested if..else, if..else Ladder
      • Selection Case, Simple Case, GOTO Label and EXIT
      • Iterations in PL/SQL
      • Simple LOOP,WHILE LOOP,FOR LOOP and NESTED LOOPS
      • SQL within PL/SQL
      • Composite Data types (Complete)
      • Cursor Management in PL/SQL
      • Implicit Cursors
      • Explicit Cursors
      • Cursor Attributes
      • Cursor with Parameters
      • Cursors with LOOPs Nested Cursors
      • Cursors with Sub Queries
      • Cursors
      • Record and PL/SQL Table Types

Advanced PL/SQL

      • Procedures in PL/SQL
      • STORED PROCEDURES
      • PROCEDURE with Parameters (IN,OUT and IN OUT)
      • POSITIONAL Notation and NAMED Notation
      • Procedure with Cursors
      • Dropping a Procedure
      • Functions in PL/SQL
      • Difference between Procedures and Functions
      • Nested Functions
      • Using stored function in SQL statements
      • Packages in PL/SQL
      • Creating PACKAGE Specification and PACKAGE Body
      • Private and Public Objects in PACKAGE

EXCEPTIONS in PL/SQL

      • Types of exceptions
      • User Defined Exceptions
      • Pre Defined Exceptions
      • RAISE_APPLICATION_ERROR
      • PRAGMA_AUTONOMOUS_TRANSACTION
      • SQL Error Code Values

Database Triggers in PL/SQL

      • Types of Triggers
      • Row Level Triggers
      • Statement Level Triggers
      • DDL Triggers
      • Trigger Auditing

File Input/Output

      • PL/SQL file I/O (Input/Output)
      • Using UTL_FILE Package

Implementing Object Technology

      • What is Object Technology ?
      • OOPS-Object Instances
      • Creation of objects
      • Creating User Defined Data Types
      • Creating Object Tables
      • Inserting rows in a table using Objects
      • Retrieving data from Object based Tables
      • Calling a Method
      • Indexing Abstact Data type Attributes

Using LOBS

      • Large Objects (LOBS)
      • Creating Tables-LOB
      • Working with LOB values
      • Inserting, Updating & Deleting Values in LOBs
      • Populating Lobis DBMS_LOB Routines
      • Using B-FILE
      • Using Collections
      • Advantages of collection
      • Ref cursor (Dynamic Cursor)
      • Weak ref cursor
      • Strong ref cursor
      • Nested Tables VARRAYS or VARYING arrays
      • Creating tables using nested tables
      • Inserting, updating & deleting Nested
      • Table records
      • Nested table in PL/SQL
      • Oracle Database Architecture
      • Introduction to Oracle Database Architecture
      • Physical structures Logical structures
      • DB Memory Structures Background Process
      • 2 Tire, 3 Tire, N-Tier Architecture

Advanced Features

      • 9i Joines
      • New Date function
      • Rename column
      • Inner Join/Natural Join
      • Left Outer Join/Right Outer Join
      • Full Outer Join
      • Multiple Inserts
      • Insert All Command
      • Merge statement
      • NVL2(), NULLIF(), COALESCE()
      • CASE expression of Select Command
      • Temporary Tables/Global Tables
      • New Function EXTRACT()
      • Autonomous Traction
      • Pragma _ Autonomous_ Transaction()
      • Bulk Collect
      • About Flash Back Queries
      • Dynamic SQL
      • New data types, Flash back Command
      • Purge Command, Recyclebin
      • Regular expressions, DML Error Logging
      • Data Pump, Virtual Columns
      • Read only tables, Cross tab Views using
      • Pivot/Unpivot operators, Follows Clause
      • Compound triggers, New data types

DBA CONCEPTS

    • Database
    • Tablespace
    • Types of Tablespaces
    • Data files /Se