Tuesday, January 9, 2018

Regulatory Affairs Training in Hyderabad,india

PSN Trainings is the Best Regulatory affairs Online/Classroom Training institute in Hyderabad,india

Regulatory Affairs Course Description

Introduction to Regulatory Affairs
  • What is Regulatory Affairs, Importance of RA department, Roles and their functions, Worldwide regulatory agencies and their roles

  • Notes on clinical trials, Drug development, Pre-formulation studies, API characterization, Generics, Innovator drugs, bio technology products and medical devices (CE marking)Regulatory Affairs Training in Hyderabad

  • ICH guidelines: Stability Testing of New Drug Substances and Products Stability Testing, Photo stability Testing of New Drug Substances and Products, Stability Testing for New Dosage Forms, Bracketing and Matrixing Designs for Stability Testing of New Drug Substances and Products, Evaluation of Stability Data, Impurities in New Drug Substances, Impurities in New Drug Products, Impurities: Guideline for Residual Solvents, Pharmaceutical Development, carcinogenicity Studies, Genotoxicity Studies.

  • Introduction to Indian Pharma industry, Drug approval process in India, Regulations of Drugs and cosmetics Act, 1945.Regulatory Affairs Training in india

  • USFDA Introduction, 21CFR, ANDA Regulatory Approval Process (US), Hatch-Waxman act, Patents and their types, GDUFA, Post approval changes (Annual reports, CB-30 and prior approval supplements), Types of DMF’s, Rules and guidelines.

  • Drug regulatory authorities in European Union (EU), different types of approval procedures (MRP, DCP, National and Centralized Procedures), brief study on post approval changes (variations and extensions), approval procedures for drug substance (DMF and CEP), rules and regulations.

  • Drug approval process in Australia, Canada, Japan and ROW markets.Regulatory Affairs Training in Ameerpet 

  • Discussion in details on M4 Common Technical Document CTD (Module 1 to 5), eCTD submissions, NeeS format.

  • Hands on experience in CTD dossier compilation

  • Handling of responses, post inspection, audit queries, GMP, GLP trainings.

  • Resume preparation and mock up interviews

Tuesday, December 5, 2017

msbi training in hyderabad @psn trainings

PSN Trainings is the Best MSBI Microsoft Business intelligence training(SSIS, SSAS, SSRS)Training institute in Hyderabad,India
Course Description

Introduction

Data Warehousing Basic Concepts

  • Data Warehouse Definition,
  • Reasons for using, uses
  • Characteristics of DWH
  • OLTP Vs OLAP Databases
msbi training in hyderabad
msbi training in india

Data Marts and Star Schema Design

  • Design of Dimension and Facts
  • Definition of Star Schema
  • Snow Flake Star Schema
  • Slowly Changing Dimensions
  • Type of Facts
  • Conformed Dimensions

Implementation Methodology

  • Kimball Methodology
  • Inmon Methodology

Types of Loads

  • First Time Load
  • Full Load
  • Incremental Load

I) SQL Server Integration Services (SSIS)

1. Introduction to SQL Server Integration Services

  • Product History
  • SSIS Package Architecture Overview
  • Development and Management Tools
  • Deploying and Managing SSIS Packages
  • Source Control for SSIS Packages

2. SQL Server Data Tools(Visual Studio)

  • Launching Data tools
  • Project templates
  • The package designer
  • The Toolbox
  • Solution Explorer
  • The Properties window
  • The Variables window
  • The SSIS menu

3. Introduction to Control Flow

  • Control Flow Overview
  • Precedence Constraints
  • The Execute SQL Task
  • The Bulk Insert Task
  • The File System Task
  • The FTP Task
  • The Send Mail Task

4. Advanced Control Flow

  • Containers - grouping and looping
  • The Analysis Services tasks
  • The Execute Process Task
  • The Execute Package Task
msbi online training in india
msbi online training in hyderabad

5. Introduction to Data Flow

  • Data Flow Overview
  • Data Sources
  • Data Destinations
  • Data Transformations
  • The Copy Column Transformation
  • The Derived Column Transformation
  • The Data Conversion Transformation
  • The Conditional Split Transformation
  • The Aggregate Transformation
  • The Sort Transformation
  • Data Viewers

6. Variables and Configurations

  • Variables Overview
  • Variable scope
  • SSIS system variables
  • Using variables in control flow
  • Using variables in data flow
  • Using variables to pass information between packages

