|
Microsoft Certified Applications Developer (MCAD) for Microsoft.NET
(3352832) |
|
Return to Search Results | Request More Information | View Comments | Recommend this Course | Purchase Course |
 |
Summary:
This set is comprised of 70 courses:
Essentials of Microsoft Networking Second Edition, Part One
Essentials of Microsoft Networking Second Edition, Part Two
Microsoft SQL Server 2000: Database Design
.NET Framework: Introduction
Microsoft SQL Server 2000: Querying with Transact-SQL
Visual Studio .NET: Introduction
Visual C#.NET: Introduction for Developers
Visual C#.NET: Advanced
Visual Basic .NET: Introduction
Creating and Manipulating Data with Microsoft ADO.NET
Managing Data Source Connections Using Microsoft ADO.NET
ASP.NET: Using VisualBasic.NET, ADO.NET, and XML
Getting Started with Microsoft Visual Studio .NET
Working with Data-Driven ASP.NET Web Applications
Managing and Finalizing ASP.NET Web Applications
Creating ASP.NET Web Applications
SQL: Advanced Querying ? Second Edition ? (Part1): Using Subqueries
SQL: Advanced Querying ? Second Edition ? (Part 2): Manipulating Tables
SQL: Advanced Querying ? Second Edition ? (Part 3): Viewing and Indexing Table Data
SQL: Fundamentals of Querying Second Edition (Part1): Basic Querying
SQL: Fundamentals of Querying Second Edition (Part2): Organizing Data
SQL: Fundamentals of Querying Second Edition (Part3): Handling Multiple Tables
ASP.NET: Using Visual C#, ADO.NET, and XML
Getting Started with COM+
Web Service Architectures and Technologies
Working with Data-driven COM+ Applications
Creating and Managing Controls with Visual C# .NET
Creating and Managing Controls with Visual Basic .NET
Securing and Managing COM+ Applications
Implementing Web Services
Implementing CRMs, Handling COM+ Events and Configuring Queued Components
Improving Web Service Performance
Finalizing COM+ Applications
Developing Applications with Visual C# .NET
Developing Applications with Visual Basic .NET
Preparing and Deploying Applications with Visual Basic .NET
Preparing and Deploying Applications with Visual C# .NET
Creating and Debugging ASP.NET Web Applications
Enhancing ASP.NET Web Application Functionality
ASP Application Migration and ASP.NET Web Application Deployment
Working with XML
Updating Your Data Integration Skills to Microsoft SQL Server? 2005 Integration Services (2943B)
Getting Started with Databases and Transact-SQL in Microsoft SQL Server? 2005 (4326)
Performing Basic Queries in Microsoft SQL Server? 2005 (4327)
Grouping and Summarizing Data in Microsoft SQL Server? 2005 (4328)
Joining Data from Multiple Tables in Microsoft SQL Server? 2005 (4329)
Working with Subqueries in Microsoft SQL Server? 2005 (4330)
Modifying Data in Microsoft SQL Server? 2005 (4331)
Querying Metadata, XML, and Full-Text Indexes in Microsoft SQL Server? 2005 (4332)
Using Programming Objects for Data Retrieval in Microsoft SQL Server? 2005 (4333)
Using Advanced Querying Techniques in Microsoft SQL Server? 2005 (4334)
Microsoft Office Access? 2007: New Features
Microsoft Office Excel 2007: New Features
Programming Microsoft SQL Server? 2005 (2939B)
Microsoft Office Excel 2007: Level 1 (Second Edition)
Microsoft Office Outlook 2007: Level 1 (Second Edition)
Creating the Data Access Tier Using Microsoft SQL Server? 2005 (2941B)
Microsoft Office Access? 2007: Level 1 (Second Edition)
Microsoft Office Excel 2007: Level 2 (Second Edition)
Microsoft Office Outlook 2007: Level 2 (Second Edition)
Microsoft Office Access? 2007: Level 2 (Second Edition)
Installing and Securing Microsoft SQL Server? 2005 (2936B)
Administering and Monitoring Microsoft SQL Server? 2005 (2937B)
Data Availability Features in Microsoft SQL Server? 2005 (2938B)
Building Service and Notifications Using Microsoft SQL Server? 2005 (2940B)
New Features of Microsoft SQL Server? 2005 Analysis Services (2942B)
Updating Your Reporting Skills to Microsoft SQL Server? 2005 Reporting Services (2944B)
Microsoft Office Excel 2007: Level 3 (Second Edition)
Microsoft Office Access? 2007: Level 3 (Second Edition)
Microsoft Office Access? 2007: Level 4 (Second Edition) |
|
Course Offered By:
Element K
500 Canal View Boulevard
Rochester, New York 14623
Phone: 585-240-7500
Courses by this Learning Provider |
|
 | | Over the past 25 years, Element K has been committed to helping the world's most prestigious companies improve their business with learning and development. |
