Online Advanced Sql eLearning
Advanced Sql 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 123-CBT Computer Based Training
Advanced Querying in Access 2003
Advanced Querying in Access 2003 Microsoft
To use advanced queries such as joins, parameter, action, and SQL queries
more...
Advanced Querying in Access 2003
Advanced Querying in Access 2003 Microsoft
To use advanced queries such as joins, parameter, action, and SQL queries
more...
Advanced Data Management in Access 2007
Advanced Data Management in Access 2007 Microsoft
You can use Microsoft Access 2007 to manage your data efficiently using advanced techniques. There are many advanced methods that can be used for modifying and enhancing tables, reports, queries, and forms in order to meet your business needs. This course explains and demonstrates retrieving and validating data, using subforms and subreports,
more...
Advanced Data Management in Access 2007 Microsoft
You can use Microsoft Access 2007 to manage your data efficiently using advanced techniques. There are many advanced methods that can be used for modifying and enhancing tables, reports, queries, and forms in order to meet your business needs. This course explains and demonstrates retrieving and validating data, using subforms and subreports,
more...
Performing Advanced Query Techniques in SQL Server 2008
Performing Advanced Query Techniques in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433)
Transact-SQL offers advanced query techniques, such as built-in aggregate, scalar, and ranking functions, and common table expressions to manipulate the result set for a query. To manipulate the result sets and generate rollup
more...
Performing Advanced Query Techniques in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433)
Transact-SQL offers advanced query techniques, such as built-in aggregate, scalar, and ranking functions, and common table expressions to manipulate the result set for a query. To manipulate the result sets and generate rollup
more...
From Online Training Directory
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...
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...
From 123-CBT Computer Based Training
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...
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...
Oracle Workflow 11i10 Managing Customizing Workflow Processes
This course covers features, types, and attributes of PL/SQL documents. It also covers how to include PL/SQL documents in messages. Further, it covers forced synchronous processes, selector/callback functions, standard API used to define selector/callback functions, and the code to define a selector/callback function. It also covers master/detail coordination activities. In addition, it covers how
more...
This course covers features, types, and attributes of PL/SQL documents. It also covers how to include PL/SQL documents in messages. Further, it covers forced synchronous processes, selector/callback functions, standard API used to define selector/callback functions, and the code to define a selector/callback function. It also covers master/detail coordination activities. In addition, it covers how
more...
Oracle Workflow 11i10 Interacting with Processes Notifications
Oracle users and end users with knowledge of Oracle 9i SQL and PL/SQL, navigating Oracle Applications 11i, and Oracle 11i E-Business Essentials for Implementers.
Learn To:
Identify options for testing a workflow process.
Identify options for administering workflow processes by using the Administrator Monitor.
Identify options for administering workflow processes by using the
more...
Oracle users and end users with knowledge of Oracle 9i SQL and PL/SQL, navigating Oracle Applications 11i, and Oracle 11i E-Business Essentials for Implementers.
Learn To:
Identify options for testing a workflow process.
Identify options for administering workflow processes by using the Administrator Monitor.
Identify options for administering workflow processes by using the
more...
Oracle Workflow 11i10 Developing Processes
This course covers the steps to diagram and create a workflow process. It also covers the steps to define item types, process activities, item type attributes, lookup types and lookup codes, messages, message attributes, and notifications activities. In addition, it covers the features of item type attributes, notification activities, and embedded regions. Finally, it covers special message
more...
This course covers the steps to diagram and create a workflow process. It also covers the steps to define item types, process activities, item type attributes, lookup types and lookup codes, messages, message attributes, and notifications activities. In addition, it covers the features of item type attributes, notification activities, and embedded regions. Finally, it covers special message
more...
Oracle Database 10g SQL Fundamentals I Part 2
In this course, the learner will learn how to use the advanced features of SQL, such as advanced querying and reporting, schema objects, manipulating large data sets, and storing and retrieving dates according to different time zones. The learner will also learn the concepts of controlling access and privileges for schema objects and using advanced subqueries. .
Learn To:
Identify
more...
In this course, the learner will learn how to use the advanced features of SQL, such as advanced querying and reporting, schema objects, manipulating large data sets, and storing and retrieving dates according to different time zones. The learner will also learn the concepts of controlling access and privileges for schema objects and using advanced subqueries. .
Learn To:
Identify
more...
Oracle Database 10g SQL Fundamentals I Part 1
In this course, learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Additionally, the learners will be introduced to the powerful SQL programming language and its features.
Learn To:
Match the different phases of system development life cycle (SDLC) with their features.
Identify features of an Entity Relationship
more...
In this course, learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Additionally, the learners will be introduced to the powerful SQL programming language and its features.
Learn To:
Match the different phases of system development life cycle (SDLC) with their features.
Identify features of an Entity Relationship
more...
Oracle SQL and SQL Plus Advanced SELECT Statements
...rse is the first course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition, this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries.
L earn To:
Write single-row subqueries.
Write
more...
...rse is the first course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition, this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries.
L earn To:
Write single-row subqueries.
Write
more...
Oracle SQL and SQL Plus SQL Plus and Reporting
...is is the second course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the fundamental concepts of SQL*Plus and queries using SQL*Plus runtime variables. In addition, this course explores saving customizations and enhancing query output.
L earn To:
Identify the fundamental concepts of SQL*Plus and write queries using SQL*Plus
more...
...is is the second course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the fundamental concepts of SQL*Plus and queries using SQL*Plus runtime variables. In addition, this course explores saving customizations and enhancing query output.
L earn To:
Identify the fundamental concepts of SQL*Plus and write queries using SQL*Plus
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...
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 - Implementing a Database - Part 3
Course Overview This is the third course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0. L earn To: Query multiple tables using Transact-SQL statements. Retrieve and modify data using advanced query techniques. C ontent Emphasis Skills-Based A udience This course is designed for IT
more...
Course Overview This is the third course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0. L earn To: Query multiple tables using Transact-SQL statements. Retrieve and modify data using advanced query techniques. C ontent Emphasis Skills-Based A udience This course is designed for IT
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4
Course Overview This is the fourth 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 methods of aggregating and accessing data from relational data structures; identify the methods of data
more...
Course Overview This is the fourth 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 methods of aggregating and accessing data from relational data structures; identify the methods of data
more...
SQL and PL SQL PL SQL Basics
Course Overview This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.
more...
Course Overview This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.
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...
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...
Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3
Course Overview This is the third course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential
more...
Course Overview This is the third course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential
more...
IBM DB2 Universal Database V6 1 App Devel Curriculum
Course Overview The Complete IBM DB2 Universal Database V6.1 Application Development Curriculum includes the courses needed to prepare for IBM Certified Solutions Expert certification exams 509 and 511. Students will learn fundamental DB2 v6.1 skills and knowledge, such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of
more...
Course Overview The Complete IBM DB2 Universal Database V6.1 Application Development Curriculum includes the courses needed to prepare for IBM Certified Solutions Expert certification exams 509 and 511. Students will learn fundamental DB2 v6.1 skills and knowledge, such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of
more...
IBM DB2 Universal Database V6 1 App Devel Curriculum
Course Overview The Complete IBM DB2 Universal Database V6.1 Application Development Curriculum includes the courses needed to prepare for IBM Certified Solutions Expert certification exams 509 and 511. Students will learn fundamental DB2 v6.1 skills and knowledge, such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of
more...
Course Overview The Complete IBM DB2 Universal Database V6.1 Application Development Curriculum includes the courses needed to prepare for IBM Certified Solutions Expert certification exams 509 and 511. Students will learn fundamental DB2 v6.1 skills and knowledge, such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of
more...
Enterprise Connectivity with J2EE V1 4 JAXP and JDBC
This course will address the core and advanced features of J2EE SDK 1.4. Enterprise Connectivity.
Learn To:
Match terms used in XML with their descriptions.
Identify features of Simple API for XML (SAX) parsing.
Identify actions performed by Simple API for XML (SAX) events that are fired when XML document items are parsed.
Match features of JDBC with the application
more...
This course will address the core and advanced features of J2EE SDK 1.4. Enterprise Connectivity.
Learn To:
Match terms used in XML with their descriptions.
Identify features of Simple API for XML (SAX) parsing.
Identify actions performed by Simple API for XML (SAX) events that are fired when XML document items are parsed.
Match features of JDBC with the application
more...
Enterprise Connectivity with J2EE V1 4 JAXP and JDBC
This course will address the core and advanced features of J2EE SDK 1.4. Enterprise Connectivity.
Learn To:
Match terms used in XML with their descriptions.
Identify features of Simple API for XML (SAX) parsing.
Identify actions performed by Simple API for XML (SAX) events that are fired when XML document items are parsed.
Match features of JDBC with the application
more...
This course will address the core and advanced features of J2EE SDK 1.4. Enterprise Connectivity.
Learn To:
Match terms used in XML with their descriptions.
Identify features of Simple API for XML (SAX) parsing.
Identify actions performed by Simple API for XML (SAX) events that are fired when XML document items are parsed.
Match features of JDBC with the application
more...
CIW Dynamic Server Pages Part 1
Course Overview This is the first course in a three part series that introduces students to PHP Hypertext Processor and provides the foundational knowledge for the course series. Additionally, this course will cover an introduction to PHP, PHP fundamentals, string manipulation and file input/output, and PHP and databases. Learn To • Identify PHP. • Identify the basic and
more...
Course Overview This is the first course in a three part series that introduces students to PHP Hypertext Processor and provides the foundational knowledge for the course series. Additionally, this course will cover an introduction to PHP, PHP fundamentals, string manipulation and file input/output, and PHP and databases. Learn To • Identify PHP. • Identify the basic and
more...
CIW Database Specialist Part 4 Advanced JDBC
This is the final course in a four part series that teaches metadata, improving JDBC programs, and building applications using JDBC. Topics covered include introduction to metadata and to ResultSetMetaData, SQL exceptions, scrollable and updateable result sets, batch updates, and prepared statements. Finally, the Building Applications Using JDBC teaches about Swing, the Layout Manager, UML and
more...
This is the final course in a four part series that teaches metadata, improving JDBC programs, and building applications using JDBC. Topics covered include introduction to metadata and to ResultSetMetaData, SQL exceptions, scrollable and updateable result sets, batch updates, and prepared statements. Finally, the Building Applications Using JDBC teaches about Swing, the Layout Manager, UML and
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 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...
From Sql Server Online Training
ONLINE MSBI - SSIS SSAS and SSRS training with Project
Hi Everyone!
Are you looking for the best PRACTICAL Online Training & Projects in Microsoft Business Intelligence(MSBI)? Here you are.
You reached the right place. We at SQL School, provide you in depth training on SSIS, SSAS and SSRS modules of MS BI process. Furthermore, we will also provide you one Real time Project along with documentation and implementation (solution) so that you can
more...
Hi Everyone!
Are you looking for the best PRACTICAL Online Training & Projects in Microsoft Business Intelligence(MSBI)? Here you are.
You reached the right place. We at SQL School, provide you in depth training on SSIS, SSAS and SSRS modules of MS BI process. Furthermore, we will also provide you one Real time Project along with documentation and implementation (solution) so that you can
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...
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...
Subqueries Reporting and User-Access Control in Oracle 9i
To describe the use of subqueries, reporting, and user-access control in an Oracle9i database Junior database administrators, application developers, and database operators
more...
To describe the use of subqueries, reporting, and user-access control in an Oracle9i database Junior database administrators, application developers, and database operators
more...
Administering Data Placement in a DB2 UDB
To describe the administration and placement of data in a DB2 UDB database Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
more...
To describe the administration and placement of data in a DB2 UDB database Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
more...
Accessing Data and Manipulating DB2 UDB Database Objects
To access data and manipulate database objects Anyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certification
more...
To access data and manipulate database objects Anyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certification
more...
Manipulating Data with DB2 UDB
To execute queries using SQL Anyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certification
more...
To execute queries using SQL Anyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certification
more...
Monitoring a DB2UDB
To explain how to monitor a DB2 UDB Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
more...
To explain how to monitor a DB2 UDB Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
more...
Office XP for the Advanced User
To provide an overview of the new features and feature enhancements in the following Microsoft Office XP applications - Access, Publisher, FrontPage, and SharePoint Team Services Advanced end-user
more...
To provide an overview of the new features and feature enhancements in the following Microsoft Office XP applications - Access, Publisher, FrontPage, and SharePoint Team Services Advanced end-user
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...
Advanced Querying in Access 2003
To use advanced queries such as joins, parameter, action, and SQL queries Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003
more...
To use advanced queries such as joins, parameter, action, and SQL queries Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003
more...
Oracle Applications Release 11i: Workflow - Part 1
Oracle Applications Release 11i: Workflow - Part 1 course introduces the learner to the architecture and advanced notification components of Oracle Workflow 2.5. In this course, the learner will gain an insight into the use of Workflow in business processes and methods for planning and creating a Workflow process. Oracle Workflow gives end users and technical personnel the ability to automate and
more...
Oracle Applications Release 11i: Workflow - Part 1 course introduces the learner to the architecture and advanced notification components of Oracle Workflow 2.5. In this course, the learner will gain an insight into the use of Workflow in business processes and methods for planning and creating a Workflow process. Oracle Workflow gives end users and technical personnel the ability to automate and
more...
JDBC Application Development Part 3: Advanced Features, OOAD and SQLJ
This third course in the series teaches learners skills needed to help them create more advanced databases. It teaches advanced features for creating JDBC programs, including prepared statements, stored procedures, transactions, concurrency control, and metadata. It also teaches how to map an object-oriented design to a relational database and how to use SQLJ standards with Java.
more...
This third course in the series teaches learners skills needed to help them create more advanced databases. It teaches advanced features for creating JDBC programs, including prepared statements, stored procedures, transactions, concurrency control, and metadata. It also teaches how to map an object-oriented design to a relational database and how to use SQLJ standards with Java.
more...
Creating Queries Forms with Access 2002
The Creating Queries and Forms with Access 2002 WBT is the second course of the Office XP: Access 2002 curriculum, which familiarizes users with the advanced features of Access 2002 that they can use while retrieving and presenting data stored in an Access database. These features include formulating simple and advanced SQL queries, and creating and designing forms. Additionally, this course
more...
The Creating Queries and Forms with Access 2002 WBT is the second course of the Office XP: Access 2002 curriculum, which familiarizes users with the advanced features of Access 2002 that they can use while retrieving and presenting data stored in an Access database. These features include formulating simple and advanced SQL queries, and creating and designing forms. Additionally, this course
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 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...
IBM DB2 UDB Essentials Part 4 - Advanced SQL
This course teaches the learner how to make use of advanced SQL techniques to access DB2 databases in different environments. Indepth coverage is given to creating SQL objects Case CAST and Summary Tables Joins Subqueries Scalar Functions Recursive SQL UDTs/UDFs and general performance guidelines. It is appropriate for learners working in all DB2 environments that is OS/390 VM/VSE AS/400 UNIX
more...
This course teaches the learner how to make use of advanced SQL techniques to access DB2 databases in different environments. Indepth coverage is given to creating SQL objects Case CAST and Summary Tables Joins Subqueries Scalar Functions Recursive SQL UDTs/UDFs and general performance guidelines. It is appropriate for learners working in all DB2 environments that is OS/390 VM/VSE AS/400 UNIX
more...
SQL Server 7.0 Database Admin. Part I
This course builds upon previous courses by covering database management and provides a foundation for advanced courses on data warehousing client/server application development and SQL to IIS active server pages. Related Exams: Prepares users for both Microsoft Exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029 Designing and Implementing Databases with Microsoft SQL Server 7.0.
more...
This course builds upon previous courses by covering database management and provides a foundation for advanced courses on data warehousing client/server application development and SQL to IIS active server pages. Related Exams: Prepares users for both Microsoft Exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029 Designing and Implementing Databases with Microsoft SQL Server 7.0.
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 Management Part III
This course explains how to design a logical model of a database and identifies the components to use in order to organize and access a SQL Server database. It describes the advanced programmatic features of the SQL language which can be used to extend the functionality of SQL stored procedures.Additionally this course examines the functions of a SQL cursor including how to navigate a result set
more...
This course explains how to design a logical model of a database and identifies the components to use in order to organize and access a SQL Server database. It describes the advanced programmatic features of the SQL language which can be used to extend the functionality of SQL stored procedures.Additionally this course examines the functions of a SQL cursor including how to navigate a result set
more...
SQL Server 7.0 Advanced Features Part I
This course describes this integration with Microsoft Office 2000 and Visual Studio. The course presents advanced failover support methods including server cluster management warm spares and redundant hardware. In addition it outlines linked and remote servers and techniques to manage transactions distributed over these servers. The course topics outline the syntax and function of advanced
more...
This course describes this integration with Microsoft Office 2000 and Visual Studio. The course presents advanced failover support methods including server cluster management warm spares and redundant hardware. In addition it outlines linked and remote servers and techniques to manage transactions distributed over these servers. The course topics outline the syntax and function of advanced
more...
SQL Server 7.0 Advanced Features Part II
This course describes this integration with Microsoft Office 2000 and Visual Studio. The course presents advanced failover support methods including server cluster management warm spares and redundant hardware. In addition It outlines linked and remote servers and techniques to manage transactions distributed over these servers. The course topics outline the syntax and function of advances
more...
This course describes this integration with Microsoft Office 2000 and Visual Studio. The course presents advanced failover support methods including server cluster management warm spares and redundant hardware. In addition It outlines linked and remote servers and techniques to manage transactions distributed over these servers. The course topics outline the syntax and function of advances
more...
CIW Database Specialist Part 4: Advanced JDBC
This is the final course in a four part series that teaches metadata improving JDBC programs and building applications using JDBC. Topics covered include introduction to metadata and to ResultSetMetaData SQL exceptions scrollable and updatable result sets batch updates and prepared statements. Finally the Building Applications Using JDBC teaches about Swing the Layout Manager UML and Application
more...
This is the final course in a four part series that teaches metadata improving JDBC programs and building applications using JDBC. Topics covered include introduction to metadata and to ResultSetMetaData SQL exceptions scrollable and updatable result sets batch updates and prepared statements. Finally the Building Applications Using JDBC teaches about Swing the Layout Manager UML and Application
more...
Advanced Oracle PL/SQL: Design Considerations and Object Types
This course introduces students to subtypes subprograms cursor variables and the NOCOPY parameter used in advanced function definitions and packages. Students also learn about object types data dictionary views and collections.
more...
This course introduces students to subtypes subprograms cursor variables and the NOCOPY parameter used in advanced function definitions and packages. Students also learn about object types data dictionary views and collections.
more...
Advanced Oracle PL/SQL: Implementation and Advanced Features
This course introduces students to advanced interface methods practices and techniques that improve the efficiency and performance of PL/SQL operations. Students also learn about essential Oracle supplied packages that are commonly used in developing applications.
more...
This course introduces students to advanced interface methods practices and techniques that improve the efficiency and performance of PL/SQL operations. Students also learn about essential Oracle supplied packages that are commonly used in developing applications.
more...
Oracle SQL and SQL*Plus: Advanced SELECT Statements
This course is the first course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries.
more...
This course is the first course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries.
more...
SQL Advanced Skills
This course is the second course in the SQL Programming curriculum that consists of two courses. The course describes the statements used to manipulate data and to work with tables, indexes, and views. The students will also be able to describe the functioning of cursors, stored procedures, triggers, and transactions.
more...
This course is the second course in the SQL Programming curriculum that consists of two courses. The course describes the statements used to manipulate data and to work with tables, indexes, and views. The students will also be able to describe the functioning of cursors, stored procedures, triggers, and transactions.
more...
SQL Queries
Describes SQL querying from simple one column, one table queries to advanced joining and merging of data from multiple tables.
more...
Describes SQL querying from simple one column, one table queries to advanced joining and merging of data from multiple tables.
more...
MS SQL Server 6.5: Advanced Retrieval Structures
In this course, students will learn to implement a database design on Microsoft SQL Server 6.5. Specific topics include: summarizing and modifying data; database object creation, such as stored procedures and triggers; data referential integrity; the implementation of distributed data in a client/server environment; and the extensibility of SQL Server. This course, together with MS SQL Server
more...
In this course, students will learn to implement a database design on Microsoft SQL Server 6.5. Specific topics include: summarizing and modifying data; database object creation, such as stored procedures and triggers; data referential integrity; the implementation of distributed data in a client/server environment; and the extensibility of SQL Server. This course, together with MS SQL Server
more...
Advanced SQL Programming
This course teaches the student how to create stored procedures, manage distributed data and transactions. The student will also learn the importance of locks and how to troubleshoot a deadlock. Finally the student will learn how to optimize the query execution plan developed by SQL Server. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 70-029.
more...
This course teaches the student how to create stored procedures, manage distributed data and transactions. The student will also learn the importance of locks and how to troubleshoot a deadlock. Finally the student will learn how to optimize the query execution plan developed by SQL Server. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 70-029.
more...
From Sessions College for Professional 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...
From Braini Academic
LPI Linux 102
Officially approved by the Linux Professional Institute (LPI).
This course builds on our "LPI Linux 101" course, fleshing out some of the more advanced Linux system administration knowledge and preparing you to ace the second exam needed to achieve LPIC-1 certification.
As in our other Linux courses, you work extensively on real-world simulations, so you gain the hands-on experience needed
more...
Officially approved by the Linux Professional Institute (LPI).
This course builds on our "LPI Linux 101" course, fleshing out some of the more advanced Linux system administration knowledge and preparing you to ace the second exam needed to achieve LPIC-1 certification.
As in our other Linux courses, you work extensively on real-world simulations, so you gain the hands-on experience needed
more...
From Futurepoint Technologies
Obiee 11g Online Training FUTUREPOINT Technologies
OBIEE 11g Reports and Dashboards Development
Topic #1 Creating Reports Using Analysis
Topic # 2 Filtering, Totals, and Formatting Views
Topic # 3 Charts and Formatting
Topic # 4 Building Pivot Table
Topic # 5 Adding Calculations and Data Formatting
Topic # 6 Creating Bins
Topic #7 Conditional Formatting
Topic #8 Advanced Formatting of Tabular Views
Topic #9 Column Selector View
more...
From ITAcademy. IN
Best Online Trainings from ITAcademyIN on NETSHAREPOINTMSBISQL SERVERORACLE
Best Online Training from ITAcademy. IN on all Microsoft Technologies.
Download our trainer's live sessions by using the below links.
.NET 3. 5 Demo :
http://www. megaupload. com/?d=R9OHHHRA
MSBI 2008 Demo
http://megaupload. com/?d=0IYL8C9H
Sharepoint 2007 Demo
http://www. megaupload. com/?d=QE97GHBN
You may need a CODEC , that can be downloaded from the below location, to play the
more...
From The Virtual Training Company
Oracle Database Administration Fundamentals II
Oracle Database Administration Fundamentals II is the third in a series of four courses covering Oracle Certification course #1Z0-032, and more. Like the other courses in this series of Oracle Certification titles, this course teaches and demonstrates by example using thoroughly tested examples. In this course, instructor Gavin Powell covers Oracle Net Services, Backup and Recovery including RMAN,
more...
Oracle Database Administration Fundamentals II is the third in a series of four courses covering Oracle Certification course #1Z0-032, and more. Like the other courses in this series of Oracle Certification titles, this course teaches and demonstrates by example using thoroughly tested examples. In this course, instructor Gavin Powell covers Oracle Net Services, Backup and Recovery including RMAN,
more...
From Skillspride Online Training
Informix SQL Advanced
This course will provide the reader with the knowledge to control database security and integrity, perform advanced database queries, optimise query efficiently and control the database within the UNIX environment
more...
This course will provide the reader with the knowledge to control database security and integrity, perform advanced database queries, optimise query efficiently and control the database within the UNIX environment
more...
Microsoft Windows NT 4 Networking Technologies
At the end of the Course readers will be able to understand the role of an NT Workstation and NT Server Administrator; formulate policies to restrict access to secure information and systems; formulate policies to properly manage backup of data; understand User Rights and their implications for security; understand Access Control Lists and how they can be used to restrict access to secure data and
more...
At the end of the Course readers will be able to understand the role of an NT Workstation and NT Server Administrator; formulate policies to restrict access to secure information and systems; formulate policies to properly manage backup of data; understand User Rights and their implications for security; understand Access Control Lists and how they can be used to restrict access to secure data and
more...
Microsoft Visual Basic 5.0 Client Server Development
This course teaches the skills required to develop client server applications using MS Visual Basic 5.0 Enterprise Edition. Readers will understand ODBC and OLE DB and the different methods available in VB 5.0 for accessing data. They will learn how to use DAO, RDO and ADO plus how to use objects in Visual Basic. Readers will create ActiveX Components and deploy them on a Network using DCOM.
more...
This course teaches the skills required to develop client server applications using MS Visual Basic 5.0 Enterprise Edition. Readers will understand ODBC and OLE DB and the different methods available in VB 5.0 for accessing data. They will learn how to use DAO, RDO and ADO plus how to use objects in Visual Basic. Readers will create ActiveX Components and deploy them on a Network using DCOM.
more...
Microsoft SQL Server 2000; Introduction to Databases and Programming
This course introduces readers to the major topics of databases and programming using Microsoft SQL Server 2000. The reader will learn about system databases, tables, data definition, creating tables, retrieving data, modifying data, indices, data integrity, views, triggers, stored procedures, programmability, distributed data and distributed transactions. Throughout the course there are practical
more...
This course introduces readers to the major topics of databases and programming using Microsoft SQL Server 2000. The reader will learn about system databases, tables, data definition, creating tables, retrieving data, modifying data, indices, data integrity, views, triggers, stored procedures, programmability, distributed data and distributed transactions. Throughout the course there are practical
more...
Microsoft SQL Server 2000 Administration
This intensive course will introduce readers to administration of Microsoft SQL Server 2000 databases. The general objective of the course is to install SQL Server, create databases, import data, set up security, automate jobs and alerts, set up replication and create a robust backup regime.
more...
This intensive course will introduce readers to administration of Microsoft SQL Server 2000 databases. The general objective of the course is to install SQL Server, create databases, import data, set up security, automate jobs and alerts, set up replication and create a robust backup regime.
more...
Microsoft SQL Server 2000 Programming Part 1
This course along with our " SQL Server 2000 Programming Part 2 course will introduce readers to the major topics of building database applications with Microsoft SQL Server 2000. The key focus of the course is on server database design and implementation using SQL Server 2000, but it also covers some client development including Access 2000's ADP format, Visual Basic using ADO, and ASP with XML.
more...
This course along with our " SQL Server 2000 Programming Part 2 course will introduce readers to the major topics of building database applications with Microsoft SQL Server 2000. The key focus of the course is on server database design and implementation using SQL Server 2000, but it also covers some client development including Access 2000's ADP format, Visual Basic using ADO, and ASP with XML.
more...
Microsoft SQL Server 2000 Programming Part 2
This course along with our " SQL Server 2000 Programming Part 1 course will introduce readers to the major topics of building database applications with Microsoft SQL Server 2000. The key focus of the course is on server database design and implementation using SQL Server 2000, but it also covers some client development including Access 2000's ADP format, Visual Basic using ADO, and ASP with XML.
more...
This course along with our " SQL Server 2000 Programming Part 1 course will introduce readers to the major topics of building database applications with Microsoft SQL Server 2000. The key focus of the course is on server database design and implementation using SQL Server 2000, but it also covers some client development including Access 2000's ADP format, Visual Basic using ADO, and ASP with XML.
more...
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...
Microsoft SQL Server 7.0 Administration
SQL Server is a scaleable RDBMS designed for client/server applications. This course will prepare Database Administrators to set up and maintain MS SQL systems in a networked environment. It provides both the theory and practical experience of installing, backing up, replicating and monitoring and tuning an SQL Server 7.0 system.
more...
SQL Server is a scaleable RDBMS designed for client/server applications. This course will prepare Database Administrators to set up and maintain MS SQL systems in a networked environment. It provides both the theory and practical experience of installing, backing up, replicating and monitoring and tuning an SQL Server 7.0 system.
more...
Microsoft SQL Server 7.0 Programming Part 1
This intensive course is designed to introduce new MS SQL developers to some of the more advanced features and facilities of this software. To encourage confidence, control and creative use of MS SQL by taking a structured look at some of the more advanced functions. To help developers plan their applications systematically, efficiently and economically and to promote good design and development
more...
This intensive course is designed to introduce new MS SQL developers to some of the more advanced features and facilities of this software. To encourage confidence, control and creative use of MS SQL by taking a structured look at some of the more advanced functions. To help developers plan their applications systematically, efficiently and economically and to promote good design and development
more...
Microsoft SQL Server 7.0 Programming Part 2
This intensive course is designed to introduce new MS SQL developers to some of the more advanced features and facilities of this software. To encourage confidence, control and creative use of MS SQL by taking a structured look at some of the more advanced functions. To help developers plan their applications systematically, efficiently and economically and to promote good design and development
more...
This intensive course is designed to introduce new MS SQL developers to some of the more advanced features and facilities of this software. To encourage confidence, control and creative use of MS SQL by taking a structured look at some of the more advanced functions. To help developers plan their applications systematically, efficiently and economically and to promote good design and development
more...
Microsoft SQL Server 6.5 Introduction
At the end of the course, readers will be able to install and configure SQL Server version 6.5; manage the storage requirements of a database and perform day-to-day operations including backing up and restoring a database, recovering from a system disaster, scheduling tasks, setting alerts, monitoring, and tuning. The basics of Transact SQL are also covered.
more...
At the end of the course, readers will be able to install and configure SQL Server version 6.5; manage the storage requirements of a database and perform day-to-day operations including backing up and restoring a database, recovering from a system disaster, scheduling tasks, setting alerts, monitoring, and tuning. The basics of Transact SQL are also covered.
more...
Microsoft SQL Server 6.5 Administration
SQL Server is a scaleable RDBMS designed for client/server applications. This course will prepare Database Administrators to set up and maintain an MSSQL systems in a networked environment. It provides both the theory and practical experience of installing, backing up, replicating and monitoring and tuning an SQL Server 6.x system.
more...
SQL Server is a scaleable RDBMS designed for client/server applications. This course will prepare Database Administrators to set up and maintain an MSSQL systems in a networked environment. It provides both the theory and practical experience of installing, backing up, replicating and monitoring and tuning an SQL Server 6.x system.
more...
Microsoft SQL Server 6.5 Programming
This intensive course is designed to introduce new MS SQL developers to some of the more advanced features and facilities of this software; to encourage confidence, control and creative use of MS SQL by taking a structured look at some of the more advanced functions to help developers plan their applications systematically, efficiently and economically; to promote good design and development
more...
This intensive course is designed to introduce new MS SQL developers to some of the more advanced features and facilities of this software; to encourage confidence, control and creative use of MS SQL by taking a structured look at some of the more advanced functions to help developers plan their applications systematically, efficiently and economically; to promote good design and development
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 |
