Online Datatypes eLearning
Datatypes Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Advanced Schemas

Advanced Schemas
To enhance schemas with user-defined datatypes and namespaces
more...
Advanced Schemas
Oracle SQL Specifics Retrieving and Formatting Data

...nd a datatype conversion function to match the number and datatypes in a compound query.
Use the ORDER BY clause to sort a compound query.
Unit 5: Utilizing Subqueries
Duration: 1 Hour(s)
Perform a query with an embedded subquery.
Perform a query with a subquery embedded in a FROM clause.
Perform a query with a multiple column subquery.
Perform a query with a correlated
more...
Oracle SQL Specifics Creating and Managing Database Objects

...aming tables and columns.
Identify the four most common datatypes used in the Oracle8 database.
Match the five Oracle8 data integrity constraints with their descriptions.
Identify the default constraint name generated by Oracle8.
Use the CREATE TABLE statement to create a table with integrity constraints.
Use the ALTER TABLE statement with the ADD clause to add a column to a table.
more...
SQL and PL SQL PL SQL Basics

...tand the PL/SQL program constructs. Identify the PL/SQL datatypes Identify how to declare PL/SQL variables and identify the PL/SQL programming conventions. Retrieve and manipulate data from the database by using PL/SQL commands Identify features and attributes of SQL cursors, and manage transactions. Use the IF-THEN-ELSE and IF-THEN-ELSIF conditional constructs and the Basic loop, FOR
more...
Oracle8i Database Admin Manage Data Storage

... Identify the characteristics of various tables and datatypes. Identify and manage tables. Identify the characteristics and types of triggers and constraints. Identify and maintain data integrity. Identify clusters and index-organized tables (IOTs). Identify and reorganize data. C ontent Emphasis Skills-Based A udience Database Administrators, System
more...
Oracle 11i 2 6 Implement Workflow Fundamentals Part 3

The course deals with fundamentals Oracle Workflow 2.6, which is provided by Oracle E-Business Suite for Oracle Application 11i. Oracle Workflow enables you to create, modify and automate business processes. In part 3, you will learn about Activities, Events, and Workflow APIs.
Learn To:
Identify the steps to define a function activity.
Identify tasks to be performed to define
more...
Oracle9i SQL Basic SELECT Statements

...clause. o Write a WHERE clause to accommodate different datatypes. o Use comparison operators with the WHERE clause. o Identify the different categories of datatypes. o Match the character datatypes with their descriptions. o Identify the features of the NUMBER datatype. Audience The target audience for this course includes database administrators and application developers. This
more...
Oracle9i SQL DML and DDL

The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table.
more...
Oracle9i Database Admin Manage Data Storage

...le database. Identify the features of the Oracle datatypes and ROWID. Identify the guidelines for creating tables and the situations resulting in row chaining, and create tables. Identify the characteristics of table parameters and high-water mark, change the parameter value, manually allocate extents, validate table structure and detect row migration.
more...
Database Technologies Introduction to SQL

... Identify the guidelines for naming tables as well as the datatypes and constraints available for table creation. o Identify how to create, alter, and delete database tables. o Identify the data manipulation commands (INSERT, UPDATE, and DELETE) as well as the transaction control commands (COMMIT and ROLLBACK). o Identify the general overview of views and indexes, including how to create
more...
Oracle8 Database Administration - Manage Data

...
Identify the characteristics of various tables and datatypes.
Create and manage tables.
Retrieve table information from the data dictionary.
Identify the characteristics and types of triggers and constraints.
Implement and maintain data integrity.
Retrieve information from the data dictionary.
Implement clusters and index-organized tables (IOTs).
Load
more...
From Serebra Learning Corporation
VBScript - Elements Arrays Procedures and Program Flow
To explain the capabilities of the VBScript programming language and the use of arrays, procedures, loops, and conditional statements in a VBScript program System administrators; web developers; application developers
more...
ANSI C Programming Introducing C
To familiarize students with the capabilities of the ANSI C language and to enable them to write useful C programs Programmers and software developers new to ANSI C
more...
ANSI C Programming Data Representation
To describe how ANSI C programs use memory to store data and how to write portable C programs Programmers and software developers new to ANSI C
more...
ANSI C Programming Expressions
To describe the syntax rules governing expressions and statements in ANSI C and how to to use expressions and statements Programmers and software developers new to ANSI C
more...
ANSI C Programming Pointers
To describe how to write advanced, efficient ANSI C programs using pointers Programmers and software developers new to ANSI C
more...
C Programming Structured Programming
To provide the student with structured programming concepts used in C Students with knowledge of structured programming techniques
more...
Tables and Indexes in Oracle9i
To describe how to manage tables and indexes in an Oracle9i database Anyone wanting to learn about Oracle9i database administration
more...
Introducing Oracle9i Database
To introduce the components and architecture of Oracle9i, the application of Oracle9i, and migrating and upgrading to Oracle9i Oracle database administrators; developers interested in the technical aspects of Oracle9i database
more...
Development Platform in Oracle9i
To explain the Oracle9i database enhancements that support the Oracle9i database development platform Database operators, administrators, and developers interested in the new technical features and benefits of an Oracle9i database
more...
Using Globalization Support in Oracle 10g
To outline the considerations and procedures for globalizing a database Oracle database administrators and database operators
more...
Group and Datetime Functions in Oracle Database 10g
To demonstrate how to use group and datetime functions in Oracle 10g Database administrators, application developers, and database operators
more...
SQL Server 2000 Databases
To describe how to create and modify SQL Server 2000 databases Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
JavaScript Fundamentals
This course describes the features of JavaScript and compares JavaScript with other technologies, such as Java. The course also covers the fundamentals of JavaScript programming, JavaScript variables, operators, loops, and conditional statements. This course is designed for application developers and authors who plan, design and implement web-based business solutions on intranets, extranets, and
more...
Programming in PERL 5
This is the first course in the CGI/PERL curriculum. It introduces the users to fundamentals of PERL programming. The course describes the datatypes, operators, arrays, hashes, loops and functions in PERL. The users will be able to rectify errors and implement the OOP features in PERL. Web programmers, who want to implement HTML forms with WEB databases, and process HTML form values.
more...
Oracle 8i PL/SQL - Database Objects and Security
This course is aimed at familiarizing the learner with the inbuilt objects and security options in Oracle. The course includes creating and managing sequences indexes and users. It also includes PL/SQL block PL/SQL records and tables PL/SQL variables and datatypes. Related Exam: Oracle Exam #1Z0-001: Introduction to Oracle: SQL and PL/SQL.
more...
Oracle 8i PL/SQL - Oracle PL/SQL Basic Operations
... the basic concepts of PL/SQL. It describes the different datatypes and variables available with PL/SQL. The course provides an overview of PL/SQL records and tables and explains how to access a database from PL/SQL. It also describes the steps to write conditional constructs and controlling structures in PL/SQL along with different types of explicit cursors and their controlling parameters.
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.
more...
From The Virtual Training Company
Microsoft Access 2002
Virtual Training Company author Dave Mercer teaches database users the fundamentals of Microsoft Access 2002. Whether an advanced, or first time database user, Access 2002 delivers powerful tools for managing and analyzing data. Learn efficient database design, how to create effective tables, and the secrets of querying. Learn the logistics of datatypes and Auto-number fields. Also, learn how to
more...
