Site Navigation:

Customizable Training


Onsite training is a very effective method to quickly train a team. Since we have written courseware, articles and published books on various technologies, we can easily adapt and tailor the material for your particular project and developer needs. Electing to have the class come to you provides a high ROI by eliminating travel costs and time away from the office while providing some progress on your project through the tailored solutions presented. The onsite option can be cost effective with as few as 3 attendees.

We will be glad to discuss this option in more detail and review dates that may work for your project team.

The following classes are offered for Customizable Onsite Training. For other technologies, visit the links on the lower right of the page.

Learning to Program in Visual C#

Standard Duration Price # of Students Additional Student Price
5 days $8,950 5 $1,000

In this course, you’ll learn to use Visual Studio 2005 to explore the Visual C# 2005 language. The course starts with a quick overview of the .NET platform, examining assemblies, Microsoft Intermediate Language, Visual Studio profiles, XML comments, IntelliSense, and debugging. From there, you’ll learn all the language features that you must internalize in order to create full-featured Web or Windows applications that make best use of the .NET platform. You’ll learn about data types, variables, and operators, along with all the important flow control structures. You’ll work through several examples demonstrating the power of the .NET Framework, and dig into creating and consuming your own classes and objects. The course moves on to working with data structures, such as arrays and collection classes, before finishing up with discussions of generics, handling exceptions and working with delegates and events. By the end of this course, you will understand the important basic concepts that will allow you to start creating the applications you need.



ASP.NET with C# 2005

Standard Duration Price # of Students Additional Student Price
5 days $8,950 5 $1,000

In this course, you’ll learn how to use Visual Studio 2005 and Visual C# 2005 to build ASP.NET 2.0 Web pages and XML Web services. You’ll gain an understanding of the new architecture behind ASP.NET 2.0 and how to use the new server controls. You’ll learn to create consistent web sites using Master Pages, to improve performance with output caching, add membership features, configure and deploy ASP.NET applications, to authenticate users and limit their access to resources, direct users using new Site Navigation tools and to handle multi-user data access conflicts. You will also become familiar with the debugging and tracing features in Visual Studio 2005 that help you quickly troubleshoot issues and you will learn how to take advantage of creating your own user-defined controls.



ASP.NET Using C# 2008

Standard Duration Price # of Students Additional Student Price
5 days $9,500 5 $1,000

In this course, you'll learn how to use Visual Studio 2008 and Visual C# 2008 to build ASP.NET 3.5 Web pages. You'll gain an understanding of the architecture behind ASP.NET and how to use the various ASP.NET server controls. You'll learn to create consistent web sites using Master Pages, add membership features, configure and deploy ASP.NET applications, to authenticate users and limit their access to resources, manage state, direct users using Site Navigation tools, debug .NET and JavaScript code, and to display and edit data using ASP.NET and ADO.NET. In addition, you'll learn about new ASP.NET 3.5 features, such as support for LINQ (Language Integrated Query), CSS tools, nested master pages, and more.