7. Debugging, Error Handling and Logging

  • SSIS debugging overview
  • Breakpoints in SSIS
  • SSIS debugging windows
  • Control Flow: The On Error event handler
  • Data Flow: Error data flow
  • Configuring Package Logging

8. Advanced Data Flow

  • The Lookup Transformation
  • Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
  • The Multicast Transformation
  • The Slowly Changing Dimension Transformation

9. Extending SSIS through Custom Code

  • Introduction to SSIS scripting
  • The SSIS script editor
  • The SSIS object model
  • Script in Control flow: The Script Task
  • Script in Data flow: The Script Component
  • Introduction to SSIS component development

10. SSIS Package Deployment

  • Configurations and deployment
  • Managing packages with DTutil
  • Managing packages with SQL Server Management Studio

II) SQL Server Reporting Services (SSRS)

1. Introducing SQL Server Reporting Services

  • Features
  • Reporting Services Architecture
  • Reporting Services Terminology
  • Reporting Services Editions

2. Creating Reports

  • Shared Data Sources
  • Creating Reports from Scratch

3. Calculations and Formatting

  • Reporting Services Items
  • Basic Expressions
  • Using the Global Collections
  • Formatting Fields
  • Conditional Formatting

4. Grouping and Sorting

  • Creating Groups
  • Interactive Sorting
  • Creating Drill-Down Reports
  • Calculating Totals and Percentages

5. Report Parameters

  • Creating Report Parameters
  • Binding Report Parameters to Dataset Parameters
  • Creating Drop-Down Parameters
  • Multi-Valued Parameters

6. Creating Matrix Reports and Charts

  • Creating a Basic Matrix Report
  • Matrix Subtotals
  • Creating Chart Reports
  • Exploring the Charting Possibilities
  • Charting Add-ons

7. Managing Reporting Services

  • Using the Web-Based Report Manager
  • Using SQL Server Management Studio- based Reporting Services Manager
  • Deploying Reports and Data Sources

8. Reporting Services Security

  • Reporting Services Security
  • Managing Roles

9. Distributing Reports via Subscriptions

  • How Subscriptions Work
  • Creating Standard Subscriptions
  • Creating Data-Driven Subscriptions
  • Managing Subscriptions

10. Ad-Hoc Reporting with Report Builder

  • The Report Builder Architecture
  • Creating Report Model Projects
  • Running Report Builder

III) SQL Server Analysis Services (SSAS)

1. Introduction to Microsoft SQL Server Analysis Services

  • Overview of Data Analysis Solutions
  • Overview of SQL Server Analysis Services.
  • Installing SQL Server Analysis Services.

2. Creating Multidimensional Analysis Solution

  • Developing Analysis Services Solutions.
  • Data Sources and Data Source Views
  • Creating a Cube

3. Working with Dimensions

  • Configuring Dimensions
  • Defining Hierarchies
  • Sorting and Grouping Attributes

4. Working with Measures and Measure Groups

  • Working with Measures.
  • Working with Measure Groups.

5. Querying Multidimensional Analysis Solutions

  • MDX Fundamentals
  • Adding Calculations to a Cube

6. Customizing Cube Functionality

  • Implementing Key Performance Indicators.
  • Implementing Actions
  • Implementing Perspectives.
  • Implementing Translations.

7. Deploying and Securing an Analysis Services Database

  • Deploying an analysis Services Database.
  • Securing an Analysis Services Database.

Tuesday, September 19, 2017

Best RPA Training institute in Hyderabad,india @ PSN Trainings

PSN Trainings is the Best Robotic Process Automation(RPA) Training Online and Classroom Training institute in Hyderabad,india.Tools like BluePrism Training, Automation Anywhere Training,UiPath Training and OpenSpan Training
AWS Course Description

