Database

Networking MCITP Windows 2008 Certification MS Exchange Server 2007 MCSE Certification Exchange Server(MCSE+I) A+ Certification N+ Certification CCNA Certification CCNP Certification Cisco Firewall Specialist(PIX and ASA) Redhat Administration and Networking Sun Solaris Administration and Networking Oracle Oracle OCP 11G Certification Oracle OCP 10G Certification Oracle Financials Oracle Real Application Cluster (RAC) Oracle Apps DBA Oracle Forms and Report Database Oracle OCP 11G Certification Oracle OCP 10G Certification MCTS SQL 2008 Certification MCITP: SQL 2008 MCTS SQL 2005 Certification MCITP: SQL 2005 PHP with MySQL ASP.Net with MS SQL Web Design / Graphic Web Design and Web DB with ASP.Net Web(Dreamweaver,CSS) & Graphic Design(Flash+Photoshop) Graphic Design(Flash+Photoshop) Photoshop Flash Web Animations PHP with MySQL ASP.Net with MS SQL Java JSP with Apache Tomcat MCTS Web Certification(C# ASP.Net) Programming Java SCJP Certification MCTS Web Certification(C# ASP.Net) MCPD Web Certification(C# ASP.Net) MCTS Windows Certification(C# ASP.Net) MCPD Windows Certification(C# ASP.Net) Web Design and Web DB with ASP.Net PHP with MySQL ASP.Net with MS SQL Java JSP with Apache Tomcat MCTS Web Certification(C# ASP.Net) Hardware A+ Certification N+ Certification Application MS Office 2007 (MCAS) Certification AutoCAD 2D and 3D Sage Line (Accounting) Management PRINCE2™ Foundation & Practitioner PRINCE2™ Foundation PRINCE2™ Practitioner

Student Feedback

View All Feedbacks

The course is going fine, I am enjoying it at the moment.

Prithviraj

Is being one of the best courses I have done so far. Deepal is great and I find even better that only two students are there. cheers

guilherme bassanelli

deepal is splendid, a comfortable tutor with lots of habits on field.class is cool even though theres only 2 of us in class at the moment.try to get more students for the class next time to enhance change of ideas i would say in overall its ok for me thanks George

George

This course is going really great am learning loads and most importantly the pace of the learning is just right...in comparison to the .NET class I am taking where I find this so rush and to be honest not really grasped a thing in the .NET course. only criticism I have is we're in there for 6/7 hours and the chairs are in real bad condition, also the white board is so dirty that at times its hard to see what is be projected on the screen. Overall the lecturer is teaching really well and I am really enjoying the course. I would recommend this course. Hiten Shah

Hiten Shah

View All Feedbacks

Training Certification Courses

Microsoft SQL Server 2005
Microsoft Certified Technology Specialists (MCTS)

(Certification towards MCITP)

Microsoft products are among the most popular and widely used in the world today. And Microsoft SQL server database along with .NET framework create vast opportunities for software professionals all over the world and London is no exception.

The Microsoft SQL server course not only teaches to the concepts of RDBMS (Relational Database Management System) but also focuses on developing proficiency with Microsoft SQL Server database and to teach “on-the-job” skills for setting up and maintaining a database.

Highlights of the course includes installing, configuring, and maintaining of MS SQL Server, manipulate relational data, database objects, stored procedures, etc.

On an average, people who are certified on MCTS SQL Server, earn a lot more than their colleagues in the industry. Enroll yourself today in this interactive, hands-on class, taught by a certified professional. The class runs for 5 weeks. Included with the course fee are the books and material for the class and unlimited practice time.

Why wait? Learn it right, the first time!

Microsoft SQL Server 2005(MCTS Certification)	£790
MS SQL 2005(MCTS) + MS SQL 2005(MCITP)	£1500
Oracle OCP + MS SQL 2005(MCTS)	£1850

MCTS SQL 2005 Certification Exam and Course Highlight

Exam 70–431:
Microsoft SQL Server 2005

Microsoft SQL Server 2005 - Implementation and Maintenance

End 2 End Process

		Enrolment Phone or In Person Course Fee £790

		Books and Course Material Included

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

		Free MS SQL 2005 Mock Exam

		Actual SQL Exam towards MCTS Exam done @ BCOC Fee not included

		Certified MCTS

Nearest starting Dates for MS SQL 2005

Start Date	Session	Time	Duration	Observations	Enrollment
Sep 27 2010	Mon, Wed	15:00-18:00	12 Classes	Twice a week class and unlimited practice hours	enrol me
1

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.

SQL Server 2005 Course Overview
Whether it is web commerce, accounting, finance, record keeping, data entry, and marketing or applications developer occupation, one of the basic tools used in many organisations in London and globally is RDBMS (SQL). SQL Server courses can prepare you for a career in database management on highly diverse level of industries in London and worldwide. Our courses for Microsoft SQL certification can also be useful for job encroachment in London because you can use the skills you gain immediately to increase your efficiency. Our SQL courses will give you clear understanding of the structure and function of a relational database system, use Microsoft SQL Server to create a relational database and use good design principles to optimise data storage and retrieval. Our courses in Microsoft SQL Server are gaining popularity, which, together with Microsoft .NET framework courses, promises to endow you to produce results via sophisticated database capabilities and information management. The SQL server course focuses primarily on developing proficiency with Microsoft SQL Server and on gaining solid skills for setting up and maintaining a database in a Microsoft Windows platform.

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

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.