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
[edit | edit source]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
[edit | edit source]- Introduction
- Selecting Data
- Restricting Data
- Sorting Data
- Single-Row Functions
- Conversion Functions
- Conditional Expressions
- Aggregating Data
- Joining Data
- Subqueries
- Set Operators
- Manipulating Data
- Transactions
- Data Definition Language
- Other Schema Objects
See Also
[edit | edit source]- Database Fundamentals
- Database Software
- Information Systems
- Wikibooks: Structured Query Language
- Oracle Database Administration
- Codecademy: Learn SQL
- TutorialsPoint: SQL Fundamentals Certification
References
[edit | edit source]- 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