MCTS: SQL Server 2005 - Business Intelligence Developer Training Package

About the MCTS: SQL Server 2005 - Business Intelligence Developer

2791: Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services (3 days)   

Course Objectives

• Describe how SQL Server Analysis Services can be used to implement analytical solutions.
• Create multidimensional analysis solutions with SQL Server Analysis Services.
• Implement dimensions in an Analysis Services solution.
• Implement measures and measure groups in an Analysis Services solution.
• Query a multidimensional Analysis Services solution.
• Customize an Analysis Services cube.
• Deploy and Secure an Analysis Services database.
• Maintain a multidimensional Analysis Services solution.
• Implement a Data Mining solution.

Course Outline

• Introduction to Microsoft SQL Server 2005 Analysis Services
  1. Overview of Data Analysis Solutions
  2. Overview of SQL Server 2005 Analysis Services
  3. Installing SQL Server 2005 Analysis Services
• Creating Multidimensional Analysis Solutions
  1. Developing Analysis Services Solutions
  2. Data Sources and Data Source Views
  3. Creating a Cube
  4. Creating a Multidimensional Analysis Solution
  5. Creating a Data Source
  6. Creating and Modifying a Data Source View
  7. Creating and Modifying a Cube
• Working with Dimensions
  1. Configuring Dimensions
  2. Defining Hierarchies
  3. Sorting and Grouping Attributes
  4. Defining Dimensions
  5. Configuring Dimensions
  6. Defining Relationships and Hierarchies
  7. Sorting and Grouping Dimension Attributes
• Working with Measures and Measure Groups
  1. Working with Measures
  2. Working with Measure Groups
  3. Configuring Measures and Measure Groups
  4. Configuring Measures
  5. Defining Dimension Usage and Relationships
  6. Configuring Measure Group Storage
• Querying Multidimensional Analysis Solutions
  1. MDX Fundamentals
  2. Adding Calculations to a Cube
  3. Querying a Cube
  4. Querying a Cube by Using MDX
  5. Creating a Calculated Member
  6. Defining a Named Set
• Customizing Cube Functionality
  1. Implementing Key Performance Indicators
  2. Implementing Actions
  3. Implementing Perspectives
  4. Implementing Translations
  5. Customizing a Cube
  6. Implementing a KPI
  7. Implementing an Action
  8. Implementing a Perspective
  9. Implementing a Translation
• Deploying and Securing an Analysis Services Database
  1. Deploying an Analysis Services Database
  2. Securing an Analysis Services Database
  3. Deploying and Securing an Analysis Services Database
  4. Deploying an Analysis Services Database
  5. Securing an Analysis Services Database
• Maintaining a Multidimensional Solution
  1. Configuring Processing Settings
  2. Logging, Monitoring, and Optimizing an Analysis Services Solution
  3. Backing Up and Restoring an Analysis Services Database
  4. Maintaining an Analysis Services Database
  5. Configuring Processing
  6. Implementing Logging and Monitoring
  7. Backing Up and Restoring an Analysis Services Database
• Introduction to Data Mining
  1. Overview of Data Mining
  2. Creating a Data Mining Solution
  3. Validating Data Mining Models
  4. Implementing Data Mining
  5. Creating a Data Mining Structure
  6. Adding a Data Mining Model
  7. Exploring Data Mining Models
  8. Validating Data Mining Models

2792: Implementing and Maintaining Microsoft SQL Server 2005 Integration Services (3 days)   

Course Objectives

• Describe SQL Server Integration Services and its tools.
• Create an Integration Services package.
• Implement control flow in an Integration Services package.
• Implement data flow in an Integration Services package.
• Implement logging in an Integration Services package.
• Debug and implement error handling in an Integration Services package.
• Implement checkpoints and transactions in an Integration Services package.
• Deploy an Integration Services package.
• Manage and secure an Integration Services package

Course Outline

• Introduction to SQL Server 2005 Integration Services
  1. Overview of Integration Services Solutions
  2. Integration Services Tools
  3. Using SQL Server Integration Services
  4. Using the Import and Export Wizard
  5. Running an Integration Services Package
• Developing Integration Services Solutions
  1. Creating an Integration Services Solution
  2. Using Variables
  3. Building and Running a Solution
  4. Implementing an Integration Services Solution
  5. Creating an Integration Services Project
  6. Implementing a Package
  7. Building and Running an Integration Services Project
• Implementing Control Flow
  1. Control Flow Tasks
  2. Control Flow Precedence Constraints
  3. Control Flow Containers
  4. Implementing Control Flow
  5. Creating a Simple Control Flow
  6. Configuring Precedence Constraints
  7. Using Containers
