MCTS: SQL Server 2008 R2, Implementation, Maintenance and Database Development - Boot Camp

About the MCTS: SQL Server 2008 R2, Implementation, Maintenance and Database Development - Boot Camp

2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL Boot Camp (2 days)   

Course Objectives

• Describe the uses of and ways to execute the Transact-SQL language.
• Use querying tool.
• Write SELECT queries to retrieve data.
• Group and summarize data by using Transact-SQL.
• Join data from multiple tables.
• Write queries that retrieve and modify data by using subqueries.
• Modify data in tables.
• Query text fields with full-text search.
• Describe how to create programming objects.
• Use various techniques when working with complex queries.

Course Outline

• Getting Started with Databases and Transact-SQL in SQL Server 2008
  1. Overview of SQL Server 2008
  2. Overview of SQL Server Databases
  3. Overview and Syntax Elements of T-SQL
  4. Working with T-SQL Scripts
  5. Using T-SQL Querying Tools
• Querying and Filtering Data
  1. Using the SELECT Statement
  2. Filtering Data
  3. Working with NULL Values
  4. Formatting Result Sets
  5. Performance Considerations for Writing Queries
• Grouping and Summarizing Data
  1. Summarizing Data by Using Aggregate Functions
  2. Summarizing Grouped Data
  3. Ranking Grouped Data
  4. Creating Crosstab Queries
• Joining Data from Multiple Tables
  1. Querying Multiple Tables by Using Joins
  2. Applying Joins for Typical Reporting Needs
  3. Combining and Limiting Result Set
• Working with Subqueries
  1. Writing Basic Subqueries
  2. Writing Correlated Subqueries
  3. Comparing Subqueries with Joins and Temporary Tables
  4. Using Common Table Expressions
• Modifying Data in Tables
  1. Inserting Data into Tables
  2. Deleting Data from Tables
  3. Updating Data in Tables
  4. Overview of Transactions
• Querying Metadata, XML, and Full-Text Indexes
  1. Querying Metadata
  2. Overview of XML
  3. Querying XML Data
  4. Overview of Full-Text Indexes
  5. Querying Full-Text Indexes
• Using Programming Objects for Data Retrieval
  1. Overview of Views
  2. Overview of User-Defined Functions
  3. Overview of Stored Procedures
  4. Overview of Triggers
  5. Writing Distributed Queries
• Using Advanced Querying Techniques
  1. Considerations for Querying Data
  2. Working with Data Types
  3. Cursors and Set-Based Queries
  4. Dynamic SQL
  5. Maintaining Query Files

6231: Maintaining a Microsoft SQL Server 2008 R2 Database Boot Camp (2.5 days)   

Course Objectives

• Explain SQL Server 2008 R2 architecture, resources requirements and perform pre-checks of I/O subsystems
• Plan, install and configure SQL Server 2008 R2
• Backup and restore databases
• Import and export wizards and explain how they relate to SSIS
• Use BCP and BULK INSERT to import data
• Manage security
• Assign, configure fixed database roles and create and assign user defined database roles
• Configure and assign permissions
• Implement SQL Server 2008 R2 Audits
• Manage SQL Server 2008 R2 Agent and Jobs
• Configure database mails, alerts and notifications
• Maintain databases
• Configure SQL Profiler Traces and Use the Database Tuning Advisor
• Monitor data by using Dynamic Management Views
• Execute multi-server queries and configure a central management server
• Deploy a data-tier-application
• Troubleshoot common issues

Course Outline

• Module 1: Introduction to SQL Server 2008 R2 and its Toolset
  1. Introduction to SQL Server Platform
  2. Working with SQL Server Tools
  3. Configuring SQL Server Services
• Module 2: Preparing Systems for SQL Server 2008 R2
  1. Overview of SQL Server 2008 R2 Architecture
  2. Planning Server Resource Requirements
  3. Pre-installation Testing for SQL Server 2008 R2
• Module 3: Installing and Configuring SQL Server 2008 R2
  1. Preparing to Install SQL Server 2008 R2
  2. Installing SQL Server 2008 R2
  3. Upgrading and Automating Installation
• Module 4: Working with Databases
  1. Overview of SQL Server Databases
  2. Working with Files and Filegroups
  3. Moving Database Files
