SQL Server 2000 DTS For Developers (Program Details)
COURSE OUTLINE
Session 1
Section A: Introduction
- CD Tour
- Database Functions
- Database History
- Design Issues
- OLTP
- Normalized Databases
Section B: Transactional Databases
- Indexing
- Index Issues
- Index Dilemma
- Double Databases
- Latency
- Retrieval Database
- Analysis Database
Section C: Data Warehouse
- Attributes
- Data Marts
- Data Mart Schema
- Fact Table
- Dimension Tables
- Hierarchies & Levels
Section D: Schemas & Data Marts
- Star Schemas
- Snowflake Schemas
- Data Mart Structure
- Creating a Data Mart
- Populate a Data Mart
- Staging Area
Section E: OLAP Cubes
- Structure
- Storage Modes
- Partitions
- Aggregation Design
- Virtual Cubes
Section F: DTS
- Solutions
- Components
- In the Data Mart
- In OLAP
- With Data Analysis
Section G: DTS Import/Export Wizard
- Wizard Startup
- Wizard Functionality
- Wizard Applications
- Wizard Steps
- Creating a Plan
Section H: Using DTS Wizard
- Database Setup
- Planning Import
- Select Source
- Destination
- Copy Options
- Save DTS Package
- Review Executed Package
- Verify
Section I: Object Transferring
- SQL to SQL
- Transfer Process
- Object Copy
Section J: Prototype Package
- Designing Package
- Column Mapping
- Dimension Load
- Use Query
- Select/Map Destination
- Map Columns
- Save/Verify
- View Package
Session 2
Section A: DTS Package
- Components
- Tasks/Steps
- Properties/Variables
- Package Designer
- Designer Toolbars
- Design Sheet
Section B: DTS Connections
- Connection Component
- Connection Sources
- Connection Types
- Connection Properties
- Connection Usage
- Parallel Data Loads
- Create Source
- Create Destination
Section C: Data Link Connections
- Connection Maintenance
- Change Connections
- Create Data Link File
- Set Properties
- Modify Package
Section D: DTS Tasks
- Tasks
- Transform Data
- Manage Data
- Job Functions
- Task Plan
- Create Task
- Setup Transformation
- Create Delete
Section E: DTS Steps
- Steps/Precedence
- Set Precedence
- Workflow Properties
- Package Organization
- Table Verification
Section F: Bulk Insert Task
- Create Bulk Insert Task
- Batch Size
- Performance Options
- Advanced Options
Section G: Format Files
- Structure
- Create Format File
- Use Bulk Insert
- Generate Format File
Section H: Executing Bulk Insert
- Bulk Insert Issues
- Staging Tables
- Bulk Insert Concepts
- Use Staging Table
- Run/Save Package
- Use Format File
- Run/Verify
Session 3
Section A: Execute SQL Tasks
- Considerations
- Parameterized Queries
- Add Global Variables
- Input Parameters
- Output Parameters
- Using SP with DTS
- Create Package
- Run/Verify
Section B: Transform Data Task
- DTS Data Pump
- Data Pump Process/Users
- Setup for Transformation
- Create Transform Task
- Transformation Options
- Column Mapping
- Middle of String
Section C: Data Type Conversion
- Transformation Flags
- Uppercase String
- DateTime Conversion
- Test Transformation
Section D: Error Handling
- Configure
- Data Movement
- SQL Server Setting
- Setup Error Reporting
- View Exception Report
- Run with Error
- Set Batch Size to 0
Section E: Transform Script
- ActiveX Script
- Transform Scripts
- Script Languages
- Components/Constants
- Script Management
- Script Performance
- Script Plan
- Skipping Row
Section F: Advanced Transformation
- One Row too Many
- Build Connections
- Select Task Properties
- Splitting Rows
- Counter Variable
- Setup Workflow
Section G: Lookup Queries
- Best Practices
- Query Plan
- Import Mapping Tables
- Create Connections
- Create Lookups
Section H: Multi-phase Data Pump
- Phases
- Usage
Session 4
Section A: Data Driven Query Task
- Design
- Usage
- ActiveX Script
- Planning
- Update with Data Query
- Destination & Source
- Create Package
- Update Query
Section B: Storing DTS Packages
- Package/Version GUIDs
- Save DTS Package
- Load/Edit Package
- Meta Data Services
- Structured Storage File
- Visual Basic Format
- Secure Packages
Section C: Data Lineage
- Metadata
- Meta Data Services
- Data Lineage
- Create Package
- Set Properties
- Save/View
- View Meta Data Info
Section D: Package Execution
- Package Behaviour
- dtsrun.exe
- Property Parameters
- Run Package
- Alternative Actions
- dtsrunui.exe
Section E: Modular Packages
- Create Modular Package
- Failure Options
- Logging Options
- Modular Design
- Build Outer Package
- Add Inner Package
Section F: Property Management
- Disconnected Edit
- Connected Edit
- Steps/Task Edit
- Dynamic Property Tasks
- Add/Edit Assignment
- Dynamic Task Practices
- Connection Challenges
Return To Main Product Page
Price: £279.00
(incl. VAT and Delivery)
for Single User Licence