• Implementing Data Flow
  1. Data Flow Sources and Destinations
  2. Data Flow Transformations
  3. Data Flow Paths
  4. Implementing Data Flows
  5. Transferring Data
  6. Implementing Transformations
  7. Using Data Viewers
  8. Configuring Error Output
• Implementing Logging
  1. Overview of Integration Services Logging
  2. Implementing Logging
  3. Implementing Logging
  4. Configuring Logging
  5. Implementing Custom Logging
• Debugging and Error Handling
  1. Debugging a Package
  2. Implementing Error Handling
  3. Debugging and Error Handling
  4. Debugging a Package
  5. Implementing Error Handling
  6. Controlling Failure Behavior
• Implementing Checkpoints and Transactions
  1. Implementing Checkpoints
  2. Implementing Transactions
  3. Implementing Checkpoints and Transactions
  4. Implementing Checkpoints in a Package
  5. Implementing Transactions in a Package
  6. Implementing a Native Transaction
  7. Deploying Packages
  8. Package Configurations
  9. Deploying Packages
  10. Deploying Integration Services Packages
  11. Creating a Package Configuration
  12. Preparing a Package for Deployment
  13. Deploying a Package
• Managing and Securing Packages
  1. Managing Packages
  2. Securing Packages
  3. Managing and Securing Packages
  4. Importing a Package
  5. Configuring and Executing a Package
  6. Scheduling a Package
  7. Securing a Package

2793: Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services (3 days)   

Course Objectives

• Describe SQL Server Reporting Services and its components.
• Create a Reporting Services report.
• Enhance a Reporting Services report.
• Create and manipulate data sets.
• Use report models to implement reporting for business users.
• Configure report publishing and execution settings.
• Implement subscriptions for reports.
• Administer Reporting Services.
• Implement custom Reporting Services applications.

Course Outline

• Introduction to Microsoft SQL Server Reporting Services
  1. Overview of SQL Server Reporting Services
  2. Installing Reporting Services
  3. Reporting Services Tools
  4. Using Reporting Services Tools
  5. Exploring Report Designer
  6. Exploring Report Manager
• Authoring Basic Reports
  1. Creating a Basic Table Report
  2. Formatting Report Pages
  3. Calculating Values
  4. Creating a Simple Report
  5. Creating a Basic Table Report
  6. Formatting Report Pages
  7. Adding Calculated Values
• Enhancing Basic Reports
  1. Interactive Navigation
  2. Displaying Data
  3. Enhancing a Report
  4. Using Dynamic Visibility
  5. Using Document Maps
  6. Initiating Actions
  7. Using a List Data Region
• Manipulating Data Sets
  1. Defining Report Data
  2. Using Parameters and Filters
  3. Using Parameter Lists
  4. Manipulating Data Sets
  5. Using parameters to restrict query results
  6. Using parameters to filter report data
  7. Creating dynamic parameter lists
  8. Using parameters with a stored procedure
• Using Report Models
  1. Creating Report Models
  2. Using Report Builder
  3. Working with Report Models
  4. Creating a Report Model
  5. Using Report Builder to Create a Report
• Publishing and Executing Reports
  1. Publishing Reports
  2. Executing Reports
  3. Creating Cached Instances
  4. Creating Snapshots and Report History
  5. Publishing and Executing Reports
  6. Publishing Reports
  7. Executing a Report On Demand
  8. Configuring and Viewing a Cached Report
  9. Configuring and Viewing a Snapshot Report
• Using Subscriptions to Distribute Reports
  1. Introduction to Report Subscriptions
  2. Creating Report Subscriptions
  3. Managing Report Subscriptions
  4. Implementing Subscriptions
  5. Creating a Standard Subscription
  6. Creating a Data-Driven Subscription
• Administering Reporting Services
  1. Server Administration
  2. Performance and Reliability Monitoring
  3. Administering Report Server Databases
  4. Security Administration
  5. Administering Reporting Services
  6. Using Reporting Services Configuration Manager
  7. Securing a Reporting Services Site
  8. Securing Items
• Programming Reporting Services
  1. Querying for Server Information Using a Web Service
  2. Automating Report Management
  3. Rendering Reports
  4. Creating Custom Code
  5. Programming Reporting Services
  6. Using URL Access to Display a Report
  7. Building a Reporting Services Web Service Client
  8. Using the Report Viewer Control

Do you have the right background for MCTS: SQL Server 2005 - Business Intelligence Developer?

Benefit of taking MCTS: SQL Server 2005 - Business Intelligence Developer at NetCom

