Online Row eLearning Training

Oracle9i Database Admin Manage Data Storage ... and reorganizing data. Learn To • Identify the row storage method used by the various tables and the components of the row structure in an Oracle 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  more...

Oracle9i SQL Data Retrieval Techniques ...one table. o Identify a Cartesian product. o Retrieve rows from two tables by using an equijoin. o Identify the features of a group function. o Write SQL statements 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  more...

Oracle9i SQL Basic SELECT Statements ...tatements; 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 model. o Match the structural elements of a relational database table with their  more...

SQL Server 2000 Design Implement Databases Part 2 Managing Data ... Add a user defined data type. Match the parts of a data row with their features. Identify characteristics of entity modeling. Identify features of attributes. Identify requirements for logical modeling. Identify the login authentication modes and methods used by SQL Server 2000. Identify the functions of database user accounts and roles in SQL Server 2000. Match the types of roles in  more...

IBM DB2 Universal Database V6 1--Fundamentals ...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. When coupled with appropriate on-the-job experience, this course will help prepare students for the IBM Certified Solutions Expert Certification exam 509. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1:  more...

Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention ... Optimize space usage within blocks. Detect and resolve row migration. Monitor and tune indexes. Recognize, diagnose, and resolve performance problems associated with sorts. Recognize, diagnose, and resolve performance problems associated with rollback segments. Define levels of locking and list the possible causes of contention. Use Oracle utilities to detect and resolve lock  more...

Oracle8i Database Admin Manage Data Storage ...naging Tables Duration: 1 - 2 Hour(s) Identify the row storage method for various types of tables. Identify the information stored in the components of the Oracle row structure. Identify the features of the Oracle built-in scalar datatypes. Identify the differences between the two large object datatypes. Identify the features of ROWID. Identify the components in a ROWID format.  more...

Oracle Form Builder R6 Writing and Debugging Code ... trigger to implement validation before the deletion of a row. Write a Pre-Insert trigger to assign sequence numbers to records. Write a Post-Update trigger to record audit information about the changes applied to base tables. Write the code to test the result of a DML operation in a trigger by using the attributes of PL/SQL implicit cursors. Identify the rules followed by Form Builder  more...

Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention ...e, optimize space usage within blocks, detect and resolve row migration and monitor and tune indexes. 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. Reconfigure and monitor rollback segments, define the number and sizes of rollback segments and allocate  more...

Oracle8 Database Administration - Manage Data ...naging Tables Duration: 1 - 2 Hour(s) Identify the row storage method for various types of tables. Identify the information stored in the components of the Oracle row structure. Identify the features of the Oracle built-in scalar datatypes. Identify the differences between the two large object datatypes. Identify the features of ROWID. Identify the components in a ROWID format.  more...

Oracle Form Builder Writing and Debugging Code ...rigger to implement a validation before the deletion of a row. Write a Pre-Insert trigger to assign sequence numbers to records. Write a Post-Update trigger to record audit information about the changes applied to base tables. Write the code to test the result of a DML operation in a trigger by using the attributes of PL/SQL implicit cursors. Identify the rules followed by Form Builder  more...

Oracle Database 10g SQL Fundamentals I Part 1 ... results in SQL statements. Identify features of single-row functions. Match the character functions with their uses. Match the number functions with their purpose. Identify the use of natural joins to retrieve data from multiple tables. Identify the use of an equijoin to retrieve data from multiple tables. Identify the use of self-join to retrieve data from a table. Audience:  more...

Oracle SQL Specifics Retrieving and Formatting Data ...etrieve data based on a hierarchical relationship between rows. L earn To: Define relational database concepts and object relational database concepts. Use the Oracle SELECT statement. Implement functions, including single row, conversion, and group functions. Use SET operators. Use subqueries. Retrieve hierarchical data. C ontent Emphasis Skills-Based A  more...

Oracle SQL and SQL Plus Advanced SELECT Statements ...ne two or more queries. L earn To: Write single-row subqueries. Write multiple-row and multiple-column subqueries. Write correlated subqueries. Write queries using number DECODE and character functions. Write hierarchical queries and format hierarchical reports. Write compound queries by using set operators and control the order of the output of the compound queries.  more...

Excel 2000 Fundamentals ...heet. Replace a text string with another string. Select rows and columns in a worksheet. Select a specified range of cells in a worksheet. Copy a range of cells from a specified location to another. Move a cell range from a specified location to another. Modify the layout of a page prior to printing. Add marginal data to customize a worksheet before printing. Modify the placement of  more...

