Examine road

WARM WELCOME FROM VELGRO TECHNOLOGIES!!! We are providing training for DATA WAREHOUSE Training is provided by well experienced (REAL TIME) Faculty!!! Fee structure Course fees: RS./- Data Warehouse The Compelling Need for Data Warehousing • Escalating Need for Strategic Information • Failures of Past Decision-Support Systems • Operational Versus Decision-Support Systems • Datawarehousing—The Only Viable Solution • Datawarehouse Defined • The Datawarehousing Movement • Evolution of Business Intelligence Data Warehouse: The Building Blocks • Review formal definitions of a data warehouse • Discuss the defining features • Distinguish between data warehouses and data marts • Study each component or building block that makes up a data warehouse • Introduce metadata and highlight its significance Trends in Data Warehousing • Data Warehouse Do-Overs • Proliferation of Data Sources • Outsourcing • Hub Versus Relational Databases • Active Data Warehouses • Fusion with CRM • Growing Number of End Users • More Complex Queries • Integrated Customer View • Exploding Data Volumes Planning and Project Management • Phases in project management • Inception • Elaboration • Construction • Transition Defining the Business Requirements • To gain agreement with stakeholders • To provide a foundation to communicate to a technology service provider what the solution needs to do to satisfy the customer’s and business’ needs • To provide input into the next phase for this project • To describe what not how the customer/business needs will be met by the solution Requirements as the driving force for data warehousing • Understand why business requirements are the driving force • Discuss how requirements drive every development phase • Specifically learn how requirements influence data design • Review the impact of requirements on architecture • Note the special considerations for ETL and metadata • Examine how requirements shape information delivery The Architectural Components • Overall Architecture • Data Warehouse Database • Sourcing, Acquisition, Cleanup and Transformation Tools • Meta data • Data Marts • Data Warehouse Administration and Management Infrastructure as the Foundation for Data Warehousing • Understand the distinction between architecture and infrastructure • Find out how the data warehouse infrastructure supports its architecture • Gain an insight into the components of the physical infrastructure • Review hardware and operating systems for the data warehouse • Study parallel processing options as applicable to the data warehouse • Discuss the server options in detail • Learn how to select the DBMS • Review the types of tools needed for the data warehouse • Study the concept and use of data warehouse appliances The Significant Role of Metadata • Find out why metadata is so important • Understand who needs metadata and what types they need • Review metadata types by the three functional areas • Discuss business metadata and technical metadata in detail • Examine all the requirements metadata must satisfy • Understand the challenges for metadata management • Study options for providing metadata Principles of Dimensional Modelling • Clearly understand how the requirements definition determines data design • Introduce dimensional modelling and contrast it with entity-relationship modelling • Review the basics of the STAR schema • Find out what is inside the fact table and inside the dimension tables • Determine the advantages of the STAR schema for data warehouses Dimensional Modelling: Advanced Topics • Discuss and get a good grasp of slowly changing dimensions • Understand large dimensions and how to deal with them • Examine the snowflake schema in detail • Learn about aggregate tables and determine when to use them • Completely survey families of STARS and their application Data Extraction, Transformation, and Loading • Part I: When to build your data warehouse • Part II: Building a new schema • Part III: Location of your data warehouse The Physical Design Process in DWH • Distinguish between physical design and logical design as applicable to the data warehouse • Study the steps in the physical design process in detail • Understand physical design considerations and know the implications • Grasp the role of storage considerations in physical design • Examine indexing techniques for the data warehouse environment • Review and summarize all performance enhancement options • Matching Information to the Classes of Users OLAP in the Data Warehouse • OLAP (Online Analytical Processing) • Overview & Introduction • OLAP Cube • HISTORY of OLAP • OLAP Operations • DATAWAREHOUSE • ARCHITECHTURE Difference between OLAP & • OLTP & TYPES OF OLAP APPLICATIONS OF OLAP • Data Warehousing and the Web • Data Warehouse Deployment • Data Quality: A Key to Success • Data Mining Basics • Growth and Maintenance contact person: SUJITHA Venue Address: #st floor,Gandhi Road, Velachery Email Id:velgrotechnologies at gmail dot com info at velgrotechnologies dot com Website:www dot velgrotechnologies dot com

Type Professional Courses SQL Performance Tuning Training FabGreen is a Training institute and software development company located in Bangalore. We provide quality IT training either at our training center or at client premises. We provide training in SharePoint, BizTalk, QTP, Selenium, and SQL. All our courses are taught by experienced trainers who have extensive field knowledge with the topics they teach. FabGreen provide services to wide range of customers like for the working professional, job seeking candidates, corporate & to the students. We provide effective and efficient customer service, answering your queries promptly and being as helpful as possible in assisting you to choose the right course. Course Features: • Sample Live Projects are provided • Lab Facility 14/7 • Interview guidance - Questions and Sample Resumes • Technical guidance and support after the course completion • Course Materials Provide • Flexible training - Individual and Batch FabGreen Technologies #6/05, VP road, 2nd cross, Old Madivala, Bangalore - Phone: / Land Marks: 1. Opposite to Total Mall Land Marks: 2. Behind Anjaneya Temple Course Objectives: • Use Windows Performance Monitor • Create a performance baseline • Collect and analyze SQL Server Extended Events • Analyze the performance of SQL queries • Analyze and optimize indexes • Use the Database Tuning Advisor • Examine and correct fragmentation • Review execution plans and the execution plan cache for optimizations • Analyze the performance of SQL queries • Design more efficient queries • Detect and reduce or eliminate blocking • Catch and solve deadlocks • Optimize database workloads Course Content: • Performance Tuning Overview • System Performance Analysis • SQL Query Performance Analysis • Index Analysis • Database Engine Tuning Advisor • Bookmark Lookup Analysis • Statistics Analysis • Fragmentation Analysis • Execution Plan Cache Analysis • Query Recompilation • Query Design Analysis • Blocking Analysis • Deadlock Analysis • Cursor Cost Analysis • Database Performance Testing • Conclusion Other Courses Offered: • SharePoint Administration • SharePoint Development • BizTalk • QTP • Selenium • IOS Training • SQL Server Administration • Query Writers • Performance Tuning • MS Business Intelligence • MDX • SQL Server Analysis Services (Multi Dimensional) • SQL Server Integration Services • SQL Server Reporting Services

