Learning Tree International
London,Edinburgh, United Kingdom
http://www.learningtree.com

Developing ADO.NET Applications for SQL Server

you will learn how to Build ADO.NET applications for SQL Server using Visual Basic .NET Maximise performance using ADO.NET’s connected model Read and process data from SQL Server and XML sources Retrieve and modify disconnected data Ensure data consistency with transactions and exception handling Exploit the powerful data-binding capabilities of ADO.NET ADO.NET Technology ......
 

you will learn how to Design and implement high-performance databases for SQL Server 7 and 2000 Create indexes that optimise different types of queries Design transactions that maximise concurrency and minimise contention Interpret the data access plans produced by the query optimiser Minimise I/O by designing efficient physical data structures Improve response time by introducing ......
 

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 ......
 

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......
 

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......
 

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......
 

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......
 

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......
 

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......
 

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......
 

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......
 

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......
 

you will learn how to Configure and manage IIS 6, the Windows Server 2003 Web server Administer the IIS 6 architecture for failure protection and health monitoring Configure mail, news, media broadcasts and Web content searches Construct mega sites and distributed Web services by leveraging the .NET platform Publish content with FTP and WebDAV Create Web gardens, farms and clusters......
 

you will learn how to Implement advanced tools and techniques to support Windows 2000 effectively Troubleshoot and optimise application and operating system (OS) performance Collect and evaluate baseline performance statistics Employ advanced troubleshooting strategies Maintain and troubleshoot the Registry Manage and restore hard disk integrity Locate sources of excessive networ......
 

you will learn how to Design and configure a secure Windows 2000 systems infrastructure Lock down your enterprise security with PKI Implement Kerberos for enhanced authentication security Maximise file system security with NTFS and EFS using encryption and recovery agents Plan, implement and manage a sophisticated security policy using the Active Directory Secure network data excha......
 

you will learn how to Install and administer clients and servers within Windows 2000 domains Manage computers with the Microsoft Management Console (MMC) and Terminal Services Configure and lock down operating system configurations using Group Policy Objects Automate software deployment based on computer and user roles Ready systems for disk cloning with SysPrep Perform automated n......
 

you will learn how to Plan and design a Windows 2000/XP enterprise effectively Migrate from NT to Windows 2000/XP without interrupting your business operation Plan Organisational Units (OUs) to avoid future restructuring Integrate the Windows 2000 DNS infrastructure into an existing environment Configure a replication topology based on your network and site structure Design delegat......
 

you will learn how to Implement and configure Windows 2000 for your environment Organise your Windows 2000 Active Directory Optimise file system resources Create logical views with the Distributed File System (DFS) Control delegated administration and group policy Establish local and network resource security Migrate from previous NT versions to Windows 2000 Introduction to W......
 

you will learn how to Install, configure and deploy SMS 2003 for your enterprise Customise SMS for resource management Manage hardware and software through automatic inventory and metering Exploit SMS remote tools to support end users at their desktops Deliver and install applications for your enterprise with SMS software distribution Maintain and troubleshoot your SMS environment ......
 

you will learn how to Build a TCP/IP internetwork for full Windows operating system integration Select suitable IP addresses and subnet masks Install and troubleshoot TCP/IP on Windows platforms Address name resolution issues and service location using NetBIOS, DNS and WINS Configure TCP/IP automatically with DHCP Locate DNS, DHCP and WINS servers on multiple subnets correctly Im......
 

Pages:- 1 2 3 4 5 6 7 8 9 10 11 12 13 14

School Index A~Z: A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z