Computer
Training
Course
List
Value Packages
Site Map
Oracle Certification
Free
Training
Online Training Series:
Oracle 9i SQL 1Z0-007 Training
|
Oracle 9i > SQL 1Z0-007 > Grouping and Summarizing Data
This Oracle 9i SQL 1Z0-007 Training Course on Grouping and Summarizing Data
is part of a 11 course, 24 hour online training series.
This complete online training series can be purchased
for only $59.95.
Length: 1 Hour
Summary:
This course examines the summarizing of query results into groups using the GROUP BY clause in Oracle9i SQL.
Objectives:
After completing this course, students will be able to:
- Explain how group functions work
- Use aggregate functions
- Use DISTINCT and ALL clauses
- Group and sort rows using the GROUP BY clause
- Use the HAVING clause to restrict data
- Use the ROLLUP, CUBE, and GROUPING SETS clauses
Outline:
- The GROUP BY clause and group functions
- Aggregate functions
- Grouping rows and sorting with GROUP BY
- Restricting Data
- Extending the GROUP BY clause
Features:
- Exercises that allow users to practice the application
- A file containing the text of the exercises
- Simulations that allow users to practice course skills, even if they don't have access to the application
- Online computer glossary
- Online skill assessment testing
Applicability:
This course is for anyone who is interested in learning more about Oracle9i SQL and in taking the Oracle 9i exam 1Z0-007: Introduction to Oracle 9i:SQL.
Prerequisites: None
Technical Requirements: (Minimum)
- Computer: 200MHz Pentium with 32MB Ram. 640 x 480 256-color video
- Operating System: Windows 95, 98, NT, ME, 2000, or XP.
- Minimum Connection Speed: 28.8k.
- Browser: Internet Explorer 5.0 or higher required.
- Authorware and Macromedia Flash player recommended but not required.
- JavaScript must be enabled.
- Netscape and AOL browsers not supported.
Need help or have questions about Oracle 9i SQL 1Z0-007? How
about 24x7 access worldwide to our instructors! Now you can get answers
from real experts within minutes via our online chat service. For just
$40.00 additional you add our Instant Mentoring service and get your
Oracle 9i SQL 1Z0-007 training courses questions quickly answered anytime from anywhere.
You might also be interested in our Technical Package which includes all of our
Oracle 9i SQL 1Z0-007 courses plus over 800 hours of additional courses.
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), includes a variety of features and all courses qualify for Continuing Education Units - CEU credit..
StaffKit is a worldwide leader in providing computer training, online
tutorials and career education. StaffKit has satisifed customers in
over 30 countries.
|
Back to Oracle 9i SQL 1Z0-007 Training
Reviews:
With only an Internet browser and a dial-up connection you can access over 4,000 hours of courseware, anytime, anywhere, for one full year.
MidWest Technology Journal
"If you are looking to get certification this is a must have resource."
TheTechMag.com
Read more customer reviews about
our e-learning training tutorials.
|
