| 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 |