Online Configuring Sql Server eLearning

Configuring SQL Server 2005 Configuring SQL Server 2005 Microsoft To configure a SQL Server instance and create a database, configure logins, users, and schemas for a database, and set up a linked server configuration  more...

Using Query Notifications Synchronizing Data With VB 2008 Using Query Notifications & Synchronizing Data With VB 2008 Microsoft Query notifications, coupled with ADO.NET synchronization services, allow developers to create applications with the ability to display up-to-date data at all times. This course examines how to use query notifications with SQL Server and how to enable efficient, remote use of data using synchronization services. Specific  more...

Configuring SQL Server 2008 Integration Services Package ...Configuring SQL Server 2008 Integration Services Package Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) This course explores the various components that make up an SSIS package. This includes elements of package control flow, such as containers used to provide the structure in packages, the actual tasks  more...

Oracle Database 11g Application Tracing Automatic SQL Tuning Oracle Database 11g: Application Tracing & Automatic SQL Tuning Oracle Oracle Database implements tracing by generating a trace file for each server process when you enable the tracing mechanism. This course explores configuring the SQL Trace facility to collect session statistics, using the TRCSESS utility to consolidate SQL trace files, formatting trace files using the tkprof utility, and  more...

SQL Server 2000 Administration This course will teach techniques for installing, configuring, and administering SQL Server 2000. This course is designed to teach the student all the necessary knowledge to successfully pass the Microsoft exam 70-228 required for MCDBA. (Installing, Configuring, and Administering Microsoft SQL Server 2000.) This indepth course covers all necessary materials to accomplish outcomes listed below.  more...

