Category Archives: Short Term Courses

• Image size, resolution, and mode
• Selection
• Color, drawing, and erasing
• Editing
• Touching up
• Layers
• Text
• Layer Style
• Blend Mode
• Filters
• Masks
• Saving patterns, Brushes
• Paths
• Shapes

JDBC 4.0

• Introduction to JDBC
• JDBC architecture
• java.sql Package
• Connection, Statement, ResultSet
• Prepared Statement
• Callable Statement
• Scrollable and Updatable ResultSet
• Batch Updates
• ResultSetMetaData
• Simple Transaction Management
• Four Levels of JDBC drivers, their pros & cons
• Features of JDBC 3.0

Servlets 3.0 

• Need of Server side Programming
• Introduction to Servlets
• Servlet Life Cycle
• javax.servlet package
• ServletConfig, ServletContext, ServletResponse
• Supplying initialization parameters to Servlets
• Performing database operations in Servlets
• Include and forward mechanisms
• Applying filters to Servlets
• javax.servlet.http Package
• HttpServlet Life Cycle
• Http request methods GET vs POST
• HttpServletRequest, HttpServletResponse
• Dealing with Http headers & error codes
• Session Tracking, purpose
• Hidden form fields, Cookies
• Http Session, URL rewriting
• Event listeners
• Web application security

JSP 2.2

• Disadvantages of Servlets
• Introduction to JSP
• JSP Life Cycle
• Creating dynamic Web content with JSP
• Scripting elements
• Scriptlet
• Declaration
• Expression
• XML syntax for JSP elements
• JSP directives page, include and taglib
• JSP implicit objects
• JSP scopes
• Include and forward mechanism
• Using a Java bean in a jsp
• JSP Model 1 architecture
• JSP Model 2 (MVC) architecture
• Custom Tag Development
• Classic Tags, Simple Tags
• Error Handling in a jsp
• JSTL
• Expression Language
• Processing XML in a JSP

• Introduction to Java
• Variables, Data Types and Other Tokens
• Operators
• Control Flow
• A Brief Introduction to Classes
• Methods
• Inheritance and Polymorphism
• Package and Interface
• String Handling
• Exception Handling
• Applet
• Threads
• Event Handling
• AWT
• Vector
• Input and Output

• What is Database?
• What is Database System?
• F.CODD’s Rules
• RDBMS
• ORDBMS
• Difference Between DBMS, RDBMS & ORDBMS

2.SQL

• What is SQL?
• DDL Commands
• Create, Alter, Drop
• Truncate, Rename
• DML Command – Insert

SQL SELECT statements

• What is SQL?
• DDL Commands
• Create, Alter, Drop
• Truncate, Rename
• DML Command – Insert

Constraints

• Primary Key Constraint
• Unique Constraint
• Not Null Constraint
• Foreign Key Constraint
• Check Constraint
• Cascade Constraints

Joins

• What is a Join?
• Cartesian Join
• Equi Join
• Non – Equi Join
• Self Join
• Outer Join
• Left Outer Join
• Right Outer Join
• Full Outer Join
• Pseudo Columns

Functions

• Numeric Functions
• Character Functions
• Date Functions
• Conversion Functions
• General Functions
• Aggregating Data Using Group Functions

Sub Queries

• Simple Sub Queries
• Multiple Row Sub Queries

Update

• Data Updating
• Updating data using Sub Queries

Delete

• Deleting Data
• Deleting data using Sub Queries
• Deleting data using join

Transaction Control Language (TCL)

• Commit
• Roll back
• Save point

Database Objects

• View
• Synonym
• Sequence
• Index
• Privileges

View

• Simple View
• Complex View
• In Line View

Synonym

• Private Synonym
• Public Synonym

Privileges

• Grant
• Revoke

3.PL/SQL

• Block Structure of PL/SQL
• Data Types, Variables & Constants

Flow Control Statements

• Simple IF
• IF-THEN-ELSE Statements
• IF-THEN-ELSIF Statements

Iterative Statements

• Simple Loop
• While Loop
• For Loop

Attribute Data Types

• %type
• %Rowtype

Cursor Management

• What is Cursor?
• Implicit Cursor
• Explicit Cursor
• Cursor with parameters
• Cursor with For Loop

Exceptions

• What is an Exception?
• Predefined Exception
• User defined Exception

Sub Programs

• Named PL/SQL Block
• Stored Procedures
• Types of Parameters
• Stored Function
• Difference between Function and Procedure

Package

• What is package?
• Importance of package

Triggers

• What is a Trigger?
• Row Level Trigger
• Table Level Trigger
• Instead of Trigger
• DML Triggers
• System Trigger

• 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

• What is C
• Variables and Keywords
• Constants
• Data Types
• Operators
• Looping Statements
• Functions
• Storage Classes
• Array
• Structure
• Pointer
• Union
• Header Files
• Dynamic linking
• Signals, forking and interprocess communication.
• Threading, and related advanced concepts
• Raw sockets
• The use of setjmp, longjmp for saving and restoring state
• Getting the return address of a function
• Memory management and fragmentation
• Interfacing between kernel modules and user level code.

• Basic In C++
• Control Structures
• Functions
• Oops Concepts
• Classes and Objects
• Constructors and Destructors
• Operator Overloading
• Inheritance
• Advanced Class Concepts
• Polymorphism and Virtual Functions
• Templates
• Exception Handling
• Streams
• Files
• Graphics
• Data Structures

• What is C
• Variables and Keywords
• Constants
• Data Types
• Operators
• Looping Statements
• Functions
• Storage Classes
• Array
• Structure
• Pointer
• Union
• Header Files

• Introduction to Web Technologies
• Adobe Photoshop
• HTML 4.01
• HTML 5
• Adobe Dreamweaver CC
• CSS 2
• CSS 3
• Responsive Web Design + BootStrap
• Java Script
• jQuery and jQuery UI
• Domain and Hosting
• WordPress
• Angular Javascript
• Website Design Project
• Web Designing Resources and Material

• Overview of .net (asp.net)
• Active server  pages .net role
• net web forms – the new technology(beginning)
• Form
• Web forms – introduction to ajax input validation
• net i – database services  (v1.1/2.0/3.5)
• net – ii
• Presenting data using asp.net bound controls (using vb.net/c#)
• Ajax ( atlas )
• net error handling &  debug.
• User controls
• Configuring asp.net application
• net web applications
• Cache services
• Security
• Deployment
• net xml web services
• Webparts
• Windows 10-new features.
• Mobile applications
• Smartphone and pocket pc
• Vsto – vs.net
• [ additional needed  services  in web  apps(optional)]

[ overview ]

• Sharepoint
• Biztalk