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

Summary:

The Oracle Database 11g: Fundamentals I study guide will prepare you to become certified as an Oracle Database 11g Administrator Certified Associate. This series will cover both basic and in-depth database administration topics, such as using SQL to retri

This Oracle Database 11g SQL Fundamentals I (1Z0-051) online training series provides over 15 hours of self-paced courseware. This web-based training provides 6 months of unlimited access to all of the following lessons:

1 . Creating Schema Objects
2 . Creating Tables and Constraints
3 . Introduction to SQL
4 . Manipulating Data
5 . Practice Exam 1
6 . Practice Exam 2
7 . Practice Exam 3
8 . Using Group Functions
9 . Using Joins and Subqueries
10 . Using Single-Row Functions

Lesson Detail:

Creating Schema Objects
This course covers creating and maintaining four types of schema objects: views, sequences, indexes, and synonyms.

• Creating Schema Objects

Creating Tables and Constraints
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.

• Creating Tables and Constraints

Introduction to SQL
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.

• Introduction to SQL

Manipulating Data
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 tabl

• Manipulating Data

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

• Practice Exam

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

• Practice Exam

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

• Practice Exam

Using Group Functions
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.

• Using Group Functions

Using Joins and Subqueries
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.

• Using Joins and Subqueries

Using Single-Row Functions
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, an

• 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

Certification:
Oracle Database 11g SQL Fundamentals I (1Z0-051)

Audience:
This series is for anyone who is preparing for the Oracle Database 11g SQL Fundamentals I (1Z0-051) exam.

Features:

• Audio accompanies each lesson page throughout the course.
• MindNotes provide printable quick-reference sheets and other files to be used as learners apply their skills on the job.
• Instructional audio with graphics highlighting key points.
• Activities allow learners to apply course concepts in an interactive questioning environment.
• Exercises allow learners to practice in the actual application being studied.
• A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
• Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
• Search text enables learners to rapidly search all text within a course to easily retrieve information required.
• Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
• A skill assessment generates a customized learning path based on the results of a pre-test.
• A glossary provides a reference for definitions of unfamiliar terms.
• Bookmarking tracks the learner's progress in a course.

Technical Requirements:

What You Get:

You will receive Unlimited Access to all of the Oracle Database 11g SQL Fundamentals I (1Z0-051) training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 6 months of unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.

Web-Based Training Products:

You might also be interested in our Technical Package which includes all of the Oracle Database 11g SQL Fundamentals I (1Z0-051) training courses listed above plus hundreds of hours of related online training courses