Programming

Student Feedback

I am doing the ASP.Net MCAD course. I have found the course very useful so far. The speed at which we are going through the topics is good and the tutor is very good as well. He constantly highlights the bits we have to remember or concentrate on for the exam. I am going to book the exam for sometime in January. From the course I will have enough to start building websites in ASP.Net.

TOBI TIKARE

I would first of all like to mention that the course set contents are well set and I have found the teacher to be very cooperative providing individual attention to detail to every student in the class helping them on their problem domains. Overall it is a good course for all other students of class except for me as the reason for my taking up this course was aiming and targeting some advanced level training for professional programmers. As a result of my experience and careful understanding of your college I would like to make a suggestion that I am hoping you would take up is to have three different courses with different prerequisites determining/assessing an entrant to be placed at which level of course. These could be three levels of course start; 1. ASP.Net for Beginners 2. ASP.Net Advance Level Programming 3. MCAD Certification Course I do understand that this is MCAD Certification targeted course but through my understanding and observations if a student is coming for a certification targeted course then the course must be related directly to achieving the certification entailing how to pass the exams to qualify to be a MCAD. Course can have various modules guiding students as to: What are the various popular/common tricky questions arising often in exams? Where can one get and what are good books & other learning material for MCAD? What are common reasons for the failure of students in this specific certification? (Analysis through previous student exam reviews, etc) Finally I would like to state that my overview of this classroom based course is that it is a course designed for ASP.Net Beginners rather than Any Advanced or Professional level programmers. Regards

Waqar Kayani

The classes are fantastic! I am sure I'm not the only one who feels that you learn so much more from the classes than all the time spent going through NetG. I would suggest encouraging more student "study" groups as it sometimes feels like your on an island out there. Thanks

Aisha Anold

The course was very good organised. I think Waqas delivered all objectives of the course. Exceed my expectation.

Alidod

View All Feedbacks

Vocational Training Certification Courses

Microsoft Certified Application Developer (MCAD)
(MCAD Certification)

Option 1

MCAD Certification Exam and Course Highlight

MCAD Exam 70-305	Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
MCAD Exam 70-310	Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
MCAD Exam: 70–431	Microsoft SQL Server 2005 - Implementation and Maintenance

OR
Option 2

MCAD Certification Exam and Course Highlight

MCAD Exam 70-316	Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
MCAD Exam 70-310	Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
MCAD Exam 70-229	Designing and Implementing Databases with Microsoft SQL Server™ 2000 Enterprise Edition

OR
Option 3

MCAD Certification Exam and Course Highlight

MCAD Exam 70-305	Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
MCAD Exam 70-306	Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
MCAD Exam 70-310	Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework

End 2 End Process

		Enrolment Phone or In Person Course Fee £2200

		Books and Course Material Included

		Hands-on instructor led Training for 11 weeks, Unlimited Pratice Hours

		Free MCAD Mock Exam

		Actual MCAD Exam done @ BCOC Fee not included

		MCAD Certified

Nearest MCAD Certification Starting Dates

Microsoft Certified Application Developer (MCAD)

MCAD 2003 Certification Overview

Our training recipe for the MCAD Certification courses including hands-on training, detailed explanation of concepts, and practice exam server for Microsoft Certification gives you a fast, solid and effective training solution for obtaining MCAD Certification.

MCAD Certification Course Contents

MCAD Exam: 70-305

Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET

MCAD Exam 70-305 Certification Exam and Course Highlight

• Creating User Services

• Create ASP.NET pages

• Web server controls

• HTML server controls, user controls

• HTML code to ASP.NET pages

• Implement navigation for the user interface

• Validate user input

• Implement error handling in the user interface

• Implement online user assistance

• Incorporate existing code into ASP.NET pages

• Display and update data

• Instantiate and invoke Web services or components

• Implement globalization

• Handle events

• Create and modify a .NET assembly

• Consuming and Manipulating Data

• Debug, rework, and resolve defects in code

• Deploying a Web Application

• Deploy a Web application

• Configuring and Securing a Web Application

• Configure security for a Web application

• Install and configure server services

Creating User Services
Create ASP.NET pages.
• Add and set directives on ASP.NET pages.
• Separate user interface resources from business logic.

Add Web server controls, HTML server controls, user controls, and HTML code to ASP.NET pages.
• Set properties on controls.
• Load controls dynamically.
• Apply templates.
• Set styles on ASP.NET pages by using cascading style sheets.
• Instantiate and invoke an ActiveX® control.

