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 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
- 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
- Using Joins and Subqueries
- Manipulating Data
Creating Tables and Constraints
- Creating Tables and Constraints
- Creating Schema Objects
- Practice Exam
- Practice 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 computer training tutorials and online education. We have satisfied e-learning customers in over 45 countries and have been providing web based training for over 8 years.
Web-Based Training Products:
Oracle Database 11g SQL Fundamentals I (1Z0-051) Online Training Series
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 over 749 hours related training courses
Technical Package
Only $129.95