Dreamweaver MX Web Applications This is the second course in a series of tutorials from the Virtual Training Company for Dreamweaver MX. It covers all that techniques required to construct a data driven web site. Author Mark Fletcher (a member of Team Macromedia) will teach you how to construct a database, create database queries using SQL (Structure Query Language) and how to connect to a database using IIS (Internet  more...

Installing Configuring and Upgrading SQL Server 2000 To describe how to install, configure, and upgrade SQL Server  more...

Managing SQL Server 2000 Databases To guide students in configuring, performing, and automating routine administrative tasks  more...

Oracle8 Performance Tuning Managing Memory and Disk I O Course Overview This course is the second in a three-part Oracle8 Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log  more...

Oracle Reports R6 Control Reports Course Overview This course is the third in a three-part Oracle Reports series that is based on Oracle Reports Release 6. This course introduces the learner to features of Oracle Reports that can be used to control report output. This course covers developing templates, creating and using parameters, coding PL/SQL triggers, exporing built-in package procedures, using the Reports Server, and  more...

SQL Server 7 0 System Administration - Part 5 Course Overview This is the final course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Identify the methods and attributes of SQL Server 7.0 replication. Identify and apply techniques for planning and setting up SQL Server 7.0 replication. Identify the procedures  more...

SQL Server 7 0 System Administration - Part 1 ...option with its description. Unit 2: Installing and Configuring SQL Server Duration: 2 - 3 Hour(s) Identify the hardware and software installation requirements for installing SQL Server 7.0. Perform a typical SQL Server 7.0 installation using the using the SQL Server Setup program. Review the steps to complete an unattended installation of SQL Server 7.0. Identify the  more...

SQL Server 7 0 System Administration - Part 2 Course Overview This is the second course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Work with Microsoft SQL Server is and Work with Microsoft SQL Server 7.0, its architecture, security, and database structure. Understand the basics of SQL Server databases and how  more...

SQL Server 7 0 System Administration - Part 3 Course Overview This is the third course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Identify the concepts, interfaces and fixed roles involved in performing backups. Gain a working knowledge of database, transaction log and filegroup backups and perform these  more...

SQL Server 7 0 System Administration - Part 4 Course Overview This is the fourth course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Automate SQL Server 7.0 administrative tasks. Identify and use the SQL Server 7.0 tools for transferring and transforming data. Identify and use the tools for monitoring and  more...

Oracle8i Performance Tuning Managing Memory Disk I O Course Overview This course is the second in a three-part Oracle8i Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log  more...

Oracle Database 10g Administration Workshop II Part 1 This course will teach learners to configure an Oracle database for multilingual applications and distributed database access. Students will also practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Learn To: Match goals of Oracle Database 10g manageability features with the methods of achieving them. Identify features of the Oracle  more...

Oracle Database 10g New Features for Administrators Part 2 Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as automatic management, manageability infrastructure, and application tuning and monitoring. Learn To: Identify features of Automatic Database Diagnostic Monitor  more...

Oracle Database 10g New Features for Administrators Part 4 Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as flash backup and recovery. Learn To: Identify features of the flash backup and recovery strategy. Identify tasks that you perform when using the flash  more...

SQL Server 2000 Database Admin Part 5 Maint SQL Server 2000 ... SQL Server 2000. Learn To Identify guidelines for configuring SQL Server Agent. Identify guidelines for using SQLAgentMail and SQL Mail. Configure a Microsoft Outlook Exchange profile for your administrative account. Identify the goals of SQL Server 2000 monitoring. Identify guidelines for performance tuning. Identify the factors to consider when detecting database performance  more...

BizTalk Server 2000 Part 5 Secruity Optimization Course Overview This is the last course in a five part series that deals with the securing of the BizTalk Server 2000 environment and the configuring of servers and groups of servers and optimization of server group performance. This course covers the use of tools and utilities to monitor the status of the BizTalk Server 2000 environment. Learn To • Identify Microsoft Windows 2000 and  more...

MCSE Windows 2000 Electives Curriculum The MCSE Windows 2000 Electives Curriculum includes the following: MS Windows 2000: Migrating from MS Windows NT 4.0 Curriculum (ID#7556) Installing, Configuring & Administering Microsoft Exchange 2000 Server Curriculum (ID#7732) Microsoft ISA Server 2000 Curriculum (ID#8041) MS SQL Server 2000 Database Administration Curriculum (ID#7895) To review individual descriptions, please select  more...

Windows 2000 Implementing Security Part 2 This course, teaches about security for Windows 2000-based computers. Security templates and security baselines are covered. The learner is guided through additional security configurations including security settings for file and print resources. Web server security and Internet security are also covered. Learn To: • To identify guidelines for planning  more...

Commerce Server 2000 Design Impl Part 5 Infra Sec Admin This is the final course in a five part series that covers designing a network infrastructure to support Commerce Server 2000, describing the infrastructure components including Web Farms, staging servers and development servers, and covering network performance improvement by using switches to connect servers. The course focuses on providing network security, including configuring firewalls and  more...

MS Project Server 2003 Introduction Part 1 This course is the first part of a two-part series. This course will focus on introduction to Project Server 2003. It will also explain the software components of Project Server 2003, its architecture, and the configuration planning process. Learn To: Identify features of Microsoft Office Project Server 2003. Match the software components of Microsoft Office Project Server 2003  more...

MS Project Server 2003 Introduction Part 2 This course introduces you to the capabilities of Microsoft Office Project Server 2003. It includes how to plan, install, and configure the platform, as well as plan for client access across the organization. Learn To: Configure SQL Server authentication for Microsoft Office Project Server 2003. Identify features of SQL Server 2000 Analysis Services. Sequence the steps to  more...

Oracle Application Server 10g Administration Part 3 Oracle Application Server 10g is an integrated, standards-based software platform that allows organizations of all sizes to be more responsive to changing business requirements. This course covers managing, configuring OC4J applications, maintaining OC4J Application pages, OracleAS Portal, managing portal users and groups, exporting and importing portal objects, and Oracle portal advanced  more...

Oracle Application Server 10g Administration II Part 3 This course introduces the various Business Intelligence components such as Discoverer, Reports, Forms, and XML applications. The users learn about configuring and managing OracleAS Discoverer, OracleAS Reports Services, OracleAS Forms, and XML applications. They also learn how to deploy and manage OracleAS Web Services. Learn To: Match the components of Oracle Application Server  more...