|
Training Classes
| Learning and Development Resources
| Training Directory
| New Training Seminars
| New Training Providers
| Site Map
| Promote Training Seminars
|
Training Keywords
| Training Seminars
| Training Providers
| Regions
|
| Advertise Training Seminars
| Login
|
||||||||||||||||||||||||
One Table Training Seminars and Classes
From Serebra Learning Corporation
Oracle 8i PL/SQL - Functions, Tables, and Groups
 This course covers the concepts of single row functions that enable the manipulation of data. The course essentially focuses on three single row functions: character functions number functions and date functions. The course also covers the concept of conversion that enables the conversion of a value from one datatype to another. The concept of retrieving data from more than one table by using more...Oracle SQL: Data Retrieval Techniques
This course is the second in a three-part Oracle series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries. In addition how to more...SQL Queries
  Describes SQL querying from simple one column, one table queries to advanced joining and merging of data from multiple tables. more...
From 123-CBT Computer Based Training
Oracle9i SQL Data Retrieval Techniques
 ...our Oracle join types used to display data from more than 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 more...SQL and PL SQL Data Retrieval Techniques
.... This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries. In addition, how to use SQL*Plus commands to build on basic SQL statements and create customized queries that retrieve the information and more...SQL and PL SQL DML and DDL
...date, time, and user values in a table. Insert rows from one table into another table. Update a row without violating the integrity constraints for that table. Update an entire column in a database table. Delete rows from a table. Identify the actions that start and end a transaction. Execute the COMMIT, SAVEPOINT, and ROLLBACK statements. Roll back pending data changes. Rollback more...Oracle SQL for End Users--Part 2
...commands. L earn To: Access data from more than one table by using equijoins and nonequijoins and join a table to itself by using a self join. Group data by using group functions. Embed single-row and multiple-row subqueries in a SQL statement. Create, format, and execute interactive reports. C ontent Emphasis Skills-Based A udience End users are the targeted more...
| ||||||||||||||||||||||||
|
| ||||||||||||||||||||||||
| Training Directory | New Training Seminars | New Training Providers | | Site Map | Promote Training | Login | Links | ||
|
| ||
| Training-Classes.com by Skillbox® 06/22/08 Copyright 1998-2008 skillbox, inc. All rights reserved |
 |
|