Vi ste ovdje
Overview/Description
To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.
Target Audience
Database Administrators, Database Designers, Developer
Support Engineers, and Technical Administrators.
Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)
Expected Duration (hours)
2.0
Lesson ObjectivesOracle Database 11g: Conversion Functions, Group Functions, and Joins
identify the...
Overview/Description
To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.
Target Audience
Database Administrators, Database Designers, Developer
Support Engineers, and Technical Administrators.
Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)
Expected Duration (hours)
1.9
Lesson ObjectivesOracle Database 11g: Subqueries, Set Operators, and...
Overview/Description
To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.
Target Audience
Database Administrators, Database Designers, Developer
Support Engineers, and Technical Administrators.
Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)
Expected Duration (hours)
1.8
Lesson ObjectivesOracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms
recognize the steps for...
Overview/Description
To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting, modifying, and formatting this information.
Target Audience
Database Administrators, Database Designers, Developer
Support Engineers, and Technical Administrators.
Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)
Expected Duration (hours)
2.2
Lesson ObjectivesOracle Database 11g: Using SQL to Query Your Database
identify the...