About Y2Fox eCatalog eLearner Kit eRegistration eSchedule Ask Experts Request Info Job Hunting Assistance  
SQL Microsoft Server 2005 Integration Service(SSIS)

Overview?
Microsoft SQL server 2005 Integration Services (SSIS) is a tool that lets you design, create, deploy and manage packages that address everyday business requirements. SSIS uses the extract transfer technology (ETL) to create complex solutions in order to support business decisions.

How you will learn?
Right from the comfort of you home, office you will be interacting live with
your instructor and other students. Most classes are about 2 hours for 2 to 5 weeks. Classes meet twice a week. If you missed a class you can download the video of the recorded classes free of charge. Students can submit questions to a team of experts from “Ask Our Experts” after registration for that service.

What You Will Learn:
Introduction to Integration Services
Scripting and Using .NET Assemblies in SSIS
Package Management - Security, Storage, Logging and Change Management
Package Execution and Scheduling
Variables and Expressions - Creating Dynamic SSIS Packages
Migrating and Upgrading From SQL Server 2000 Data Transformation Services (DTS) to SSIS in SQL 2005
Creating SSIS Packages - Container-based Tasks
Data Transformation and Data Flow Tasks in SSIS: Moving Data from Point A to Point Z
Installing and Configuring SQL Server Integration Services (SSIS)
Creating SSIS Packages using the New Package Wizard
Using the Business Intelligence Design Studio (BIDS) to Create Packages
Using Workflow, Constraints, and Error Sinks
SSIS Package Flow
Scheduling SSIS Packages and Executing SSIS Packages as Part of a SQL Server Job
SSIS Variables, Looping, and Downloading/Uploading Text Files.
and more.  See visual Layout

Prerequisites: Familiarity with database concepts and Windows or equivalent knowledge is recommended but not required.
 

Microsoft SQL Server Analysis Service (SSAS)

What is SSAS used for?
Microsoft SQL Server 2005 Analysis Services (SSAS) will help you create sophisticated online analytical processing (OLAP) and data mining solutions. The Analysis Services tools provide the capability to design, create, and manage cubes and data-mining models from data warehouses and to provide client access to OLAP data and data mining data. The step-by-step tutorials in the following list will help you learn how to get the most out of Analysis Services so that you can work efficiently, right from the start.

What You Will Learn:
You will learn how to define data sources, data source views, dimensions, and cubes in an Analysis Services project within BI Development Studio. You will also learn how to view a cube by deploying the Analysis Services project to an instance of Analysis Services and then processing the deployed objects. You will also learn how to modify the measures, dimensions, hierarchies, attributes, and measure groups in the Analysis Services project, and how to then deploy the incremental changes to the deployed cube on the development server. Finally, you will learn how to define calculations, Key Performance Indicators (KPIs), actions, perspectives, translations, and security roles and more.
See visual Layout

Prerequisites: Familiarity with database concepts and Windows or equivalent knowledge, is recommended but not required.


Microsoft SQL Server Reporting Service  (SSRS)

This class will allow you to create a basic Report
Follow the steps in this tutorial to learn how to create your first report. This tutorial shows you how to work with Report Designer to create a data source connection, define a simple query, and build a layout to contain your data. You will how to:
Creating a Report Server Project
Creating a Report
Setting Up Connection Information
Defining a Query for the Report
Adding a Table Data Region
Previewing the Basic Report
If you want to have a more advance understand and hand-on experience with Microsoft Reporting service please contact us by filling  up the custom training request form.
 See Reporting service courses visual Layout

Microsoft SQL Server 2005 Replication

What is Replication used for?
There are numerous reasons to use replication, including sales data distribution and collection, pricing distribution, offloading of reports, and more. Replication takes a database or subset of a database and keeps it up-to-date on another server uses are extensive. Uses of replication can include:
• Scaling out applications
• Data warehousing
• Distributing and consolidating data from satellite locations
• Offloading report processing

What You Will Learn:
You will learn replication components, types of replication, configure replication based on real world scenario, Managing replication, Monitoring and Tuning Replication. At the end of this class you will master everything you need to know to apply your knowledge to real world scenario. See video layout
Prerequisites: Familiarity with database concepts and Windows or equivalent knowledge, is recommended but not required.
Free classes based on real world scenario

For our SQL students you should know that if you register for one of leading class such as SSIS – SSAS- Reporting Services - Replication – Transaction SQL – DTS
You get free classes for Log shipping and database Mirroring- Disaster Recovery Solutions and Performance tuning introductory.

Oracle Database applications:

What Recovery Manager (RMAN)

What RMAN is for?
Backup can be made using straightforward operating system utilities such as WinZip on windows, cp, tar, cpio on UNIX. But any Oracle shop it’s highly recommends using Recovery Manager. The possibility to recover lost data is one of main occupation of your job as DBA. RMAN gives you a greater possibility to recover lost data.

What You Will Learn?
You will learn how to
Configure database parameter that affect RMAN operations
Change RMAN default settings with CONFIGURE
Manage RMAN’s persistent settings
Start RMAN utility and allocate channels
Use The RMAN Backup command to create Backup sets and image copies
Enable block change tracking
Manage the backups and images copies taken with RMAN with the LIST and REPORT commands.

Prerequisites: Familiarity with database concepts and Windows/Linux or equivalent knowledge is recommended but not required.

Real Application cluster (RAC)

What Real Application cluster (RAC) is for:
RAC is oracle database high availability tool and it is used for failover and failback situation between database servers.

What You Will Learn:

You will learn how to install RAC first in your own environment, how to administrator and troubleshoot the applications. This class will give the knowledge necessary to become an RAC support person for your current or future organization.

Prerequisites: Familiarity with database concepts and Windows/Linux or equivalent knowledge, is recommended but not required.

Good to know

Register for one of our leading classes and get access to Enterprise Manager and Data warehouse manager for free

 
 
 
Search by product