 |
|
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.
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.
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
.
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
|
|
| |
|
|
|
|
|
