Birmingham - Bristol - Cambridge - Coventry - Edinburgh - Glasgow - Kingston - Leeds - London - Manchester - Slough

CSE training courses and schools
Cisco Sales Essentials

School: Learning Tree International
[All Courses]

Integrating Access with SQL Server
Course Format: Classroom
you will learn how to Develop database solutions using Access as a front-end to SQL Server Create tables, views and stored procedures in SQL Server Upsize Access data to exploit SQL Server capabilities Optimise Access forms and reports based on linked SQL Server data Transform Access queries into stored procedures and views Employ ADO programming practices to manage data using VBA ...
 

SQL Queries for SQL Server
Course Format: Classroom
you will learn how to Develop complex and robust SQL queries for SQL Server 7 and 2000 Query multiple tables with inner joins, outer joins and self-joins Transform data with built-in functions Summarise data using aggregation and grouping Build simple and correlated subqueries Determine the most efficient SQL solution for application requirements Solve real-world business problem...
 

SQL Server 2000 Reporting Services
Course Format: Classroom
you will learn how to Leverage SQL Server 2000 Reporting Services to produce sophisticated reports Author robust reports to extract business intelligence out of your data Extract relevant report data using parameters and filters Render interactive reports with the drill down and drill through features Deploy reports to a Report Server for centralised access and administration Secur...
 

SQL Server 2000 Data Transformation Services
Course Format: Classroom
you will learn how to Migrate and transform data using SQL Server 2000 Data Transformation Services (DTS) Extend the capabilities of a DTS package with ActiveX scripts Troubleshoot DTS package errors using the DTS package logs and exception files Customise packages and control the workflow of transformation tasks Optimise performance with SQL-based transformations Implement transac...
 

SQL Server Transact-SQL Programming
Course Format: Classroom
you will learn how to Develop database applications for SQL Server 7 and 2000 with Transact-SQL Query and modify data with Transact-SQL Create and debug stored procedures Take advantage of AFTER and INSTEAD OF triggers Manage concurrency using transactions and locking options Exchange data effectively using Transact-SQL’s support for XML Tune database queries for optimal per...
 

SQL Server 2000 Database Administration
Course Format: Classroom
you will learn how to Administer SQL Server 2000 effectively using Enterprise Manager and Transact-SQL Install multiple SQL Server instances Utilise SQL Server recovery models to back up and restore databases Manage multistep jobs with SQL Server Agent Create and manage databases, files and transaction logs Manage SQL Server login, database and object security Set up transactio...
 

SQL Server 2000 Introduction
Course Format: Classroom
you will learn how to Utilise the key components of SQL Server 2000 Implement a database schema with SQL Server Enterprise Manager Retrieve and modify data with SQL tools Administer databases with wizards Replicate data between databases Perform multidimensional data analysis using Analysis Services and Microsoft Excel Query SQL Server from the Web using XML Migrate data from d...
 

Exchange Troubleshooting & Disaster Recovery
Course Format: Classroom
you will learn how to Optimise the operation of Exchange 2003 within the Active Directory Modify Exchange configuration using ADSIEdit and the Metabase Explorer Configure front-end/back-end servers to interoperate with existing firewalls Restore mailbox data using the Recovery Storage Group in Exchange 2003 Execute an Exchange disaster recovery following a complete server failure R...
 

Microsoft Exchange Server 2003 Administration
Course Format: Classroom
you will learn how to Build an Exchange Server 2003 e-mail network hosted on a Windows Server 2003 domain Create mailbox and mail-enabled Users along with Contacts, Distribution Groups and Query Groups Manage Exchange servers through the System Manager Microsoft Management Console (MMC) Backup and restore Exchange databases Connect multiple clients to Exchange Server 2003 including O...
 

Exchange 2000 Administration
Course Format: Classroom
you will learn how to Build an Exchange 2000 e-mail network using Windows 2000 Server Manage the Exchange infrastructure with Microsoft Management Console (MMC) snap-ins Incorporate new features, including Routing Groups, policies and Storage Groups Integrate Exchange 2000 into a legacy Exchange 5.5 environment and execute a migration Monitor an Exchange 2000 network of servers using...
 

Page(s):- 1 2 3 4 5 6 7 8 [ Popular Topics ]