Implement navigation for the user interface.
• Manage the view state.
• Manage data during postback events.
• Use session state to manage data across pages.

Validate user input.
• Validate non-Latin user input.

Implement error handling in the user interface.
• Configure custom error pages.
• Implement Global.asax, application, page-level, and page event error handling.

Implement online user assistance.
Incorporate existing code into ASP.NET pages.

Display and update data.
• Transform and filter data.
• Bind data to the user interface.
• Use controls to display data.

Instantiate and invoke Web services or components.
• Instantiate and invoke a Web service.
• Instantiate and invoke a COM or COM+ component.
• Instantiate and invoke a .NET component.
• Call native functions by using platform invoke.

Implement globalization.
• Implement localizability for the user interface.
• Convert existing encodings.
• Implement right-to-left and left-to-right mirroring.
• Prepare culture-specific formatting.

Handle events.
• Create event handlers.
• Raise events.

Implement accessibility features.
Use and edit intrinsic objects. Intrinsic objects include response, request, session, server, and application.
• Retrieve values from the properties of intrinsic objects.
• Set values on the properties of intrinsic objects.
• Use intrinsic objects to perform operations.

Creating and Managing Components and .NET Assemblies

Create and modify a .NET assembly.
• Create and implement satellite assemblies.
• Create resource-only assemblies.
• Create Web custom controls and Web user controls.

Consuming and Manipulating Data
Access and manipulate data from a Microsoft SQL Server™ database by creating and using ad hoc queries and stored procedures.

Access and manipulate data from a data store. Data stores include relational databases, XML documents, and flat files. Methods include XML techniques and ADO.NET.
Handle data errors.

Testing and Debugging

Create a unit test plan.
Implement tracing.
• Add trace listeners and trace switches to an application.
• Display trace output.

Debug, rework, and resolve defects in code.
• Configure the debugging environment.
• Create and apply debugging code to components, pages, and applications.
• Provide multicultural test data to components, pages, and applications.
• Execute tests.
• Resolve errors and rework code.

Deploying a Web Application
Plan the deployment of a Web application.
• Plan a deployment that uses removable media.
• Plan a Web-based deployment.
• Plan the deployment of an application to a Web garden, a Web farm, or a cluster.

Create a setup program that installs a Web application and allows for the application to be uninstalled.
Deploy a Web application.
Add assemblies to the global assembly cache.

Maintaining and Supporting a Web Application
Optimize the performance of a Web application.
Diagnose and resolve errors and issues.

Configuring and Securing a Web Application
Configure a Web application.
• Modify the Web.config file.
• Modify the Machine.config file.
• Add and modify application settings.

Configure security for a Web application.
• Select and configure authentication type. Authentication types include Windows® Authentication, None, forms-based, Microsoft Passport, Internet Information Services (IIS) authentication, and custom authentication.
• Configure authorization. Authorization methods include file-based methods and URL-based methods.
• Configure role-based authorization.
• Implement impersonation.

Configure and implement caching. Caching types include output, fragment, and data.
• Use a cache object.
• Use cache directives.

Configure and implement session state in various topologies such as a Web garden and a Web farm.
• Use session state within a process.
• Use session state with session state service.
• Use session state with Microsoft SQL Server.

Install and configure server services.
• Install and configure a Web server.
• Install and configure Microsoft FrontPage® Server Extensions.

MCAD Exam: 70-310

Developing XML Web Services and Server Components with Microsoft Visual Basic .Net and the Microsoft .NET Framework

MCAD Exam 70-310 Certification Exam and Course Highlight

• Create and consume a serviced component

• Create and consume a .NET Remoting object

• Create and consume an XML Web service

• Access and manipulate data from a Microsoft SQL Server

• Access and manipulate XML data

• .NET Remoting object, and an XML Web service

• Publish an XML Web service

• Implement error handling in the user interface

• deploy side-by-side deployments and applications

Creating and Managing Microsoft Windows® Services, Serviced Components, .NET Remoting Objects, and XML Web Services
Create and manipulate a Windows service.
• Write code that is executed when a Windows service is started or stopped.

Create and consume a serviced component.
• Implement a serviced component.
• Create interfaces that are visible to COM.
• Create a strongly named assembly.
• Register the component in the global assembly cache.
• Manage the component by using the Component Services tool.

