Get documents about "ST_training_program_winter_2012_withBI
Document Sample
Students Training "Systems Engineering & Data Integration" Software Maintenance Lab
ЕРАМ Training Center
Students Training Program "Systems Engineering & Data Integration"
“Applications Support for Windows & Data Integration”
№ Topics Total Lectures Practices
Module 1 Computer Network Fundamentals 20 8 12
Module 2 Automating Administration with Windows PowerShell 2.0 (Introduction) 16 4 12
Module 3 Configuring Windows Server 2008 Active Directory 32 8 24
Module 4 Installing and Configuring Microsoft SQL Server 2008 Database 36 14 22
Totals hours 104 34 70
Module 5 ANSI SQL 32 12 20
Module 6 Data Integration and Reporting Services 40 16 24
Module 7 Exit Test project 2 2
Totals hours 178 62 116
1
Students Training "Systems Engineering & Data Integration" Software Maintenance Lab
Students Training Program
" Applications Support for Windows & Data Integration"
№ Topics Lectures Practices Total
1. Computer Network Fundamentals 8 12 20
Introduction to Network Technologies
Virtual Machines
• Virtualization Brief History
• Virtualization Tools
• How to Create and Set Up VMs in Hyper-V
• Setting Up Network in VMs
Network Fundamentals
1.1 • Networking types & LAN data-link concepts (NIC, MAC) 2
• Phone Line
• xDSL
• P2P
• Crossover
• COM-port
Wireless Networking
• Wi-Fi
• Bluetooth
Types of Network. LAN concepts
Topologies
OSI reference model
Network Protocols: TCP/IP, UDP
Configuration on Windows 12
1.2 IP address, CIDR, Special-use addresses 2
Command Line Utilities
Network Hardware
Sharing
Remote Connections
Windows Server 2008 Active Directory Review
Introduction to IP Technologies
DHCP (Dynamic Host Configuration Protocol)
DNS (Domain Name System), DynDNS
1.3 2
IP routing: Static and Dynamic Routing, Routing Tools
NAT (Network Address Translation)
Proxy Server
Network Monitoring Tools
1.4 Monitoring Performance and Reliability in Server 2008
2
Using the Performance Monitor for Analysis
Using the Reliability Monitor for Analysis
Exit Lesson
Overview of the studied material
1.5
Exit Task
2. Automating Administration with Windows PowerShell 2.0 (Introduction) 4 12 16
PowerShell Fundamentals
Introduction - Modern Cutting-Edge Windows IT Infrastructure Administration
The purpose of Microsoft Windows PowerShell
Overview PowerShell tools
2.1 2 6
PowerGUI
Key PowerShell commandlets - Get-Command, Get-Help, Get-Member, Get-
PSDrive
PowerShell PipeLine
PowerShell In Action
What you must know about PowerShell Scripts;
Security Features;
Parameterized Scripts;
2.2 2 4
Core PowerShell Commandlets - Using the Format Cmdlets, Custom Columns,
HTML Output, The Core Cmdlets. Live Demonstration: Preforming Common
Administrative Tasks with PowerShell
IT Administration with PowerShell
2.3 Exit Task 2
3 Configuring Windows Server 2008 Active Directory 8 24 32
Introducing Active Directory Domain Services (AD DS)
Introducing Active Directory, Identity, and access
3.1 1
Active Directory Components and Concepts
Install Active Directory Domain Services
2
Students Training "Systems Engineering & Data Integration" Software Maintenance Lab
№ Topics Lectures Practices Total
Extend IDA with Active Directory Services
Secure and Efficient Administration of Active Directory
Work with Active Directory Snap-ins
Custom Consoles and Least Privilege
Find Objects in Active Directory
Use DS Commands to Administer Active Directory
Manage Users
Create and Administer User Accounts
Configure User Object Attributes
Automate User Account Creation
Manage Groups
3.2 Manage an Enterprise with Groups 1
Administer Groups
Best Practices for Group Management
Support Computer Accounts
Create Computers and Join the Domain
Administer Computer Objects and Accounts
Implement a Group Policy Infrastructure
Understand Group Policy
Implement a Group Policy
Explore Group Policy Settings and Features
Manage Group Policy Scope
Group Policy Processing
3.3 1
Troubleshoot Policy Application
Manage Enterprise Security and Configuration with Group Policy Settings
Delegate the Support of Computers
Manage Security Settings
Manage software with GPSI
Auditing 24
Secure Administration
Delegate Administrative Permissions
Audit Active Directory Changes
Improve the Security of Authentication in an Active Directory Domain Services (AD
3.4 1
DS) Domain
Configure Password and Lockout Policies
Audit Authentication
Configure Read-Only Domain Controllers
Configure Domain Name System (DNS)
Review DNS Concepts, Components, and Processes
3.5 Install and Configure DNS Server in an AD DS Domain 1
AD DS,DNS, and Windows
Advanced DNS Configuration and Administration
Administer Active Directory Domain Services (AD DS) Domain Controllers
Domain Controller Installation Options
3.6 Install a Server Core DC 1
Manage Operations Masters
Configure DFS Replication of SYSVOL
Manage Sites and Active Directory Replication
Configure Sites and Subnets
3.7 1
Configure the Global Catalog and Application Partitions
Configure Replication
Manage Multiple Domains and Forests
Configure Domain and Forest Functional Levels
3.8 1
Manage Multiple Domains and Trust Relationships
4 Installing and Configuring Microsoft SQL Server 2008 Database 14 22 36
Installing and Configuring SQL Server
Short overview SQL Server components and services (SQL server analysis
services, SQL server reporting services, SQL Server integration services)
4.1 2
Unattended installation
Tool: sqlcmd
Using SQL Server Management Studio
Managing Databases and Files
Database structure
4.2 Database options 2
File placement, Filegroups
Schemas
Disaster Recovery, Backup and Restore
Backup options
Backup strategies overview
4.3 2
Recovery Models
22
Restore operations
DB Snapshots
Managing Security
4.4 2
Levels (roles) of Security
3
Students Training "Systems Engineering & Data Integration" Software Maintenance Lab
№ Topics Lectures Practices Total
Authentication and Authorization
Scopes and Securables
Ownership Chains
Automating Administrative Tasks
SQL Agent, Jobs
Maintenance Plans
4.5 2
SSIS Introduction
Database Mail
Alerts
Overview of Replication and High Availability
Replication architecture
Types of Replication
4.6 High Availability introduction 2
Log Shipping Overview
Mirroring Overview
Server Clustering Overview
Monitoring and Troubleshooting
Activity Monitor
Performance Monitor
4.7 DM Views 2
SQL Server Profiler
Index Performance Tuning
Analyzing Query Performance
5. ANSI SQL 12 20 32
An Overview of Relational Databases and Introducing SQL
What is a relational database?
Components of a relational database
Normalised data
5.1 1
Anatomy of a table
Primary and foreign keys
The need for an SQL standard
The ANSI standards
Retrieving Data with SQL
Introducing Queries: The SELECT Statement
The Clauses of the SELECT Statement
Using FROM to Specify the Source Table(s)
Retrieving Entire Tables and specific columns, aliases
5.2 Using DISTINCT 1
Performing Calculations
Using WHERE to Filter Results
Range Filtering using BETWEEN and IN
NULL and its Implications Explained
Using ORDER BY to Sort the Output
Joining tables
The theory of joining tables
5.3 1
The Different Types of Joins: Cross, Inner, Outer, Full, Left and Right
Using JOINs with WHERE
Summarized Queries
Using Aggregate Functions (MAX(), SUM(), AVG(), COUNT() etc)
20
5.4 The Way Aggregate Functions Work 1
Using GROUP BY to Group Results
The HAVING clause
Subqueries and Union
Using Subqueries
5.5 Operator EXISTS 1
Correlated Subqueries
Operator UNION
Inserting, Updating and Deleting Data
Operator INSERT
5.6 1
Operator UPDATE
Operator DELETE
Overview of Transact SQL programming
T-SQL Language - An Introduction to Common Terms and Tools
Declaring Variables
Stored Procedure Programming and Error Handling
Views and User-Defined Functions
Triggers
5.7 3
Transactions and Locking
Working with XML
Design Patterns for Transact-SQL
Cursors
Temporary tables in TSQL
Dynamic SQL in TSQL
Overview of PL/SQL programming
5.8 3
Basics of PL/SQL
4
Students Training "Systems Engineering & Data Integration" Software Maintenance Lab
№ Topics Lectures Practices Total
PL/SQL structures
Use of SQL in PL/SQL
Nested blocks in PL/SQL
Introducing Subprograms
Stored procedures, functions and packages
Error checking – exception handling
Triggers
Cursors in PL/SQL
6. Data Integration 8 16 24
Introduction to SSIS
Understanding Integration Services
Overview of Control Flow in Integration Services
Working with Workflow Tasks
6.1 2
Exploring and Executing an SSIS Package in BIDS
The Data Flow Task
Data Viewers
Data Flow Transformations
Variables and Configurations
Understanding Variables
Using Variables in Control Flow
6.2 1
Using Variables in Data Flow
Configurations
Using Variables and Configurations between Packages
Advanced Control Flow and Data Flow
Advanced Control Flow Overview
Using Containers
6.3 1
Transactions Support in Integration Services
Synchronous and Asynchronous Transformations
Using Advanced Transformations 16
Error Logging and Handling in SSIS
Handling Errors and Debugging
6.4 Checkpoints 1
Packaging Logging
Event Handling
Package Deployment and management
Deploying Packages
Create a Package Deployment Utility
Installing a Package
6.5 Overview of Package Management
1
Managing Integration Services Packages
Executing Packages
Integration Services Security
Resolving performance issues and Best Practices in SSIS
Best Practices for Using Integration Services
Best Practices for Package Development and Design
6.6 Data Flow Best Practices
2
Deployment and Management Best Practices
7. Exit Test project 2 2
5
