Diploma in Software Programming

• Introduction of Programming Languages, Types of Languages, Evolution of 'C' Language • Structure of a 'C' Program, 'C' Program development life cycle, Executing and Debugging a 'C' Program • C' Tokens, Keywords and Identifiers, Operators, Constants, Variables, Data Types • Precedence of Operators, Scope and Lifetime of Variables • Control Statement and Expressions, Decision Making using if statement, Types of if …else block • Switch case Block, Arithmetic Expressions, Evaluation of Expressions, goto statement • Looping, Concept of Loop, For loop, While loop, Do while loop, Jumping in Loop, break and continue statement • Algorithms and Flowchart, Algorithms and Flowcharts (Definitions,Symbols), Characteristics of an algorithm • Arrays and String, Introduction of Array, One - D Array, Two - D Array, Mutlidimensional Array • Dynamic Arrays, Implementing String Variables, String handling Functions • Functions, Concept of Function, User defined Function, System Defined Function, Types of parameter passing in function • Pointers, Need of Pointers, Types of Pointers, Pointer Expression, Arrays of Pointers, Pointers and Functions • Structure and Unions, Need of Structure, Implementing Structure Variable, Arrays of Structure • Structure within Structure, Introduction of Unions, Difference between Structure and Unions • File Handling using 'C', Opening and Closing File, Input / Output operations on File • Random Access to Files, Command Line ArgumentsDynamic Memory Allocation • Concept of Dynamic Allocation, Implementing Malloc and Calloc Functions, Releasing the free space • Storage Classes and Preprocessor, Introduction of Storage Class, Types of Storage Classes • Introduction of Preprocesor, Macro Substitution, File Inclusion • Introduction of Data Structure, Concept of Data Structure, Types of Data Structure, Implementing Stack & Linkedlist • Graphics using C, VDU Basics, Simple library functions

• Introduction to Object Oriented Programming, Concept of OOP, Features of OOP • Introduction of 'C++', Structure of 'C++' program, Executing and Debugging a 'C++' Program • C++ Tokens and Type Casting, Keywords and Identifiers, Operators, Constants • Variables, Data Types, Precedence of Operators, Scope and Lifetime of Variables • Classes & Objects, Classes & Object specifiers, Defining data members and member functions • Array of objects, Managing console I/O, 'C++' stream classes, Formatted and unformatted console I/O • Function in 'C++', Call by reference, Return by reference, Function overloading and default arguments • Inline function, Static class members, Friend functions, Virtual Functionns • Constructors and Destructor, Concept of Constructor, Types of Constructors • Memory allocation (new and delete), Usage of destructor • Operator Overloading, Overloading Unary and Binary operators, Overloading using friend function • Inheritance, Types of inheritance, Virtual base classes and abstract base classes • Constructor and destructor in derived class • Working with files, File operations, File pointer and their manipulation, File updation with random access • Exception Handling, Various Exception Handling classes, Implementing try and catch block & thow keyword • Templates, Introduction to Templates, Class templates, function templates and overloading of function templates • Standard Template Library (STL), Run Time Type Identification (RTTI)