• Why Choose Microsoft - Technical Training at NetCom Learning?

  As a recognition for training excellence, NetCom Learning was chosen by Microsoft as the 2007 Worldwide Learning Solutions Partner of the year out of 1400 training companies.

  In addition, we have won numerous other training awards for quality and customer satisfaction by CompTIA, EC-Council and other vendors. We are simply passionate about learning and achieving the highest customer satisfaction in your learning experience!

  See the training value proposition below:

  Why Microsoft - Technical Training at NetCom? NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS). CPLS is the premier training channel and delivery mechanism for Microsoft training content. NetCom was honored by Microsoft as the 2007 Worldwide Partner of the Year for Learning Solutions. Selected as the Number One CPLS from over 1400 worldwide CPLSs, Microsoft recognized our commitment and ability to deliver high-quality learning services using a consultative engagement model. Microsoft Certified Partner for Learning Solutions Value Proposition: Microsoft Certified Partner for Learning Solutions Non-authorized Training Center Only MCT (Microsoft Certified Trainers) are authorized to teach the class Non MCT can teach the course Taught using Microsoft Authorized Courseware (MOC), includes free evaluation software and online training Do not have access to official courseware Partners adhere to stringent Microsoft designated lab requirements Computer and lab equipment may not be up to requirements of course Successful candidates are awarded Certificate of Completion directly from Microsoft for most of the courses Not authorized to issue Certificate of Completion Software Assurance Vouchers can only be redeemed at a CPLS Cannot redeem Software Assurance Vouchers from Microsoft Overall, a better quality training experience Substandard training experience Here are some important web links: Certifications Career Tracks Course Catalog (PDF Version) Course Listing by Vendor Sign up for Free Workshops Student Loan as low as $25 per month Our Recognition List What our students have to say Why NetCom? Locations

• NetCom provides Authorized Training

  NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Platinum Partner, EC-Council Accredited Training Center, Adobe Authorized Training Center, Autodesk Authorized Training Center and many others. We are proud to offer the highest quality, authorized training solutions from our many partners for our customers.

  See our comprehensive list of partner authorizations.