|
|
|
Course Cost:
$370.00 (Purchase Course)
|
Promotions:
We offer 15% discount to Dice Learning members. Please add coupon code DICESPECIAL15 to your checkout on this site.
Purchase any Element K web-based course and get one month FREE Dice Advantage service with your first purchase. A $29 value! Contact us for details.
|
Course Duration:
38 Hours, 59 Minutes
|
Course Type:
Self Paced
|
|
|
Description:
The following 70 courses are included:
Essentials of Microsoft Networking Second Edition, Part One
Description:
In this course you will examine the components of a computer network, network processing strategies, the role of network adapters, identify media access control methods, examine characteristics of common network topologies, and the session management process.
Objectives:
After completing this course you will be able to identify the three network-processing strategies, the roles of network adapters in data transmissions, media-access control methods, characteristics of common network topologies, examine session management process, and compare data representation methods.
Duration: 5 Hours, 20 Minutes
Essentials of Microsoft Networking Second Edition, Part Two
Description:
In this course you will examine how to administer a network, explore the fundamental technologies associated with wide area networks and remote network access, and examine how the Internet is a valuable tool for network administrators.
Objectives:
After completing this course you will be able to install Windows NT, create and manage network accounts, monitor network performance, enhance data security on a network, identify methods for avoiding data loss, identify common technologies associated with long-haul communication lines, investigate technologies used for remote access, and identify Internet resources for network administrators.
Duration: 5 Hours, 23 Minutes
Microsoft SQL Server 2000: Database Design
Description:
In this course you will explore how to identify the features of Microsoft SQL Server 2000. You will use Transact-SQL, create databases and tables, implement data integrity techniques and indexes, and query multiple tables using joins. You will also design subqueries, use aggregate functions in queries and create user-defined functions.
Objectives:
After completing this tutorial you will be able to identify the two forms the SQL server database typically takes, and list two features the make SQL Server a powerful database management system.
Duration: 17 Hours, 24 Minutes
.NET Framework: Introduction
Description:
The key to understanding .NET and how it may impact your life is to recognize the technical innovations that make it both powerful and unique. This course is the first in a series of .NET-related courses. It will provide you with the basic concepts required to decode the terminology and features of .NET, and will serve as the foundation for the other .NET courseware.
Objectives:
In this course, you will describe the .NET Framework components and the development tool, Visual Studio.NET, and discuss their role in enabling and supporting the .NET paradigm.
Duration: 3 Hours, 30 Minutes
Microsoft SQL Server 2000: Querying with Transact-SQL
Description:
In this course, you will explore the features of Transact-SQL and the Transact SQL statement types and elements that enable you to design flexible programs. You will explore the techniques for modifying data in tables and the different types of functions in SQL that you can use to summarize data. After completing this course, you will be able to use the Transact-SQL utilities to query a SQL server, retrieve data by using the SELECT statement, modify data by using the INSERT, UPDATE, and DELETE statements, and summarize data by using the TOP, GROUP BY, COMPUTE, and COMPUTE BY clauses. You will also be able to query multiple tables through the use of joins, use subqueries, work with full-text indexes, and other types of programming objects in Transact-SQL.
Objectives:
After completing this tutorial, you will be able to define the different types of Transact-SQL statements and use SQL Query Analyzer to execute them.
Duration: 7 Hours
Visual Studio .NET: Introduction
Description:
Welcome to Visual Studio .NET: Introduction. This course is the recommended course following .NET Framework: Introduction and expands upon the basic concepts you learned about the Visual Studio .NET tool. Now that you have taken the course .NET Framework: Introduction, you understand the basic concepts, features, and possibilities of .NET. With that foundation in place, you are now ready to explore the Visual Studio .NET environment. In this course, you learn how to work with the IDE Windows in Visual Studio .NET to create the different .NET project types. The target audience is anyone interested in Visual Studio .NET either with or without previous Visual Studio experience.
Objectives:
You will identify the relevance of the lesson content.
Duration: 2 Hours, 49 Minutes
Visual C#.NET: Introduction for Developers
Description:
You are now entering the new world of .NET programming by using the C# programming language and the Visual C#.NET integrated development environment inside Visual Studio.NET.
Objectives:
In this course, you will create C# programs based on the Microsoft .NET Framework, including console applications, class libraries, and Windows form-based applications, using correct syntax and modern object-oriented programming techniques.
Duration: 18 Hours, 31 Minutes
Visual C#.NET: Advanced
Description:
You have already entered into the new world of .NET programming by using some of the basic features of the C# programming language and the Visual C#.NET integrated development environment inside Visual Studio.NET. Building on the basics, you are now ready to pursue the advanced aspects of Visual C#.NET programming that are introduced in this course.
Objectives:
In this course, you will program rich client Windows desktop applications and distributed applications by using Visual C#.NET.
Duration: 17 Hours, 49 Minutes
Visual Basic .NET: Introduction
Description:
This course is designed for programmers who have written code for at least three months using a procedural language (such as Fortran, Pascal, C, or Cobol) or an object-oriented programming language (such as Java, C++, Delphi, or Powerbuilder). Further, it is designed for programmers who have used Visual Studio .NET to create .NET projects.
Objectives:
In this course, you will examine how to use Visual Basic .NET to create graphical user interface applications.
Duration: 16 Hours, 53 Minutes
Creating and Manipulating Data with Microsoft ADO.NET
Description:
This course teaches developers to build data-centric applications and Web services with Microsoft ADO.NET, Microsoft SQL Server 2000, and the Microsoft .NET Framework.This course contains virtual labs. A note about virtual system requirements: If you access the Internet from behind a proxy server, you may not be able to take a virtual lab. This affects AOL and Gateway.net users who use a modified browser and those who access virtual lab technology from behind a corporate firewall. Modified browser users should use either Internet Explorer or Netscape Navigator (both 4.0 or higher). Users behind a corporate proxy server should access virtual lab technology through a commercial ISP account. NOTE: Connection to the real PCs and servers is done via the VNS protocol. As a result, there is a requirement for a connection through ports 5800-5821 and 5900-5921.
Objectives:
In this course, you will use Microsoft ADO.NET to build and enhance data-centric applications and Web services.
Duration: 4 Hours, 44 Minutes
Managing Data Source Connections Using Microsoft ADO.NET
Description:
This course teaches developers to build data-centric applications and Web services with Microsoft ADO.NET, Microsoft SQL Server 2000, and the Microsoft .NET Framework.This course contains virtual labs. A note about virtual system requirements: If you access the Internet from behind a proxy server, you may not be able to take a virtual lab. This affects AOL and Gateway.net users who use a modified browser and those who access virtual lab technology from behind a corporate firewall. Modified browser users should use either Internet Explorer or Netscape Navigator (both 4.0 or higher). Users behind a corporate proxy server should access virtual lab technology through a commercial ISP account. NOTE: Connection to the real PCs and servers is done via the VNS protocol. As a result, there is a requirement for a connection through ports 5800-5821 and 5900-5921.
Objectives:
In this course, you will use Microsoft ADO.NET to build and enhance data-centric applications and Web services.
Duration: 4 Hours, 8 Minutes
ASP.NET: Using VisualBasic.NET, ADO.NET, and XML
Description:
Programmers at any skill level interested in writing ASP.NET applications.
Objectives:
In this course, you will create ASP.NET Web pages that dynamically display content, display, manipulate, and modify data in a relational database, and display, manipulate, and modify XML data.
Duration: 17 Hours, 38 Minutes
Getting Started with Microsoft Visual Studio .NET
Description:
In this course, you will use Microsoft Visual Studio .NET and Microsoft ASP .NET to build powerful Web sites. This will allow you to build sites that access databases and process data using dynamic, server-side programming. Thanks to these newly learned skills, your sites will be accessible to users of any of the popular browsers.
Objectives:
Upon successful completion of this course, students will be able to: examine the various technologies that are part of the Microsoft .NET Framework, use Microsoft Visual Studio .NET, and use Microsoft .NET-based languages.
Duration: 2 Hours, 44 Minutes
Working with Data-Driven ASP.NET Web Applications
Description:
In this course, you will use Microsoft Visual Studio .NET and Microsoft ASP .NET to build powerful Web sites. This will allow you to build sites that access databases and process data using dynamic, server-side programming. Thanks to these newly learned skills, your sites will be accessible to users of any of the popular browsers.
Objectives:
Upon successful completion of this course, students will be able to: access relational data using Microsoft Visual Studio .NET, access data with Microsoft ADO.NET, call stored procedures with Microsoft ADO.NET, read and write XML data, and consume and create XML Web services.
Duration: 6 Hours, 2 Minutes
Managing and Finalizing ASP.NET Web Applications
Description:
In this course, you will use Microsoft Visual Studio .NET and Microsoft ASP .NET to build powerful Web sites. This will allow you to build sites that access databases and process data using dynamic, server-side programming. Thanks to these newly learned skills, your sites will be accessible to users of any of the popular browsers.
Objectives:
Upon successful completion of this course, students will be able to: manage state, configure, optimize, and deploy a Microsoft ASP.NET Web application, and secure a Microsoft ASP.NET Web application.
Duration: 3 Hours, 26 Minutes
Creating ASP.NET Web Applications
Description:
In this course, you will use Microsoft Visual Studio .NET and Microsoft ASP .NET to build powerful Web sites. This will allow you to build sites that access databases and process data using dynamic, server-side programming. Thanks to these newly learned skills, your sites will be accessible to users of any of the popular browsers.
Objectives:
Upon successful completion of this course, students will be able to: create a Microsoft ASP.NET Web Form, add code to a Microsoft ASP.NET Web form, use tracing to view runtime information about ASP.NET Web Applications, validate user input. and create user controls.
Duration: 4 Hours, 24 Minutes
SQL: Advanced Querying ? Second Edition ? (Part1): Using Subqueries
Description:
Because of various business conditions and requirements, you may need to use advanced concepts and techniques to query the database. In this course, you will create advanced SQL queries.
Students should have basic introductory SQL skills, basic computer skills, and be familiar with concepts related to database structure and terminology.
Objectives:
In this course, you will work with advanced queries.
Duration: 1 Hours, 25 Minutes
SQL: Advanced Querying ? Second Edition ? (Part 2): Manipulating Tables
Description:
You already know the basics of SQL, including writing basic queries, and filtering, sorting and grouping data. In this course you will learn how to perform advanced queries that use subqueries. You will also learn how to manipulate data and table structure, including how to create constraints. You will also work with views and learn how to index data. This is an intermediate course, and assumes students have basic SQL skills, basic computer skills, and are familiar with concepts related to database structure and terminology.
Objectives:
In this course, you will manipulate tables.
Duration: 2 Hours, 5 Minutes
SQL: Advanced Querying ? Second Edition ? (Part 3): Viewing and Indexing Table Data
Description:
Because of various business conditions and requirements, you may need to view sections of tables. You may also need to index the data in the tables to speed record retrieval. In this course, you will view sections of large tables and speed record retrieval by indexing tables.
Students should have basic introductory SQL skills, basic computer skills, and be familiar with concepts related to database structure and terminology.
Objectives:
In this course, you will work with advanced queries and manipulate tables. You will also view and index table data.
Duration: 1 Hours, 29 Minutes
SQL: Fundamentals of Querying Second Edition (Part1): Basic Querying
Description:
You have access to company databases and your job may require you to retrieve data from those databases. Retrieval of information from a database is dependent on precisely ordered logic and specific information. This course will help you to use Structured Query Language (SQL) as a tool to implement that logic and define the instructions.
Any person with basic computer skills, familiar with concepts related to database structure and terminology, who wants to use SQL to query databases.
Objectives:
In this course, you will learn how to compose SQL queries to retrieve information from the database.
Duration: 2 Hours, 4 Minutes
SQL: Fundamentals of Querying Second Edition (Part2): Organizing Data
Description:
You have access to company databases and your job may require you to retrieve data from those databases. Retrieval of information from a database is dependent on precisely ordered logic and specific information. This course will help you to use Structured Query Language (SQL) as a tool to implement that logic and define the instructions.
Any person with basic computer skills, familiar with concepts related to database structure and terminology, who wants to use SQL to query databases.
Objectives:
In this course, you will learn how to use various functions and organize the data present in the database.
Duration: 1 Hours, 35 Minutes
SQL: Fundamentals of Querying Second Edition (Part3): Handling Multiple Tables
Description:
You have access to company databases and your job may require you to retrieve data from those databases. Retrieval of information from a database is dependent on precisely ordered logic and specific information. This course will help you to use Structured Query Language (SQL) as a tool to implement that logic and define the instructions.
Any person with basic computer skills, familiar with concepts related to database structure and terminology, who wants to use SQL to query databases.
Objectives:
In this course, you will learn how to combine data from two or more tables to retrieve information and generate an HTML output.
Duration: 1 Hours, 17 Minutes
ASP.NET: Using Visual C#, ADO.NET, and XML
Description:
In this course, you will create dynamic Web pages using the latest Microsoft server-side technology, ASP.NET.
This course is suited for programmers at any skill level interested in writing ASP.NET applications.
Objectives:
In this course, you will create ASP.NET Web pages that dynamically display content, display, manipulate, and modify data in a relational database, and display, manipulate, and modify XML data.
Duration: 17 Hours, 38 Minutes
Getting Started with COM+
Description:
This course is intended for: 1) Departmental developers who currently build client/server applications and large-scale solutions for departments inside a business. 2) Consultants who work with developers to build client/server applications and large-scale solutions for businesses. 3) Web developers who build Web-based applications requiring significant infrastructure support such as transactions, security, and pooling of resources. 4) Line-of-business (LOB) application developers.
Objectives:
In this course, you will create a COM+ application and create components that use Just-in-Time activation.
Duration: 3 Hours, 44 Minutes
Web Service Architectures and Technologies
Description:
This course is designed for experienced software developers who have previously built component-based applications.
Objectives:
In this course, you will develop Web Services using Microsoft ASP.NET.
Duration: 3 Hours, 23 Minutes
Working with Data-driven COM+ Applications
Description:
This course is intended for: 1) Departmental developers who currently build client/server applications and large-scale solutions for departments inside a business. 2) Consultants who work with developers to build client/server applications and large-scale solutions for businesses. 3) Web developers who build Web-based applications requiring significant infrastructure support such as transactions, security, and pooling of resources. 4) Line-of-business (LOB) application developers.
Objectives:
In this course, you will run a query and retrieve a result using Microsoft ADO.NET, pass parameters to a stored procedure, create typed DataSet objects, and use construction strings to specify connection information to establish a connection to a data source. You will also implement transaction processing using Microsoft .NET Enterprise Services.
Duration: 3 Hours, 40 Minutes
Creating and Managing Controls with Visual C# .NET
Description:
In this course, you will learn the skills required to build Windows Forms applications by using the .NET Framework. You will create and deploy fully functional, accessible, and secure Windows Forms.
This course is intended for the intermediate programmer who is responsible for designing and building Windows Forms applications by using the .NET Framework. It is designed for developers who have C# development skills. Typically, these individuals perform the following key activities: help create functional specifications, design and develop user interfaces, create and test prototypes, and write Windows Forms applications.
Objectives:
In this course, you will gain the skills required to build Windows Forms applications by using the .NET Framework.
Duration: 4 Hours, 50 Minutes
Creating and Managing Controls with Visual Basic .NET
Description:
In this course, you will learn the skills required to build Windows Forms applications by using the .NET Framework. You will create and deploy fully functional, accessible, and secure Windows Forms.
This course is intended for the intermediate programmer who is responsible for designing and building Windows Forms applications by using the .NET Framework. It is designed for developers who have Microsoft Visual Basic .NET development skills. Typically, these individuals perform the following key activities: Help create functional specifications; design and develop user interfaces; create and test prototypes; and write Windows Forms applications.
Objectives:
In this course, you will gain the skills required to build Windows Forms applications by using the .NET Framework.
Duration: 4 Hours, 36 Minutes
Securing and Managing COM+ Applications
Description:
This course is intended for: 1) Departmental developers who currently build client/server applications and large-scale solutions for departments inside a business. 2) Consultants who work with developers to build client/server applications and large-scale solutions for businesses. 3) Web developers who build Web-based applications requiring significant infrastructure support such as transactions, security, and pooling of resources. 4) Line-of-business (LOB) application developers.
Objectives:
In this course, you will implement role-based security in enterprise applications and manage state using Microsoft .NET Enterprise Services.
Duration: 4 Hours, 33 Minutes
Implementing Web Services
Description:
You are ready to develop Web services applications using Microsoft ASP .NET. You are familiar with .NET programming using either Visual Basic .NET or C#. You need to acquire the knowledge and skills needed to build Web services applications.
This course is designed for experienced software developers who have previously built component-based applications.
Objectives:
In this course, you will acquire the knowledge and skills needed to develop Web services applications using Microsoft ASP.NET.
Duration: 4 Hours, 10 Minutes
Implementing CRMs, Handling COM+ Events and Configuring Queued Components
Description:
In this course, you will implement Compensating Resource Managers; configure Loosely Coupled Events; implement publishers, subscribers, and event classes; and implement queued components.
Objectives:
In this course, you will implement Compensating Resource Managers; configure Loosely Coupled Events; implement publishers, subscribers, and event classes; and implement queued components.
Duration: 5 Hours, 38 Minutes
Improving Web Service Performance
Description:
You are ready to develop Web Services applications using Microsoft ASP.NET. You are familiar with .NET programming using either Visual Basic .NET or C#. You need to acquire the knowledge and skills needed to build Web Services applications.
This course is designed for experienced software developers who have previously built component-based applications.
Objectives:
In this course, you will acquire the knowledge and skills needed to develop Web Services applications using Microsoft ASP.NET.
Duration: 4 Hours, 49 Minutes
Finalizing COM+ Applications
Description:
In this course, you will debug COM+ applications, deploy and administer COM+ applications, and implement COM+ 1.5 enhancements.
Objectives:
In this course, you will debug COM+ applications, deploy and administer COM+ applications, and implement COM+ 1.5 enhancements.
Duration: 4 Hours, 44 Minutes
Developing Applications with Visual C# .NET
Description:
In this course, you will learn the skills required to build Windows Forms applications by using the .NET Framework. You will create and deploy fully functional, accessible, and secure Windows Forms.
This course is intended for the intermediate programmer who is responsible for designing and building Windows Forms applications by using the .NET Framework. It is designed for developers who have C# development skills. Typically, these individuals perform the following key activities: help create functional specifications, design and develop user interfaces, create and test prototypes, and write Windows Forms applications.
Objectives:
In this course, you will gain the skills required to build Windows Forms applications by using the .NET Framework.
Duration: 5 Hours, 44 Minutes
Developing Applications with Visual Basic .NET
Description:
In this course, you will learn the skills required to build Windows Forms applications by using the .NET Framework. You will create and deploy fully functional, accessible, and secure Windows Forms.
This course is intended for the intermediate programmer who is responsible for designing and building Windows Forms applications by using the .NET Framework. It is designed for developers who have Microsoft Visual Basic .NET development skills. Typically, these individuals perform the following key activities: help create functional specifications; design and develop user interfaces; create and test prototypes; and write Windows Forms applications.
Objectives:
In this course, you will gain the skills required to build Windows Forms applications by using the .NET Framework.
Duration: 5 Hours, 43 Minutes
Preparing and Deploying Applications with Visual Basic .NET
Description:
In this course, you will learn the skills required to enhance the usability of applications. You will explore how to deploy your Windows Forms Applications. Lastly, you will secure your Windows Forms Applications.
This course is intended for the intermediate programmer who is responsible for designing and building Windows Forms applications by using the .NET Framework. It is designed for developers who have Microsoft Visual Basic .NET development skills. Typically, these individuals perform the following key activities: Help create functional specifications; design and develop user interfaces; create and test prototypes; and write Windows Forms applications.
Objectives:
In this course, you will gain the skills required to prepare and deploy applications with Visual Basic.NET.
Duration: 3 Hours, 6 Minutes
Preparing and Deploying Applications with Visual C# .NET
Description:
In this course, you will learn the skills required to enhance the usability of applications. You will explore how to deploy your Windows Forms Applications. Lastly, you will secure your Windows Forms Applications.
This course is intended for the intermediate programmer who is responsible for designing and building Windows Forms applications by using the .NET Framework. It is designed for developers who have C# development skills. Typically, these individuals perform the following key activities: help create functional specifications; design and develop user interfaces; create and test prototypes; and write Windows Forms applications.
Objectives:
In this course, you will gain the skills required to prepare and deploy applications with Visual C# .NET.
Duration: 3 Hours, 14 Minutes
Creating and Debugging ASP.NET Web Applications
Description:
The course provides the information that developers need to know to successfully upgrade their Web development skills from being able to create Active Server Pages (ASP) to Microsoft ASP.NET. The material that comprises this course explains the differences in ASP versus ASP.NET, thereby creating an understanding of the efforts that are involved in getting an existing ASP Web application functioning in an ASP.NET environment.
This course is intended for existing Web developers who are currently writing ASP Web applications.
Objectives:
In this course, you will acquire the skills to create and debug Microsoft ASP.NET applications.
Duration: 4 Hours, 26 Minutes
Enhancing ASP.NET Web Application Functionality
Description:
This course reveals some of the new features of ASP.NET that can be used to improve an existing ASP Web application. It also covers accessing data using ADO.NET and implementing Web services.
This course is intended for existing Web developers who are currently writing ASP Web applications.
Objectives:
In this course, you will acquire the skills to enhance ASP.NET Web application functionality by accessing data using ADO.NET, managing state, authenticating users, and implementing Web services.
Duration: 6 Hours, 28 Minutes
ASP Application Migration and ASP.NET Web Application Deployment
Description:
This course provides students with several strategies for migrating ASP Web applications to ASP.NET, as well as a corresponding list of tasks that must be completed for successful migration. It also covers accessing COM objects and deploying ASP.NET Web applications.
This course is intended for existing Web developers who are currently writing ASP Web applications.
Objectives:
In this course, you will acquire the skills to migrate ASP Web applications to ASP.NET and to deploy ASP.NET Web applications.
Duration: 3 Hours, 6 Minutes
Working with XML
Description:
This course is intended for programmers who build web-based or Windows-based applications to access data or web services.
You may want to query, navigate, transform, or serialize XML documents to build web-based or Windows-based integrated applications that are scalable and flexible. In this course, you will query, transform, serialize, and manipulate cached XML.
Objectives:
In this course, you will explain the process of querying an XML document by using XPath, locate and manipulate XML by using the DOM, apply an XSLT transformation to an XML document by using the .NET XML classes, and serialize and deserialize objects by using the XmlSerializer class.
Duration: 4 Hours, 32 Minutes
Updating Your Data Integration Skills to Microsoft SQL Server? 2005 Integration Services (2943B)
Description:
This course will enable business intelligence developers experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. The course is broken into four modules:
- Exploring SQL Server? 2005 Integration Services Architecture and Core Concepts;
- Designing and Debugging SQL Server? 2005 Integration Services Packages
- Rich Functionality in SQL Server? 2005 Integration Services
- Extensibility
ATTENTION: Depending on your subscription, the Virtual Labs (vLabs) for this course may not be available. If the Virtual Labs do not launch when you click the launch button, contact your company Training Administrator for more information about your subscription.
Objectives:
At the end of the course, students will be able to:
Design and debug SSIS Packages
Configure and deploy SSIS Packages
Duration: 6 Hours
Getting Started with Databases and Transact-SQL in Microsoft SQL Server? 2005 (4326)
Description:
In this course, you analyze how client/server architecture works, and examine the various database and business tasks that you can perform by using the components of Microsoft SQL Server 2005. You also query SQL Server 2005 databases by using T-SQL querying tools.
In addition, this course explains the basics of the T-SQL language, its syntax, and how to manage T-SQL scripts.
This course also helps prepare you for certification exam 70-431.
ATTENTION: Depending on your subscription, the Virtual Labs (vLabs) for this course may not be available. If the Virtual Labs do not launch when you click the launch button, contact your company Training Administrator for more information about your subscription.
Objectives:
Describe the architecture and components of SQL Server 2005.
Describe the structure of a SQL Server database.
Explain the basics of the SQL language.
Describe the syntax elements of T-SQL.
Explain how to manage T-SQL scripts.
Use T-SQL querying tools to query SQL Server 2005 databases.
Duration: 2 Hours
Performing Basic Queries in Microsoft SQL Server? 2005 (4327)
Description:
In this course, you perform basic queries in Microsoft SQL Server 2005. You use Transact-SQL (T-SQL) statements such as SELECT to write queries, filter data, and format result sets.
In addition, this course covers the performance considerations that affect data retrieval and the use of the Query Optimizer.
This course also helps prepare you for certification exam 70-431.
ATTENTION: Depending on your subscription, the Virtual Labs (vLabs) for this course may not be available. If the Virtual Labs do not launch when you click the launch button, contact your company Training Administrator for more information about your subscription.
Objectives:
Retrieve data by using the SELECT statement.
Filter data by using different search conditions.
Explain how to work with NULL values.
Format result sets.
Describe the performance considerations that affect data retrieval.
Duration: 2 Hours
Grouping and Summarizing Data in Microsoft SQL Server? 2005 (4328)
Description:
In this course, you group and summarize data when generating reports in Microsoft SQL Server 2005. You rank group data and create cross-tabulation queries. You also use aggregate functions including functions native to SQL Server, functions that use NULL values, and custom aggregate functions using the .NET Framework.
In addition, this course covers the GROUP BY, HAVING, COMPUTE, PIVOT, UNPIVOT, ROLLUP, and CUBE clauses and functions such as SUM, AVG, COUNT, MAX, MIN, GROUPING, RANK, DENSE_RANK, NTILE, and ROW_NUMBER.
This course also helps prepare you for certification exam 70-431.
ATTENTION: Depending on your subscription, the Virtual Labs (vLabs) for this course may not be available. If the Virtual Labs do not launch when you click the launch button, contact your company Training Administrator for more information about your subscription.
Objectives:
Summarize data by using aggregate functions.
Summarize grouped data by using the GROUP BY and COMPUTE clauses.
Rank grouped data.
Create cross-tabulation queries by using the PIVOT and UNPIVOT clauses.
Duration: 2 Hours
Joining Data from Multiple Tables in Microsoft SQL Server? 2005 (4329)
Description:
In this course, you retrieve data from multiple tables by using Transact-SQL (T-SQL) in Microsoft SQL Server 2005. You apply the inner join, outer join, cross join, and self join to retrieve the desired result set. You also use the APPLY operator to join using a user-defined function.
In addition, you examine the various techniques provided by SQL Server 2005 to combine and limit result sets such as UNION, EXCEPT, INTERCEPT, TOP, and TABLESAMPLE.
This course also helps prepare you for certification exam 70-431.
ATTENTION: Depending on your subscription, the Virtual Labs (vLabs) for this course may not be available. If the Virtual Labs do not launch when you click the launch button, contact your company Training Administrator for more information about your subscription.
Objectives:
Query multiple tables by using joins.
Apply joins for typical reporting needs.
Combine and limit result sets.
Duration: 2 Hours
Working with Subqueries in Microsoft SQL Server? 2005 (4330)
Description:
In this course, you write subqueries and correlated subqueries by using Transact-SQL (T-SQL) in Microsoft SQL Server 2005. You determine the best option among subqueries, joins, and temporary tables to get your desired result. You refine subqueries by using the ANY, ALL, and SOME operators.
In addition, this course explains common table expressions (CTEs) to write recursive queries.
This course also helps prepare you for certification exam 70-431.
ATTENTION: Depending on your subscription, the Virtual Labs (vLabs) for this course may not be available. If the Virtual Labs do not launch when you click the launch button, contact your company Training Administrator for more information about your subscription.
Objectives:
Write basic subqueries.
Write correlated subqueries.
Compare subqueries with joins and temporary tables.
Use common table expressions in queries.
Duration: 2 Hours
Modifying Data in Microsoft SQL Server? 2005 (4331)
Description:
In this course, you modify data in tables using Transact-SQL (T-SQL) in Microsoft SQL Server 2005. You insert, delete, and update single or multiple rows of data in the tables. You use statements such as INSERT, DELETE, UPDATE, INSERT?SELECT, SELECT INTO, and TRUNCATE TABLE statements.
In addition, you examine implicit and explicit transactions, the importance of transaction isolation levels, and how to manage transactions.
This course also helps prepare you for certification exam 70-431.
ATTENTION: Depending on your subscription, the Virtual Labs (vLabs) for this course may not be available. If the Virtual Labs do not launch when you click the launch button, contact your company Training Administrator for more information about your subscription.
Objectives:
Explain how SQL Server implements transactions.
Insert data into tables.
Delete data from tables.
Update data in tables.
Duration: 2 Hours
Querying Metadata, XML, and Full-Text Indexes in Microsoft SQL Server? 2005 (4332)
Description:
In this course, you query metadata, XML data, and full-text indexes by using Transact-SQL (T-SQL) in Microsoft SQL Server 2005. You query metadata by using SQL Server views and commands. You query XML data by using OpenXML and XQuery. You also query relational data combined with XML data.
In addition, you analyze the purpose and process of querying full-text indexes.
This course also helps prepare you for certification exam 70-431.
ATTENTION: Depending on your subscription, the Virtual Labs (vLabs) for this course may not be available. If the Virtual Labs do not launch when you click the launch button, contact your company Training Administrator for more information about your subscription.
Objectives:
Query metadata.
Describe the functionality of XML.
Query XML data.
Describe the functionality of full-text indexes.
Query full-text indexes.
Duration: 2 Hours
Using Programming Objects for Data Retrieval in Microsoft SQL Server? 2005 (4333)
Description:
In this course, you retrieve data by using the various programming objects provided by Microsoft SQL Server 2005. You encapsulate expressions with user-defined functions and SQL Server views. You also utilize stored procedures, and triggers to encapsulate T-SQL logic.
In addition, you perform distributed queries and learn how SQL Server works with heterogeneous data such as databases, spreadsheets, and other servers.
This course also helps prepare you for certification exam 70-431.
ATTENTION: Depending on your subscription, the Virtual Labs (vLabs) for this course may not be available. If the Virtual Labs do not launch when you click the launch button, contact your company Training Administrator for more information about your subscription.
Objectives:
Encapsulate expressions by using user-defined functions.
Encapsulate queries by using views.
Explain how stored procedures encapsulate T-SQL logic.
Write distributed queries.
Duration: 2 Hours
Using Advanced Querying Techniques in Microsoft SQL Server? 2005 (4334)
Description:
In this course, you apply advanced querying techniques in Microsoft SQL Server 2005. You follow best practices to query complex data involving data/time and multinational data. You query complex table structures such as data stored in hierarchies and self-referencing tables. You also analyze query execution and optimize query performance.
In addition, you use Microsoft Visual SourceSafe for managing query source files.
This course also helps prepare you for certification exam 70-431.
ATTENTION: Depending on your subscription, the Virtual Labs (vLabs) for this course may not be available. If the Virtual Labs do not launch when you click the launch button, contact your company Training Administrator for more information about your subscription.
Objectives:
Explain the recommendations for querying complex data.
Query complex table structures.
Write efficient queries.
Use various techniques when working with complex queries.
Maintain query files.
Duration: 2 Hours
Microsoft Office Access? 2007: New Features
Description:
This course provides an overview of the redesigned user interface and interactive features of Microsoft Office Access 2007. This course is designed for experienced Access users who have worked with earlier versions of Microsoft Access, ideally Microsoft Access 2003, and who have or are planning to upgrade to Microsoft Access 2007.
Objectives:
In this course, you will explore and use the new and enhanced features of Microsoft Office Access 2007.
Duration: 3 Hours, 15 Minutes
Microsoft Office Excel 2007: New Features
Description:
This course provides an overview of the redesigned user interface and interactive features of Microsoft Office Excel 2007. This course is designed for experienced Excel users who have worked with earlier versions of Microsoft Excel, ideally Microsoft Excel 2003, and who have upgraded or are planning to upgrade to Microsoft Excel 2007.
Objectives:
In this course, you will explore the new and enhanced features of Microsoft Office Excel 2007 and use them to effectively organize, analyze, and present data.
Duration: 4 Hours
Programming Microsoft SQL Server? 2005 (2939B)
Description:
This course will enable database developers experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. The course is broken into three modules:
- Working with SQL Server 2005
- Exploring Transact-SQL Enhancements in SQL Server 2005
- Exploring the Use of XML in SQL Server 2005
Objectives:
Use the new features and enhancements in SQL Server 2005 and describe the new development tools.
Use Transact-SQL enhancements to perform database development tasks.
Develop XML-based Solutions using SQL Server 2005.
Duration: 6 Hours
Microsoft Office Excel 2007: Level 1 (Second Edition)
Description:
You want to migrate your spreadsheet data to an electronic format. In this course, you will use Microsoft Office Excel 2007 to manage, edit, and print data.
This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft Office, Windows 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets.
Objectives:
In this course, you will create and edit basic Microsoft Office Excel 2007 worksheets and workbooks.
Duration: 6 Hours, 30 Minutes
Microsoft Office Outlook 2007: Level 1 (Second Edition)
Description:
This course is intended for the beginner student that has no previous experience using Outlook. In this course, you will, compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes.
This course is designed for any person with a basic understanding of Microsoft Windows who needs to use Microsoft Office Outlook 2007 to compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes. In addition, this course helps prepare students who desire to take the Microsoft Certified Applications Specialist certification for Outlook.
Objectives:
In this course, you will compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes.
Duration: 8 Hours, 30 Minutes
Creating the Data Access Tier Using Microsoft SQL Server? 2005 (2941B)
Description:
This course will enable database developers experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. The course is broken into three modules:
- Using the .NET CLR in SQL Server 2005
- Developing Client Applications
- Using SQL Management Objects
Objectives:
Use .NET CLR integration in SQL Server 2005.
Develop client applications using ADO.NET and Data Binding.
Develop administrative applications using SQL Management Objects.
Duration: 6 Hours
Microsoft Office Access? 2007: Level 1 (Second Edition)
Description:
One of the most efficient and powerful way of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, create and modify databases and its various objects using the Microsoft Office Access 2007 relational database application.
This course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access 2007 can also take this course.
Objectives:
In this course, you will create and modify new databases and their various objects.
Duration: 7 Hours, 30 Minutes
Microsoft Office Excel 2007: Level 2 (Second Edition)
Description:
In this intermediate-level course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas, which will allow the data to be analyzed in a variety of formats.
The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.
Objectives:
In this course, you will apply visual elements and advanced formulas to a worksheet to display data in various formats.
Duration: 6 Hours
Microsoft Office Outlook 2007: Level 2 (Second Edition)
Description:
This course is the second in a series of three Microsoft Office Outlook 2007 courses and is intended for intermediate users. In this course, you will customize your Outlook environment, Calendar, mails, folders and also track, share, assign, and quickly locate various Outlook items.
This course is designed for experienced Outlook users who need to customize their environment, Calendar, and email messages to meet their specific requirements and who wish to track, share, assign, and locate various Outlook items.
Objectives:
In this course, you will customize your environment, Calendar, and mail messages to meet your specific needs as well as track, share, assign, and quickly locate various Outlook items.
Duration: 8 Hours, 15 Minutes
Microsoft Office Access? 2007: Level 2 (Second Edition)
Description:
So far you have been focusing only on essential database user skills such as creating and working with Access tables, relationships, queries, forms, and reports. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications. Microsoft Office Access 2007: Level 2 is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Level 2 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. This course is also a prerequisite to taking more advanced courses in Access 2007. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access 2007 can also take this course.
Objectives:
In this course, you will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft Office Access? 2007 with other applications.
Duration: 6 Hours, 15 Minutes
Installing and Securing Microsoft SQL Server? 2005 (2936B)
Description:
This course will enable database administrators experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. The course is broken into three modules:
- Understanding the SQL Server 2005 Architecture
- Installing SQL Server 2005
- Securing SQL Server 2005
Objectives:
Describe the architecture of SQL Server 2005.
Install SQL Server 2005.
Secure a SQL Server 2005 database.
Duration: 6 Hours
Administering and Monitoring Microsoft SQL Server? 2005 (2937B)
Description:
This course will enable database administrators experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. The course is broken into three modules:
- Exploring SQL Server 2005 Administrative Tools
- Monitoring SQL Server 2005
- Maintaining Databases and Indexes
Objectives:
Use SQL Server 2005 administration tools.
Monitor SQL Server 2005.
Maintain databases and indexes in SQL Server 2005.
Duration: 6 Hours
Data Availability Features in Microsoft SQL Server? 2005 (2938B)
Description:
This course will enable database administrators experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. The course is broken into three modules:
- Understanding Disaster Recovery
- Understanding Data Availability in SQL Server 2005
- Understanding SQL Server 2005 Replication Features
Objectives:
Perform backup and restore operations.
Configure database mirroring.
Configure replication using SQL Server 2005.
Duration: 6 Hours
Building Service and Notifications Using Microsoft SQL Server? 2005 (2940B)
Description:
This course will enable database developers experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. The course is broken into three modules:
- Using Service Broker
- Using Native HTTP Support
- Using Notification Services
Objectives:
Describe the Service Broker architecture.
Use Service Broker for message-based communication.
Describe the native HTTP support features in SQL Server 2005.
Implement a Web service using native HTTP endpoints.
Describe the architecture of a Notification Services solution.
Design and implement a simple Notification Services solution.
Duration: 6 Hours
New Features of Microsoft SQL Server? 2005 Analysis Services (2942B)
Description:
In this course you administer and program SQL Server 2005 Analysis Services. In addition, you design and deploy a Unified Dimensional Model as well as work with data mining solutions.
This course is intended for architects, database developers, database administrators, and business intelligence developers, who are experienced in Microsoft SQL Server.
This course also helps prepare you for certification exam 70-445.
Objectives:
Understand the core concepts of SQL Server Analysis Services (SSAS) and the new features in the SSAS architecture.
Design and deploy a Unified Dimensional Model.
Upgrade to and configure SSAS 2005.
Understand the new MDX and programming features in SSAS 2005.
Understand data mining concepts and the tools used to develop data mining models.
Duration: 6 Hours
Updating Your Reporting Skills to Microsoft SQL Server? 2005 Reporting Services (2944B)
Description:
In this course, you develop and deploy scalable and secure reporting solutions for an enterprise environment by using Microsoft SQL Server Reporting Services (SSRS). You author, publish, and manage reports by using SSRS. This course is intended for database developers, database administrators, and business intelligence developers who are experienced in Microsoft SQL Server. This course also helps prepare you for certification exam 70-445.
Objectives:
Understand the features and core concepts of SSRS.
Design a report by using Report Designer.
Deploy and manage reports in SSRS.
Create and work with ad hoc reports.
Duration: 6 Hours
Microsoft Office Excel 2007: Level 3 (Second Edition)
Description:
You have used Microsoft Office Excel 2007 to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.
This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft Office Excel 2007, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
Objectives:
In this course, you will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.
Duration: 8 Hours, 15 Minutes
Microsoft Office Access? 2007: Level 3 (Second Edition)
Description:
You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing the forms and reports and maintaining a database.
This course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft Office Specialist Certification for Microsoft Office Access? 2007, and it is a prerequisite to take more advanced courses in Microsoft Office Access? 2007.
Objectives:
In this course, you will create complex Access databases by structuring existing data, writing advanced queries, working with macros, making effective use of forms and reports, and performing database maintenance.
Duration: 5 Hours, 30 Minutes
Microsoft Office Access? 2007: Level 4 (Second Edition)
Description:
Effective database management calls for mastering the advanced administrative and collaborative features of Access. In this course, you will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.
This course is designed for students who have a thorough understanding of the basic and advanced user features of the Access 2007 application, and are interested in learning introductory level administrator skill sets. The course is also for the student who may be working in a web-based environment and may need to adapt Access applications to the environment.
Objectives:
In this course, you will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.
Duration: 5 Hours, 15 Minutes
|
|
Applicable Vendor Technologies:
Microsoft
|
|
Associated Disciplines:
Software
|
|
RECOMMEND THIS COURSE
You must be logged in as a Candidate to recommend courses
|
|
|
|
|
|
|