• Object Oriented Programming (OOPS) concepts and terminology, Advantages of OOPS • Fundamentals of OOPS, Core Java Programming Introduction of Java • What is Java?, How to Get Java, A First Java Program, Compiling and Interpreting Applications • The JDK Directory Structure, Using Eclipse • Data types and Variables, Primitive Datatypes, Declarations, Variable Names • Numeric Literals, Character Literals, String formatting and Parsing, String Literals • Arrays,Non-Primitive Datatypes, The Dot Operator • Methods, Calling Methods, Defining Methods, Method Parameters Scope, Why all the static? • Operators and Expressions, Expressions, Assignment Operator, Arithmetic Operators • Relational Operators, Logical Operators, Increment and Decrement Operators • Operate-Assign Operators (+=, etc.), The Conditional Operator, Operator Precedence • Implicit Type Conversions, The Cast Operator, Strict typing, Type conversion • Control Flow Statements, Conditional (if) Statements, Data types and Variables • Adding an else if, Conditional (switch) Statements, while and do-while Loops, for Loops • The continue Statement, The break Statement • Introduction to Object-Oriented Programming, Classes and Objects, Fields and Methods • Encapsulation, Access Control, Inheritance, Polymorphism • Using Java Objects, Printing to the Console, printf Format Strings, StringBuilder and StringBuffer • Methods and Messages, toString, Parameter Passing, Comparing and Identifying Objects, Destroying Objects • Inheritance in Java, Casting, Method Overriding, Polymorphism, super keyword, The Object Class • Packages, The import Statement, Static Imports, CLASSPATH and Import, Defining Packages, Package Scope • Interfaces and Abstract Classes, Separating Interface and Implementation, Defining Interfaces • UML Interfaces and Realization, Implementing and Extending Interfaces, Runnable Threads, Abstract Classes • Lambda Built-in Functional Interfaces, java.util.function package, Use primitive versions of functional interface • Use binary versions of functional interface, Use the UnaryOperator interface • Exception Handling, Exceptions Overview, Catching Exceptions, The finally Block, Exception Methods • Declaring Exceptions, Defining and Throwing Exceptions, Errors and Runtime Exceptions, Assertions • The Collections Framework, The Set Interface, Set Implementation Classes, The List Interface • List Implementation Classes, The Map Interface, Map Implementation Classes, Utility classes, Generics • Inner Classes, Member Classes, Local Classes, Anonymous Classes, Instance Initializers, Static Nested Classes • Introduction to Threads, Non-Threaded Applications, Threaded Applications, Creating Threads • Thread States, Runnable Threads, Coordinating Threads, Interrupting Threads, Runnable Interface ,ThreadGroups • Swing, Swing GUI Components, Using Swing API • Applet, Life Cycle of an Applet • JDBC, Creating a Database and tables, Getting Information from Database, Obtaining Result Set Information • Connecting a Java program to a Database, Prepared Statements & Statement Classes in Java • Inserting, Updating & Deleting Table data • Servlets, What is a web application, Java Servlets, What is a Servlet, Servlet Lifecycle, Servlet Context • Session management, Building the first Servlet, Deploying the Servlet • JSP, What is a JSP Page, Basic HTML Tags, JSP Tag library, JSP Page Life-cycle • Creating the first Dynamic web page using JSP, MVC architecture, 3-tier architecture

• Introduction, History, Features, Setting up path, Working with Python, Basic Syntax • Variable and Data Types, Operator, Conditional Statements, Looping • Control Statements, break, continue, pass • String Manipulation, Accessing strings, Basic Operation, String slices, Functions and methods • Lists - Accessing list, Operations, Working with lists, Function and Methods • Tuple - Accessing tuples, Operations, Working with lists, Function and Methods • Dictionaires - Accessing values in dictionaries, Working with dictionaries, Properties, Functions • Functions, Defining a function, Calling a function, Types of functions, Function Arguments • Anonymous functions, Global and local variables • Modules, Importing module, Math module, Random module, Packages, Composition • Input-Output, Printing on screen, Reading data from keyboard, Opening and closing file • Reading and writing files • Exception Handling, Exception, Except clause, Try ? finally clause, User Defined Exceptions • OOPs concept, Class and object, Attributes, Inheritance, Overloading, Overriding, Data hiding • Regular expressions, Match function, Search function, Matching VS Searching, Modifiers, Patterns • CGI - Introduction, Architecture, CGI environment variable, GET and POST methods, Cookies, File upload • Database - Introduction, Connections, Executing queries, Transactions, Handling error • Networking, Socket, Socket Module, Methods, Client and server, Internet modules • Multithreading, Thread, Starting a thread, Threading module, Synchronizing threads • Multithreaded Priority Queue • GUI Programming, Introduction, Tkinter programming, Tkinter widgets, Sending email

• Introduction to SQL constructs, Basic Structure, DDL Commands, DML Commands • Simple Queries, Nested Queries, Aggregate Functions, Clauses, Triggers and Views • Joining Oracle tables, Equi join, Outer Join, Hiding joins by creating views • SQL access methods, Merge join, Hash Join, Nested Loop join • Advanced SQL operators, Using IN, NOT IN, EXISTS and NOT EXISTS • Between operator, EXISTS clause, Using wildcards in queries (LIKE operator) • Subqueries, Correlated subqueries, Non - correlated subqueries • SQL Tuning - Introduction to rule based optimization, Introduction to cost based optimization • Collecting table and index statistics, Using column histograms, Changing the default optimizer modes • Using TKPROF, Using SQL*Trace, SQL reusability within the library cache • Table high water mark, Table striping and table partitions • Basics of PL/SQL - Introduction, Overview and benefits of PL/SQL, PL/SQL architecture • PL/SQL wrapper utility, PL/SQL Structures, Simple blocks, Control structures • PL/SQL records, Declaring Variables and Constants, Loops in PL/SQL, Executing a PL/SQL Block • PL/SQL tables, Defining PL/SQL tables, Reasons to use PL/SQL tables, Populating a PL/SQL table • Retrieving from a PL/SQL table, Triggers in PL/SQL, Triggers and database events • Defining a trigger, Timing a trigger, Enabling and disabling a trigger • Stored procedures and functions, Basics of stored procedures, Basics of functions • Defining stored procedures & functions, Function and stored procedures prototypes • Passing arguments to functions and stored procedures, Recompiling functions and stored procedures