PowerPoint 2000 Expert User ...e cells in a table. Format the text in a cell. Insert a row and a column. Unit 4: Enhancing a Presentation Duration: 1 Hour(s) Import the contents of a Word file. Import a chart from an Excel file. Import a presentation. Import a sound clip that is saved as a file. Import a movie clip that is saved as a file. Import an animated GIF file. Add an action button to a slide.  more...

SQL and PL SQL Basic SELECT ...tatements; restricting and sorting data; and using single-row functions. L earn To: Identify relational database concepts and properties. Describe database design processes by explaining the system development life cycle and entity relationship modeling. Describe the concept of object relational database management systems. Write SQL SELECT queries. Customize SQL queries when  more...

SQL and PL SQL Data Retrieval Techniques ...y the user will be covered. L earn To: Retrieve rows from multiple tables by using an equijoin, a non-equijoin, an outer join, and a self join. Write SQL statements that contain common group functions. Restrict groups of rows retrieved by using the HAVING clause and to write SQL statements that contain common group functions. Group rows retrieved by using the GROUP BY clause.  more...

SQL and PL SQL DML and DDL ...efine 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 stored in the table. Create a table within the SQL*Plus environment. Create a table using the rows  more...

Oracle Database 10g New Features for Administrators Part 4 ...ures of Flashback Drop. Identify options for retrieving row history information using the Flashback Versions Query feature. Identify characteristics of Flashback Transaction Query. Identify characteristics of Flashback Table operation. Unit 3: General Storage Enhancements Identify features of the SYSAUX tablespace. Identify the steps to relocate SYSAUX occupants by using  more...

IBM DB2 Universal Database V6 1--Fundamentals ...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. When coupled with appropriate on-the-job experience, this course will help prepare students for the IBM Certified Solutions Expert Certification exam 509. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1:  more...

IBM DB2 Universal Database V6 1--Fundamentals ...base technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. When coupled with appropriate on-the-job experience, this course will help prepare students for the IBM Certified Solutions Expert Certification exam 509. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1:  more...

Oracle SQL for End Users--Part 1 ...earner writes statements that contain a variety of single-row functions. L earn To: Identify database principles and concepts concerning the Oracle server, SQL, and SQL*Plus. Write basic SQL SELECT statements. Add clauses to basic SQL SELECT statements to restrict and sort data retrieved by a query. Write SQL statements that contain a variety of single-row functions. C  more...

Oracle SQL for End Users--Part 2 ...in a SQL statement to display information about groups of rows in the database. This course also covers how to embed subqueries in SQL statements. Finally, the learner creates interactive reports by using substitution variables, and executes a formatted report by using SQL*Plus commands. L earn To: Access data from more than one table by using equijoins and nonequijoins and join a  more...

Excel XP Fundamentals ... the contents of a cell in a worksheet. • Insert a row and column in a worksheet. • Delete a row and column from a worksheet. • Hide a row and column in a worksheet. Audience The intended audience for this course includes end users and power users who may or may not be familiar with previous versions of Microsoft Excel. Their relevant duties may include office or  more...

Excel XP Expert User ...er data in a list by using the data form. • Sort a row in a list by using multiple columns. • Sort a column in a list by using multiple rows. • Create a custom sort order. • Apply a custom filter to a list. • Summarize data in a list by using subtotals. Unit 2: Workbook Capabilities 2 - 3 hours • Create a shared workbook. • Highlight  more...

Database Technologies Introduction to SQL ...ors. o Identify how to use arithmetic operators, single row functions, and group functions to manipulate query data. o Identify how to retrieve database information using subqueries and joins. o 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  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...

Excel 2003 Proficient User ...ng with comments in cells. Hide a row and a column.. Identify methods for sizing a row and a column. Freeze a row and a column. Insert a worksheet. Identify formatting options on the Sheet menu. Move a worksheet within a workbook by using the Edit menu.  more...

Oracle Database 10g PL SQL Fundamentals Part 2 ...ify the code to create a Data Manipulation Language (DML) row trigger. Audience: The target course audience is Application Developers, Database Designers, System Analysts, PL/SQL Developer, Technical Consultant, Forms Developer, and Portal Developer. Deployment: Self-Study Language Options: US English Total Learning Time: 8 hours Objectives: Unit 1: PL/SQL  more...