Courses

Course Name	Syllabus	Syllabus in Detail
Foundation Course in Oracle SQL/PLSQL	Introduction	RDBMS, DDL, DML, DCL, Query, Insert, Update, TIMEZONE, TIMESTAMP, TO_TIMESTAMP, TO_TIMESTAMP_TZ(), CAST()
	SET Operations	Set Operations, Union, Intersect, Minus, IN, Exist, Multicolumn Subqueries, Queries involving Multiple Tables, Cartesian Product, Self Join, Table alias
	SQL Operators	Arithmetic, Logical, Query Expression
	SQL Functions	Number, Character, Date, etc.
	Pseudocolumns	LEVEL, ROWID, ROWNUM, ROWSCN, SYSDATE, UID, USER
	Ampersand(&) Variables	Single and Double Ampersand(&) Variables
	Aggregate Functions	Group By, Having, With, Order By
	DML	Updating and Deleting data in existing table, UPDATE, DELETE, DROP, Renaming a table, Inserting Data using Query, Creating Table using Query
	Views	Creating Views, Synonyms
	Advanced Queries	Advanced Queries, Pseudocolumns, SUM, DECODE
	Constraints	Integrity Constraints, Domain Constraints, Key Constraints, Primary Key, Unique Key, Foreign Key, Implementation of Foreign Key, Enabling/Disabling a Constraint, NOVALIDATE Clause, Immediate, Deferred, Updatable, Join, Views
	ROLL UP, CUBE, Group_ID	ROLL UP, CUBE, Group_ID
	Joins	Natural Join, Cross Join, ON Clause, Outer Join, Histogram
	Scalar Subquery	Scalar Subquery, Use in Select, Where, Order By Clause
	CASE Statement	CASE Statement, NULLIF Function, NVL2, COALESCE Function
	Special Insert Cases	Multitable Insert, Unconditional Insert, Pivot Insert, Conditional Insert, Insert First, Merge
	Regular Expression	Regular Expression, Specifying Patterns, Metacharacters, REGEXP_SUBSTR Function, REGEXP_REPLACE, REGEXP_LIKE
	Model Queries	Model Queries, Dimensions and Cells, Construction of a Model Query, Additional Clauses, PIVOT Query, Displaying Data from Multiple Columns, Displaying Data by using Multiple Aggregate Functions, Multiple Rows, UNPIVOT

Course Name	Syllabus	Syllabus in Detail
Foundation Course in Java	Introduction	Introduction, Origin and Evolution of Java, Java and other Programming Languages, Object Oriented Programming(OOP) Concept, Benefits, Applications, Added Security with Java, Java Environment, Java Compilers, Program Execution
	Data Types	Constants, Variables, Data Types, Keywords, Integer, Real, Char, Boolean
	Java Statements	Input Methods, Command-Line Arguments, Java Instructions, Type Declaration, Arithmetic Instruction, Type Conversion, Explicit Conversion, Hierarchy of Operations, Associativity of Operators, Constant Variables, Console Output in Java, println() & format() Functions, Control Instructions
	Decision Control Statements	& and \| Operators, ! Operator, Conditional Operators
	Loop Control Statements	While Loop, For Loop, Partial For Loop, Multiple Initializations of For Loop, Nesting of Loops, Do-While Loop, Break Statement, Continue Statement
	Case Control Statements	Decisions using Switch, Switch v/s If-Else Ladder
	Object Oriented Programming(OOP)	Structured Programming, Object-Orientd Programming, Characteristics of OOP, Objects, Classes, Inheritance, Polymorphism
	Classes and Objects	Classes, Defining a Class, Constructors, Accessing Class Members, Final Variables & Classes, Object Creation, Object Destruction, 'this' Reference, Static Members, Static Block,
	Methods(Functions)	Why use Functions, Function Declaration, Passing Values between Functions, Function Overloading, Functions with Variable Number of Arguments, Passing Objects to a Function, Nesting of Functions, Final Methods, Static Functions, Method Overriding
	Arrays	Array Declaration, Accessing Elements of an Array, Entering Data into an Array, Reading Data from an Array, Array Initialization, Array Access, Bounds Checking, Passing Array to a Function, Returning an Array, Common Array Operations, Array of Objects, One-Dimensional Arrays, Two-Dimensional Arrays, Multi-Dimensional Arrays, Passing and Returning 2-d Array, Jagged Arrays, Resizing of Arrays
	Strings & Enum	Strings, Splitting Strings, StringBuilder Class, Array of Strings, Sorting Strings, Enumeration, Uses
	Inheritance & Polymorphism	Uses, Constructors, Final keyword, Polymorphism, Abstract Classes and Functions, Interfaces, Different Implementations
	Errors & Exceptions	Errors, Types of Errors, Exceptions, Exception Handling, Catching Multiple Exceptions, Finally Block, User-Defined Exceptions, Throw, Try, Catch
	Threads	Creating a Thread, Extending the Thread Class, Stopping and Blocking a Thread, Life Cycle of a Thread, Multitasking and Multithreading, Multithreading in Java, Launching Threads, Implementing the 'Runnable Interface', Synchronization, Synchronized Block, Inter-thread Communication, Thread Priorities
	Generic	Generic Functions, Multiple Type Parameters, Generic Classes, Bounded Type Parameters
	Java Collections	Array of Names and Numbers, Maintaining a Stack, Linked List, Tree, HashMap, Algorithms
	JDBC	Data Organization, Common Database operations, Database Operations through Java, JDBC Architecture, JDBC Driver Types, Common JDBC API Components