• Award winning, world-class Instructors

  Carmille A. - Highly-skilled in graphics and web software including Adobe CS3, CS4 & CS5 Photoshop, Dreamweaver, Illustrator, InDesign, Captivate, Acrobat and Quark; - Expert in Microsoft Office, including Excel, Word and PowerPoint. Licensed Application Instructor and Microsoft Certified Trainer since 2000. - Over 20 years of experience as Creative Director for multinational corporations such as McCann Erickson, Lintas, and Publicis. Bio: Carmille has been a Licensed Application Instructor and Microsoft Certified Trainer for years. She specializes in web development, business productivity and digital media applications such as SharePoint, Quark and the Adobe Creative Suite as well as numerous programming languages including XML, XHMTL, HTML and CSS. Carmille is passionate about educating and has a unique talent for making complex design and development principals seem "easy" to students from all levels of expertise. She currently teaches Adobe Graphic and Web Designer, Microsoft Office Specialist, SharePoint End User and the acclaimed Website Development Professional courses at NetCom Learning. Her 20+ years of experience as Creative Director for multinational corporations bring a special and innovative approach to her classes at NetCom Learning.

  Emilio G. - Vastly experienced working within multinational environments and capable of connecting to different audiences - In-depth expertise in the implementation, troubleshooting and documentation of networks and security systems, with strong "hands on" technical knowledge of CISSP, CEH and CHFI. - Master of Science in Electronics Engineering, and holder of several technical certifications. - Highly-skilled in diverse fields ranging from Security, Computer Forensics, Networking, Routing Protocols, Programming, Databases and Applications to name a few. Bio: With over 25 years of technical experience, Emilio brings a dynamic set of skills supported by a Masters Degree in Electronics Engineering and on-the-field experience working in multinational environments. He also holds more than 12 Cisco, CompTIA, and Microsoft certifications. Although he is well versed and thorough in multiple technological fields, his technical forte lies in the security domain, specifically CISSP, CEH and CHFI. Emilio�s skills have evolved over time, studying closely and constantly staying well informed of the growing cyber threats. These are just some of the few reasons why Emilio brings to his classes more than just what's in the books.

  Enayat M. - Bachelors Degree in Mathematics and holder of several Cisco, CompTIA and Microsoft certifications. - Experienced instructor working in the field since 1999 and Subject Matter Expert at NetCom Learning since 2006. - Worked as Technical Support at Solomon Smith Barney/Citibank. Bio: Enayat Meer has a Bachelors Degree in Mathematics and holds numerous certifications such as A+, Network+, Security+, CCNA, MCT, and MCTS to name a few. He is an experienced trainer, and has served as an A+, NT4.0, Window 2000 and Windows 2003 instructor in a variety of New York schools since 1999. Since that time, he has also provided technical support at Solomon Smith Barney/Citibank in its private banking and global assets management group. Enayat has trained over 800 students at NetCom Learning. He has been a Subject Matter Expert at NetCom Learning since 2006 and his hands-on project expertise is an invaluable addition to NetCom Learning�s classroom instruction, helping to bring theoretical topics to life.

  Erick P. - In-depth experience in all phases of project lifecycle: requirements gathering, specifications, development and team management, testing, end user training, and maintenance in addition to .NET, ASP, ADO, SQL, JavaScript, and SharePoint. - Developed the first online multimedia training content system to Harvard University as well as multiple online multimedia projects for the North Carolina State Government. - Highly rated instructor averaging 8.7 out of 9 on evaluation reports. Bio: Erick has been training business and IT professionals since 1989, when he developed and introduced the first online multimedia training content system to Harvard University. Since then he has honed his business, programming, and database skills providing highly customized software solutions and education programs for multiple clients such as North Carolina State Government, Cisco, IBM, and Time Warner Cable. Erick's teaching prowess and real-world experience leading a team of software application developers make him a top Instructor and Subject Matter Expert at NetCom Learning, where he averages 8.7 out of 9 on evaluation reports.

  Ignacio J. - Designs and architects Microsoft IT solutions since the early 1990s. - Hands-on experience in multiple Microsoft Dynamics products including CRM, GP, SL, AX and NAV since 2004. - Taught over 250 courses at NetCom Learning. Bio: Ignacio is a Senior Solutions Architect, Civil Engineer and Certified Expert Trainer. He has been designing and architecting Microsoft IT solutions since the early 1990s, and has extensive experience developing scalable and high performance integration solutions. In 2004, Ignacio expanded into business management and accounting software as well, where he gained hands-on experience in many Microsoft Dynamics products including CRM, GP, SL, AX and NAV. Ignacio holds a library of industry-wide certifications from Microsoft and other leading IT vendors. He has taught over 250 courses at NetCom Learning and is revered by students for his wide-ranging IT expertise.

  J Tom K. - Software Developer and sought-after Microsoft Certified Trainer (MCT) with over 30 years of hands-on experience. - Expert in Microsoft technologies: .NET Framework, C#, VB .NET, ASP .NET, XML Web Services, ADO .NET, SQL Server, SharePoint Portal Server, Content Management Server, Commerce Server, BizTalk, MSMQ, COM+, COM Migration to .NET and PocketPC development. - Extremely knowledgeable and rated as excellent by NetCom Learning students. Bio: Tom Kinser is an accomplished Software Developer and sought-after Microsoft Certified Trainer (MCT). Tom is also an expert in successfully designing software, managing and training programmers for over 30 years. Tom specializes in helping businesses, enterprises, and government agencies apply current technologies to solve their unique business problems. He accomplishes this via hands-on training in cutting-edge programming and database design techniques. Tom consistently delivers successful training engagements in both classroom and live-online settings and is rated as excellent by NetCom Learning students.

  Jayson F. - Over 32 years of experience as well as 18 certifications, including Cisco, CompTIA, and Microsoft. - Strong background, with web development & design of infrastructure for companies such as AT&T, Sports Illustrated, and Toys R Us. - Specialist in applying process and finding solutions to solve them in addition to training people in the skills to manage the process and meet goals. Bio: Jayson is a talented and valued Microsoft Certified Trainer (MCT) with over 32 years of IT experience. Along with web development & design of infrastructure for companies such as AT&T, Sports Illustrated, and Toys R Us, he holds several IT certifications. He is a CCDA, CCNA, Security+ certified, MCDBA, and MCSE to name a few. Jayson's focus is on finding solutions to problems and applying process to solve them. He instructs professionals in the skills to manage the process and meet goals, which makes him a respected trainer at NetCom Learning.

  Mark L. - Experience teaching beginner to advanced software engineering and development classes - Architectured NetCom Learning's Mobile Development Professional training package (Android & iPhone) - Acclaimed instructor at NetCom Learning, with evaluation score of 8.7 out of 9. Bio: Mark is an accomplished web and mobile development trainer and Subject Matter Expert. He has been teaching beginner to advanced software engineering and development classes since 2005. With an extensive background in corporate programming he easily understands the impact of new technologies and the knowledge developers need to succeed. Most recently Mark architectured NetCom Learning's Mobile Development Professional training package (Android & iPhone) to much critical acclaim. Mark's passion and aptitude for the subject matter is abundant, and clearly evident in his near-perfect post-class evaluation scores (8.7 out of 9) and praise from clients.

  Michael G. - Over 22 years of professional experience in the IT field, including more than a decade as a Certified Trainer. - An expert in Cisco's Routing, Switching, Security, Voice and Wireless areas, as well as select Microsoft, Novell, CompTIA, Sun and CWNP courses. - High-skilled and acclaimed instructor. Has trained over 900 students at Netcom Learning. Bio: Michael has over 22 years of professional experience in the IT field, including more than a decade as a Certified Trainer. An expert in Cisco's Routing, Switching, Security, Voice and Wireless areas, Michael also teaches select Microsoft, Novell, CompTIA, Sun and CWNP courses. Michael's dedication and passion for teaching is unmatched. He has trained over 900 students at Netcom Learning since 2006 and his evaluation scores average 8.7 out of 9.

  Mingya (Alan) T. - MBA in Information System from Montclair University, NJ. - Onsite training on behalf of Microsoft to numerous companies, including CITI Group Lehman Brothers, Prudential Insurance Company, Toshiba, and KPMG. - Microsoft Certified Trainer (MCT) since 2001. Bio: Alan is a highly experienced Microsoft Certified Trainer. In addition to his MBA in Information System, he is a member of the Microsoft Gold Certified Partner and has done onsite training for companies such as CITI Group Lehman Brothers, Prudential Insurance Company, Toshiba, and KPMG; on behalf of Microsoft. Alan has been teaching at NetCom Learning since 2007, focusing on SharePoint, .NET, and BizTalk.

  See more...  
