Point
Advertise your Institute
Mail us: university@siliconindia.com    Ph: 080-46441165
 
IT Courses > Visva Techologies
Training Institute - Visva Techologies Hyderabad
Visva Techologies
Hyderabad
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

Courses offered
J2EE   Advance Java  
Advanced SAS   SAS/WAREHOUSE ADMINISTRATOR  
SAS/MACROS   SS SQL  
SAS STAT   SAS Graph  
SAS Report   SAS/ODS