About Us
Visva Techologies offering
high quality training with cost effective services to individuals We have expert
trainers and flexible timing who constantly upgrade the skills/technologies so that
the professional levels of competency are ensured through our esteemed services. We
will help you find a course you would love to learn and enhance your knowledge,
Weoffers wide spectrum of training solutions that are designed to suit every skill,
ranging from procedural, operational, managerial to the end user. And incorporates
outstanding individuals from diverse and separate background experiences, which
focuses on providing the best quality support and the right technology solution
Online Courses Offered
SAS
(Statistical analysis system), the world’s fastest and powerful statistical
package for data analysis. It comprises multi engine architecture for better data
management and reporting.
Faculty - VENKAT (6+ yrs of Exp in IT,
Certified Professional & Online Trainer in SAS BI )
Duration - 30 Hours
SAS SYLLABUS - PART-I
BASE SAS
*
Introduction To Sas System & Architecture
* History And
Various Modules
* Features
*
Variables & Sas Syntax Rules
* Sas Data Sets
* Data Set Options
* Operators
* If – Then Else Statement
* Where
Statement
* Creating & Redefining Variables
* Reading Raw Data
* Infile Statement
With Options
* Multiple Observations and Multiple
Datasets.
* Input Styles
* SAS
Functions
* Select Statement
* Do
Loops
* Leave and Continue Statements
* Output Statement & Put Statement
* Stop And Error
Statements
* Array Statement
*
Modifying And Combining Data Sets
* Updating Master Data
Set
* Key Board Macros & Add Abbreviations
* Display Manager Commands
* Using cross
over statement
* PDV and input buffer with compilation and
description phase.
* USING LRECL RAW DATA
SAS/REPORTS
* Frequency Report
* One-Way Frequency Report
* Cross
Tabular Frequency Report
* Summary Statistics
* Creating A List Report
* Define
Statement
* Order Usage and Group
*
Printing Grand Totals
* Rbreak Statement
* Tabulate Procedure
* One-Dimensional
Tables
* Two-Dimensional Tables
*
Obtaining A Total
* Analysis Variables with options
* Summary Statistics
BASE
SAS PROCEDURES
* Proc Sort
*
Proc Print
* Proc Means
* Proc
Freq
* Proc Plot
* Proc Chart
* Proc Compare
* Proc Copy
* Proc Summary
* Proc Append
* Proc Datasets
* Proc Contents
* Proc Delete
* Proc Format
* Proc Printto
* Proc Import
* Proc Export
* Proc transpose
* Proc cross tabulation
* And various
types of calculations based on observations and variables using PROC.
SAS/ODS
* Creating Rtf File
*
Creating Html File
* Creating Pdf File
* Creating Xml File
SAS SYLLABUS - PART -II
ORACLE - SQL CONCEPTS
* Introduction
* History
* Features
* Sql Command Set
* Operators In Sql
* Order By Clause
* Group By Clause
* Having Clause
* Distinct Clause
* Create and Insert
* Deleting,
Populating And Updating
SAS/REPORTS
*
Frequency Report
* One-Way Frequency Report
* Cross Tabular Frequency Report
*
Summary Statistics
* Creating A List Report
* Define Statement
* Order Usage and
Group
* Printing Grand Totals
*
Rbreak Statement
* Tabulate Procedure
* One-Dimensional Tables
* Two-Dimensional Tables
* Obtaining A Total
* Analysis Variables
with options
* Summary Statistics
SAS/GRAPH
* Chart Procedure
* Vertical &
Horizontal charts
* Donut ,Pie & Block charts
* Group & Subgroups
* Gplot
Procedure
* Multiple Plots & Overlay
* Symbol Statement
* Title and Footnote
Statements
* Goptions
SAS/STAT
# Proc
Univariate
# Proc Corr
# Proc Reg
# Proc Anova
# Proc Rank
SAS/ETL
* Introduction To ETL
* Other ETL tools
* Application Of ETL In DW
* ETL Process Model Development In SAS With Project
* Resume preparation and various interview questions and
certification material and guidance free.
SAS/SQL
* Introduction To SAS/SQL
* Features & Uses
* Terminology
* Data Types, Key Words, & Operators
* Functions, Predicates & Functions
* Formatting
Output
* Group By Clause, Order By Clause & Having
Clause
* Case Expression and Conditional Logic.
* Creating ,Populating & Deleting Tables
* Alter Table Statement
* Renaming A
Table & Columns
* Changing Column’s Length
* Joins & Views
SAS/ACCESS
* Import & Export Procedures
*
Importing data from Ms-Access & Ms-Excel
* Importing data
from Oracle database
* DbLoad Procedure
SAS/MACROS
* Macro Concepts
*
Macros And Macro Variables
* Creating Macro Variables
* Using Macro Variables
* Creating
Modular Code With Macros
* Invoking A Macro
* Adding Parameters To Macros
* Macros
With Conditional Logic
* Using Various Procedures In
Macros
* Automatic Variables
* Macro
Functions
* Including External Macros
SAS/WAREHOUSE ADMINISTRATOR
* Introduction To DW
* Relationship Between SAS And Data Warehousing
* Advantages & disadvantages
*
Global Warehouse Designing Steps
* Database Designing
* Set up DWH Environment
* Add DWH to
DWH Environment
SAS SYLLABUS - PART -III (Only One Project)
* CLINICAL PROJECT
* BANKING PROJECT
* HEALTHCARE PROJECT
ADVANCED SAS
* ENETRPRISE GUIDE
* DATA INTEGRATION STUDIO
* OLAP CUBE
STUDIO
* INFORMATION MAP STUDIO
* SAS
__ADD IN FOR MICROSOSOFT OFFICE
* WEB REPORT STUDIO
J2SE5.0 & 6.0
* How to install java
* JVM architecture
* Data types,
Variables, Keywords and Identifiers
* Operators and
Expressions
* Naming Conventions in Java
* Control flow statements
* Arrays,
Command line Arguments
* Object and class
* Object oriented programming
*
Inheritance
* Interfaces
* Abstract
classes, inner classes
* Access specifiers, access
modifiers
* Packages
* Collection
Framework
* Exception Handling
*
Multi Threading
* Input/Output Streams
* Networking
* AWT, Applets and
swings
* FAQ’S and SCJP Exam Oriented Concepts
NEW FEATURES
* Generics
* Enhanced for loop (foreach loop)
*
Auto Boxing/ Un Boxing
* Typesafe Enums
* Varargs
* Static Import
* Metadata (Annotations)
* Collections
Framework
* Reflection API
*
Application development on eclipse IDE
Advanced java (web technologies)
JDBC 4.0
* Introduction to JDBC
* JDBC architecture
* Java.sql
package
* Connection, Statements, Resultset
* Prepared Statement
* Callable
statement
* Scrollable and updated Resultset
* Batch updates
* Resultset Metadata
* Simple transaction management
* Four
levels of JDBC drivers,their pros & cons
* Features of
JDBC 3.0
J2EE
* RMI remote method
ivocation
* J2EE architecture
* J2EE
vs .NET
* EJB enterprise java Beans
*
EJB 2.0
* EJB 2.1
* EJB 3.0
* EJB 3.1
* JTS/JTA java transaction
service /java transaction API
* JNDI java naming &
directory interface
* JAAS (java authentication and
authorization service)
* JMS 1.1 (java messaging service)
* Java mail 1.3
* XML (extensible markup
language)
* XSL
* JAXP 1.2 (java API
for XML parsing)
SERVLETS 3.0
* Need of server side programming
*
Introduction on servlets
* Servlet life cycle
* Javax. Servlet package
* Servlet
config, servlet context,servlet response
* Supplying
initialization parameters to servlets
* Performing database
operators 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
*
disadvantages of servlets
* introduction to JSP
* JSP life cycle
* Creating dynamic web
content with JSP
* Scripting elements
o Scriplet
o Declaration
o 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