Online Oracle Database 11g SQL Fundamentals I (1Z0-051) Training

Database » Oracle

Only $99.95

ONLINE Oracle SQL TRAINING FEATURES

  • Learn Oracle SQL online with these interactive online Oracle SQL courses.
  • Affordable Pricing (Only $99.95 for the complete series)
  • A full year to complete the Oracle SQL courses
  • Retake the Oracle SQL courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test
  • Oracle Database 11g SQL Fundamentals I (1Z0-051) Series (15 hours)

1. Oracle Database 11g SQL Fundamentals I (1Z0-051):1 Introduction to SQL

Time: 2 hours
This course covers Oracle SQL fundamentals such as the various types of SQL statements, and it also introduces SQL*Plus and a few SQL*Plus commands. You'll also learn the uses of SELECT statements.

Objectives

  • List the capabilities of SQL SELECT statements
  • Execute a basic SELECT statement
  • Limit the rows that are retrieved by a query
  • Sort the rows that are retrieved by a query
  • Use ampersand substitution to restrict and sort output at runtime

Topics

  • Introduction to SQL


2. Oracle Database 11g SQL Fundamentals I (1Z0-051):2 Using Single-Row Functions

Time: 4 hours
This course explores single-row functions that can be called from SQL statements. These functions include character, numeric, date, conversion, and miscellaneous functions. The material covers the functions that are available, the rules for using them, and additional information you need to know for the exam.

Objectives

  • Describe various types of functions available in SQL
  • Use character, number, and date functions in SELECT statements
  • Describe various types of conversion functions that are available in SQL
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Apply conditional expressions in a SELECT statement

Topics

  • Single-Row Fundamentals
  • Using Single-Row Character Functions
  • Using Single-Row Numeric Functions
  • Using Single-Row Date Functions
  • Using Single-Row Conversion Functions
  • Using Other Single-Row Functions


3. Oracle Database 11g SQL Fundamentals I (1Z0-051):3 Using Group Functions

Time: 1 hours
This course covers group function fundamentals including the use of aggregate functions such as GROUP BY and HAVING. It also addresses creating superaggregates and nesting functions.

Objectives

  • Identify the available group functions
  • Describe the use of group functions
  • Group data by using the GROUP BY clause
  • Include or exclude the grouped rows by using the HAVING clause

Topics

  • Using Group Functions


4. Oracle Database 11g SQL Fundamentals I (1Z0-051):4 Using Joins and Subqueries

Time: 1 hours
This course covers the use of table joins to relate two or more tables. It discusses the use of set operators to combine the results of more than one query into one. This course also examines the use of subqueries to manipulate data.

Objectives

  • Write SELECT statements to access data from more than one table using equijoins and nonequijoins
  • Join a table to itself by using a self-join
  • View data that generally does not meet a join condition by using outer joins
  • Generate a Cartesian product of all rows from two or more tables
  • Define subqueries
  • Describe the types of problems that the subqueries can solve
  • List the types of subqueries
  • Write single-row and multiple-row subqueries
  • Describe set operators
  • Use a set operator to combine multiple queries into a single query
  • Control the order of rows returned

Topics

  • Using Joins and Subqueries


5. Oracle Database 11g SQL Fundamentals I (1Z0-051):5 Manipulating Data

Time: 1 hours
This course covers manipulating data using SQL data manipulation language (DML) statements and coordinating multiple changes using transactions. It also covers inserting new data into a table, updating existing data, and deleting existing data from a table.

Objectives

  • Describe each data manipulation language (DML) statement
  • Insert rows into a table
  • Update rows in a table
  • Delete rows from a table
  • Control transactions

Topics

  • Manipulating Data


6. Oracle Database 11g SQL Fundamentals I (1Z0-051):6 Creating Tables and Constraints

Time: 2 hours
This course covers the main database objects. It also covers the use of DDL statements to create and manage tables, as well as the application of constraints to columns.

Objectives

  • Categorize the main database objects
  • Review the table structure
  • List the data types that are available for columns
  • Create a simple table
  • Explain how constraints are created at the time of table creation
  • Describe how schema objects work

Topics

  • Creating Tables and Constraints


7. Oracle Database 11g SQL Fundamentals I (1Z0-051):7 Creating Schema Objects

Time: 1 hours
This course covers creating and maintaining four types of schema objects: views, sequences, indexes, and synonyms.

Objectives

  • Create simple and complex views
  • Retrieve data from views
  • Create, maintain, and use sequences
  • Create and maintain indexes
  • Create private and public synonyms

Topics

  • Creating Schema Objects


8. Oracle Database 11g SQL Fundamentals I (1Z0-051):8 Practice Exam 1

Time: 1 hours
This course presents questions that will help you prepare for the Oracle Database 11g SQL Fundamentals I (1Z0-051) exam.

Objectives

  • Complete the practice exam questions

Topics

  • Practice Exam


9. Oracle Database 11g SQL Fundamentals I (1Z0-051):9 Practice Exam 2

Time: 1 hours
This course presents questions that will help you prepare for the Oracle Database 11g SQL Fundamentals I (1Z0-051) exam.

Objectives

  • Complete the practice exam questions

Topics

  • Practice Exam


10. Oracle Database 11g SQL Fundamentals I (1Z0-051):10 Practice Exam 3

Time: 1 hours
This course presents questions that will help you prepare for the Oracle Database 11g SQL Fundamentals I (1Z0-051) exam.

Objectives

  • Complete the practice exam questions

Topics

  • Practice Exam



Resources for Oracle Database 11g SQL Fundamentals I (1Z0-051)

  • Know of a good resource for Oracle Database 11g SQL Fundamentals I (1Z0-051) Online Training? Please Let Us Know.
Student Login



  1. Forgot My Password
  2. Support

Live eLearning

Like a class you would go to, but you don't have to go anywhere

More...

Try a Free Course

Click here to try a free course.

Partners & Resources
  1. View Partners & Resources
  2. Become a Partner
© Webucator, Inc. All rights reserved. | Toll Free: 877-932-8228 | UK: 0808-101-3484 | From outside the USA: 315-849-2724| Fax: 315-849-2723