• Hadoop: Basic Concepts, What is Hadoop?, The Hadoop Distributed File System • How Hadoop Map Reduce Works, Anatomy of a Hadoop Cluster • Setting Up a Hadoop cluster, Make a fully Distributed Hadoop Cluster • Cluster Specification, Network Topology, Cluster Specification and Installation, Hadoop Configuraton • Hadoop Daemons, Master Daemons, Name Node, Job Tracker, Secondary Name Node • Slave Daemons, Data Node, Task Tracker • HDFS ( Hadoop Distributed File System ), Blocks and Splits, Input Splits, HDFS Splits • Methods of Accessing HDFS, Java Approach, CLI Approach • Writing a MapReduce Program, Examining a Sample MapReduce Program With several examples • Basic API Concepts, The Driver Code, The Mapper, The Reducer, Hadoop's Streaming API • The configure and close Methods, Sequence Files, Record Reader, Record Writer • Role of Reporter, Output Collector, Directly Accessing HDFS, ToolRunner

• Introduction to Visual Basic, Introduction Graphical User Interface (GUI) • Programming Language (Procedural Object Oriented, Event Driven) • The Visual Basic Environment, How to use VB complier to compile / debug and run the programs. • Introduction to VB Controls, Textboxes, Frames, Check Boxes • Option Buttons, Images, Setting a Border &Styles,The Shape Control, The line Control • Working with multiple controls and their properties,Designing the User Interface • Keyboard access, tab controls,Default & Cancel property, Coding for controls • Variables, Constants, and Calculations, Naming rules/conventions, Constants, Named & intrinsic • Decision & Conditions, Menus, Sub-Procedures and Sub-functions • Multiple Forms, Creating , adding, removing Forms in project, Hide • Show Method, Load, Unload, Statement, Me Keyword • Referring to Objects on a Different Forms, List, Loops and Printing • List Boxes & Combo Boxes, Filling the List using Property window / AddItem Method • Clear Method, List box Properties, Removing an item from a list • List Box/ Combo Box, Do/Loops, For/Next Loops, Using MsgBox Function • Using String Function, Printing to printer using Print Method, Arrays • OOP in VB, Classes, Creating a new Class,Creating a new object using a class • The Initialize & Terminate events, Data Files, Opening and Closing Data Files, The Free File Function • Viewing the data in a file, Sequential File Organization (Writing Data to a sequential Disk File • The Err Object, Random Data File Opening a random file,Reading and writing a random file(Get, Put, LOF, Seek). • Accessing Database File, Creating the database files for use by Visual Basic ( Using MS- Access) • Using the Data Control ,setting its property, Using Data Control with forms, navigating the database in code • Using listboxes & comboboxes as data bound controls, updating a database file ( adding, deleting records ) . • Displaying data in grids ( grid control, properties of grid )

• OverView, CLR,CLS, MSIL, Assemblies, NameSpaces, .NET Languages, Dll’s(Vs)Exe’s • BASICS - Using Variables and Arrays,Methods and Parameters,Decision Structures and Loops • Handling Errors and Exceptions, Object oriented programming • Classes, structures and enums, Constructors, Destructors, Properties, Inheritance • Shadowing(new methods), Overriding, Method Overloading, this and base Keyword • Sealed classes, Interfaces, Abstract Classes, Working with Delegates, Designing • Implementing Events, Generics, Sealed classes and Partial classes • C#.NET Application Architecture, Compiling, Debugging and Running in IDE • Introduction to gui programming, System.Windows.Forms Assembly, System.Drawing, • The Form Class, Win Forms, Visual Inheritance, Programming with Controls, User Controls • System.IO, Readers and Writers, Streams, System.Collections • Hashtable, ArrayList, Serialization, Formatters, Binary Serialization • Formatters, Binary Formatter, SOAP Serialization, XML Serialization • ADO.NET I - Introduction, Architecture, System.Data.Dll, System.Data.Oledb,System.Data.SqlClient • Data Readers, Command Object, Procedure Execution (PL/SQL) • ADO.NET II - Data Adapters and DataSets, Data Tables, Data Relations, Data Views, Assemblies, • Strong Names, GAC, Private and Shared Assemblies, SFA, MFA, Multithreading • Threading Introduction, System.Thrading NameSpaces, Thread Members, Thread States