| Microsoft Access - Introduction |
| Course Number | ALTO-1539A | |
| Price | $795.00 |
| Length | 2 Day |
| Description | The two-day introductory segment is a comprehensive yet selective exploration of the key features and functions of the powerful Access products. You will learn the crucial configuration steps and design techniques that make it possible to create robust, full-featured database applications without any programming. The major components in Access have dozens and sometimes even hundreds of options for the way they can be used. This course does not attempt to cover everything, rather, it concentrates on the features and functions that will make the most effective use of your time and efforts. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Microsoft Access - Intermediate |
| Course Number | ALTO-1539B | |
| Price | $795.00 |
| Length | 2 Day |
| Description | The two-day intermediate segment is intended for those already familiar with basic Access operations and are ready to make the transition from Access user to application developer. You will learn how to directly control and manipulate Access from behind the scenes to create queries, data entry forms and reports that function precisely in the manner you require. Access is far more powerful and flexible than it might initially appear, making Access suitable for every kind of database application. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Microsoft Access - Advanced |
| Course Number | ALTO-1539C | |
| Price | $395.00 |
| Length | 1 Day |
| Description | The one-day advanced segment is an absolutely intense day intended for experienced Access developers who want to fine-tune their applications to exploit the many powerful features and functions built into Access. Access applications have numerous options for dealing with multiple users: different forms of security, concurrency and isolation can be combined to solve any conceivable design problem. Access can be extended by incorporating server-based data sources, ActiveX controls and servers into your applications. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Microsoft Access Series |
| Course Number | ALTO-1539 | |
| Price | $1,985.00 |
| Length | 5 Day |
| Description | This five day course combines the introductory, intermediate and advanced courses.The two-day introductory segment is a comprehensive yet selective exploration of the key features and functions of the powerful Access products. You will learn the crucial configuration steps and design techniques that make it possible to create robust, full-featured database applications without any programming. The major components in Access have dozens and sometimes even hundreds of options for the way they can be used. This course does not attempt to cover everything, rather, it concentrates on the features and functions that will make the most effective use of your time and efforts.The two-day intermediate segment is intended for those already familiar with basic Access operations and are ready to make the transition from Access user to application developer. You will learn how to directly control and manipulate Access from behind the scenes to create queries, data entry forms and reports that function precisely in the manner you require. Access is far more powerful and flexible than it might initially appear, making Access suitable for every kind of database application.The one-day advanced segment is an absolutely intense day intended for experienced Access developers who want to fine-tune their applications to exploit the many powerful features and functions built into Access. Access applications have numerous options for dealing with multiple users: different forms of security, concurrency and isolation can be combined to solve any conceivable design problem. Access can be extended by incorporating server-based data sources, ActiveX controls and servers into your applications. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Visual Studio 2008: ASP.NET 3.5 |
| Course Number | MOC-6463 | |
| Price | $1,100.00 |
| Length | 2 Day |
| Description | This two-day instructor-led course provides students with the knowledge and skills to create a fully functional Web application by using ASP.NET 3.5. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Visual Studio 2008 ADO.NET 3.5 |
| Course Number | MOC-6464 | |
| Price | $1,100.00 |
| Length | 2 Day |
| Description | This two-day instructor-led course provides students with the knowledge and skills to access and modify data by using ADO.NET 3.5. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Programming with VB.NET 2008 |
| Course Number | BM-LPVBNET2008 | |
| Price | $2,750.00 |
| Length | 5 Day |
| Description | This course is a practical introduction to programming in Visual Basic and the use of services provided by .NET. It emphasizes the Visual Basic language and how to build Visual Basic applications from an object-oriented perspective. It is current to Visual Studio 2008 and .NET 3.5, which introduces important new features such as local type inference, extension methods, lambda expressions and Language-Integrated Query (LINQ). The new features are covered in a new chapter. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Visual Studio 2008 Connected Systems: Windows Presentation Foundation |
| Course Number | MOC-6460 | |
| Price | $1,650.00 |
| Length | 3 Day |
| Description | This three-day instructor-led course provides students with the knowledge and skills to build and configure a Windows Presentation Foundation (WPF) solution. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Visual Studio 2008 Connected Systems: Windows Communication Foundation |
| Course Number | MOC-6461 | |
| Price | $1,650.00 |
| Length | 3 Day |
| Description | This three-day instructor-led course provides students with the knowledge and skills to build and configure a Windows Communication Foundation (WCF) solution. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Complete C# using VS 2010 |
| Course Number | INT-1202 | |
| Price | $2,495.00 |
| Length | 5 Day |
| Description | Alto’s Complete C# course is designed to expose experienced software developers to the C# programming language and the core APIs of the .NET platform. The course will begin by exposing attendees to the syntax and semantics of the C# programming language and Object Oriented Programming (OOP) concepts. Students will gain an understanding of the .NET type system (classes, structures, enums, interfaces and delegates), assembly configuration, file IO operations and the role of type metadata. Once the foundational topics have been addressed, the remainder of the class will introduce the role of Windows Forms, ADO.NET and ASP.NET.
This course makes use of Visual Studio 2010. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Complete VB using VS 2010 |
| Course Number | INT-1302 | |
| Price | $2,495.00 |
| Length | 5 Day |
| Description | Intertech’s Complete VB course is designed to expose experienced software developers to the VB programming language and the core APIs of the .NET platform. The course will begin by exposing attendees to the syntax and semantics of the VB programming language and Object Oriented Programming (OOP) concepts. Students will gain an understanding of the .NET type system (classes, structures, enums, interfaces and delegates), assembly configuration, file IO operations and the role of type metadata. Once the foundational topics have been addressed, the remainder of the class will introduce the role of Windows Forms, ADO.NET, and ASP.NET. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Developing Web Applications with Microsoft Visual Studio 2010 |
| Course Number | BM-MOC-10264 | |
| Price | $2,750.00 |
| Length | 5 Day |
| Description | In this course, students will learn to develop advanced ASP.NET MVC and Web Forms applications using .NET Framework 4 tools and technologies. The focus will be on coding activities that enhance the performance and scalability of the Web site application. ASP.NET MVC will be introduced and compared with Web Forms so that students know when each should/could be used. This will also prepare the student for exam 70-515. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Introduction to Web Development with Microsoft Visual Studio 2010 |
| Course Number | BM-MOC-10267 | |
| Price | $2,750.00 |
| Length | 5 Day |
| Description | This five-day instructor-led course provides knowledge and skills on developing Web applications by using Microsoft Visual Studio 2010. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Developing Data Access Solutions with Microsoft Visual Studio 2010 |
| Course Number | BM-MOC-10265 | |
| Price | $2,750.00 |
| Length | 5 Day |
| Description | In this course, experienced developers who know the basics of data access (CRUD) in Windows client and Web application environments will learn to optimize their designs and develop better performing data access code by using the ADO.NET Entity Framework, LINQ, WCF Data Services, the Sync Framework, and ADO.NET. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Developing Windows Applications with Microsoft Visual Studio 2010 |
| Course Number | BM-MOC-10262 | |
| Price | $2,750.00 |
| Length | 5 Day |
| Description | In this course, experienced developers who know the basics of Windows Forms development gain more advanced Windows Client design and development skills. WinForms and WPF programming models, as well as relative strengths and when to use each technology, are covered. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Complete Windows Presentation Foundation for .NET 4.0 |
| Course Number | INT-1141 | |
| Price | $2,595.00 |
| Length | 4 Day |
| Description | Windows Presentation Foundation (WPF) has quickly become the preferred framework for desktop GUI applications. Intertech's Complete WPF will examine this key API beginning with the topics of XAML, code files and WPF development tools. Attendees will learn about the WPF control content model, styles and control templates, data binding, graphical rendering services and the construction of navigationally-based applications. As well, attendees will gain hands on experience using both Visual Studio and Microsoft Expression Blend to build WPF applications. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Complete Windows Communication Foundation for .NET 4.0 |
| Course Number | INT-1138 | |
| Price | $2,050.00 |
| Length | 3 Day |
| Description | Windows Communication Foundation (WCF) is an API used to build distributed applications using .NET 3.0 (and higher). WCF was designed to expose the current multitude of Windows remoting APIs (web services, MSMQ, TCP, peer-to-peer, etc) from a single unified toolkit. In this course, attendees will examine the overall WCF programming model, binding choices, host options, security issues and the use of declarative markup to specify the underlying infrastructure. Attendees will also learn about the major changes to WCF with the release of .NET 4.0 |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Developing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006 |
| Course Number | MOC-2933 | |
| Price | $2,495.00 |
| Length | 5 Day |
| Description | This five-day, instructor-led, hands-on course provides students with the knowledge and skills to efficiently and effectively integrate systems, employees, and trading partners through orchestration in a highly flexible and highly automated manner. This course is intended for solution architects and developers who are responsible for developing Microsoft BizTalk Server 2006 business process and integration solutions. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Microsoft Silverlight 4 Using Visual Studio 2010 Level 2 |
| Course Number | AD-SL4B | |
| Price | $1,200.00 |
| Length | 2 Day |
| Description | Silverlight 4.0 makes it possible for developers to create rich, interactive applications delivered through a Web browser to nearly any client operating system, including Windows, Mac, and Linux. This course moves beyond the basics of creating and hosting Silverlight applications, working through some more advanced controls, more graphic issues including shapes, geometries, brushes, transforms, and animations, through deploying Silverlight applications. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Microsoft Silverlight 4 Using Visual Studio 2010 Level 1 |
| Course Number | AD-SL4A | |
| Price | $1,200.00 |
| Length | 2 Day |
| Description | Silverlight 4.0 makes it possible for developers to create rich, interactive applications delivered through a Web browser to nearly any client operating system, including Windows, Mac, and Linux. This course introduces the basics of creating and hosting Silverlight applications, working through many of the important controls, through binding Silverlight applications to live data. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| SQL Server for Developers |
| Course Number | ALTO-2073 | |
| Price | $1,595.00 |
| Length | 3 Day |
| Description | This three-day, hands-on course provides students with the technical skills required to program a database solution using Microsoft SQL Server. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Creating Reporting Solutions using Microsoft SQL Server Reporting Services |
| Course Number | AD-2793 | |
| Price | $1,195.00 |
| Length | 2 Day |
| Description | In this course, you will learn how to use SQL Server Reporting Services to create, execute, and manage reports. You will learn how to create tabular, matrix (cross-tab), and chart reports. You'll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You'll explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. You'll gain a thorough understanding of Reporting Services security, report snapshots, subscriptions, and the use of custom assemblies. You'll also discover how to integrate reports into your ASP.NET and WinForms applications using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer. Finally, you'll learn how to empower your users to create ad-hoc reports using Report Builder and Report Model projects. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| SQL Server Integration Services |
| Course Number | AD-2792 | |
| Price | $1,595.00 |
| Length | 3 Day |
| Description | This course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| SQL Server Analysis Services |
| Course Number | AD-6234 | |
| Price | $1,595.00 |
| Length | 3 Day |
| Description | In this course, you will learn how to use Microsoft SQL Server Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server developer the tools to build data cubes and forecasting solutions. This course also provides information on end-user tools including Microsoft Excel 2007, Office Visio 2007 Professional Edition, SQL Server Business Intelligence Development Studio (BIDS) Microsoft SQL Server 2005 Integrated Services and Reporting Services. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Solving Business Problems with MDX in SQL Server 2008 |
| Course Number | SQM-SQLMDX08 | |
| Price | $2,350.00 |
| Length | 3 Day |
| Description | This hands-on, instructor led course will guide you step-by-step through the Analysis Service 2008 Multi Dimensional eXpression (MDX) OLAP query language. You will learn a practical approach to solve real-world problems using MDX expressions, calculations and queries, which will allow users to extract valuable information. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Writing Queries Using Microsoft SQL Server 2008 Transact-SQL |
| Course Number | MOC-2778 | |
| Price | $1,650.00 |
| Length | 3 Day |
| Description | This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Implementing and Maintaining Microsoft SQL Server 2008 Integration Services |
| Course Number | MOC-6235 | |
| Price | $1,650.00 |
| Length | 3 Day |
| Description | This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
This course is 95 percent relevant to SQL 2005 users and is the recommended training solution for those people looking to learn SSIS for SQL 2005. The concepts, tools and best practices are almost identical between SQL 2005 and 2008. Please note; at times there are new features of SQL 2008 that are covered which are not available to SQL 2005 implementations. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services |
| Course Number | MOC-6236 | |
| Price | $1,650.00 |
| Length | 3 Day |
| Description | This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.
This course is 95 percent relevant to SQL 2005 users and is the recommended training solution for those people looking to learn SSIS for SQL 2005. The concepts, tools and best practices are almost identical between SQL 2005 and 2008. Please note; at times there are new features of SQL 2008 that are covered which are not available to SQL 2005 implementations. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| SQL Server 2008 Architecture, Internals and Tuning |
| Course Number | NHSQLPerTune08 | |
| Price | $3,950.00 |
| Length | 5 Day |
| Description | This is an advanced 5-day course designed for advanced SQL Server professionals. The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as tuning techniques. This course will be presented on SQL Server 2008 and cover features specific to that version, but most of the information is relevant to SQL Server 2005 as well.The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as performance tuning techniques. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| SQL Server 2008 End to End Business Intelligence Workshop |
| Course Number | SQM-SQLEndBI | |
| Price | $3,295.00 |
| Length | 5 Day |
| Description | Business intelligence solutions provide the infrastructure that enables users at all levels of a business to make better decisions based on more accurate and up-to-date information. This workshop focuses on teaching IT professionals the best practices and skills required to successfully design, build, deploy, and operate a business intelligence solution using SQL Server 2008 Integration Services, Analysis Services and Reporting Services. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Advanced T SQL Querying Programming and Tuning for SQL Server 2005 and 2008 |
| Course Number | SQM-TASQLPrg08 | |
| Price | $3,950.00 |
| Length | 5 Day |
| Description | The course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2005 and 2008. In this course you will learn the details and capabilities of T-SQL in the following areas: Logical Query Processing; Query Tuning; Subqueries, Ranking Functions, Joins and Set Operations; Aggregating and Pivoting Data; TOP and APPLY; Data Modification; Data Type Related Problems; Programmable Objects (Dynamic SQL, Views, User Defined Functions, Stored Procedures, Triggers, Transactions and Concurrency, Exception Handling); Graphs, Trees and Hierarchies. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Implementing a Microsoft SQL Server 2008 R2 Database |
| Course Number | MOC-6232B | |
| Price | $2,795.00 |
| Length | 5 Day |
| Description | This five-day instructor-led course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best practices on how to use SQL Server 2008 R2 product features and tools related to implementing a database server. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Querying and Processing SQL Server Data with Transact SQL Statements |
| Course Number | ALTO-2778 | |
| Price | $1,195.00 |
| Length | 2 Day |
| Description | By the end of this course you will:
• Be familiar with the tools used to interact with SQL Server databases.
• Be comfortable with basic SELECT statement syntax and be able to write queries that extract records from a single table.
• Understand enough about the more advanced SELECT statement syntax that you can figure out what the statement is doing and where to go to learn more.
• Be able to safely make changes to records in tables, using INSERT, UPDATE and DELETE statements.
• Be able to create and alter VIEWs.
• Be able to find text patterns in data using the LIKE operator and full text searching. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Maintaining a Microsoft SQL Server 2008 R2 Database |
| Course Number | MOC-6231B | |
| Price | $2,495.00 |
| Length | 5 Day |
| Description | This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a database.
The primary audience for this course is individuals who administer and maintain SQL Server databases. This course can also be helpful for individuals who develop applications that deliver content from SQL Server databases. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services |
| Course Number | MOC-6234 | |
| Price | $1,650.00 |
| Length | 3 Day |
| Description | Elements of this syllabus are subject to change.
This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.
This course is 95 percent relevant to SQL 2005 users and is the recommended training solution for those people looking to learn SSAS for SQL 2005. The concepts, tools and best practices are almost identical between SQL 2005 and 2008. Please note; at times there are new features of SQL 2008 that are covered which are not available to SQL 2005 implementations |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Crystal Reports 2011: Report Design II and III - Business Reporting and Processing Strategies |
| Course Number | RD-220-230 | |
| Price | $1,725.00 |
| Length | 3 Day |
| Description | RD 220 - This course is designed to give you comprehensive skills and in-depth knowledge to plan and create reports that will help you analyze and interpret information using Crystal Reports®.
As a business benefit, you will be able to increase your understanding of formulas, variables, arrays, templates, parameters, summaries, and sections, which will help you make more effective report design decisions and create more efficient reports.
RD 230 - This one-day instructor led classroom course is designed to give you the comprehensive skills and in-depth knowledge required to plan and create reports that will help you analyze and interpret important information.
As a business benefit, you will find that your increased understanding of report processing, formulas, custom functions and subreports will help you make more effective report design decisions and create more efficient reports. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Crystal Reports 2011: Report Design I - Fundamentals of Report Design |
| Course Number | RD-210 | |
| Price | $1,150.00 |
| Length | 2 Day |
| Description | This two-day instructor led classroom course is designed to give you comprehensive skills and in-depth knowledge to plan and create reports that will help you analyze and interpret information using Crystal Reports®.
As a business benefit, you will find that this course is an in-depth approach to the entire report creation cycle from planning a report prototype to distributing a report. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| SharePoint No-Code Application Development for Workflows, Data Connectivity, and KPIs |
| Course Number | NH-SP07DesignWF | |
| Price | $2,544.00 |
| Length | 4 Day |
| Description | Now that the organization has gotten SharePoint installed... what's next? In this 4 day course you will learn how to take the foundation that SharePoint provides and construct "no code" BI Applications (using custom Workflows, Data Sources/Views, Key Performance Indicators, Excel Services, Business Data Catalog, and InfoPath Forms Services) using the built in capabilities in SharePoint and SharePoint Designer without coding anything. You will learn how to streamline existing processes, centralize access to information, and ultimately improve support for and use of SharePoint as a business productivity tool in your organization. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Microsoft SharePoint 2010 Application Development |
| Course Number | MOC-10175 | |
| Price | $2,750.00 |
| Length | 5 Day |
| Description | This course provides existing .NET developers with practical information and labs that enables them to build solutions on the Microsoft SharePoint 2010 platform. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Microsoft Access - Introduction |
| Course Number | ALTO-1539A | |
| Price | $795.00 |
| Length | 2 Day |
| Description | The two-day introductory segment is a comprehensive yet selective exploration of the key features and functions of the powerful Access products. You will learn the crucial configuration steps and design techniques that make it possible to create robust, full-featured database applications without any programming. The major components in Access have dozens and sometimes even hundreds of options for the way they can be used. This course does not attempt to cover everything, rather, it concentrates on the features and functions that will make the most effective use of your time and efforts. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Microsoft Access - Intermediate |
| Course Number | ALTO-1539B | |
| Price | $795.00 |
| Length | 2 Day |
| Description | The two-day intermediate segment is intended for those already familiar with basic Access operations and are ready to make the transition from Access user to application developer. You will learn how to directly control and manipulate Access from behind the scenes to create queries, data entry forms and reports that function precisely in the manner you require. Access is far more powerful and flexible than it might initially appear, making Access suitable for every kind of database application. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Microsoft Access - Advanced |
| Course Number | ALTO-1539C | |
| Price | $395.00 |
| Length | 1 Day |
| Description | The one-day advanced segment is an absolutely intense day intended for experienced Access developers who want to fine-tune their applications to exploit the many powerful features and functions built into Access. Access applications have numerous options for dealing with multiple users: different forms of security, concurrency and isolation can be combined to solve any conceivable design problem. Access can be extended by incorporating server-based data sources, ActiveX controls and servers into your applications. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Microsoft Access Series |
| Course Number | ALTO-1539 | |
| Price | $1,985.00 |
| Length | 5 Day |
| Description | This five day course combines the introductory, intermediate and advanced courses.The two-day introductory segment is a comprehensive yet selective exploration of the key features and functions of the powerful Access products. You will learn the crucial configuration steps and design techniques that make it possible to create robust, full-featured database applications without any programming. The major components in Access have dozens and sometimes even hundreds of options for the way they can be used. This course does not attempt to cover everything, rather, it concentrates on the features and functions that will make the most effective use of your time and efforts.The two-day intermediate segment is intended for those already familiar with basic Access operations and are ready to make the transition from Access user to application developer. You will learn how to directly control and manipulate Access from behind the scenes to create queries, data entry forms and reports that function precisely in the manner you require. Access is far more powerful and flexible than it might initially appear, making Access suitable for every kind of database application.The one-day advanced segment is an absolutely intense day intended for experienced Access developers who want to fine-tune their applications to exploit the many powerful features and functions built into Access. Access applications have numerous options for dealing with multiple users: different forms of security, concurrency and isolation can be combined to solve any conceivable design problem. Access can be extended by incorporating server-based data sources, ActiveX controls and servers into your applications. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Complete Java |
| Course Number | IT-2101 | |
| Price | $2,495.00 |
| Length | 5 Day |
| Description | The Java language began modestly as a programming language to address the needs of a diverse set of consumer appliances, but has since evolved to become the most popular language and platform for building enterprise level applications. Intertech Training’s Complete Java course teaches you the syntax and core APIs of the Java programming language while also coaching you on the conventions and practical techniques necessary to code Java professionally.
The class begins by describing the core syntax of the Java language while also exposing students to object-oriented programming concepts. After establishing this essential foundation, the class then covers other crucial topics like exception handling, packaging, and when to use arrays versus collections. In addition, you learn how to use critical Java APIs for I/O, database access and graphical user interface development. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Complete Java Web Development |
| Course Number | IT-2201 | |
| Price | $2,495.00 |
| Length | 4 Day |
| Description | Complete Java Web Development is a crash course in developing cutting edge Web applications using the latest Java EE 5 technologies from Sun and the open source community. The course builds a strong understanding of Servlet technology as the cornerstone of Java's Web platform. It shows how JSPs build on the Servlet architecture and help your development teams achieve clear role separation. Allowing Web developers to focus on functionality while the Web designers create the layout - without stepping on each other's toes. Additionally, the class will show you how to use JSTL, custom tags and JSP expression language to reduce Java code in Web pages while adding tremendous power and capability to those pages. Attendees will also learn JavaBean component development and how these components can be easily integrated into JSPs. The class culminates in an exploration of Java MVC frameworks and compares some of the more popular offerings like Struts and Spring MVC.
While focusing on Web technologies, the course also exposes developers to the constant trade off between application robustness and complexity. This is not a class that focuses on theory. Participants will find the course is loaded with practical labs and simulations. After taking this class, your developers will be able to build Web applications faster, that are more scalable, and that are easier to maintain. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Complete Struts Using Eclipse Training |
| Course Number | I-W-472 | |
| Price | $1,995.00 |
| Length | 3 Day |
| Description | This course introduces the students to Jakarta Struts 1.2. During the course, students will learn to design and develop Struts based applications. Many real life hands on exercises are used to teach various concepts of Struts. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Visual Studio 2008: ASP.NET 3.5 |
| Course Number | MOC-6463 | |
| Price | $1,100.00 |
| Length | 2 Day |
| Description | This two-day instructor-led course provides students with the knowledge and skills to create a fully functional Web application by using ASP.NET 3.5. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Visual Studio 2008 ADO.NET 3.5 |
| Course Number | MOC-6464 | |
| Price | $1,100.00 |
| Length | 2 Day |
| Description | This two-day instructor-led course provides students with the knowledge and skills to access and modify data by using ADO.NET 3.5. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Programming with VB.NET 2008 |
| Course Number | BM-LPVBNET2008 | |
| Price | $2,750.00 |
| Length | 5 Day |
| Description | This course is a practical introduction to programming in Visual Basic and the use of services provided by .NET. It emphasizes the Visual Basic language and how to build Visual Basic applications from an object-oriented perspective. It is current to Visual Studio 2008 and .NET 3.5, which introduces important new features such as local type inference, extension methods, lambda expressions and Language-Integrated Query (LINQ). The new features are covered in a new chapter. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Visual Studio 2008 Connected Systems: Windows Presentation Foundation |
| Course Number | MOC-6460 | |
| Price | $1,650.00 |
| Length | 3 Day |
| Description | This three-day instructor-led course provides students with the knowledge and skills to build and configure a Windows Presentation Foundation (WPF) solution. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Visual Studio 2008 Connected Systems: Windows Communication Foundation |
| Course Number | MOC-6461 | |
| Price | $1,650.00 |
| Length | 3 Day |
| Description | This three-day instructor-led course provides students with the knowledge and skills to build and configure a Windows Communication Foundation (WCF) solution. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Complete C# using VS 2010 |
| Course Number | INT-1202 | |
| Price | $2,495.00 |
| Length | 5 Day |
| Description | Alto’s Complete C# course is designed to expose experienced software developers to the C# programming language and the core APIs of the .NET platform. The course will begin by exposing attendees to the syntax and semantics of the C# programming language and Object Oriented Programming (OOP) concepts. Students will gain an understanding of the .NET type system (classes, structures, enums, interfaces and delegates), assembly configuration, file IO operations and the role of type metadata. Once the foundational topics have been addressed, the remainder of the class will introduce the role of Windows Forms, ADO.NET and ASP.NET.
This course makes use of Visual Studio 2010. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Complete VB using VS 2010 |
| Course Number | INT-1302 | |
| Price | $2,495.00 |
| Length | 5 Day |
| Description | Intertech’s Complete VB course is designed to expose experienced software developers to the VB programming language and the core APIs of the .NET platform. The course will begin by exposing attendees to the syntax and semantics of the VB programming language and Object Oriented Programming (OOP) concepts. Students will gain an understanding of the .NET type system (classes, structures, enums, interfaces and delegates), assembly configuration, file IO operations and the role of type metadata. Once the foundational topics have been addressed, the remainder of the class will introduce the role of Windows Forms, ADO.NET, and ASP.NET. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Developing Web Applications with Microsoft Visual Studio 2010 |
| Course Number | BM-MOC-10264 | |
| Price | $2,750.00 |
| Length | 5 Day |
| Description | In this course, students will learn to develop advanced ASP.NET MVC and Web Forms applications using .NET Framework 4 tools and technologies. The focus will be on coding activities that enhance the performance and scalability of the Web site application. ASP.NET MVC will be introduced and compared with Web Forms so that students know when each should/could be used. This will also prepare the student for exam 70-515. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Introduction to Web Development with Microsoft Visual Studio 2010 |
| Course Number | BM-MOC-10267 | |
| Price | $2,750.00 |
| Length | 5 Day |
| Description | This five-day instructor-led course provides knowledge and skills on developing Web applications by using Microsoft Visual Studio 2010. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Developing Data Access Solutions with Microsoft Visual Studio 2010 |
| Course Number | BM-MOC-10265 | |
| Price | $2,750.00 |
| Length | 5 Day |
| Description | In this course, experienced developers who know the basics of data access (CRUD) in Windows client and Web application environments will learn to optimize their designs and develop better performing data access code by using the ADO.NET Entity Framework, LINQ, WCF Data Services, the Sync Framework, and ADO.NET. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Developing Windows Applications with Microsoft Visual Studio 2010 |
| Course Number | BM-MOC-10262 | |
| Price | $2,750.00 |
| Length | 5 Day |
| Description | In this course, experienced developers who know the basics of Windows Forms development gain more advanced Windows Client design and development skills. WinForms and WPF programming models, as well as relative strengths and when to use each technology, are covered. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Complete Windows Presentation Foundation for .NET 4.0 |
| Course Number | INT-1141 | |
| Price | $2,595.00 |
| Length | 4 Day |
| Description | Windows Presentation Foundation (WPF) has quickly become the preferred framework for desktop GUI applications. Intertech's Complete WPF will examine this key API beginning with the topics of XAML, code files and WPF development tools. Attendees will learn about the WPF control content model, styles and control templates, data binding, graphical rendering services and the construction of navigationally-based applications. As well, attendees will gain hands on experience using both Visual Studio and Microsoft Expression Blend to build WPF applications. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Complete Windows Communication Foundation for .NET 4.0 |
| Course Number | INT-1138 | |
| Price | $2,050.00 |
| Length | 3 Day |
| Description | Windows Communication Foundation (WCF) is an API used to build distributed applications using .NET 3.0 (and higher). WCF was designed to expose the current multitude of Windows remoting APIs (web services, MSMQ, TCP, peer-to-peer, etc) from a single unified toolkit. In this course, attendees will examine the overall WCF programming model, binding choices, host options, security issues and the use of declarative markup to specify the underlying infrastructure. Attendees will also learn about the major changes to WCF with the release of .NET 4.0 |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Developing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006 |
| Course Number | MOC-2933 | |
| Price | $2,495.00 |
| Length | 5 Day |
| Description | This five-day, instructor-led, hands-on course provides students with the knowledge and skills to efficiently and effectively integrate systems, employees, and trading partners through orchestration in a highly flexible and highly automated manner. This course is intended for solution architects and developers who are responsible for developing Microsoft BizTalk Server 2006 business process and integration solutions. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| SharePoint No-Code Application Development for Workflows, Data Connectivity, and KPIs |
| Course Number | NH-SP07DesignWF | |
| Price | $2,544.00 |
| Length | 4 Day |
| Description | Now that the organization has gotten SharePoint installed... what's next? In this 4 day course you will learn how to take the foundation that SharePoint provides and construct "no code" BI Applications (using custom Workflows, Data Sources/Views, Key Performance Indicators, Excel Services, Business Data Catalog, and InfoPath Forms Services) using the built in capabilities in SharePoint and SharePoint Designer without coding anything. You will learn how to streamline existing processes, centralize access to information, and ultimately improve support for and use of SharePoint as a business productivity tool in your organization. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Microsoft SharePoint 2010 Application Development |
| Course Number | MOC-10175 | |
| Price | $2,750.00 |
| Length | 5 Day |
| Description | This course provides existing .NET developers with practical information and labs that enables them to build solutions on the Microsoft SharePoint 2010 platform. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Introduction to Microsoft Project |
| Course Number | PRJ-101 | |
| Price | $795.00 |
| Length | 2 Day |
| Description | The two-day introductory course is a detailed roadmap to successfully managing projects using Microsoft Project. You will learn the key elements of project management and how to apply that knowledge using the robust features of Microsoft Project. You will learn to schedule, baseline, manage, and complete a project using the features of Microsoft Project. Exercises reinforce your learning and there is time allotted for you to work on your own projects. This course does not attempt a comprehensive look at all of the hundreds of features but concentrates on examples of each feature set to set the course for Getting the Job Done with Microsoft Project. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Advanced Microsoft Project |
| Course Number | PRJ-201 | |
| Price | $395.00 |
| Length | 1 Day |
| Description | The one-day advanced course is intended for those already successfully using Microsoft Project to manage individual projects that now need to use some advanced techniques. You will learn the key elements of multiple project management using shared resources and how to apply that knowledge using the robust features of Microsoft Project. You will learn to create a resource pool contour resources use formulas in cells, link tasks across projects and more. Exercises reinforce your learning and there is time allotted for you to work on your own projects. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Crystal Reports 2011: Report Design II and III - Business Reporting and Processing Strategies |
| Course Number | RD-220-230 | |
| Price | $1,725.00 |
| Length | 3 Day |
| Description | RD 220 - This course is designed to give you comprehensive skills and in-depth knowledge to plan and create reports that will help you analyze and interpret information using Crystal Reports®.
As a business benefit, you will be able to increase your understanding of formulas, variables, arrays, templates, parameters, summaries, and sections, which will help you make more effective report design decisions and create more efficient reports.
RD 230 - This one-day instructor led classroom course is designed to give you the comprehensive skills and in-depth knowledge required to plan and create reports that will help you analyze and interpret important information.
As a business benefit, you will find that your increased understanding of report processing, formulas, custom functions and subreports will help you make more effective report design decisions and create more efficient reports. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Crystal Reports 2011: Report Design I - Fundamentals of Report Design |
| Course Number | RD-210 | |
| Price | $1,150.00 |
| Length | 2 Day |
| Description | This two-day instructor led classroom course is designed to give you comprehensive skills and in-depth knowledge to plan and create reports that will help you analyze and interpret information using Crystal Reports®.
As a business benefit, you will find that this course is an in-depth approach to the entire report creation cycle from planning a report prototype to distributing a report. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Complete Java |
| Course Number | IT-2101 | |
| Price | $2,495.00 |
| Length | 5 Day |
| Description | The Java language began modestly as a programming language to address the needs of a diverse set of consumer appliances, but has since evolved to become the most popular language and platform for building enterprise level applications. Intertech Training’s Complete Java course teaches you the syntax and core APIs of the Java programming language while also coaching you on the conventions and practical techniques necessary to code Java professionally.
The class begins by describing the core syntax of the Java language while also exposing students to object-oriented programming concepts. After establishing this essential foundation, the class then covers other crucial topics like exception handling, packaging, and when to use arrays versus collections. In addition, you learn how to use critical Java APIs for I/O, database access and graphical user interface development. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Complete Java Web Development |
| Course Number | IT-2201 | |
| Price | $2,495.00 |
| Length | 4 Day |
| Description | Complete Java Web Development is a crash course in developing cutting edge Web applications using the latest Java EE 5 technologies from Sun and the open source community. The course builds a strong understanding of Servlet technology as the cornerstone of Java's Web platform. It shows how JSPs build on the Servlet architecture and help your development teams achieve clear role separation. Allowing Web developers to focus on functionality while the Web designers create the layout - without stepping on each other's toes. Additionally, the class will show you how to use JSTL, custom tags and JSP expression language to reduce Java code in Web pages while adding tremendous power and capability to those pages. Attendees will also learn JavaBean component development and how these components can be easily integrated into JSPs. The class culminates in an exploration of Java MVC frameworks and compares some of the more popular offerings like Struts and Spring MVC.
While focusing on Web technologies, the course also exposes developers to the constant trade off between application robustness and complexity. This is not a class that focuses on theory. Participants will find the course is loaded with practical labs and simulations. After taking this class, your developers will be able to build Web applications faster, that are more scalable, and that are easier to maintain. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Complete Struts Using Eclipse Training |
| Course Number | I-W-472 | |
| Price | $1,995.00 |
| Length | 3 Day |
| Description | This course introduces the students to Jakarta Struts 1.2. During the course, students will learn to design and develop Struts based applications. Many real life hands on exercises are used to teach various concepts of Struts. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Introduction to Microsoft Project |
| Course Number | PRJ-101 | |
| Price | $795.00 |
| Length | 2 Day |
| Description | The two-day introductory course is a detailed roadmap to successfully managing projects using Microsoft Project. You will learn the key elements of project management and how to apply that knowledge using the robust features of Microsoft Project. You will learn to schedule, baseline, manage, and complete a project using the features of Microsoft Project. Exercises reinforce your learning and there is time allotted for you to work on your own projects. This course does not attempt a comprehensive look at all of the hundreds of features but concentrates on examples of each feature set to set the course for Getting the Job Done with Microsoft Project. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Advanced Microsoft Project |
| Course Number | PRJ-201 | |
| Price | $395.00 |
| Length | 1 Day |
| Description | The one-day advanced course is intended for those already successfully using Microsoft Project to manage individual projects that now need to use some advanced techniques. You will learn the key elements of multiple project management using shared resources and how to apply that knowledge using the robust features of Microsoft Project. You will learn to create a resource pool contour resources use formulas in cells, link tasks across projects and more. Exercises reinforce your learning and there is time allotted for you to work on your own projects. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| SQL Server for Developers |
| Course Number | ALTO-2073 | |
| Price | $1,595.00 |
| Length | 3 Day |
| Description | This three-day, hands-on course provides students with the technical skills required to program a database solution using Microsoft SQL Server. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Creating Reporting Solutions using Microsoft SQL Server Reporting Services |
| Course Number | AD-2793 | |
| Price | $1,195.00 |
| Length | 2 Day |
| Description | In this course, you will learn how to use SQL Server Reporting Services to create, execute, and manage reports. You will learn how to create tabular, matrix (cross-tab), and chart reports. You'll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You'll explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. You'll gain a thorough understanding of Reporting Services security, report snapshots, subscriptions, and the use of custom assemblies. You'll also discover how to integrate reports into your ASP.NET and WinForms applications using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer. Finally, you'll learn how to empower your users to create ad-hoc reports using Report Builder and Report Model projects. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| SQL Server Integration Services |
| Course Number | AD-2792 | |
| Price | $1,595.00 |
| Length | 3 Day |
| Description | This course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| SQL Server Analysis Services |
| Course Number | AD-6234 | |
| Price | $1,595.00 |
| Length | 3 Day |
| Description | In this course, you will learn how to use Microsoft SQL Server Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server developer the tools to build data cubes and forecasting solutions. This course also provides information on end-user tools including Microsoft Excel 2007, Office Visio 2007 Professional Edition, SQL Server Business Intelligence Development Studio (BIDS) Microsoft SQL Server 2005 Integrated Services and Reporting Services. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Solving Business Problems with MDX in SQL Server 2008 |
| Course Number | SQM-SQLMDX08 | |
| Price | $2,350.00 |
| Length | 3 Day |
| Description | This hands-on, instructor led course will guide you step-by-step through the Analysis Service 2008 Multi Dimensional eXpression (MDX) OLAP query language. You will learn a practical approach to solve real-world problems using MDX expressions, calculations and queries, which will allow users to extract valuable information. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Writing Queries Using Microsoft SQL Server 2008 Transact-SQL |
| Course Number | MOC-2778 | |
| Price | $1,650.00 |
| Length | 3 Day |
| Description | This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Implementing and Maintaining Microsoft SQL Server 2008 Integration Services |
| Course Number | MOC-6235 | |
| Price | $1,650.00 |
| Length | 3 Day |
| Description | This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
This course is 95 percent relevant to SQL 2005 users and is the recommended training solution for those people looking to learn SSIS for SQL 2005. The concepts, tools and best practices are almost identical between SQL 2005 and 2008. Please note; at times there are new features of SQL 2008 that are covered which are not available to SQL 2005 implementations. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services |
| Course Number | MOC-6236 | |
| Price | $1,650.00 |
| Length | 3 Day |
| Description | This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.
This course is 95 percent relevant to SQL 2005 users and is the recommended training solution for those people looking to learn SSIS for SQL 2005. The concepts, tools and best practices are almost identical between SQL 2005 and 2008. Please note; at times there are new features of SQL 2008 that are covered which are not available to SQL 2005 implementations. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| SQL Server 2008 Architecture, Internals and Tuning |
| Course Number | NHSQLPerTune08 | |
| Price | $3,950.00 |
| Length | 5 Day |
| Description | This is an advanced 5-day course designed for advanced SQL Server professionals. The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as tuning techniques. This course will be presented on SQL Server 2008 and cover features specific to that version, but most of the information is relevant to SQL Server 2005 as well.The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as performance tuning techniques. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| SQL Server 2008 End to End Business Intelligence Workshop |
| Course Number | SQM-SQLEndBI | |
| Price | $3,295.00 |
| Length | 5 Day |
| Description | Business intelligence solutions provide the infrastructure that enables users at all levels of a business to make better decisions based on more accurate and up-to-date information. This workshop focuses on teaching IT professionals the best practices and skills required to successfully design, build, deploy, and operate a business intelligence solution using SQL Server 2008 Integration Services, Analysis Services and Reporting Services. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Advanced T SQL Querying Programming and Tuning for SQL Server 2005 and 2008 |
| Course Number | SQM-TASQLPrg08 | |
| Price | $3,950.00 |
| Length | 5 Day |
| Description | The course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2005 and 2008. In this course you will learn the details and capabilities of T-SQL in the following areas: Logical Query Processing; Query Tuning; Subqueries, Ranking Functions, Joins and Set Operations; Aggregating and Pivoting Data; TOP and APPLY; Data Modification; Data Type Related Problems; Programmable Objects (Dynamic SQL, Views, User Defined Functions, Stored Procedures, Triggers, Transactions and Concurrency, Exception Handling); Graphs, Trees and Hierarchies. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Implementing a Microsoft SQL Server 2008 R2 Database |
| Course Number | MOC-6232B | |
| Price | $2,795.00 |
| Length | 5 Day |
| Description | This five-day instructor-led course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best practices on how to use SQL Server 2008 R2 product features and tools related to implementing a database server. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Querying and Processing SQL Server Data with Transact SQL Statements |
| Course Number | ALTO-2778 | |
| Price | $1,195.00 |
| Length | 2 Day |
| Description | By the end of this course you will:
• Be familiar with the tools used to interact with SQL Server databases.
• Be comfortable with basic SELECT statement syntax and be able to write queries that extract records from a single table.
• Understand enough about the more advanced SELECT statement syntax that you can figure out what the statement is doing and where to go to learn more.
• Be able to safely make changes to records in tables, using INSERT, UPDATE and DELETE statements.
• Be able to create and alter VIEWs.
• Be able to find text patterns in data using the LIKE operator and full text searching. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Maintaining a Microsoft SQL Server 2008 R2 Database |
| Course Number | MOC-6231B | |
| Price | $2,495.00 |
| Length | 5 Day |
| Description | This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a database.
The primary audience for this course is individuals who administer and maintain SQL Server databases. This course can also be helpful for individuals who develop applications that deliver content from SQL Server databases. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services |
| Course Number | MOC-6234 | |
| Price | $1,650.00 |
| Length | 3 Day |
| Description | Elements of this syllabus are subject to change.
This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.
This course is 95 percent relevant to SQL 2005 users and is the recommended training solution for those people looking to learn SSAS for SQL 2005. The concepts, tools and best practices are almost identical between SQL 2005 and 2008. Please note; at times there are new features of SQL 2008 that are covered which are not available to SQL 2005 implementations |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Microsoft Silverlight 4 Using Visual Studio 2010 Level 2 |
| Course Number | AD-SL4B | |
| Price | $1,200.00 |
| Length | 2 Day |
| Description | Silverlight 4.0 makes it possible for developers to create rich, interactive applications delivered through a Web browser to nearly any client operating system, including Windows, Mac, and Linux. This course moves beyond the basics of creating and hosting Silverlight applications, working through some more advanced controls, more graphic issues including shapes, geometries, brushes, transforms, and animations, through deploying Silverlight applications. |
| More Information | View Full Course Outline and Scheduled Classes |
| |
| Microsoft Silverlight 4 Using Visual Studio 2010 Level 1 |
| Course Number | AD-SL4A | |
| Price | $1,200.00 |
| Length | 2 Day |
| Description | Silverlight 4.0 makes it possible for developers to create rich, interactive applications delivered through a Web browser to nearly any client operating system, including Windows, Mac, and Linux. This course introduces the basics of creating and hosting Silverlight applications, working through many of the important controls, through binding Silverlight applications to live data. |
| More Information | View Full Course Outline and Scheduled Classes |
| |