Online Null eLearning Training
 online course |
 instructor led class |
 learn at home |
 group study |
 self directed training |
 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 Serebra Learning Corporation
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...
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 123-CBT Computer Based Training
Oracle9i SQL Data Retrieval Techniques
...tatements that contain common group functions. o Manage null values when using group functions in a SQL statement. o Identify the requirements for using subqueries. o Identify the characteristics of each subquery type. o Write a single-row subquery to return one row in the WHERE clause of a SELECT statement. o Identify the characteristics of substitution variables. o Prompt the user
more...
...tatements that contain common group functions. o Manage null values when using group functions in a SQL statement. o Identify the requirements for using subqueries. o Identify the characteristics of each subquery type. o Write a single-row subquery to return one row in the WHERE clause of a SELECT statement. o Identify the characteristics of substitution variables. o Prompt the user
more...
IBM DB2 Universal Database V6 1--App Development
... of host variables to determine whether a column contains null values. Identify situations in which to use cursors in an application that contains embedded SQL. Code a statement that uses a specific type of cursor to manipulate data using embedded SQL. Code a positioned update using embedded SQL. Match SQLCA elements with the error-handling information they contain. Identify the
more...
... of host variables to determine whether a column contains null values. Identify situations in which to use cursors in an application that contains embedded SQL. Code a statement that uses a specific type of cursor to manipulate data using embedded SQL. Code a positioned update using embedded SQL. Match SQLCA elements with the error-handling information they contain. Identify the
more...
IBM DB2 Universal Database V6 1--App Development
... of host variables to determine whether a column contains null values. Identify situations in which to use cursors in an application that contains embedded SQL. Code a statement that uses a specific type of cursor to manipulate data using embedded SQL. Code a positioned update using embedded SQL. Match SQLCA elements with the error-handling information they contain. Identify the
more...
... of host variables to determine whether a column contains null values. Identify situations in which to use cursors in an application that contains embedded SQL. Code a statement that uses a specific type of cursor to manipulate data using embedded SQL. Code a positioned update using embedded SQL. Match SQLCA elements with the error-handling information they contain. Identify the
more...
IBM DB2 Universal Database V6 1--Fundamentals
... Identify column definitions that allow the insertion of null values. Create a table based on a set of instructions. Locate information in system catalogs by viewing a system catalog table. Create a view with specific characteristics. Create an index with specific characteristics. Identify the effects of table check constraints given a CREATE table statement. Identify characteristics of
more...
... Identify column definitions that allow the insertion of null values. Create a table based on a set of instructions. Locate information in system catalogs by viewing a system catalog table. Create a view with specific characteristics. Create an index with specific characteristics. Identify the effects of table check constraints given a CREATE table statement. Identify characteristics of
more...
IBM DB2 Universal Database V6 1--Fundamentals
... Identify column definitions that allow the insertion of null values. Create a table based on a set of instructions. Locate information in system catalogs by viewing a system catalog table. Create a view with specific characteristics. Create an index with specific characteristics. Identify the effects of table check constraints given a CREATE table statement. Identify characteristics of
more...
... Identify column definitions that allow the insertion of null values. Create a table based on a set of instructions. Locate information in system catalogs by viewing a system catalog table. Create a view with specific characteristics. Create an index with specific characteristics. Identify the effects of table check constraints given a CREATE table statement. Identify characteristics of
more...
Oracle SQL Specifics Retrieving and Formatting Data
... calculation in a query.
Use the NVL function to convert null values to zero.
Display a column with a column alias.
Use the concatenation operator to combine query results from multiple table columns into a single column.
Perform a query using a pseudocolumn.
Identify the components of a basic WHERE clause.
Use the WHERE clause to query for a character string or a date.
Match each type
more...
... calculation in a query.
Use the NVL function to convert null values to zero.
Display a column with a column alias.
Use the concatenation operator to combine query results from multiple table columns into a single column.
Perform a query using a pseudocolumn.
Identify the components of a basic WHERE clause.
Use the WHERE clause to query for a character string or a date.
Match each type
more...
SQL Server 7 0 - Implementing a Database - Part 4
... description. Select the ways aggregate functions handle null values. Select statements to use with the GROUP BY clause on columns. Select statements to use with the GROUP BY clause on expressions. Select when to use the HAVING clause. Perform the steps to summarize group values. Perform the steps to summarize combinations of groups. Select the characteristics of the GROUPING function.
more...
... description. Select the ways aggregate functions handle null values. Select statements to use with the GROUP BY clause on columns. Select statements to use with the GROUP BY clause on expressions. Select when to use the HAVING clause. Perform the steps to summarize group values. Perform the steps to summarize combinations of groups. Select the characteristics of the GROUPING function.
more...
SQL and PL SQL Data Retrieval Techniques
...L statements that contain common group functions. Manage null values when using group functions in a SQL statement. Group rows retrieved by using the GROUP BY clause. Retrieve a subgroup of rows from within a larger group retrieved by using the GROUP BY clause. Restrict groups of rows retrieved by using the HAVING clause. Identify illegal queries involving group functions. Write a SQL
more...
...L statements that contain common group functions. Manage null values when using group functions in a SQL statement. Group rows retrieved by using the GROUP BY clause. Retrieve a subgroup of rows from within a larger group retrieved by using the GROUP BY clause. Restrict groups of rows retrieved by using the HAVING clause. Identify illegal queries involving group functions. Write a SQL
more...
SQL and PL SQL DML and DDL
...traints as a means of enforcing data integrity. Prohibit null values using the NOT NULL constraint. Define a unique constraint for a column to ensure that two rows do not contain the same value. Define a PRIMARY KEY constraint using the CREATE TABLE statement. Create a referential integrity constraint for a foreign key column. Define a check constraint to ensure that appropriate values are
more...
...traints as a means of enforcing data integrity. Prohibit null values using the NOT NULL constraint. Define a unique constraint for a column to ensure that two rows do not contain the same value. Define a PRIMARY KEY constraint using the CREATE TABLE statement. Create a referential integrity constraint for a foreign key column. Define a check constraint to ensure that appropriate values are
more...
IBM DB2 Universal Database V6 1--Fundamentals
... Identify column definitions that allow the insertion of null values. Create a table based on a set of instructions. Locate information in system catalogs by viewing a system catalog table. Create a view with specific characteristics. Create an index with specific characteristics. Identify the effects of table check constraints given a CREATE table statement. Identify characteristics of
more...
... Identify column definitions that allow the insertion of null values. Create a table based on a set of instructions. Locate information in system catalogs by viewing a system catalog table. Create a view with specific characteristics. Create an index with specific characteristics. Identify the effects of table check constraints given a CREATE table statement. Identify characteristics of
more...
IBM DB2 Universal Database V6 1--Fundamentals
... Identify column definitions that allow the insertion of null values. Create a table based on a set of instructions. Locate information in system catalogs by viewing a system catalog table. Create a view with specific characteristics. Create an index with specific characteristics. Identify the effects of table check constraints given a CREATE table statement. Identify characteristics of
more...
... Identify column definitions that allow the insertion of null values. Create a table based on a set of instructions. Locate information in system catalogs by viewing a system catalog table. Create a view with specific characteristics. Create an index with specific characteristics. Identify the effects of table check constraints given a CREATE table statement. Identify characteristics of
more...
Oracle SQL for End Users--Part 1
Course Overview Oracle SQL and SQL*Plus are powerful components of Oracle's relational and object relational database management systems. This course is designed for end users who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties, introduces the Oracle server, and indicates how SQL and SQL*Plus are used in the
more...
Course Overview Oracle SQL and SQL*Plus are powerful components of Oracle's relational and object relational database management systems. This course is designed for end users who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties, introduces the Oracle server, and indicates how SQL and SQL*Plus are used in the
more...
Oracle SQL for End Users--Part 2
...oup by using the COUNT group function in a query. Manage null values when using group functions in a SQL statement. Group rows retrieved by using the GROUP BY clause. Identify illegal queries involving group functions. Unit 3: Subqueries Duration: 2 Hour(s) Identify the proper syntax when using a subquery in a SQL statement. Identify the characteristics of the subquery types.
more...
...oup by using the COUNT group function in a query. Manage null values when using group functions in a SQL statement. Group rows retrieved by using the GROUP BY clause. Identify illegal queries involving group functions. Unit 3: Subqueries Duration: 2 Hour(s) Identify the proper syntax when using a subquery in a SQL statement. Identify the characteristics of the subquery types.
more...
