Online Sql Tools eLearning - Training Resources
Sql Tools Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From Online Training Directory
Java 2 -- Advanced Enterprise Java
This course contains 3 units: Java Database Connectivity (JDBC), Java Native Interface, and The Debugger. Each unit covers detail the elements of Java necessary to implement these features and functions as you program in the Advanced Enterprise Java language.
The first unit explains the concept of Java Database Connectivity (JDBC).
It covers the features and functions of JDBC and the differences
more...
This course contains 3 units: Java Database Connectivity (JDBC), Java Native Interface, and The Debugger. Each unit covers detail the elements of Java necessary to implement these features and functions as you program in the Advanced Enterprise Java language.
The first unit explains the concept of Java Database Connectivity (JDBC).
It covers the features and functions of JDBC and the differences
more...
Crystal Reports XI
Receive a fundamental understanding of the concepts of Crystal Reports XI by learning to build reports, use formulas, build groups, work with records, and create charts.
Crystal Reports XI Receive a fundamental understanding of the concepts of Crystal Reports XI by learning to build reports, use formulas, build groups, work with records, and create charts. Follow Jason Manibog as he teaches you
more...
Receive a fundamental understanding of the concepts of Crystal Reports XI by learning to build reports, use formulas, build groups, work with records, and create charts.
Crystal Reports XI Receive a fundamental understanding of the concepts of Crystal Reports XI by learning to build reports, use formulas, build groups, work with records, and create charts. Follow Jason Manibog as he teaches you
more...
From 123-CBT Computer Based Training
Oracle Database 11g Getting Started with SQL and PL SQL New Features
To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database objects, find subpatterns, and track dependencies
more...
Oracle Database 11g Getting Started with SQL and PL SQL New Features
To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database objects, find subpatterns, and track dependencies
more...
Oracle Database 11g Change Management Overview and SQL Plan Management
outline the uses of management tools in Oracle Database 11g, such as SQL Performance Analzer, SQL tuning sets, and SQL plan baselines, and outline how you can use them to effectively manage change and execute SQL plans.
more...
outline the uses of management tools in Oracle Database 11g, such as SQL Performance Analzer, SQL tuning sets, and SQL plan baselines, and outline how you can use them to effectively manage change and execute SQL plans.
more...
Oracle Database 11g Database Replay and Automatic SQL Tuning
Explain the benefits and uses of Oracle Database 11g's crucial developer tools, Database Replay and Automatic SQL Tuning, when setting up and testing a database
more...
Explain the benefits and uses of Oracle Database 11g's crucial developer tools, Database Replay and Automatic SQL Tuning, when setting up and testing a database
more...
Oracle Database 11g Diagnostic Enhancements and Using the Data Recovery Advisor
recognize the steps for detecting, diagnosing, and repairing critical errors and data failures in Oracle Database 11g, using its enhanced, proactive, diagnostic tools, such as Automatic Diagnostic Repository, Support Workbench, SQL Repair Advisor, and the Data Recovery Advisor.
more...
recognize the steps for detecting, diagnosing, and repairing critical errors and data failures in Oracle Database 11g, using its enhanced, proactive, diagnostic tools, such as Automatic Diagnostic Repository, Support Workbench, SQL Repair Advisor, and the Data Recovery Advisor.
more...
Oracle Database 11g PL SQL Variables Attributes and Executable Statements
To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.
more...
To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.
more...
Implementing Security for SQL in VB NET Applications
To determine how to secure SQL connections, select the most appropriate strategy to protect against SQL injection attacks, and handle user input using various validation and error handling techniques
more...
To determine how to secure SQL connections, select the most appropriate strategy to protect against SQL injection attacks, and handle user input using various validation and error handling techniques
more...
ADO NET Connections and Commands
To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design
more...
To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design
more...
ADO NET Connections and Commands
To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design
more...
To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design
more...
SQL Server 2005 Messaging and Querying Tools
To implement Service Broker components and use full-text search in SQL Server 2005
more...
To implement Service Broker components and use full-text search in SQL Server 2005
more...
Implementing Security for SQL in C NET Applications
To determine how to secure SQL connections, select the most appropriate strategy to protect against SQL injection attacks, and handle user input using various validation and error handling techniques
more...
To determine how to secure SQL connections, select the most appropriate strategy to protect against SQL injection attacks, and handle user input using various validation and error handling techniques
more...
Small Business Server 2000
To provide an overview of Microsoft Small Business Server (SBS) 2000 and its main features, such as its management consoles and monitoring tools, and to show how Microsoft Exchange 2000, ISA Server 2000, and Microsoft SQL Server 2000 integrate with SBS 2000
more...
To provide an overview of Microsoft Small Business Server (SBS) 2000 and its main features, such as its management consoles and monitoring tools, and to show how Microsoft Exchange 2000, ISA Server 2000, and Microsoft SQL Server 2000 integrate with SBS 2000
more...
Oracle9i Peformance Tuning Managing Memory and Disk I O
This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the
more...
This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the
more...
Oracle9i Database Admin Manage an Instance
Course Overview The Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are
more...
Course Overview The Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are
more...
Oracle9i SQL Basic SELECT Statements
This course covers relational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. Learn To: o Identify the components of the relational
more...
This course covers relational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. Learn To: o Identify the components of the relational
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...
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...
BizTalk Server 2000 Part 4 Components Solutions Troubleshooting
Course Overview This is the fourth course in a five part series that presents the knowledge and skills necessary to create application integration components (AICs) for use with BizTalk Messaging Services. It also covers the deployment and management of an automated business process between trading partners using BizTalk Server 2000. In this respect, it presents a type of practical application
more...
Course Overview This is the fourth course in a five part series that presents the knowledge and skills necessary to create application integration components (AICs) for use with BizTalk Messaging Services. It also covers the deployment and management of an automated business process between trading partners using BizTalk Server 2000. In this respect, it presents a type of practical application
more...
BizTalk Server 2000 Part 3 Monitoring Orchestration
Course Overview This is the third course in a five part series that deals with the tracking of interchanges and business documents using BizTalk Document Tracking. It also covers the orchestration of the business process using BizTalk Orchestration Designer. The learner will review the core procedures necessary for using both these tools and has an opportunity to practice their use in the three
more...
Course Overview This is the third course in a five part series that deals with the tracking of interchanges and business documents using BizTalk Document Tracking. It also covers the orchestration of the business process using BizTalk Orchestration Designer. The learner will review the core procedures necessary for using both these tools and has an opportunity to practice their use in the three
more...
BizTalk Server 2000 Part 2 Documents Mapping Managing Submitting
Course Overview This is the second course in a five part series that deals with the mapping and managing of document flow. This course covers creating maps using BizTalk Mapper, creating objects in and managing BizTalk Messaging Manager, and the submission of documents to BizTalk Server. The course continues to build upon the scenario companies that form the scenario core of the curriculum,
more...
Course Overview This is the second course in a five part series that deals with the mapping and managing of document flow. This course covers creating maps using BizTalk Mapper, creating objects in and managing BizTalk Messaging Manager, and the submission of documents to BizTalk Server. The course continues to build upon the scenario companies that form the scenario core of the curriculum,
more...
BizTalk Server 2000 Part 1 Intro to BizTalk Server 2000
Course Overview This is the first course in a five part series that introduces the learner to the context of BizTalk operations, identifying the main challenges of EAI and B2B communications. BizTalk is contextualized in terms of a solution to these various challenges. This course covers the BizTalk administration model and its tools and services. It also covers the installation requirements
more...
Course Overview This is the first course in a five part series that introduces the learner to the context of BizTalk operations, identifying the main challenges of EAI and B2B communications. BizTalk is contextualized in terms of a solution to these various challenges. This course covers the BizTalk administration model and its tools and services. It also covers the installation requirements
more...
BizTalk Server 2000 Curriculum
Course Overview This curriculum introduces the learner to the context of BizTalk operations, identifying the main challenges of EAI and B2B communications. This curriculum covers creating maps using BizTalk Mapper, creating objects in and managing BizTalk Messaging Manager, and the submission of documents to BizTalk Server. Additionally, it covers the tracking of interchanges and business
more...
Course Overview This curriculum introduces the learner to the context of BizTalk operations, identifying the main challenges of EAI and B2B communications. This curriculum covers creating maps using BizTalk Mapper, creating objects in and managing BizTalk Messaging Manager, and the submission of documents to BizTalk Server. Additionally, it covers the tracking of interchanges and business
more...
IBM DB2 Univ Database V7 1 Transition Part 1 Core Competencies
Course Overview This is the first course in a two part series that students will learn about OLAP functionality, SQL and AD Enhancements. Additionally, this course covers Federated Databases and Extenders and what has been added in these areas. Learn To Identify the enhancements that emerged with each version of DB2. Identify the six main product editions of the DB2 family. Identify
more...
Course Overview This is the first course in a two part series that students will learn about OLAP functionality, SQL and AD Enhancements. Additionally, this course covers Federated Databases and Extenders and what has been added in these areas. Learn To Identify the enhancements that emerged with each version of DB2. Identify the six main product editions of the DB2 family. Identify
more...
IBM DB2 Univ Database V7 1 Transition Part 1 Core Competencies
Course Overview This is the first course in a two part series that students will learn about OLAP functionality, SQL and AD Enhancements. Additionally, this course covers Federated Databases and Extenders and what has been added in these areas. Learn To Identify the enhancements that emerged with each version of DB2. Identify the six main product editions of the DB2 family. Identify
more...
Course Overview This is the first course in a two part series that students will learn about OLAP functionality, SQL and AD Enhancements. Additionally, this course covers Federated Databases and Extenders and what has been added in these areas. Learn To Identify the enhancements that emerged with each version of DB2. Identify the six main product editions of the DB2 family. Identify
more...
SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks
This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking. Learn To: o Identify
more...
This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking. Learn To: o Identify
more...
SQL Server 2000 Database Admin Part 4 Managing Data
Course Overview This course deals with transferring data, managing replication services, and maintaining high availability. Learn To Identify guidelines for importing and exporting data. Match SQL Server 2000 tools used to import and export data with their functions. Identify the features and functions of the Data Transformation Services (DTS) process. Identify the features of
more...
Course Overview This course deals with transferring data, managing replication services, and maintaining high availability. Learn To Identify guidelines for importing and exporting data. Match SQL Server 2000 tools used to import and export data with their functions. Identify the features and functions of the Data Transformation Services (DTS) process. Identify the features of
more...
SQL Server 2000 Database Admin Part 2 Manag Databases
Course Overview This is the second course in a five part series that will teach students how to plan for managing databases with SQL Server 2000. This course also includes both theoretical and practical instruction in the creation and management of objects. Learn To Identify the database option categories. Identify features of the tools used to view database properties. View database
more...
Course Overview This is the second course in a five part series that will teach students how to plan for managing databases with SQL Server 2000. This course also includes both theoretical and practical instruction in the creation and management of objects. Learn To Identify the database option categories. Identify features of the tools used to view database properties. View database
more...
IBM DB2 Universal Database V6 1--Administration
Course Overview This course will provide database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement
more...
Course Overview This course will provide database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement
more...
IBM DB2 Universal Database V6 1--Administration
Course Overview This course will provide database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement
more...
Course Overview This course will provide database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement
more...
Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention
Course Overview This course is the third in a three-part Oracle8i Performance Tuning series. This interactive course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately.
more...
Course Overview This course is the third in a three-part Oracle8i Performance Tuning series. This interactive course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately.
more...
Oracle8i Performance Tuning Architecture Strategy
Course Overview This course is the first in a three-part Oracle8i Performance Tuning series. This interactive course will introduce participants to tools and techniques used to improve the performance of the Oracle8i server. Participants will be introduced to files and events that support the tuning process. In addition, students will learn considerations for tuning applications. Finally,
more...
Course Overview This course is the first in a three-part Oracle8i Performance Tuning series. This interactive course will introduce participants to tools and techniques used to improve the performance of the Oracle8i server. Participants will be introduced to files and events that support the tuning process. In addition, students will learn considerations for tuning applications. Finally,
more...
Oracle8i Database Admin Manage an Instance
Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:
more...
Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:
more...
Oracle Database 10g Administration Workshop II Part 3
This course covers various functions of the Flashback technology. In addition to performing flashback operations at the database level, you can flash back a table or recover a table that has been dropped by mistake. The course also covers the tools used to monitor and improve database performance as well as detect and repair database corruption.
Learn To:
Identify features of Flashback
more...
This course covers various functions of the Flashback technology. In addition to performing flashback operations at the database level, you can flash back a table or recover a table that has been dropped by mistake. The course also covers the tools used to monitor and improve database performance as well as detect and repair database corruption.
Learn To:
Identify features of Flashback
more...
Oracle Form Builder R6 Including Reusable Oracle Components
Course Overview This course is the sixth in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course will enable learners to implement methods to use additional data sources, to work with Oracle8 objects, and to integrate charts, reports, and timers in form modules. In addition, the course covers the procedures to reuse components, objects, and code and to
more...
Course Overview This course is the sixth in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course will enable learners to implement methods to use additional data sources, to work with Oracle8 objects, and to integrate charts, reports, and timers in form modules. In addition, the course covers the procedures to reuse components, objects, and code and to
more...
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention
Course Overview
This course is the third in a three-part Oracle8 Performance Tuning series. This course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student
more...
Course Overview
This course is the third in a three-part Oracle8 Performance Tuning series. This course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student
more...
Oracle8 Backup and Recovery - Troubleshooting and Recovery
Course Overview
This course is the second course in a two-part series that introduces participants to the critical task of planning and implementing database recovery strategies. This course will identify ways of handling different types of failures, diagnosing errors and detecting corruption. Additionally, users will be introduced to the different types of Oracle recovery methods and how to
more...
Course Overview
This course is the second course in a two-part series that introduces participants to the critical task of planning and implementing database recovery strategies. This course will identify ways of handling different types of failures, diagnosing errors and detecting corruption. Additionally, users will be introduced to the different types of Oracle recovery methods and how to
more...
Oracle8 Database Administration - Manage an Instance
Course Overview
This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support.
L earn To:
more...
Course Overview
This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support.
L earn To:
more...
SQL Server 7 0 Designing Implementing Data Warehouses - Part 1
Course Overview This is the first course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the characteristics of different decision support systems and components and tools used in data warehousing;
more...
Course Overview This is the first course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the characteristics of different decision support systems and components and tools used in data warehousing;
more...
Visual C 6 0 Designing Implementing Desktop Applications - Part 1
Course Overview This is the first course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using the MFC library and the Microsoft Visual C++ 6 development environment. L earn To: Identify the features, tools, Wizards and resource editors of Visual C++ 6.0. Install and configure SQL Server and Microsoft
more...
Course Overview This is the first course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using the MFC library and the Microsoft Visual C++ 6 development environment. L earn To: Identify the features, tools, Wizards and resource editors of Visual C++ 6.0. Install and configure SQL Server and Microsoft
more...
Introduction to Data Warehousing
Course Overview
This course presents an introduction to Data Warehousing. Beginning with the basic concepts of data warehousing, this course helps you understand the processes involved in and the architecture of data warehousing. The tools involved in analyzing the warehouse data will also be covered. Finally, you'll learn about the Oracle data warehouse.
L earn To:
Identify the basic
more...
Course Overview
This course presents an introduction to Data Warehousing. Beginning with the basic concepts of data warehousing, this course helps you understand the processes involved in and the architecture of data warehousing. The tools involved in analyzing the warehouse data will also be covered. Finally, you'll learn about the Oracle data warehouse.
L earn To:
Identify the basic
more...
Oracle SQL Tuning Diagnostics and Tuning Schema
Course Overview
This course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths, such as partitioned views, B-tree indexes, bitmapped indexes, index clusters, and hash
more...
Course Overview
This course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths, such as partitioned views, B-tree indexes, bitmapped indexes, index clusters, and hash
more...
SQL Server 7 0 - Implementing a Database - Part 1
Course Overview This is the first course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Identify the components of SQL Server 7.0. Identify the characteristics of Transact-SQL and its processing. Perform the skills to construct and manage databases. C ontent Emphasis
more...
Course Overview This is the first course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Identify the components of SQL Server 7.0. Identify the characteristics of Transact-SQL and its processing. Perform the skills to construct and manage databases. C ontent Emphasis
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...
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...
SQL and PL SQL Basic SELECT
Course Overview This course is the first in a three-part Oracle SQL series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing basic
more...
Course Overview This course is the first in a three-part Oracle SQL series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing basic
more...
Oracle Database 10g New Features for Administrators Part 1
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 the new features of Oracle Database 10g that are applicable to database administration. The features include Manageability concepts, Grid computing, enhanced installation features, configuration and performance
more...
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 the new features of Oracle Database 10g that are applicable to database administration. The features include Manageability concepts, Grid computing, enhanced installation features, configuration and performance
more...
Oracle Database 10g Administration Workshop I Part 1
Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will be taught to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.
Learn To:
more...
Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will be taught to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.
Learn To:
more...
Crystal Reports 8 5 Introductory Report Design Part 2
Course Overview This is the second course in a two part series that builds on the information taught in the first course, Crystal Reports 8.5: Introductory Report Design Part 1 (13889). Learners will be working with formulas, linking reports, working with Cross-tabs, formatting sections, creating charts, and creating geographical maps. After completing this course, learners will be able to use
more...
Course Overview This is the second course in a two part series that builds on the information taught in the first course, Crystal Reports 8.5: Introductory Report Design Part 1 (13889). Learners will be working with formulas, linking reports, working with Cross-tabs, formatting sections, creating charts, and creating geographical maps. After completing this course, learners will be able to use
more...
Commerce Server 2000 Design Implementation Curriculum
The Commerce Server 2002 provides users with the skills necessary for user profiling, catalog management and advanced online business analytics including installation, administration tools, site packaging, and Commerce Server Manager. This curriculum consists of five Skill Builder courses. Course 74116 MS Commerce Server 2000: Design and Imp. Part 1 - Intro, 74117 MS Commerce Server 2000: Design
more...
The Commerce Server 2002 provides users with the skills necessary for user profiling, catalog management and advanced online business analytics including installation, administration tools, site packaging, and Commerce Server Manager. This curriculum consists of five Skill Builder courses. Course 74116 MS Commerce Server 2000: Design and Imp. Part 1 - Intro, 74117 MS Commerce Server 2000: Design
more...
Commerce Server 2000 Design Impl Part 1 Intro
This is the first course in a five part series that covers Commerce Server 2000, focusing on business, functional, and integration requirements that need to be considered in preparation for its deployment. The course then covers Business to Consumer Web sites and fundamental elements of Commerce Server 2000, including installation, administration tools, site packaging, and Commerce Server Manager.
more...
This is the first course in a five part series that covers Commerce Server 2000, focusing on business, functional, and integration requirements that need to be considered in preparation for its deployment. The course then covers Business to Consumer Web sites and fundamental elements of Commerce Server 2000, including installation, administration tools, site packaging, and Commerce Server Manager.
more...
Commerce Server 2000 Design Impl Part 2 Users Objects Catalogs
This is the second course in a five part series that covers the importance of user authentication and how to set up identification, authentication, and profiling systems for anonymous and registered users. The course also focuses on catalogs in a Commerce Server Web site, the tools used to create one, and the skills required to build Web pages to browse and search catalogs. Learn To: o
more...
This is the second course in a five part series that covers the importance of user authentication and how to set up identification, authentication, and profiling systems for anonymous and registered users. The course also focuses on catalogs in a Commerce Server Web site, the tools used to create one, and the skills required to build Web pages to browse and search catalogs. Learn To: o
more...
Microsoft NET Tech Overview Part 1 NET Platform Framework
This course gives an introduction and basic explanation of the Microsoft .NET Platform and its components, including the .NET Enterprise Servers (BizTalk Server, Application Center, Host Integration Center, Mobile Information Center Internet Security and Acceleration Server and SQL Server) as well as development tools and technologies (XML, ASP.NET, Visual Studio.NET, and SOAP). Other areas such
more...
This course gives an introduction and basic explanation of the Microsoft .NET Platform and its components, including the .NET Enterprise Servers (BizTalk Server, Application Center, Host Integration Center, Mobile Information Center Internet Security and Acceleration Server and SQL Server) as well as development tools and technologies (XML, ASP.NET, Visual Studio.NET, and SOAP). Other areas such
more...
Microsoft NET Tech Overview Part 1 NET Platform Framework
This course gives an introduction and basic explanation of the Microsoft .NET Platform and its components, including the .NET Enterprise Servers (BizTalk Server, Application Center, Host Integration Center, Mobile Information Center Internet Security and Acceleration Server and SQL Server) as well as development tools and technologies (XML, ASP.NET, Visual Studio.NET, and SOAP). Other areas such
more...
This course gives an introduction and basic explanation of the Microsoft .NET Platform and its components, including the .NET Enterprise Servers (BizTalk Server, Application Center, Host Integration Center, Mobile Information Center Internet Security and Acceleration Server and SQL Server) as well as development tools and technologies (XML, ASP.NET, Visual Studio.NET, and SOAP). Other areas such
more...
Microsoft NET Tech Overview Part 2 NET Server Infrastructure Services
This course covers the .NET Enterprise Servers infrastructure, explaining each of the servers in turn - BizTalk Server 2000, Application Center 2000, Commerce Server 2000, Host Integration Server, SQL Server 2000, Exchange Server 2000, ISA Server 2000, Mobile Information 2001 Server. It then covers each of the chief products of the .NET initiative and each of the chief services. The course
more...
This course covers the .NET Enterprise Servers infrastructure, explaining each of the servers in turn - BizTalk Server 2000, Application Center 2000, Commerce Server 2000, Host Integration Server, SQL Server 2000, Exchange Server 2000, ISA Server 2000, Mobile Information 2001 Server. It then covers each of the chief products of the .NET initiative and each of the chief services. The course
more...
Microsoft NET Tech Overview Part 2 NET Server Infrastructure Services
This course covers the .NET Enterprise Servers infrastructure, explaining each of the servers in turn - BizTalk Server 2000, Application Center 2000, Commerce Server 2000, Host Integration Server, SQL Server 2000, Exchange Server 2000, ISA Server 2000, Mobile Information 2001 Server. It then covers each of the chief products of the .NET initiative and each of the chief services. The course
more...
This course covers the .NET Enterprise Servers infrastructure, explaining each of the servers in turn - BizTalk Server 2000, Application Center 2000, Commerce Server 2000, Host Integration Server, SQL Server 2000, Exchange Server 2000, ISA Server 2000, Mobile Information 2001 Server. It then covers each of the chief products of the .NET initiative and each of the chief services. The course
more...
Oracle Database 10g PL SQL Fundamentals Part 3
In this course, the learner will get familiar with the procedural language to access Oracle database. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. The student will also learn about the compilation tools and their options.
Learn To:
Match the stages in the execution of SQL statements with
more...
In this course, the learner will get familiar with the procedural language to access Oracle database. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. The student will also learn about the compilation tools and their options.
Learn To:
Match the stages in the execution of SQL statements with
more...
From Serebra Learning Corporation
Visual Basic 6 0 Database Access Part I
This course provides an introduction to Visual Basic's capabilities relating to database access and manipulation in an online environment. It explains how databases are organized, how information is retrieved and manipulated in databases, and what technologies are available to ensure cross-platform and uniform access to database information. This course describes the fundamentals of viewing
more...
This course provides an introduction to Visual Basic's capabilities relating to database access and manipulation in an online environment. It explains how databases are organized, how information is retrieved and manipulated in databases, and what technologies are available to ensure cross-platform and uniform access to database information. This course describes the fundamentals of viewing
more...
Transferring and Transforming Data in SQL Server 2000
To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Transferring and Transforming Data in SQL Server 2000
To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Visual Basic 6 0 Advanced Enterprise Client Server Dev Part I
This course discusses database security implementations to aid a developer in correctly programming components that access data without compromising security. The different security modes available to Microsoft SQL Server 7.0 and previous versions of SQL Server are explained, as well as their respective advantages. It also explains creating Windows NT accounts and user groups. This course
more...
This course discusses database security implementations to aid a developer in correctly programming components that access data without compromising security. The different security modes available to Microsoft SQL Server 7.0 and previous versions of SQL Server are explained, as well as their respective advantages. It also explains creating Windows NT accounts and user groups. This course
more...
What Microsoft NET Means for IT Professionals
To introduce the concepts and components of Microsoft .NET Business managers, IT professionals
more...
To introduce the concepts and components of Microsoft .NET Business managers, IT professionals
more...
Data Integration with C 2005 and ASP NET 2 0
To configure data controls and to establish and configure database connections in .NET 2.0 web applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005, C# 2005, and ASP.NET 2.0 to develop web-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Web-Based Client Development (70-528) exam
more...
To configure data controls and to establish and configure database connections in .NET 2.0 web applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005, C# 2005, and ASP.NET 2.0 to develop web-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Web-Based Client Development (70-528) exam
more...
Data Integration with Visual Basic 2005 and ASP NET 2 0
To configure data controls and to establish and configure database connections in .NET 2.0 web applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005, Visual Basic 2005, and ASP.NET 2.0 to develop web-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Web-Based Client Development (70-528) exam
more...
To configure data controls and to establish and configure database connections in .NET 2.0 web applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005, Visual Basic 2005, and ASP.NET 2.0 to develop web-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Web-Based Client Development (70-528) exam
more...
ADO NET Connections and Commands
To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design C# programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design C# programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
ADO NET Connections and Commands
To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
Building ADO NET DataSets
To describe how to use ADO.NET's disconnected DataSet object model, including DataSets, DataAdapters, DataTables, DataRelations, DataRows, and DataColumns Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
To describe how to use ADO.NET's disconnected DataSet object model, including DataSets, DataAdapters, DataTables, DataRelations, DataRows, and DataColumns Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
XML Data Access in VB NET
To use the .NET Framework to manage XML data All Microsoft VB.NET developers wanting to write enterprise applications with serviced components, Windows Services, or .NET Remoting, or studying for the 70-310 exam Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
more...
To use the .NET Framework to manage XML data All Microsoft VB.NET developers wanting to write enterprise applications with serviced components, Windows Services, or .NET Remoting, or studying for the 70-310 exam Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
more...
Small Business Server 2000
To provide an overview of Microsoft Small Business Server (SBS) 2000 and its main features, such as its management consoles and monitoring tools, and to show how Microsoft Exchange 2000, ISA Server 2000, and Microsoft SQL Server 2000 integrate with SBS 2000 Network administrators for companies of up to 50 users; IT solutions companies that wish to deploy SBS 2000
more...
To provide an overview of Microsoft Small Business Server (SBS) 2000 and its main features, such as its management consoles and monitoring tools, and to show how Microsoft Exchange 2000, ISA Server 2000, and Microsoft SQL Server 2000 integrate with SBS 2000 Network administrators for companies of up to 50 users; IT solutions companies that wish to deploy SBS 2000
more...
Monitoring and Managing IP Telephony Using Internal Server Tools
To demonstrate how to manage and monitor an IP telephony solution using internal server tools IT professionals responsible for installing, configuring, and maintaining the ongoing administration of a Cisco IP telephony solution; candidates preparing for the Cisco IP Telephony exam (642-444 CIPT)
more...
To demonstrate how to manage and monitor an IP telephony solution using internal server tools IT professionals responsible for installing, configuring, and maintaining the ongoing administration of a Cisco IP telephony solution; candidates preparing for the Cisco IP Telephony exam (642-444 CIPT)
more...
Monitoring IP Telephony
To recognize the tools of the IP telephony environment and how to maintain it, and monitor and troubleshoot the Cisco CallManager system IT professionals responsible for installing, configuring, and maintaining the ongoing administration of a Cisco IP Telephony solution; candidates preparing for the Cisco IP Telephony exam (642-444 CIPT)
more...
To recognize the tools of the IP telephony environment and how to maintain it, and monitor and troubleshoot the Cisco CallManager system IT professionals responsible for installing, configuring, and maintaining the ongoing administration of a Cisco IP Telephony solution; candidates preparing for the Cisco IP Telephony exam (642-444 CIPT)
more...
Optimizing Database Performance in Oracle 10g
To outline the processes and considerations for optimizing an Oracle database using alerts, trace files, and advisors Oracle database administrators and database operators
more...
To outline the processes and considerations for optimizing an Oracle database using alerts, trace files, and advisors Oracle database administrators and database operators
more...
Using the Scheduler to Automate Tasks in Oracle 10g
To outline the processes and considerations for using the Scheduler tool Oracle database administrators and database operators
more...
To outline the processes and considerations for using the Scheduler tool Oracle database administrators and database operators
more...
Oracle Database 10g New Resource Scheduling and Task-Management Features
To identify the new resource, scheduling, and task-management features of Oracle 10g Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
To identify the new resource, scheduling, and task-management features of Oracle 10g Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
Installing Configuring and Upgrading SQL Server 2000
To describe how to install, configure, and upgrade SQL Server Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
To describe how to install, configure, and upgrade SQL Server Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Monitoring SQL Server 2000 Performance
To explain how to monitor SQL Server for optimal performance Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
To explain how to monitor SQL Server for optimal performance Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Advanced Database Features in Access 2002
To demonstrate a range of advanced database features in Access 2002 Anyone wishing to become familiar with Microsoft Access 2002 at an advanced level; students seeking to obtain Microsoft Office User Specialist (MOUS) certification in the use of Microsoft Access 2002 at advanced level
more...
To demonstrate a range of advanced database features in Access 2002 Anyone wishing to become familiar with Microsoft Access 2002 at an advanced level; students seeking to obtain Microsoft Office User Specialist (MOUS) certification in the use of Microsoft Access 2002 at advanced level
more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 1
This is the first course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the characteristics of different decision support systems and components and tools used in data warehousing; identify the
more...
This is the first course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the characteristics of different decision support systems and components and tools used in data warehousing; identify the
more...
Oracle8i DBA--SQL*Loader, Oracle Export and Import, and NLS
The course is aimed at familiarizing you with the data transfer tools of Oracles. The course will teach you how to use SQL*Loader to load data into an Oracle database. The course will also teach you how to use the Oracle Export and Import Utilities. Next the course will detail explain the NLS feature of Oracle8i. The course initiates the learner into hands-on learning by helping the learner to
more...
The course is aimed at familiarizing you with the data transfer tools of Oracles. The course will teach you how to use SQL*Loader to load data into an Oracle database. The course will also teach you how to use the Oracle Export and Import Utilities. Next the course will detail explain the NLS feature of Oracle8i. The course initiates the learner into hands-on learning by helping the learner to
more...
SQL Server 7.0 Introduction
This course presents an overview of the features and benefits of SQL Server 7.0 a major update to Microsoft's SQL Server database product. It describes the major differences between versions 6.5 and 7.0 and examines core components data warehousing application development tools and SQL management tools. This course provides an excellent foundation for advanced courses on upgrade and
more...
This course presents an overview of the features and benefits of SQL Server 7.0 a major update to Microsoft's SQL Server database product. It describes the major differences between versions 6.5 and 7.0 and examines core components data warehousing application development tools and SQL management tools. This course provides an excellent foundation for advanced courses on upgrade and
more...
SQL Server 7.0 Installing and Upgrading
This course presents a comprehensive view of upgrading and installation process and its installation types and requirements. Students will learn the procedures for installing and upgrading to SQL Server 7.0. The course describes setup options that must be determined before installing SQL Server 7.0 and covers logon accounts the Windows NT User Account network protocols management tools and sort
more...
This course presents a comprehensive view of upgrading and installation process and its installation types and requirements. Students will learn the procedures for installing and upgrading to SQL Server 7.0. The course describes setup options that must be determined before installing SQL Server 7.0 and covers logon accounts the Windows NT User Account network protocols management tools and sort
more...
SQL Server 7.0 Management Part I
This course is designed to teach the skills necessary to take full advantage of SQL Server 7.0 features and enhancements used to manage data. SQL Server 7.0 contains two powerful tools for managing data: Transact-SQL at the command-line level and SQL Server Wizard features. This course presents a comprehensive view of the database development process by outlining the processes of creating the
more...
This course is designed to teach the skills necessary to take full advantage of SQL Server 7.0 features and enhancements used to manage data. SQL Server 7.0 contains two powerful tools for managing data: Transact-SQL at the command-line level and SQL Server Wizard features. This course presents a comprehensive view of the database development process by outlining the processes of creating the
more...
SQL Server 7.0 Data Warehousing SQL Part I
This course is designed to help students gain knowledge of the core components of data warehousing application development tools and SQL management tools. The course introduces basic concepts terminology for understanding SQL Server 7.0 relational databases Structured Query Language and new or improved features. It builds on this foundation to cover client/server web applications programming
more...
This course is designed to help students gain knowledge of the core components of data warehousing application development tools and SQL management tools. The course introduces basic concepts terminology for understanding SQL Server 7.0 relational databases Structured Query Language and new or improved features. It builds on this foundation to cover client/server web applications programming
more...
SQL Server 7.0 Developing SQL Client/Server Part I
This course is designed to present a comprehensive view of the client/server application. The course outlines the structure and elements of client/server architecture interfaces available strategies in accessing data from the client side through queries and tools available with SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server
more...
This course is designed to present a comprehensive view of the client/server application. The course outlines the structure and elements of client/server architecture interfaces available strategies in accessing data from the client side through queries and tools available with SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server
more...
SQL Server 7.0 Developing SQL Client/Server Part II
This course is designed to present a comprehensive view of the client/server application. The course outlines the structure and elements of client/server architecture interfaces available strategies in accessing data from the client side through queries and tools available with SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server
more...
This course is designed to present a comprehensive view of the client/server application. The course outlines the structure and elements of client/server architecture interfaces available strategies in accessing data from the client side through queries and tools available with SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server
more...
SQL Server 7.0 Web Integration
This course introduces several new or enhanced technologies procedures and tools for increased dependence on the Web for business applications. The course presents a comprehensive view of Web applications with SQL Server 7.0. The course outlines Microsoft's overall Web strategy including reasons for linking the databases to Web clients possible tasks that can be accomplished through Web
more...
This course introduces several new or enhanced technologies procedures and tools for increased dependence on the Web for business applications. The course presents a comprehensive view of Web applications with SQL Server 7.0. The course outlines Microsoft's overall Web strategy including reasons for linking the databases to Web clients possible tasks that can be accomplished through Web
more...
Oracle9i Performance Tuning: Managing Memory and Disk I/O
This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database.
more...
This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database.
more...
Microsoft .NET Technology Overview: Part 1 - .NET Platform and Framework
This course gives an introduction and basic explanation of the Microsoft .NET Platform and its components including the .NET Enterprise Servers (BizTalk Server Application Center Host Integration Center Mobile Information Center Internet Security and Acceleration Server and SQL Server) as well as development tools and technologies (XML ASP.NET Visual Studio.NET and SOAP). Other areas such as
more...
This course gives an introduction and basic explanation of the Microsoft .NET Platform and its components including the .NET Enterprise Servers (BizTalk Server Application Center Host Integration Center Mobile Information Center Internet Security and Acceleration Server and SQL Server) as well as development tools and technologies (XML ASP.NET Visual Studio.NET and SOAP). Other areas such as
more...
Oracle8i Performance Tuning: Optimizing Sorts and Minimizing Contention
This course is the third in a three-part Oracle8i Performance Tuning series. This interactive course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts ensure that sorting is done in memory where possible use direct writes for large sorts and allocate temporary space appropriately. The student will use
more...
This course is the third in a three-part Oracle8i Performance Tuning series. This interactive course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts ensure that sorting is done in memory where possible use direct writes for large sorts and allocate temporary space appropriately. The student will use
more...
Oracle8 Performance Tuning: Optimizing Sorts and Minimizing Contention
This course is the third in a three-part Oracle8 Performance Tuning series. This course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts ensure that sorting is done in memory where possible use direct writes for large sorts and allocate temporary space appropriately. The student will use Oracle tools
more...
This course is the third in a three-part Oracle8 Performance Tuning series. This course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts ensure that sorting is done in memory where possible use direct writes for large sorts and allocate temporary space appropriately. The student will use Oracle tools
more...
Oracle SQL Tuning: Diagnostics and Tuning the Schema
This course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths such as partitioned views B-tree indexes bitmapped indexes index clusters and hash clusters. Participants will
more...
This course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths such as partitioned views B-tree indexes bitmapped indexes index clusters and hash clusters. Participants will
more...
MS SQL Server 7.0 Basics
This course teaches the student the concept of database and tables in SQL Server 7.0. It also covers the tools used to maintain data integrity. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 7-029.
more...
This course teaches the student the concept of database and tables in SQL Server 7.0. It also covers the tools used to maintain data integrity. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 7-029.
more...
From Software Training Academy, Inc
SQL Server 2005
In this course, you ll learn about the features that are available in SQL Server; how to design and create a database; and how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll learn about the new enhancements to the Transact-SQL programming
more...
In this course, you ll learn about the features that are available in SQL Server; how to design and create a database; and how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll learn about the new enhancements to the Transact-SQL programming
more...
SQL Server 2005 Integration Services SSIS
This course will enable technology professionals with little or no ETL experience and minimal exposure to SQL Server 2005 and Visual Studio 2005 to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development
more...
This course will enable technology professionals with little or no ETL experience and minimal exposure to SQL Server 2005 and Visual Studio 2005 to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development
more...
SQL Server 2005 Analysis Services SSAS
In this course, you will learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to
more...
In this course, you will learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to
more...
Oracle 10g - Introduction to SQL
This course is designed for developers who are new to relational database and need to know how to query, update and create basic objects in Oracle databases.
Students receive a comprehensive introduction to Oracle's implementation of the SQL language and the common query tools, SQL*Plus and iSQL*Plus. The course includes a lesson on basic relational database concepts.
LEARNING OBJECTIVES
more...
This course is designed for developers who are new to relational database and need to know how to query, update and create basic objects in Oracle databases.
Students receive a comprehensive introduction to Oracle's implementation of the SQL language and the common query tools, SQL*Plus and iSQL*Plus. The course includes a lesson on basic relational database concepts.
LEARNING OBJECTIVES
more...
Oracle Applications Using ADO NET and C
Oracle is a robust and powerful data storage engine that provides services on all levels of an application infrastructure combining programmer-definable objects and tools, data manipulation tools that are capable of retrieving data from a host of data sources and storing those data in a database, and the capability to automate tasks and run them under developer control.
This comprehensive course
more...
Oracle is a robust and powerful data storage engine that provides services on all levels of an application infrastructure combining programmer-definable objects and tools, data manipulation tools that are capable of retrieving data from a host of data sources and storing those data in a database, and the capability to automate tasks and run them under developer control.
This comprehensive course
more...
NET Framework using Visual Basic
Microsoft .NET is an advance in programming technology that greatly simplifies application development, both for traditional, proprietary applications and for the emerging paradigm of Web-based services. .NET is a complete restructuring of Microsoft?s whole system infrastructure and represents a major learning challenge for programmers developing applications on Microsoft platforms. There is
more...
Microsoft .NET is an advance in programming technology that greatly simplifies application development, both for traditional, proprietary applications and for the emerging paradigm of Web-based services. .NET is a complete restructuring of Microsoft?s whole system infrastructure and represents a major learning challenge for programmers developing applications on Microsoft platforms. There is
more...
NET Framework using C
Microsoft .NET is an advance in programming technology that greatly simplifies application development, both for traditional, proprietary applications and for the emerging paradigm of Web-based services. .NET is a complete restructuring of Microsoft?s whole system infrastructure and represents a major learning challenge for programmers developing applications on Microsoft platforms. Part of .NET
more...
Microsoft .NET is an advance in programming technology that greatly simplifies application development, both for traditional, proprietary applications and for the emerging paradigm of Web-based services. .NET is a complete restructuring of Microsoft?s whole system infrastructure and represents a major learning challenge for programmers developing applications on Microsoft platforms. Part of .NET
more...
From Binary Research International, Inc.
Implementing and Maintaining Microsoft SQL Server 2005
The training course consists of online, live instructor-led sessions and additional self-paced e-learning content, scenario-based labs, and assessments to provide Participants with the knowledge and skills to manage and maintain Microsoft SQL Server 2005.
Topics include:
SQL Server 2005 Architecture
Preparing to Install SQL Server 2005
Installing SQL Server 2005
Installing and Configuring
more...
From ProTrain Online
MCTS .NET Framework
Microsoft Certified Technology Specialist (MCTS): .NET Framework certifications enable professionals to target specific technologies and to distinguish themselves by demonstrating in-depth knowledge and expertise in the various Microsoft specialized technologies. A MCTS Certification in Microsoft teaches technicians how to implement and maintain databases using specific instructions and
more...
Microsoft Certified Technology Specialist (MCTS): .NET Framework certifications enable professionals to target specific technologies and to distinguish themselves by demonstrating in-depth knowledge and expertise in the various Microsoft specialized technologies. A MCTS Certification in Microsoft teaches technicians how to implement and maintain databases using specific instructions and
more...
From The Virtual Training Company
Oracle Performance Tuning 1Z0-033
VTC author, Gavin Powell, covers material in the 1Z0-033 Oracle 9i tuning certification examination, including the basics of performance tuning and tuning tools. Memory tuning covers the shared pool, the database buffer cache and other buffers. From an I/O perspective, topics covered are physical file structures of the database, tablespaces, datafiles and at the block level. Also covered are
more...
VTC author, Gavin Powell, covers material in the 1Z0-033 Oracle 9i tuning certification examination, including the basics of performance tuning and tuning tools. Memory tuning covers the shared pool, the database buffer cache and other buffers. From an I/O perspective, topics covered are physical file structures of the database, tablespaces, datafiles and at the block level. Also covered are
more...
Oracle Introduction to Oracle SQL and PL SQL
Virtual Training Company's Introduction to Oracle SQL and PL/SQL tutorial will cover the relational Database Model, the Oracle Architecture and the Physical database. The tutorial is aimed at programmers, and individuals who have had prior SQL and relational database experience. Gavin Powell, your instructor, will begin teaching you many Oracle tools such as the SQL Plus, SQL Plus Worksheet, and
more...
Virtual Training Company's Introduction to Oracle SQL and PL/SQL tutorial will cover the relational Database Model, the Oracle Architecture and the Physical database. The tutorial is aimed at programmers, and individuals who have had prior SQL and relational database experience. Gavin Powell, your instructor, will begin teaching you many Oracle tools such as the SQL Plus, SQL Plus Worksheet, and
more...
From Teach Me IT
Implementing an Oracle8 Data Warehouse
Implementing an Oracle8 data warehouse is the second course in the Oracle8 Data Warehousing curriculum. The course provides the users an insight into the functionalities of an Oracle data warehouse and enables them to organize for building a data warehouse. Apart from getting familiar with the concepts of moving and managing data, the users also receive a sound understanding of SQL*Loader, a
more...
Implementing an Oracle8 data warehouse is the second course in the Oracle8 Data Warehousing curriculum. The course provides the users an insight into the functionalities of an Oracle data warehouse and enables them to organize for building a data warehouse. Apart from getting familiar with the concepts of moving and managing data, the users also receive a sound understanding of SQL*Loader, a
more...
Getting Started with SQL Server 2000
The Getting Started with SQL Server 2000 course is the first course in the SQL Server 2000 Database Implementation curriculum. This course introduces the features and components of SQL Server 2000. It describes the architecture of SQL Server 2000 and the various programming tools that are used to work with Transact SQL statements. It also teaches the various methods to create and manage databases
more...
The Getting Started with SQL Server 2000 course is the first course in the SQL Server 2000 Database Implementation curriculum. This course introduces the features and components of SQL Server 2000. It describes the architecture of SQL Server 2000 and the various programming tools that are used to work with Transact SQL statements. It also teaches the various methods to create and manage databases
more...
SQL Server 7.0 - Basics
SQL Server 7.0 - Basics presents the concept of database and tables in SQL Server 7.0. It also covers the tools used to maintain data integrity. This course is the first course of the three courses in the Implementing SQL Server curriculum. The Implementing SQL Server curriculum prepares the students for the Microsoft Certification exam Implementing and Designing Databases with Microsoft SQL
more...
SQL Server 7.0 - Basics presents the concept of database and tables in SQL Server 7.0. It also covers the tools used to maintain data integrity. This course is the first course of the three courses in the Implementing SQL Server curriculum. The Implementing SQL Server curriculum prepares the students for the Microsoft Certification exam Implementing and Designing Databases with Microsoft SQL
more...
VB 6.0 Database Basics
VB 6.0 Database Basics course is the first course of the three courses in the VB Databases curriculum. This curriculum prepares the students for the Microsoft Certified Professional Designing and Implementing Desktop Applications with Microsoft Visual Basic6.0 (70-176) exam. This course teaches students database basics and database creation through a VB application. Also, this course teaches the
more...
VB 6.0 Database Basics course is the first course of the three courses in the VB Databases curriculum. This curriculum prepares the students for the Microsoft Certified Professional Designing and Implementing Desktop Applications with Microsoft Visual Basic6.0 (70-176) exam. This course teaches students database basics and database creation through a VB application. Also, this course teaches the
more...
From Skillspride Online Training
Microsoft SQL Server 7.0 New Features
This intensive course introduces the new features of Microsoft SQL Server 7.0. It covers the issues involved in installing SQL Server 7.0 and upgrading from previous releases; focuses on the improved user interface and data management tools; discusses changes to the security model and application development platform; and summarizes the new design elements and architecture of SQL Server 7.0.
more...
This intensive course introduces the new features of Microsoft SQL Server 7.0. It covers the issues involved in installing SQL Server 7.0 and upgrading from previous releases; focuses on the improved user interface and data management tools; discusses changes to the security model and application development platform; and summarizes the new design elements and architecture of SQL Server 7.0.
more...
From Sessions Online School of Design
database and dynamic web design
Learn the Web technology that powers a million ecommerce sites, enabling dynamic, interactive tools and applications.
In this hands-on 6-lesson course, you'll discover how to create dynamic Web sites using PHP and the MySQL database server. You'll learn the basic language syntax of PHP, how to design and administer a database as part of a relational database system, set up mailing lists, build
more...
Learn the Web technology that powers a million ecommerce sites, enabling dynamic, interactive tools and applications.
In this hands-on 6-lesson course, you'll discover how to create dynamic Web sites using PHP and the MySQL database server. You'll learn the basic language syntax of PHP, how to design and administer a database as part of a relational database system, set up mailing lists, build
more...
online course |
instructor-led class |
learn at home |
group study |
self-directed study |
cd-based training |
DVD video training |
printed book |
e-book digital book |
workshop seminar |
train the trainer |
computer-based learning |
discount pricing |
online tutorial |
