Oracle SQL Fundamentals introduces Oracle SQL language and database concepts, including data selection and manipulation, data definition, and other schema objects. This course is Oracle-specific. See Database Fundamentals for a more generic introduction to database concepts.

This course comprises 15 lessons covering Oracle SQL fundamentals. Each lesson includes a combination of Wikipedia and Oracle readings, YouTube videos, and hands-on learning activities. The course also assists learners in preparing for Oracle SQL Fundamentals I certification.

Preparation

This is a second-semester, college-level course. Learners should already be familiar with Information Systems concepts. Familiarity with Database Software is also helpful.

Lessons

  1. Introduction
  2. Selecting Data
  3. Restricting Data
  4. Sorting Data
  5. Single-Row Functions
  6. Conversion Functions
  7. Conditional Expressions
  8. Aggregating Data
  9. Joining Data
  10. Subqueries
  11. Set Operators
  12. Manipulating Data
  13. Transactions
  14. Data Definition Language
  15. Other Schema Objects

See Also

References

  • Oracle: Database 11g: SQL Fundamentals I Exam Topics
  • Ramklass and Watson. OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051. Oracle Press. ISBN 9780071597869
This article is issued from Wikiversity. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.