• Module 5: Understanding SQL Server 2008 R2 Recovery Models
  1. Backup Strategies
  2. Understanding SQL Server Transaction Logging
  3. Planning a SQL Server Backup Strategy
• Module 6: Backup of SQL Server 2008 R2 Databases
  1. Backing up Databases and Transaction Logs
  2. Managing Database Backups
  3. Working with Backup Options
• Module 7: Restoring SQL Server 2008 R2 Databases
  1. Understanding the Restore Process
  2. Restoring Databases
  3. Working with Point-in-time Recovery
  4. Restoring System Databases and Individual Files
• Module 8: Importing and Exporting Data
  1. Transferring Data To/From SQL Server 2008 R2
  2. Importing & Exporting Table Data
  3. Inserting Data in Bulk
• Module 9: Authenticating and Authorizing Users
  1. Authenticating Connections to SQL Server
  2. Authorizing Logins to Access Databases
  3. Authorization Across Servers
• Module 10: Assigning Server and Database Roles
  1. Working with Server Roles
  2. Working with Fixed Database Roles
  3. Creating User-defined Database Roles
• Module 11: Authorizing Users to Access Resources
  1. Authorizing User Access to Objects
  2. Authorizing Users to Execute Code
  3. Configuring Permissions at the Schema Level
• Module 12: Auditing SQL Server Environments
  1. Options for Auditing Data Access in SQL Server
  2. Implementing SQL Server Audit
  3. Managing SQL Server Audit
• Module 13: Automating SQL Server 2008 R2 Management
  1. Automating SQL Server Management
  2. Working with SQL Server Agent
  3. Managing SQL Server Agent Jobs
• Module 14: Configuring Security for SQL Server Agent
  1. Understanding SQL Server Agent Security
  2. Configuring Credentials
  3. Configuring Proxy Accounts
• Module 15: Monitoring SQL Server 2008 R2 with Alerts and Notifications
  1. Configuration of Database Mail
  2. Monitoring SQL Server Errors
  3. Configuring Operators, Alerts and Notifications
• Module 16: Performing Ongoing Database Maintenance
  1. Ensuring Database Integrity
  2. Maintaining Indexes
  3. Automating Routine Database Maintenance
• Module 17: Tracing Access to SQL Server 2008 R2
  1. Capturing Activity using SQL Server Profiler
  2. Improving Performance with the Database Engine Tuning Advisor
  3. Working with Tracing Options
• Module 18: Monitoring SQL Server 2008 R2
  1. Monitoring Activity
  2. Capturing and Managing Performance Data
  3. Analyzing Collected Performance Data
• Module 19: Managing Multiple Servers
  1. Working with Multiple Servers
  2. Virtualizing SQL Server
  3. Deploying and Upgrading Data-Tier Applications
• Module 20: Troubleshooting Common SQL Server 2008 R2 Administrative Issues
  1. SQL Server Troubleshooting Methodology
  2. Resolving Service-related Issues
  3. Resolving Concurrency Issues
  4. Resolving Login and Connectivity Issues

6232: Implementing a Microsoft SQL Server 2008 R2 Database Boot Camp (2.5 days)   

Course Objectives

• Understand the product, its components, and basic configuration.
• Work with the data types supported by SQL Server.
• Design and implement tables and work with schemas.
• Design and implement views and partitioned views.
• Describe the concept of an index and determine the appropriate data type for indexes and composite index structures.
• Identify the appropriate table structures and implement clustered indexes and heaps.
• Describe and capture execution plans.
• Design and implement non-clustered indexes, covering indexes, and included columns.
• Design and implement stored procedures.
• Implement table types, table valued parameters, and the MERGE statement.
• Describe transactions, transaction isolation levels, and application design patterns for highly-concurrent applications.
• Design and implement T-SQL error handling and structured exception handling.
• Design and implement scalar and table-valued functions.
• Design and implement constraints.
• Design and implement triggers.
• Describe and implement target use cases of SQL CLR integration.
• Describe and implement XML data and schema in SQL Server.
• Use FOR XML and XPath queries.
• Describe and use spatial data types in SQL Server.
• Implement and query full-text indexes.

Course Outline

• Module 1: Introduction to SQL Server and its Toolset
  1. Introduction to SQL Server Platform
  2. Working with SQL Server Tools
  3. Configuring SQL Server Services
