ST_training_program_winter_2012_withBI by huanghengdong


									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

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
            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
            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
            Using the Performance Monitor for Analysis
            Using the Reliability Monitor for Analysis
       Exit Lesson
           Overview of the studied material
           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
          Key PowerShell commandlets - Get-Command, Get-Help, Get-Member, Get-
          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

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
       Disaster Recovery, Backup and Restore
            Backup options
            Backup strategies overview
4.3                                                                                           2
            Recovery Models
            Restore operations
            DB Snapshots
       Managing Security
4.4                                                                                           2
            Levels (roles) of Security

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
       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)
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
5.7                                                                                      3
           Transactions and Locking
           Working with XML
           Design Patterns for Transact-SQL
           Temporary tables in TSQL
           Dynamic SQL in TSQL
       Overview of PL/SQL programming
5.8                                                                                      3
          Basics of PL/SQL

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
          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
           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
           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
          Deployment and Management Best Practices

 7.    Exit Test project                                                         2            2


To top