Create and consume a .NET Remoting object.
• Implement server-activated components.
• Implement client-activated components.
• Select a channel protocol and a formatter. Channel protocols include TCP and HTTP. Formatters include SOAP and binary.
• Create client configuration files and server configuration files.
• Implement an asynchronous method.
• Create the listener service.
• Instantiate and invoke a .NET Remoting object.

Create and consume an XML Web service.
• Control characteristics of Web methods by using attributes.
• Create and use SOAP extensions.
• Create asynchronous Web methods.
• Control XML wire format for an XML Web service.
• Instantiate and invoke an XML Web service.

Consuming and Manipulating Data

Access and manipulate data from a Microsoft SQL Server™ database by creating and using ad hoc queries and stored procedures.

Create and manipulate DataSets.
• Manipulate a DataSet schema.
• Manipulate DataSet relationships.
• Create a strongly typed DataSet.

Access and manipulate XML data.
• Access an XML file by using the Document Object Model (DOM) and an XmlReader.
• Transform DataSet data into XML data.
• Use XPath to query XML data.
• Generate and use an XSD schema.
• Write a SQL statement that retrieves XML data from a SQL Server database.
• Update a SQL Server database by using XML.
• Validate an XML document.

Testing and Debugging

Create a unit test plan.
Implement tracing.
• Configure and use trace listeners and trace switches.
• Display trace output.

Instrument and debug a Windows service, a serviced component, a .NET Remoting object, and an XML Web service.
• Configure the debugging environment.
• Create and apply debugging code to components and applications.
• Provide multicultural test data to components and applications.
• Execute tests.

Use interactive debugging.
Log test results.
• Resolve errors and rework code.
• Control debugging in the Web.config file.
• Use SOAP extensions for debugging.

Deploying Windows Services, Serviced Components, .NET Remoting Objects, and XML Web Services

Plan the deployment of and deploy a Windows service, a serviced component, a .NET Remoting object, and an XML Web service.

Create a setup program that installs a Windows service, a serviced component, a .NET Remoting object, and an XML Web service.
• Register components and assemblies.

Publish an XML Web service.
• Enable static discovery.
• Publish XML Web service definitions in the UDDI.

Configure client computers and servers to use a Windows service, a serviced component, a .NET Remoting object, and an XML Web service.
Implement versioning.
Plan, configure, and deploy side-by-side deployments and applications.

Configure security for a Windows service, a serviced component, a .NET Remoting object, and an XML Web service.
• Configure authentication type. Authentication types include Windows authentication, Microsoft .NET Passport, custom authentication, and none.
• Configure and control authorization. Authorization methods include file-based authorization and URL-based authorization.
Configure and implement identity management.

MCAD Exam: 70–431
Microsoft SQL Server 2005 - Implementation and Maintenance

Microsoft SQL Server 2005 Course Highlight

Installing and Configuring SQL Server 2005
SQL Server 2005 Instance
SQL Server 2005 Security
Configure and Manage linked Servers
Implementing High Availability and Disaster Recovery
Implement log shipping.
Supporting Data Consumers
SQL Relational Data
XML Data
HTTP End Point
Implement Service Broker components.
Import and Export Data
SQL Server 2005 Database Replication
Maintaining Databases
Manage databases by using Transact-SQL.
Monitoring and Troubleshooting SQL Server Performance
Creating and Implementing Database Objects
Implement a table.
Implement a view.
Implement functions.
Implement stored procedures.
Implement indexes.
Create user-defined types.

Installing and Configuring SQL Server 2005

Install SQL Server 2005.
Verify prerequisites.
Upgrade from an earlier version of SQL Server.

SQL Server 2005 Instance

Create an instance.
Configure SQL Server 2005 instances and databases.
Configure log files and data files.
Configure the SQL Server Database Mail subsystem for an instance.
Choose a recovery model for the database.

SQL Server 2005 Security

Configure SQL Server security.
Configure server security principals.
Configure database securable.
Configure encryption.

Configure and Manage linked Servers

Configure linked servers by using SQL Server Management Studio (SSMS).
Identify the external data source.
Identify the characteristics of the data source.
Identify the security model of the data source.

Implementing High Availability and Disaster Recovery

Implement database mirroring.
Prepare databases for database mirroring.
Create endpoints.
Specify database partners.
Specify a witness server.
Configure an operating mode.

Implement log shipping.

Initialize a secondary database.
Configure log shipping options.
Configure a log shipping mode.
Configure monitoring.
Manage database snapshots.
Create a snapshot.
Revert a database from a snapshot.

Supporting Data Consumers

