Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Oracle Database 11g: Querying a Database with SQL $74.95
Oracle Database 11g: Conversion Functions, Conditional Expressions, Group Functions, and Joins $74.95
Oracle Database 11g: Manipulating Queries and Data $74.95
Oracle Database 11g: Using DDL, Views, and Schema Objects $74.95
Oracle Database 11g: Controlling User Access and Managing Objects $74.95
Oracle Database 11g: Managing Data Dictionary Views and Large Data Sets $74.95
Oracle Database 11g: Managing Time Zones and Datetime Functions $74.95
Oracle Database 11g: Subqueries and Regular Expressions $74.95

Bundle Price: $289.00
Total Savings: $310.60


Oracle Database 11g: Querying a Database with SQL

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.
  • Oracle Database 11g Components - identify the functions, capabilities, and terminology associated with Oracle Database 11g's components and relational databases in general.
  • Using SQL Statements - recognize the steps for using Oracle SQL Developer to create a new database connection and browse tables.
  • The SQL SELECT Statement - recognize the steps for using the SQL SELECT statement to retrieve different sets of data from a database.
  • Restricting Data - recognize the steps for limiting and ordering the rows returned by a SQL query.
  • Sorting Data - recognize ways to sort data returned by a SQL query, using substitution variables as well as the DEFINE and VERIFY commands.
  • SQL Functions - recognize the steps for using SQL functions to modify, format, and otherwise manipulate returned data.
  • Identifying and Writing SELECT Queries - identify and write SQL queries to display, sort, and format output in a given scenario.

Oracle Database 11g: Conversion Functions, Conditional Expressions, Group Functions, and Joins

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.
  • Conversion and General Functions - identify the steps for using functions to convert character, date, and numeric values and perform operations pertaining to null values.
  • Conditional Expressions - recognize the steps for using the CASE expression and the DECODE function to implement conditional processing.
  • Using Conversion Functions and Conditional Expressions - identify and write queries that convert data types and implement conditional processing, in a given scenario.
  • Group Functions - recognize the benefits of using group functions to return values for groups of rows.
  • Creating and Manipulating Group Functions - identify the steps for creating, restricting, and nesting group functions.
  • Using Joins - identify the steps for using joins to return data from more than one table.
  • Writing Queries Using Group Functions and Joins - write queries that calculate values for groups of data and return values from multiple tables in a given scenario.

Oracle Database 11g: Manipulating Queries and Data

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.
  • Subqueries - recognize the steps for using subqueries inside other queries to perform various actions.
  • Set Operators - identify the steps for using set operators to combine the results of two or more queries.
  • Identifying and Using Set Operators - write queries using set operators.
  • Modifying Tables - identify the steps for adding new rows to a table, modifying table data, and removing rows.
  • Controlling Transactions - recognize the steps for controlling database transactions, and implementing read consistency.
  • Using INSERT, UPDATE, and DELETE Statements - insert, update and delete rows in a table, and control data transactions to it.

Oracle Database 11g: Using DDL, Views, and Schema Objects

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.
  • Creating Tables and Data Types - recognize the steps for creating, defining, and naming a table, and for specifying data types for its columns.
  • Constraints - recognize the steps for using constraints to prevent invalid data entry into tables.
  • Using the ALTER TABLE and DROP TABLE Statements - recognize the steps for altering or dropping a table.
  • Views - identify the steps for creating and manipulating views to view or hide a table's data.
  • Sequences, Indexes, and Synonyms - recognize the steps for using sequences to create integers, using indexes to improve the performance of queries, and using synonyms to give a table an alternative name.
  • Creating Tables, Sequences, Synonyms, and Indexes - create a new table and create and use a sequence, index, and synonym.

Oracle Database 11g: Controlling User Access and Managing Objects

To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.
  • System and Object Privileges - identify the steps for granting and revoking system and object privileges.
  • Granting User Privileges - grant privileges to users in a given scenario.
  • Altering Existing Objects - recognize the steps for altering a table by adding, modifying and dropping columns.
  • Managing Indexes and Constraints - recognize the steps for adding and manipulating constraints and for creating indexes.
  • Flashback Operations and External Tables - identify the steps for recovering your database using flashback, and for manipulating external data.
  • Working with Tables, Indexes and Constraints - alter a table by dropping columns and adding constraints and indexes.

Oracle Database 11g: Managing Data Dictionary Views and Large Data Sets

To recognize the steps for querying data dictionary views to viewsschema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows.
  • Using Data Dictionary Views - identify the steps for using data dictionary views to find information about tables, constraints, views, sequences, and synonyms.
  • Querying Data Dictionary Views - query the appropriate dictionary views to find information about schema objects in a given scenario.
  • Using Subqueries to Manipulate Data - recognize the steps for manipulating data using subqueries and explicit default values.
  • Using Multitable Inserts - identify the steps for inserting into multiple tables, merging rows in tables, and tracking changes to data.
  • Performing Multiple INSERTs and MERGE Operations - manipulate large data sets using multitable INSERT and MERGE operations.

Oracle Database 11g: Managing Time Zones and Datetime Functions

To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.
  • Time Zones and Intervals - recognize the steps for managing time zones and time intervals.
  • Datetime Functions - recognize the steps for using datetime functions to manage dates and times in Oracle Database 11g.
  • Displaying Time Zones Offsets - display time zone offsets in a given scenario.
  • Using the EXTRACT Function - extract and return the value of a datetime field in a given scenario.

Oracle Database 11g: Subqueries and Regular Expressions

To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.
  • Multiple-Column and Scalar Subqueries - identify the steps for writing multiple-column and scalar subqueries.
  • Correlated Subqueries and WITH Clause - recognize the steps for solving problems by using correlated subqueries and the WITH clause.
  • Multiple-Column, Correlated and Scalar Subqueries - write multiple-column, correlated, and scalar subqueries in a given scenario and solve a problem using the WITH clause.
  • Benefits of Regular Expressions - recognize the benefits of implementing complex match logic in the database, using regular expressions.
  • Regular Expressions Functions and Subexpressions - identify the steps for using regular expressions functions and for accessing subexpressions.
  • Using Regular Expression Functions - use regular expressions functions to search for, replace, and manipulate data, and also add a CHECK constraint to a column.
Register Now
Oracle Database 11g: Introduction to SQL e-learning bundle
  • Course ID:
    271468
  • Duration:
    n/a
  • Price:
    $289