Introduction to RPA

    1.RPA Automation Anywhere (AA) Tool


  • NLP and RPA
  • How Robotic Process Automation works
  • Why to automate repetitive tasks/process
  • List of Robotic Process Automation Tools
  • Robotic Process Automation Tool selection Checklist
  • Product Architecture
  • RPA Training in Hyderabad

    Task Bots

  • Meta Bots
  • IQ Bots

  • Automation Anywhere Dashboard

    Task Bots

  • Recording a Task
  • Task Creation

  • Overview of Task Editor

  • Task Editor of features
  • Action List
  • RPA Training institute in Hyderabad

  • Commands used

  • Excel Command
  • Variable Operation Command
  • PDF integration Command
  • IF/ELSE Command
  • Database Command
  • Email Automation Command
  • File and Folder Commands
  • Error Handling Commands
  • PGP Command
  • Webservice Implementation
  • RPA Automation Anywhere Tool Training

  • 2.RPA Blue Prism Tool

  • Introduction to BP and Operational Agility
  • BP as an RPA Tool
  • Introduction to RPA and RDA components
  • Process Studio and Object Studio
  • Process Flow and circular paths/Input and outputs
  • Break points /Looping structure /Decision statements& Collections
  • Data Items(Local&Global)/Data Types
  • Case Management
  • BP Control Room Configuration & Credential Manager
  • Use of BP Item Templates (Coding Standard)
  • Application Modeller/Spying
  • BP Coding Standards
  • Attributes/Wait/Terminate commands
  • Error Management/Exception Handling
  • Release manager
  • USE CASE
  • FAQ's
  • RPA Blue Prism Tool Training in Hyderabad

  • 3.RPA UIpath Tool

  • Flowchart
  • Sequence
  •     Modular
  • Variables
  •     Data Manipulation
  • Recording
  • Documentation
  • Tool Activities
  • Advanced UI Interaction
  •     About UI Elements
        UI Activities Properties
  • Input Methods
  •     Example of Using Input Methods
  • Output or Screen Scraping Methods
  •     Examples of Using Output or Screen Scraping Methods
  • About Web Scraping
  •     Example of Using Web Scraping
  • About Data Scraping
  •     Example of Using Data Scraping
  • Selectors
  • Image and Text Automation
  •     Mouse and Keyboard Activities
        Text Activities
        OCR Activities
        Image Activities
  • Mouse and Keyboard Automation
  •     Text Automation
        OCR and Image Automation



Monday, May 29, 2017

Best Hadoop Training institute in Hyderabad @ PSN Trainings

PSN Trainings is the Best Big Data/Hadoop Analytics Online and Classroom Training institute in Hyderabad,India

Hadoop training in Hyderabad providing professional course in Hadoop Technology. Hadoop is a free, Java-based programming framework that supports the processing of large data sets in a distributed computing environment. It is part of the Apache project sponsored by the Apache Software Foundation. Hadoop makes it possible to run applications on systems with thousands of nodes involving thousands of terabytes. Its distributed file system facilitates rapid data transfer rates among nodes and allows the system to continue operating uninterrupted in case of a node failure. This approach lowers the risk of catastrophic system failure, even if a significant number of nodes become inoperative. PSN Trainings has the best expertise to handle the Hadoop training in Bangalore. PSN Trainings Provides Best Hadoop Online Training By Real-time Experts
.
Big data Hadoop Introduction
Introduction to Hadoop
History of Hadoop
Building Blocks - Hadoop Eco-System
Who is Behind Hadoop
What Hadoop is good for and what it is not

HDFS
Configuring HDFS
Interacting With HDFS
HDFS Permissions and Security
Additional HDFS Tasks
HDFS Overview and Architecture
HDFS Installation
Hadoop File System Shell
File System Java API

MAPREDUCE
Map/Reduce Overview and Architecture
Installation
Developing Map/Red Jobs
Input and Output Formats
Job Configuration
Job Submission
Practicing Map Reduce Programs (atleast 10 Map Reduce Algorithms)


Getting Started With Eclipse IDE

Configuring Hadoop API on Eclipse IDE
Connecting Eclipse IDE to HDFS

Hadoop Streaming

AdvancedMapReduce Features
Custom Data Types
Input Formats
Output Formats
Partitioning Data
Reporting Custom Metrics
Distributing Auxiliary Job Data

Distributing Debug Scripts

Using Yahoo Web Services

Pig

Pig Overview
Installation
Pig Latin
Pig with HDFS

Hive

Hive Overview
Installation
Hive QL
Hive Unstructured Data Analyzation
Hive Semistructured Data Analyzation

HBase

HBase Overview and Architecture
HBase Installation
HBase Shell
CRUD operations
Scanning and Batching
filters
HBase Key Design
ZooKeeper

Zoo Keeper Overview
Installation
Server Mantainace

Sqoop

Sqoop Overview
Installation
Imports and Exports

CONFIGURATION

Basic Setup
Important Directories
Selecting Machines
Cluster Configurations
Small Clusters: 2-10 Nodes
Medium Clusters: 10-40 Nodes
Large Clusters: Multiple Racks

Integrations

Putting it all together
Distributed installations



hadoop training in hyderabad
hadoop training in hyderabad