SAP Transport Management Course curriculum 1. SAP TM OVERVIEW (TM90) – 3 HOURS 1.1. The SAP Transportation Management System Overview 1.2. Managing Transportation Execution 1.3. Master Data Requirements for the SAP TM System 1.4. Reporting and Analytics in the SAP TM System 1.5. Integration of SAP Transportation Management with Other Applications ACHIEVE GOALS • Explain the tangible and strategic benefits of an Integrated TM solution • Discuss the implementation of SAP Transportation Management (TM) to • integrate enterprise wide transportation processes with its core business • processes • Outline the transportation business processes provided by SAP TM • Understand SAP TM and how it is used in various transportation scenarios • including manual planning, “one click planning” – for both Inbound and • Outbound transportation 2. PROCESSES IN SAP TRANSPORTATION MANAGEMENT OVERVIEW (TM100) – 25 HOURS 2.1. Introduction to Net Weaver Business Client UI 2.2. Introduction to Network Master Data: 2.2.1. Products and Locations 2.2.2. Transportation Lanes and Resources 2.2.3. Other#. 2.3. Overview of supported Business scenarios: 2.3.1. Outbound and Inbound Shipments (Domestic and Int#l) 2.3.2. Ocean Freight 2.3.3. Air Freight 2.3.4. Freight Forwarding 2.4. Overview of Transportation Planning 2.4.1. Examine concept of Freight Units 2.4.2. Create Transportation Proposals 2.4.3. Generate Freight Orders 2.5. Examination of Transportation Execution 2.5.1. Carrier Selection 2.5.2. Tendering Shipments 2.5.3. Delivery Generation and Integration 2.5.4. Shipment Creation 2.5.5. Generate Documents and Analytics 2.6. Introduction to Freight Settlement 2.6.1. Transportation Charge Management 2.6.2. Calculating Charges 2.6.3. Freight Settlement 2.6.4. Generating Accruals 2.6.5. Cost Distribution ACHIEVE GOALS • This course will prepare the participant to outline the transportation business processes provided by the SAP Transportation Management (TM) system. • This will be accomplished by identifying and examining the SAP TM building blocks necessary for processing shipments of goods. Participants will engage in Transportation network maintenance, order/requirements integration and management, transportation planning, shipment execution, and freight invoicing and settlement. Each participant will have the opportunity to utilize both the SAP ERP and SAP TM systems using the NetWeaver Business Client interface. 3. PLANNING IN TRANSPORTATION MANAGEMENT- PROCESSES AND CUSTOMIZING (TM110) – 25 HOURS 3.1. Creation of Organizational elements related to Transportation Planning 3.2. Designing a transportation network: 3.2.1. Overview of ECC master data 3.2.2. Locations 3.2.3. Transportation Zones and Hierarchies 3.2.4. Means of Transportation and Transportation lanes 3.2.5. Resources and Equipment Types 3.3. Conditions and Incompatibilities to support transportation restrictions 3.4. Creating and Configuration Order Management Scenarios: 3.4.1. Configure ERP Requirement Integration 3.4.2. Configure TM requirement and Planning Document Types 3.4.3. Set up and discuss Sales order Scheduling Scenarios 3.5. Perform Transportation Planning activities Selection and Planning Profiles 3.6. Experiment planning with Transportation cockpit Personalize Transportation Cockpit 3.7. Perform Interactive Transportation Planning scenarios 3.7.1. Modal decisions 3.7.2. Pooled Shipments 3.7.3. Automated Planning (Zero Click) 3.7.4. International Ocean Shipments ACHIEVE GOALS • This course will enable participants to grasp in detail the transportation network Configuration, the ECC integration for both master and transactional data as well as the configuration of different planning scenarios. They will build a transportation network using integration to ECC; Setup integration between ECC and TM to support both inbound and outbound transportation requirements; Setup and execute several different planning scenarios related To road and ocean transportation processes using manual and automated planning capabilities. 4. TM CHARGE MANAGEMENT 4.1. Business purpose and key business requirements 4.2. Architecture of Transportation Charge Management 4.3. Master Data – Scale 4.4. Master Data – Rate Table 4.5. Master Data – Calculation Sheet 4.6. Master Data – Agreement 4.7. Forwarding Settlement Document 4.8. Freight Settlement Document 4.9. Transfer Forwarding and Freight Settlement document to SAP ERP 4.10. Brief overview of Business Analytics in SAP TM8.0 with Business Content Viewer (BCV) and Xcelsius ACHIEVE GOALS • Identify customer requirements for configuring and implementing the transportation • charge management module of SAP TM8.0 • Explain the key master data set up for transportation charge management module of • SAP TM8.0 • Explain and demonstrate how to create settlement documents in SAP TM8.0 and • Transfer to SAP ERP.

PHP/ MYSQL TRAINING. PHP is a widely used programming language which works on the principal of server side scripting to produce dynamic Web pages. It can be easily integrated with HTML and SQL to produce these dynamic web pages, and is often used to process the contents of a Web page form as it is more secure and reliable than JavaScript. Learning outcomes: - Understanding the basics of the PHP; - Examine how web pages are developed using PHP; - Learn certain specific PHP variables and syntax; - Better understanding of how PHP, HTML and MYSQL work together to produce dynamic pages. we do have weekday and weekend batches we are giving 100% placement assistance for freshers and experienced For More information on Course Details, batch schedules, fee structure and Registration Please contact: Software Training Labs # 46, First floor, C.C. Willa, Off Intermediate Ring Road, Next to Ejipura Signal. Bangalore-47:

Splunk is a software that enables, and manages search data from any application, server, and network device in no time. � Splunk makes machine data reachable, utilizable and helpful to everyone.It�s the secure way to examine the enormous streams of machine data produced by technology infrastructure and IT systems �virtual, physical, and in the cloud. � A number of corporations around the world use Splunk to scrutinize their end-to-end infrastructures, shun service outages and gain real-time critical insights into client�s experience, transactions and key business metrics. BigDataTraining. IN is a rapidly growing software development company providing high quality software development and IT consulting services. � BigDataTraining. IN consultants are experienced professionals who combine a solid � technology foundation with an in depth understanding of business processes. Registrations Open Call: +91 Visit Us: #67, 2nd Floor, Gandhi Nagar 1st Main Road, Adyar, Chennai-20 To register for upcoming Splunk training classes 3 days (Classroom) - June

Splunk is a software that enables, and manages search data from any application, server, and network device in no time. � Splunk makes machine data reachable, utilizable and helpful to everyone. It�s the secure way to examine the enormous streams of machine data produced by technology infrastructure and IT systems �virtual, physical, and in the cloud. � Apache Splunk training,Best Splunk training in classroom,Apache splunk chennai,Splunk training in chennai,Splunk fastrack This course is designed for IT professionals - developers, non-Hadoop engineers, managers & freshers to dive deeply into Hadoop Stack detailed design and hands-on exercises. After completion of this course, you will be able to design and implement BigData solutions to solve complex data problems. Learn the way Industry Wants � Splunk training with Production Level UseCases +91 Visit Us: #67, 2nd Floor, Gandhi Nagar 1st Main Road, Adyar, Chennai-20 To register for upcoming Splunk classes Fast Track (3 days Classroom) July

WHAT IS SAS? SAS (Statistical Analysis System) BASE is developed for business intelligence. It is integrated software for access data, manage data and generating reports. It SAS BASE training in Peridot systems gives in depth knowledge on subject. In this program we teach you the basics of data warehousing before starting SAS BASE class. In this training we cover syllabus in modules of SAS, accessing data, creating data. Course Structure BASICS BEFORE STARTING SAS: • DATAWAREHOSING Concepts. • What is ETL? SAS INTRODUCTION: • What is SAS? • History of SAS. • Modules available SAS. • Create temporary and permanent SAS data set. • Combining SAS Data Set. • Understanding How Data Sets Are Read. MANAGING DATA • Investigate SAS data libraries using base SAS utility procedure • Sort observations in a SAS data set. • Conditionally execute SAS statement. • Use assignment statement in the DATA step. GENERATING REPORT • Generate list report using the PRINT procedure. • Generate summary reports and frequency tables using base. HANDLING ERRORS • Identify logic errors. • Recognize correct syntax errors. • Examine data errors. Venue: Kamatchi Krupa Apts, No: 84/8, Ground Floor, Venkatarathinam main street, Venkatarathinam Nagar, LB Road, Adyar, Chennai, Mobile : 8056102481/96000-63484 Mail: papitha.v@peridotsystems.in

Kalvi Higher Education and Research Institute OCA, OCJP Certification Training in Madurai Kalvi Higher Education and Research Institute is a global training provider. Started its training activity in the year 2001.We have our corporate office at Madurai. We are an ISO 9001:2008 certified Institution on Quality Management System Standard. Our Trade mark is registered and we are approved by Govt of Tamil Nadu. Our core strength is offering long-term and short-term courses in high-end topics in IT. OCA, OCJP Certification Training in Madurai This course introduces students to the new features in Oracle Database 10g Release 2 - the database for Grid computing. Students learn how to use Oracle Database 10g new features to increase database availability, to simplify database performance monitoring and tuning through the use of Oracle Database 10g Advisors, and to offer simplified database manageability. The course also covers security changes that students need to understand. Hands-on practice sessions give students an opportunity to examine many of the new features, and to practice database administration with Enterprise Manager Database Control. OCA, OCJP Certification Training in Madurai Corporate Office: MADURAI 134, First Main Road, K.K.Nagar, Madurai - 625020. 91-9500710004 0452-4353991 / 4354991