• Actual Client Testimonials

  May 15 2012 Good training, great instructor. -Kenneth C. Course(s) Taken MCTS and MCITP: Microsoft SharePoint 2010, Administration and Configuration - Boot Camp

  
  

  May 15 2012 The experience was everything I had hoped for plus more. Our instructor was very knowledgeable and great at presenting the content in a way that was easy to understand. -Zehrudin N. Course(s) Taken MCTS and MCITP: Microsoft SharePoint 2010, Administration and Configuration - Boot Camp

  
  

  May 15 2012 Instructor is very good at explaining things that are difficult to comprehend sometimes and he does it in a way that helps you better understand. -Juan G. Course(s) Taken MCTS and MCITP: Microsoft SharePoint 2010, Administration and Configuration - Boot Camp

  
  

  May 15 2012 Instructor knowledge of the product was in depth. Excellent training and real world example. Explained the course in easy manner to understand. -David T. Course(s) Taken MCTS and MCITP: Microsoft SharePoint 2010, Administration and Configuration - Boot Camp

  
  

  May 15 2012 I have enjoyed my training class and training facilities. I will come back. -James M. Course(s) Taken MCTS and MCITP: Microsoft SharePoint 2010, Administration and Configuration - Boot Camp

  
  

  May 11 2012 Been to NetCom several times and it's always been satisfying with the training area and staff. -Sal I. Course(s) Taken Microsoft Windows Server 2008

  
  

  May 02 2012 I have never learned and retained this much information in such a short period of time, everything about my experience has been positive. -Adam W. Course(s) Taken MCTS and MCITP: Windows 7 Configuration and Desktop Support Technician - Boot Camp

  
  

  Apr 20 2012 Overall great experience. Was very pleased with the way the course was handled by the instructor. -A. Moctezuma Course(s) Taken Programming in C# with Microsoft .NET Framework 4

  
  
