Oracle SQL Fundamentals

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

• Database Fundamentals
• Database Software
• Information Systems
• Wikibooks: Structured Query Language
• Oracle Database Administration
• Codecademy: Learn SQL
• TutorialsPoint: SQL Fundamentals Certification

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