• Module 2: Working with Data Types
  1. Using Data Types
  2. Working with Character Data
  3. Converting Data Types
  4. Working with Specialized Data Types
• Module 3: Designing and Implementing Tables
  1. Designing Tables
  2. Working with Schemas
  3. Creating and Altering Tables
• Module 4: Designing and Implementing Views
  1. Introduction to Views
  2. Creating and Managing Views
  3. Performance Considerations for Views
• Module 5: Planning for SQL Server Indexing
  1. Core Indexing Concepts
  2. Data Types and Indexes
  3. Single Column and Composite Indexes
• Module 6: Implementing Table Structures in SQL Server
  1. SQL Server Table Structures
  2. Working with Clustered Indexes
  3. Designing Effective Clustered Indexes
• Module 7: Reading SQL Server Execution Plans
  1. Execution Plan Core Concepts
  2. Common Execution Plan Elements
  3. Working with Execution Plans
• Module 8: Improving Performance through Nonclustered Indexes
  1. Designing Effective Nonclustered Indexes
  2. Implementing Nonclustered Indexes
  3. Using the Database Engine Tuning Advisor
• Module 9: Designing and Implementing Stored Procedures
  1. Introduction to Stored Procedures
  2. Working With Stored Procedures
  3. Implementing Parameterized Stored Procedures
  4. Controlling Execution Context
• Module 10: Merging Data and Passing Tables
  1. Using the MERGE Statement
  2. Implementing Table Types
  3. Using Table Types as Parameters
• Module 11: Creating Highly Concurrent SQL Server Applications
  1. Introduction to Transactions
  2. Introduction to Locks
  3. Management of Locking
  4. Transaction Isolation Levels
• Module 12: Handling Errors in T-SQL Code
  1. Designing T-SQL Error Handling
  2. Implementing T-SQL Error Handling
  3. Implementing Structured Exception Handling
• Module 13: Designing and Implementing User-Defined Functions
  1. Designing and Implementing Scalar Functions
  2. Designing and Implementing Table-valued Functions
  3. Implementation Considerations for Functions
  4. Alternatives To Functions
• Module 14: Ensuring Data Integrity through Constraints
  1. Enforcing Data Integrity
  2. Implementing Domain Integrity
  3. Implementing Entity and Referential Integrity
• Module 15: Responding to Data Manipulation via Triggers
  1. Designing DML Triggers
  2. Implementing DML Triggers
  3. Advanced Trigger Concepts
• Module 16: Implementing Managed Code in SQL Server
  1. Introduction to SQL CLR Integration
  2. Importing and Configuring Assemblies
  3. Implementing SQL CLR Integration
• Module 17: Storing XML Data in SQL Server
  1. Introduction to XML and XML Schemas
  2. Storing XML Data and Schemas in SQL Server
  3. Implementing the XML Data Type
• Module 18: Querying XML Data in SQL Server
  1. Using the T-SQL FOR XML Statement
  2. Getting Started with XQuery
  3. Shredding XML
• Module 19: Working with SQL Server Spatial Data
  1. Introduction to Spatial Data
  2. Working with SQL Server Spatial Data Types
  3. Using Spatial Data in Applications
• Module 20: Working with Full-Text Indexes and Queries
  1. Introduction to Full-Text Indexing
  2. Implementing Full-Text Indexes in SQL Server
  3. Working with Full-Text Queries

Why should you take the MCTS: SQL Server 2008 R2, Implementation, Maintenance and Database Development - Boot Camp

For IT professionals, certification is a third party validation of your skills, that helps distinguish you from your peers. Beyond demonstrating a level of competency and proficiency, certification proves that you are committed to your cause and that you've invested the time and money to prove it. Holding a certification also makes you a more valuable employee, and often results in raises, promotions, and a better career.

For organizations, certifications identify the credentials that can be used to hire the right employee. Having certified employees also increases sales for the organization by proving to prospective clients that the organization has the skills to support its claims.

Do you have the right background for MCTS: SQL Server 2008 R2, Implementation, Maintenance and Database Development - Boot Camp?

Benefit of taking MCTS: SQL Server 2008 R2, Implementation, Maintenance and Database Development - Boot Camp 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 Bootcamp 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 2008 R2, Implementation, Maintenance and Database Development - Boot Camp?

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