• Real world Client Case Studies
  
  

  Great Plains training & certification

  Published On: 14 April 2008

  Customer: Washington State Penitentiary

  Location: Walla Walla, WA, US

  Industry: State & Local Government

  The Department of Corrections, Washington State in collaboration with its criminal justice partners, contributes to staff and community safety and hold offenders accountable through administration of criminal sanctions and effective re-entry programs. The Department of Corrections is responsible for administering adult corrections programs operated by the State of Washington. This includes state correctional institutions and programs for offenders supervised in the community.

  Business Needs: The Department of Corrections IT networking department used Microsoft Dynamics GP integrated with Microsoft SQL Server as an accounting solution to automate their processes. But their employees were not trained in GP so they outsourced the maintenance to the Partner from whom they bought the software. The Partner had initially configured and implemented the software for them, but was now also responsible for regular maintenance. However, the Department of Corrections wanted to reduce the costs of outsourcing by getting their own employee trained on GP. They decided to get six people trained and NetCom sold them the value of getting the master certification for installation and configuration, financials, inventory and order processing for their team.   Solution: NetCom created a custom training plan for them to satisfy all their needs. NetCom provided them with fifteen days of onsite training. The training prepared them for SQL server elective to get master certification in GP 9. The training solution included modules from Financial, Installation, Configuration, Inventory and order processing along with SQL Server training. NetCom provided them with exam vouchers, books and custom certification preparation they need for the training.The six students trained were the ones responsible for the Department of Corrections networks for the entire state of Washington. Instead of continuing to hire experts to administer and maintain their system, they invested in education to raise their own in house GP experts.   Training: Courses Taken 2072: Microsoft SQL Server 2000 System Administration 8505: Installation and Configuration in Microsoft Dynamics GP 9.0 8508: Receivables Management I in Microsoft Dynamics GP 9.0 8509: Payables Management I in Microsoft Dynamics GP 9.0 8510: Bank Reconciliation I in Microsoft Dynamics GP 9.0 8511: Fixed Assets I in Microsoft Dynamics GP 9.0 8512: Inventory in Microsoft Dynamics GP 9.0 8513: Purchase Order Processing in Microsoft Dynamics GP 9.0 8514: Sales Order Processing in Microsoft Dynamics GP 9.0 8506+8507: Foundation I and General Ledger I in Microsoft Dynamic GP 9.0 - Accelerated Version Packages Purchased MCDBA: Microsoft Certified Database Administrator (Core) Microsoft Dynamics GP 9.0 - Installation and Configuration Microsoft Dynamics GP 9.0 - Financials - Accelerated Microsoft Dynamics GP 9.0 - Inventory and Order Processing   Benefits: The training helped improved their productivity. They cut down their costs significantly by implementing the software in-house rather than outsourcing. Microsoft Dynamics GP integrated with Microsoft SQL Server training from NetCom helped them deliver on a long-term vision of community safety by installing and configuring their financials by inventory and order processing.

  
  

  USS-POSCO - Microsoft .NET 2.0 Development

  Published On: 18 November 2009

  Customer: USS-POSCO Industries

  Location: Pittsburgh, PA, US

  Industry: Metals & Mining::Steel Production

  The USS-POSCO steel finishing plant is owned and operated by USS-POSCO Industries (UPI), a joint venture company established by U. S. Steel Corporation and POSCO, of the Republic of Korea. The first Pittsburgh steel facility opened in 1910 as a 60-man foundry under the name Columbia Steel. Consisting of one building and a single 150-ton open hearth, the plant furnished steel castings for the dredging, lumber and shipping industries. Today, UPI manufactures cold rolled, galvanized and tin mill products from hot rolled steel. With the support of nearly 1,000 hourly and salaried employees, UPI ships steel daily to more than 150 customers, primarily in the thirteen western states.

  Business Needs: The need arose when [USS-POSCO] management decided to purchase a third party software package for HR & Payroll. As a traditional IBM Mainframe COBOL and Java shop, they needed to ensure that the new applications would integrate seamlessly with the existing legacy and Java applications. The new software was developed in the Microsoft .NET 3.5 platform, and at the time of purchase they had no formal training in Microsoft Development Tools and Platforms. USS-POSCO looked around for public courses and found that either there were no suitable courses available or those that were offered publicly conflicted with their work schedules.   Solution: NetCom quickly delivered a complete private training solution to USS-POSCO's doorstep in Pittsburgh, PA. "NetCom's solution was perfect from the quality of the courseware, delivery and timely schedule stand point. After an initial consultation with a NetCom representative, we were able to understand each other and quickly came up with a plan of execution for customized courses in a very tight schedule. As all the students were experienced programmers, we wanted our training to be concise and compact. After further discussions with the potential trainers and consultants, a course detail was drawn up, and we had a chance to review the course outline before approving it. The training courses were conducted on site and our employees were happy not having to travel. The all inclusive cost was just right. We are happy to say that the training course was delivered by a well experienced and competent instructor." - Liung Ling, Senior Programmer, USS-POSCO   Training: Courses Taken 2124: Programming with C# 2956: Core Foundations of Microsoft .NET 2.0 Development Packages Purchased MCSD: Microsoft Certified Solution Developer (C#.Net Track) MCTS: .NET 3.5 ADO.NET and ASP.NET Application   Benefits: USS-POSCO was able to gain the necessary skills to complement their programming knowledge and facilitate a successful transition into the Microsoft Development Tools and .NET platforms. NetCom was able to service the needs of USS-POSCO within their tight schedule, by condensing a great deal of knowledge into 4 days of intensive, customized training. Because the students were experienced programmers they were able to dictate and thrive in this fast pace. NetCom provided an experienced instructor and shipped all authorized course materials to USS-POSCO. Since the employees did not have to travel, there was minimal down-time and maximum Return on Investment. "After four very intense days of learning, we feel that we have gained a great deal. Thank you." - Liung Ling, Senior Programmer, USS-POSCO

  
  

  Providing certification training for QWEST

  Published On: 14 April 2008

  Customer: Qwest Communications

  Location: Denver, CO, US

  Qwest® is a leading provider of voice, video and data services across America and the world. For more than a century, homes and businesses have relied on our dependable dial tone connection. Qwest's employees, approximately 40,000, are committed to delivering world-class products backed by unmatched customer service. Whether you're a single household, a small business or a global corporation, from voice to data to video, Qwest has a solution just for you.

  Business Needs: Qwest was looking to expand its operations and needed key in-house IT expertise to scale its operations. Their technicians needed to gain systems engineer skills to achieve this.   Solution: NetCom create a custom class for Qwest and provided certification training to two groups of eight students each. Each group went through six weeks of training focused on MCSE training and certification. Qwest flew in the students from national locations to a central training facility.   Training: Courses Taken 2272: Implementing and Supporting Microsoft Windows XP Professional 2285: Installing, Configuring, and Administering Microsoft Windows XP Professional Consulting Service Packages Purchased MCSA, MCSE 2003, Windows XP - Accelerated Microsoft Windows XP Consulting Service   Benefits: The training went very well and Qwest was very satisfied with NetCom's certification training approach. They were able to connect better with their customers by earning the MCSE certifications as their customers actually value Qwest more with the MCSE credentials. The MCSE certification for Windows 2003 helped them significantly to go beyond providing the basic skills to show the specialized real-world capability to their customers and made their growth process easier.NetCom is also working on providing similar training to one more group, followed by Upgrade to Server 2008 training to two more groups.

  
  

  Customized SQL training for expert SQL users

  Published On: 14 April 2008

  Customer: Gold Bridge Partners, Inc.

  Location: Augusta, ME

  Industry: Computer Services::Information Technology Services

  Gold Bridge Partners, Inc. is a nationally-recognized web development and technology corporation located in Augusta, ME. For nearly a decade their team has been delivering technical and creative solutions for government, private businesses, and non-profit organizations. Gold Bridge's products and services include custom software development, web design, IT support, and much more. They understand the importance of a professional online presence for every business and organization. Their goal is to provide you with an attractive website and integrated tools to keep you on the cutting-edge.

  Business Needs: Gold Bridge Partners IT development team had been developing business log for years in middle tear application components developed in application languages such as Java, Perl, PHP, ASP/VB and .NET. In a recent project they included as much business logic as possible in the database (DB2 PL/SQL). They were considering developing their business logic more at the database level in the future, specifically for upcoming SQL Server / .NET projects. We want to be sure we are aware of best practices for coding T-SQL stored procedures and triggers and what unexpected issues or pitfalls we might be up against. We have many years experience developing software and some years experience writing T-SQL. We just want to make sure we know what we're doing before we try to write the entire business logic layer in T-SQL. We want to bring our already experienced developers to the EXPERT level. said Jonathan Williams, IT development manager for Gold Bridge.   Solution: Since the intended audience was a very advanced group of SQL users, NetCom created a custom onsite training class for them using Microsofts MCITP SQL 2005 advanced Business Intelligence Program. NetComs subject matter expert (SME) created a custom plan for them making sure the custom training gave enough time to make the training effective. The final training was scheduled as a four day class for five of their employees, and took into consideration their budget constraints.   Training: Courses Taken 2794: Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005 Packages Purchased MCITP: SQL Server 2005 - Business Intelligence Developer   Benefits: The training went very well. We are pleased. James (our SME) was both fun and informative. The training that we have received has aided us greatly in our development efforts said Jonathan. With NetComs database training, they were able to develop their business logic at the database level effectively.

  
  

  Custom Great Plains and BizTalk Training

  Published On: 14 April 2008

  Customer: Universidad de las Americas Puebla

  Location: Puebla, Mxico

  Industry: Education::Colleges & Universities

  The Universidad de las Américas Puebla (UDLA) was founded in 1940 as the Mexico City College and the first twelve students graduated in 1944. The Universidad de las Américas was accepted as a member of the Southern Association of Colleges and Schools (SACS) in 1959.The UDLA's academic programs have been officially accredited by the Department of Public Education since 1976. In 1985 the university officially changed its name to Fundación Universidad de las Américas Puebla.

  Business Needs: "We need to learn more about Great Plains and the different options we have to extend its functionality" said Hugo Lopez, Training coordinator of Universidad de las Americas Puebla. UDLA had implemented Microsoft Dynamics GP as an Enterprise Resource Planning (ERP) but was having problems with its implementation as people in their IT department were not trained in GP. UDLA started looking for GP training in Mexico but was unsuccessful in finding the training to satisfy their needs. When UDLA contacted NetCom, they wanted to send two people to US for the Dynamics GP training.   Solution: Universidad de las Americas Pueblas goal was to gain the in-depth knowledge to customize and implement Microsoft Dynamics GP using Dexterity. Since there was no official courseware for Dexterity, NetCom created custom training as per their needs. NetCom also provided them custom training at their site in Mexico where they could train a group of employees. This also helped them circumvent immigration issues with their employees getting VISA to the US.NetCom sent a bilingual (English and Spanish speaking) GP instructor to run the custom class for them. The training went on for three weeks and was very successful. "My Team and I are very happy with the training and with the instructor (hes a person who really knows a lot about the product). This training is going to be very useful in the projects that we are working on. We are so happy, that we are interested in some additional training" said Hugo. UDLA also requested BizTalk Server training for econnect. Again, NetCom created another custom plan for econnect training which was conducted over eight days.   Training: Courses Taken 2933: Developing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006 2934: Deploying and Managing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006 8507: General Ledger I in Microsoft Dynamics GP 9.0 8517: Report Writer in Microsoft Dynamics GP 9.0 8518: Business Portal Installation and Configuration in Microsoft Dynamics GP 8519: Microsoft Dynamics GP Integration Manager 8520: Modifier with Visual Basic with Applications (VBA) in Microsoft Dynamics GP 9.0 8597: General Ledger II in Microsoft Dynamics GP 9.0 Consulting Service Packages Purchased MCTS: BizTalk Server 2006 Microsoft Dynamics GP 9.0 - Other Consulting Service   Benefits: Universidad de las Americas Pueblas IT department had already implemented Microsoft Dynamics GP as an (ERP) but now they were able to use its full functionality. They were very satisfied with the whole training and were able to customize Microsoft Dynamics GP and integrate it with the other applications with associated technology. They were also able to integrate econnect with BizTalk very efficiently.

  
  

  Global Vista Training for international law firm

  Published On: 14 April 2008

  Customer: Latham & Watkins

  Location: US and Paris, France; Brussels, Belgium; Hong Kong

  Business Needs: Keeping up with the cutting edge technology and service their clients in the best possible way, Latham and Watkins required a stable and reliable IT infrastructure, so they decided to migrate from Microsofts Windows XP to Windows Vista. But they realized that to successfully integrate Vista in their organization and getting full advantage of Vista applications, their tech team requires the right training. So they turned to NetCom in search to satisfy their training needs. What we really need is a course that updates our Tech Support skills from XP to Vista said Diane, Latham & Watkins training development manager.   Solution: Latham & Watkins was looking to run a series of 2 day custom Vista classes over 2-3 months at their several offices around the U.S. & worldwide that require this training. After understanding their training needs, NetComs lead Microsoft Subject Matter Expert (SME) and training logistics team put together a customized version of Vista courses 5115 and 5118 that would address the needs of Latham & Watkins. They wanted to include the introduction to Vista and the Aero Interface and IE 7.0 and take out any reference to Bit locker, Defender, and Firewall. A custom class with the custom course curriculum was created and held and multiple locations globally.   Training: Courses Taken 5118: Maintaining and Troubleshooting Windows Vista Computers 5115: Installing and Configuring the Windows Vista Operating System Consulting Service Packages Purchased MCTS: Windows Vista Configuration MCITP: Enterprise Support Technician Consulting Service   Benefits: NetComs training made for an effective transition from Windows XP to Vista for Latham & Watkins. They were very pleased with NetComs SMEs two day custom Vista training.The training was eventually held at several locations within the US and four other cities globally Paris, France; Brussels, Belgium; Hong Kong, China and Hamburg, Germany.

• Awards won by NetCom

  NetCom Learning is an award winning, customer focused company. We are simply Passionate About Learning!

  See our list of awards.

• Specialized Boot Camp Training

  

  This training is also available as a boot camp. NetCom is world famous for delivering specialized boot camp training to our clients.

  For answers to questions regarding our boot camp training delivery format, please refer to our Boot Camp FAQ section.

Next Step, how do I attend the MCTS: SQL Server 2005 - Business Intelligence Developer?

Call us toll-free at 1-888-563-8266 FREE Training Inquiry form Website Live Chat Contact us via Email: info@netcomlearning.com

NetCom Accepts Microsoft Assurance Training Vouchers