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 online training series will cover both basic and in-depth database administration topics, such as using SQL to retrieve, restrict, and sort data, along with using functions, subqueries, and reporting.

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

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

Lesson Detail:

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

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, and additional information you need to know for the exam.

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

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

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

Manipulating Data

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

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

Creating Schema Objects

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

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

Audience:

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:

Internet connection
Browser: Internet Explorer, FireFox, Chrome, Safari, Opera or any standards compliant browser.
Authorware and Macromedia Flash player recommended but not required.
JavaScript must be enabled.

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 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.

StaffKit is a leader in providing online computer training tutorials and online education. We have customers use our online training courses in over 75 countries. StaffKit has been providing e-learning solutions for 10 years.

Web-Based Training Products:

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

Only $59.95

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