In this course, you will learn how to…

  • Use ASP.NET server controls to generate HTML and to execute event procedures.
  • Configure and deploy ASP.NET applications.
  • Promote consistency within your Web site through the use of Master Pages.
  • Retrieve and manipulate data using ADO.NET.
  • Display and edit data quickly and easily using data binding features.
  • Use Membership features to manage your Web users.
  • Manage session and application state to give users a rich browsing experience.
  • Use Site Navigation controls to direct users within your site.
  • Add scalability and reliability by setting up an out-of-process session state server.
  • Use ASP.NET's new CSS tools to create consistent and maintainable sites.
  • Validate user input using validation controls.
  • Debug .NET code that runs on the server to generate Web pages and interact with the user.
  • Find problems in JavaScript code and learn about other debugging tools in Visual Studio.



    Microsoft SQL Server 7.0 Level 1 & Level 2

    Standard Duration Price # of Students Additional Student Price
    5 days $9,500 5 $1,000

    Level 1 is for developers coming from Microsoft Access or Visual Basic development backgrounds who have applications that they’re hoping to upsize to SQL Server. Learn some of the issues with installation and configuration, database design issues, how to import non-Jet data, and how to either share data between SQL Server and Jet, or completely upsize data to SQL Server. This introductory course teaches you the fundamentals and gives you a taste of the potential of Microsoft SQL Server 7.0.

    In Level 1 you will learn...

  • Learn to install and configure Microsoft SQL Server 7.0.
  • Set up and normalize your database.
  • Import and link data to Microsoft
  • Convert databases from Microsoft
  • Migrate your Microsoft Access databases into Microsoft SQL Server 7.0.

    The first part of Level 2 focuses on querying. You’ll learn how to create a basic query using SELECT statements and then move into more advanced types of queries. Then, you'll learn techniques for making the best use of Microsoft SQL Server. You’ll learn how to optimally configure Microsoft SQL Server and use techniques for backing up your data. This course also focuses on topics that are relevant to multi-user, replication, and Internet/intranet environments.

    In Level 2 you will learn...

  • Create basic queries using SELECT statements.
  • Use joins, subqueries, and action queries.
  • Use stored procedures, triggers,
  • Use transaction processing and locking to resolve multi-user conflicts.
  • Configure and tune SQL Server using the Wizards.
  • Set up the security features of your SQL Server database.
  • Publish SQL Server data to the Web.



    Introduction to Microsoft SQL Server 2000: Level 1 & 2

    Standard Duration Price # of Students Additional Student Price
    5 days $8,950 5 $1,000

    Level 1 is for developers coming from Microsoft Access, Visual Basic, Active Server Pages or other development backgrounds who want to learn to build successful databases solutions with SQL Server. Even developers who've already used Oracle, Sybase, DB2 or other relational database management systems will find this course useful for getting up to speed on SQL Server 2000. Learn about the features that are available in SQL Server; how to design and create a database; and how to build basic queries using Transact-SQL, the language of SQL Server. This introductory course teaches you the fundamentals and gives you a taste of the potential of Microsoft SQL Server 2000.

    In Level 1 you will learn...

  • Learn to install and configure Microsoft SQL Server 2000.
  • Understand basic database design principles and how to implement them in SQL Server.
  • Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.

    Level 2 assumes that you already know how to create a well-designed database and how to write simple SQL queries for retrieving and manipulating data. The course shows you how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL (T-SQL), the programming language of SQL Server. You'll also learn how to take advantage of SQL Server's tools for maintaining, securing, and tuning your databases.

    In Level 2 you will learn...

  • Use the programming environment in the Query Analyzer and learn the Transact-SQL language.
  • Understand the differences between view, stored procedures, triggers, and user-defined functions, and know the advantages and drawbacks of each.
  • Design and implement reliable backup and maintenance plans.
  • Understand the SQL Server security model; and create logins, users and permissions to protect your data.
  • Configure and tune SQL Server, and monitor database activity



    Introduction to Microsoft SQL Server 2000: Level 3

    Standard Duration Price # of Students Additional Student Price
    3 days $5,370 5 $600

    SQL Server 2000 includes a rich set of tools that go beyond the basics of querying and manipulating data. Microsoft added many very useful capabilities in SQL Server that most developers never discover. This course assumes that you already know the fundamentals of how to build a database and program it with Transact-SQL. Learn about the advanced features available to you for maintaining, analyzing, searching and distributing your data. Integrate your data safely with Internet and cross-platform applications.

    In Level 3 you will learn...

  • Use Data Transformation Services (DTS) to import and export data, or to move it between external data sources, handling data mapping and conversion when necessary.
  • Support distributed users by implementing SQL Server Replication, and understand which replication options are appropriate for which requirements.
  • Publish data to the Web, and take advantage of SQL Server 2000’s rich support for Extensible Markup
  • Use Analysis Services to create online analytical processing (OLAP) solutions and to mine your data for hidden patterns.



    SQL Server 2000: OLAP Cubes and Queries

    Standard Duration Price # of Students Additional Student Price
    2 days $3,580 5 $400

    In this course, you will learn how to use Microsoft SQL Server 2000 Analysis Services for creating OLAP databases and cubes. Analysis Services is a product that ships with Microsoft SQL Server 2000. This course will explain how to use Analysis Services to provide a level of data analysis and reporting that goes beyond the capabilities of relational database systems. The course will detail how Analysis Services works and how to create OLAP databases, dimensions, and cubes. You will learn how to use Analysis Manager, the administrative tool of Analysis Services, and its many wizards, objects, and properties, to create effective OLAP cubes for data analysis.

    In this course you will learn how to...

  • Use Microsoft SQL Server 2000 Analysis Services
  • Use Analysis Manager
  • Understand and use dimensions
  • Create cubes and measures
  • Design storage for cubes
  • Create partitions and virtual cubes
  • Use calculated members
  • Use MDX expressions
  • Secure OLAP databases, dimensions, and cubes
  • Deploy OLAP databases



    SQL Server 2000: DTS and Transformations

    Standard Duration Price # of Students Additional Student Price
    2 days $3,580 5 $400

    In this course, you will learn how to use Data Transformation Services (DTS) in Microsoft SQL Server 2000. This course presents DTS as an integral part of a data warehousing solution. You will learn how DTS works, how to set up DTS packages, and how to use the graphical tools for creating and maintaining packages. You will also learn how to use the various components of DTS packages: connections, tasks, steps, and global variables. Learning DTS not only benefits those who design and build data warehouses and data marts, but also anyone who works with data that is stored in different formats throughout an organization. This course shows you how Data Transformation Services can be used in any situation involving data transfer or maintaining the consistency of data.

    In this course, you will learn to...

  • Understand what a data warehouse is and how to use it.
  • Use the DTS Import/Export Wizard.
  • Work with the components of a DTS package.
  • Use the DTS Package Designer.
  • Copy and manipulate data using DTS.
  • Use the Transfer Data Task.
  • Use the Bulk Insert Task.
  • Store DTS packages.
  • Execute and secure DTS packages.
  • Modify the properties of DTS packages.



    Microsoft SQL Server 2005

    Standard Duration Price # of Students Additional Student Price
    5 days $8,950 5 $1,000

    In this course, you’ll learn about the features that are available in SQL Server; how to design and create a database; and how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and programmers can now use .NET languages like C# and Visual Basic to build database objects.

    SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. You'll learn how to take advantage of the new, user-friendly management console that integrates both authoring and administrative tasks. You'll learn how to take advantage of SQL Server's tools for analyzing and tuning your databases. You'll also learn about integration services, implementing security, and Microsoft's new Business Intelligence (BI) suite.

    In this course, you will learn:

  • Install and configure Microsoft SQL Server 2005.
  • Understand basic database design principles and how to implement them in SQL Server.
  • Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.
  • Understand the differences between view, stored procedures, triggers, and user-defined functions.
  • Perform calculations with Visual Basic and Visual C# code rather than T-SQL.
  • Use the new Common Table Expressions for creating hierarchical queries.
  • Understand the SQL Server security model.
  • Configure and tune SQL Server, and monitor database activity.
  • Support distributed users by implementing SQL Server Replication.
  • Publish data to the Web, and take advantage of SQL Server’s rich support for XML.
  • Understand Business Intelligence to add reporting and analysis capabilities.



    Microsoft SQL Server 2005 for Administrators

    Standard Duration Price # of Students Additional Student Price
    5 days $8,950 5 $1,000

    In this course, you'll learn about available features for the administration of SQL Server, and how to design, create, modify, analyze and tune your databases. You will learn how to build basic queries using Transact-SQL, how to take advantage of the new, user-friendly management console, and how to use SQL Server's tools for configuring, tuning and monitoring database activity. This course also covers critical topics like integration services, implementing security, disaster prevention and recovery, failover clustering, database mirroring and more.

    In this course, you will learn how to…

  • Install and configure Microsoft SQL Server 2005.
  • Understand basic database design principles and how to implement them in SQL Server.
  • Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.
  • Understand the SQL Server security model.
  • Configure and tune SQL Server, and monitor database activity.
  • Support distributed users by implementing SQL Server Replication.
  • Learn about disaster recovery options.
  • Understand high availability concepts.
  • See how to implement SQL Server high-availability features: failover clustering, database mirroring, log shipping, and peer-to-peer replication.
  • Explore new techniques for monitoring and troubleshooting SQL Server.
  • Learn how to implement asynchronous messaging with the new Service Broker.



    Microsoft SQL Server 2005 T-SQL with Advanced Topics

    Standard Duration Price # of Students Additional Student Price
    5 days $8,950 5 $1,000

    In this course, you'll start by learning about the basic features that are available in SQL Server, including how to design and create a database and how to build queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You'll learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and how programmers can now use .NET languages like C# and Visual Basic to build database objects. You'll also learn about enhancements made to SQL Server 2005 for handling complex data structures, using partitioning, and working with XML.

    In this course, you will…

  • Understand basic database design principles and how to implement them in SQL Server.
  • Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.
  • Understand the differences between view, stored procedures, triggers, and user-defined functions.
  • Use the new Common Table Expressions for creating hierarchical queries.
  • Perform calculations with Visual Basic and Visual C# code rather than T-SQL.
  • Discover partitioning with SQL Server.
  • Examine new RANKing functions, Common Table Expressions, and learn techniques for dealing with complex queries.
  • Explore advanced techniques for working with complex data.
  • Discover new XML capabilities in SQL Server 2005.



    Microsoft SQL Server 2005 Integration Services

    Standard Duration Price # of Students Additional Student Price
    3 days $5,370 5 $600

    This course will enable technology professionals with little or no ETL experience and minimal exposure to SQL Server 2005 and Visual Studio 2005 to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development Studio (BIDS) and working with Control Flow and Data Flow. 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.



    Writing Queries Using Microsoft SQL Server 2005 T-SQL

    Standard Duration Price # of Students Additional Student Price
    3 days $5,370 5 $600

    In this course, you’ll learn how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and programmers can now use .NET languages like C# and Visual Basic to build database objects.

    In this course, you will…

  • Understand basic database design principles and how to implement them in SQL Server.
  • Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.
  • Understand the differences between view, stored procedures, triggers, and user-defined functions.
  • Use the new Common Table Expressions for creating hierarchical queries.
  • Perform calculations with Visual Basic and Visual C# code rather than T-SQL.



  • Details:

    The DSW Group, Ltd. charges a flat travel free for the continental U.S. of $1700 for 5 day classes, $1500 for 4 day classes, $1300 for 3 day classes, $1100 for 2 day classes, and $900 for 1 day classes. This fee is in addition ot the above pricing. A non-refundable deposit of $3,000 is required to lock in a scheduled date and instructor. Balance duie will be invoiced upon completion, due Net 15 upon receipt of invoice. Payment can be made by check, Visa, Master Card, American Express or Discover.

    Normal class times for a 5-Day class are 9:00am to 5:00pm Monday through Thursday and 9:00 to 1:00pm on Friday. Unless instructed otherwise, we will assume business casual as the appropriate dress code.

    Our client is responsible for providing the training room, one PC for each student, appropriate software loaded on each machine, whiteboard, screen and projector for our instructor to use with his notebook computer.

    Contact:

    To inquire and/or schedule an onsite training session, please contact:

    Training@thedswgroup.com
    770-953-0393

    The DSW Group

    Consultants, Trainers and Content Producers. Learn more about us.

    Available Technologies

    Explore other training options...