Online Sql Functions eLearning Training

IBM DB2 Univ Database V7 1 Transition Part 1 Core Competencies ...unctions of the star schema model. Identify the new OLAP SQL functions in DB2 version 7.1. Identify the features of declared temporary tables. Identify the factors to consider when using declared temporary tables. Identify the way in which savepoints control the outcome of transactions. Identify the new features of federated databases. Identify the new features of the SQL Explain utility. more...

IBM DB2 Univ Database V7 1 Transition Part 1 Core Competencies ...unctions of the star schema model. Identify the new OLAP SQL functions in DB2 version 7.1. Identify the features of declared temporary tables. Identify the factors to consider when using declared temporary tables. Identify the way in which savepoints control the outcome of transactions. Identify the new features of federated databases. Identify the new features of the SQL Explain utility. more...

IBM DB2 Universal Database V6 1--App Development ...ng, and dynamic SQL programming. L earn To: Use SQL functions in DB2 Applications. Use different application objects in DB2, such as schema, user-defined types, user-defined functions, and stored procedures. Use SQL within an application. Use dynamic SQL within an application. C ontent Emphasis Skills-Based A udience This course is intended for application more...

IBM DB2 Universal Database V6 1--App Development ...ng, and dynamic SQL programming. L earn To: Use SQL functions in DB2 Applications. Use different application objects in DB2, such as schema, user-defined types, user-defined functions, and stored procedures. Use SQL within an application. Use dynamic SQL within an application. C ontent Emphasis Skills-Based A udience This course is intended for application 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...

Oracle Database 10g PL SQL Fundamentals Part 1 ...ines for programming in PL/SQL. Identify features of PL/SQL functions. Identify features of nested blocks. Identify uses of PL/SQL operators. Match SQL statements with their functions. Identify guidelines for retrieving data in PL/SQL. Identify codes for manipulating data using DML statements. Identify the syntax for testing the outcome of SQL statements using cursors. Identify more...

Oracle Database 10g SQL Fundamentals I Part 1 ...hile retrieving data by using SQL statements. Unit 3: SQL Functions Identify features of single-row functions. Match the character functions with their uses. Match the number functions with their purpose. Identify features of the date functions. Identify features the functions used to convert data types. Identify the use of nested functions in retrieving data from tables.  more...

Oracle SQL Specifics Retrieving and Formatting Data ...database management system (ORDBMS). Users will learn how SQL functions can be used in SQL SELECT statements to extract data from the database and how SET operators can be used to combine multiple queries into a single query. Users will also learn how subqueries and correlated subqueries can help to solve data retrieval problems. Finally, participants will learn how to retrieve data based on a more...

SQL and PL SQL PL SQL Basics ... variables. Manipulate data in PL/SQL variables by using SQL functions. Convert the datatype of a variable by using a data conversion function. Identify the features of variable scoping in nested PL/SQL blocks. Create a bind variable in the SQL*Plus environment. Identify the case conventions for writing PL/SQL code. Match the identifiers with their naming conventions. Unit 3: more...

Oracle Database 10g Administration Workshop II Part 1 ...scriptions. Identify NLS parameters that can be used in SQL functions. Identify features of different types of linguistic sorting. Identify key concepts related to linguistic sorting. Identify key concepts related to linguistic comparisons. Identify features of linguistic indexes. Identify features of linguistic sorts that can be customized. Match the views used to obtain more...

Oracle Database 10g PL SQL Fundamentals Part 2 ...ating a PL/SQL function. Identify characteristics of PL/SQL functions. Identify tasks you can perform for managing PL/SQL functions. Unit 2: PL/SQL Packages Identify features of PL/SQL packages. Sequence steps for developing PL/SQL packages. Identify the syntax for creating a PL/SQL package. Identify tasks involved in managing PL/SQL packages. Identify features of the more...