SiliconIndia > Training Institutes > Visva Techologies
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
      • Scriplet
      • 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
       
    Contact counselors
    ------------------------------------------------------------------------------------------------
    *Name  
    *Email
    *Location  
    *Ph/mob  
    Message  
    *Type the characters you see in the picture

    ------------------------------------------------------------------------------------------------
    Contact Us
    Mr.Venkatesh
    Mobile : 07396002845
    Email : cvpvenkat@gmail.com
    Hyderabad