Online Group Functions eLearning Training

SQL Functions in Oracle 9i To describe how to use SQL functions for data retrieval Junior database administrators, application developers, 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...

Oracle9i SQL Data Retrieval Techniques ...group functions, subqueries, and the iSQL*Plus report variables. Additionally, this course shows students how to access data from multiple table using joins, aggregate data using group functions, create subqueries, and use iSQL*Plus commands to create customized queries. Learn To: o Identify the four Oracle join types used to display data from more than one table. o Identify a Cartesian more...

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...

Oracle9i SQL: Data Retrieval Techniques This course covers joins, group functions, subqueries, and the iSQL*Plus report variables. Additionally, this course shows students how to access data from multiple table using joins, aggregate data using group functions, create subqueries, and use iSQL*Plus commands to create customized queries. more...

Oracle SQL for End Users Part 2 This course is the second in a two-part SQL for End Users series that is based on Introduction to Oracle: SQL and PL/SQL. In this course the learner displays data from multiple tables by using equijoins non-equijoins and self joins. In addition this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database. This course also covers 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...

Oracle9i SQL: Data Retrieval Techniques This course covers joins group functions subqueries and the iSQL*Plus report variables. Additionally this course shows students how to access data from multiple table using joins aggregate data using group functions create subqueries and use iSQL*Plus commands to create customized queries.  more...

Oracle Database 10g SQL Fundamentals I Part 1 In this course, learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Additionally, the learners will be introduced to the powerful SQL programming language and its features. Learn To: Match the different phases of system development life cycle (SDLC) with their features. Identify features of an Entity Relationship (ER) more...

Oracle SQL Specifics Retrieving and Formatting Data ...mplement functions, including single row, conversion, and group functions. Use SET operators. Use subqueries. Retrieve hierarchical data. C ontent Emphasis Skills-Based A udience Application Developers, System Analysts, Database Administrators, Technical Support Personnel. Prior knowledge of SQL. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: more...

Oracle SQL and SQL Plus Advanced SELECT Statements ...porating comparison operators. Complete a query by using group functions in a single-row subquery. Complete a SELECT statement by using multiple single-row subqueries. Complete the statement to create a table based on the definition of an existing table by using a subquery. Complete the statement to insert values into a table from another table by using a subquery. Complete the UPDATE more...

SQL and PL SQL Data Retrieval Techniques ...ore 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 display it in a format specified by the user will be more...

Oracle SQL for End Users--Part 2 ...elf joins. In addition, this course introduces the use of group functions 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 more...

Database Technologies Introduction to SQL ...ow 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 data manipulation more...