Oracle Database 11g: SQL Fundamentals I


Description:

Storing and accessing data are part of a person's day-to-day activities. One of the most efficient and powerful ways of managing data is by using databases. Information can be stored, linked, and managed using a database application such as Oracle 11g and its associated tools SQL*Plus. This course is intended for students who have some technical background in desktop computer database use and who wish to acquire competency in Oracle systems usage so as to pursue a career as an Oracle technical professional.

This course carries the following professional education credits: 0.8 CEUs. For more information on accreditation bodies, please visit www.elementk.com/products/certification-and-accreditation.

Objectives:

  • In this course, you will acquire the essential SQL skills that will allow you to write queries against single and multiple tables, manipulate data in tables, and create database objects. You will also use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. This course maps to requirements for the Oracle Database 11g: SQL Fundamentals I certification exam (exam number 1Z0-051).

Hardware and Software Required:

  • Browser Microsoft Internet Explorer 7 (or higher)
  • Browser Mozilla Firefox 2 (or higher)
  • Browser Apple Safari 2 (or higher)
  • Operating System Microsoft Windows 2000, XP, Vista, or Windows 7
  • Operating System Apple Mac OS X 10.4 (or higher)
  • Processor Pentium III 1 GHz (or better)
  • Processor Macintosh Intel-based or PowerPC G4 (or better)
  • RAM 512 MB (1 GB or more recommended)
  • Internet connection 256K (broadband recommended)
  • Adobe Flash Player 8 (current version recommended)
  • Adobe Reader 7 (or higher)
  • Other requirements may apply to supplemental offline activities. Omitting these optional activities does not affect course completion.



User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-ORCL-DB11G-SQL-F1
  • Duration: 8 hours 15 minutes
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend