Oracle SQL Fundamentals
Jump to navigation
Jump to search
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