Retrieve data to support ad hoc and recurring queries.
Construct SQL queries to return data.
Format the results of SQL queries.
Identify collation details.

SQL Relational Data

Manipulate relational data.
Insert, update, and delete data.
Handle exceptions and errors.
Manage transactions.

XML Data

Manage XML data, Identify the specific structure needed by a consumer.
Retrieve XML data, Modify XML data.
Convert between XML data and relational data.
Create an XML index.
Load an XML schema.

HTTP End Point

Implement an HTTP endpoint.
Create an HTTP endpoint.
Secure an HTTP endpoint.

Implement Service Broker components.

Create services, Create queues, Create contracts.
Create conversations, Create message types, Send messages to a service.
Route a message to a service, Receive messages from a service.

Import and Export Data

Import and export data from a file.
Set a database to the bulk-logged recovery model to avoid inflating the transaction log.
Run the bcp utility, Perform a Bulk Insert task.
Import bulk XML data by using the OPENROWSET function.
Copy data from one table to another by using the SQL Server 2005 Integration Services (SSIS) Import and Export Wizard.

SQL Server 2005 Database Replication

Manage replication.
Distinguish between replication types.
Configure a publisher, a distributor, and a subscriber.
Configure replication security.
Configure conflict resolution settings for merge replication.
Monitor replication.
Improve replication performance.
Plan for, stop, and restart recovery procedures.

Maintaining Databases

Implement and maintain SQL Server Agent jobs.
Set a job owner.
Create a job schedule.
Create job steps.
Configure job steps.
Disable a job.
Create a maintenance job.
Set up alerts.
Configure operators.
Modify a job.
Delete a job.
Manage a job.

Manage databases by using Transact-SQL.

Manage index fragmentation.
Manage statistics.
Shrink files.
Perform database integrity checks by using DBCC CHECKDB.
Back up a database.
Perform a full backup.
Perform a differential backup.
Perform a transaction log backup.
Initialize a media set by using the FORMAT option.
Append or overwrite an existing media set.
Create a backup device.
Back up filegroups.
Restore a database.
Identify which files are needed from the backup strategy.
Restore a database from a single file and from multiple files.
Choose an appropriate restore method.
Move a database between servers.
Choose an appropriate method for moving a database.

Monitoring and Troubleshooting SQL Server Performance

Gather performance and optimization data by using the SQL Server Profiler.
Start a new trace.
Save the trace logs.
Configure SQL Server Profiler trace properties.
Configure a System Monitor counter log.
Correlate a SQL Server Profiler trace with System Monitor log data.
Gather performance and optimization data by using the Database Engine Tuning Advisor.
Build a workload file by using the SQL Server Profiler.
Tune a workload file by using the Database Engine Tuning Advisor.
Save recommended indexes.
Monitor and resolve blocks and deadlocks.
Identify the cause of a block by using the sys.dm_exec_requests system view.
Terminate an errant process.
Configure SQL Server Profiler trace properties.
Identify transaction blocks.
Diagnose and resolve database server errors.
Connect to a non-responsive server by using the dedicated administrator connection (DAC).
Review SQL Server startup logs.
Review error messages in event logs.
Monitor SQL Server Agent job history.
Identify the cause of a failure.
Identify outcome details.
Find out when a job last ran.
Gather performance and optimization data by using DMVs.

Creating and Implementing Database Objects

Implement a table.

Specify column details.
Specify the filegroup.
Assign permissions to a role for tables.
Specify a partition scheme when creating a table.
Specify a transaction.

Implement a view.

Create an indexed view.
Create an updateable view.
Assign permissions to a role or schema for a view.
Implement triggers.
Create a trigger.
Create DDL triggers for responding to database structure changes.
Identify recursive triggers.
Identify nested triggers.
Identify transaction triggers.

Implement functions.

Create a function.
Identify deterministic versus nondeterministic functions.

Implement stored procedures.

Create a stored procedure.
Recompile a stored procedure.
Assign permissions to a role for a stored procedure.
Implement constraints.
Specify the scope of a constraint.
Create a new constraint.

Implement indexes.

Specify the filegroup.
Specify the index type.
Specify relational index options.
Specify columns.
Specify a partition scheme when creating an index.
Disable an index.
Create an online index by using an ONLINE argument.

Create user-defined types.

Create a Transact-SQL user-defined type.
Specify details of the data type.
Create a CLR user-defined type.
Implement a full-text search.
Create a catalog.
Create an index.
Specify a full-text population method.
Implement partitions.