Oracle Database: SQL Fundamentals part 1 (English)

• Module 1 – Introduction to Oracle
• Module 2 – Introduction to SQL
• Module 3 – Data definition
• Module 4 – Data manipulation
• Module 5 – Retrieving information
• Module 6 – Grouping
• Module 7 – Operators
• Module 8 – Functions

• Module 9 – Constraints
• Module 10 – Multiple tables – joins
• Module 11 – Multiple tables – ANSI joins
• Module 12 – Multiple tables – subqueries
• Module 13 – SET Operators
• Module 14 – Extra data definition
• Module 15 – SQL Scripts

View more subjectsView less subjects

• Module 1 – Introduction to Oracle
  • Preface- Introduction to Oracle
  • Database
  • Relational database
  • Oracle tools
  • The Oracle Cloud
  • Accessing the Oracle database
• Module 2 – Introduction to SQL
  • Preface – Introduction to SQL
  • Foundations of SQL
  • Local Database
  • SQL Developer
  • Connection Navigator
  • SQL Worksheet
  • Toolbar
  • Menus
  • Change the screen layout
  • Saving statements
• Module 3 – Data definition
  • Data definition – preface
  • Reading a syntax diagram
  • CREATE TABLE
  • Column specification
  • ALTER TABLE
  • NULL values
  • Identity columns
  • Default values
  • DROP COLUMN
  • Invisible columns
  • DROP TABLE
  • PURGE – empty the recycle bin
  • FLASHBACK TABLE
  • Virtual columns
• Module 4 – Data manipulation
  • Data manipulation – preface
  • Transaction control
  • INSERT – add rows
  • UPDATE – change data
  • DELETE – remove rows
  • TRUNCATE TABLE
  • DML on an identity column
  • DML on virtual columns
  • Transaction control settings
• Module 5 – Retrieving information
  • Retrieving information – preface
  • Selection of rows
  • SELECT clause – projection
  • FROM clause – specify tables
  • WHERE clause – specify conditions
  • ORDER BY clause – sort the result
  • Eliminate duplicate rows
• Module 6 – Grouping
  • Grouping – preface
  • Aggregate functions
  • GROUP BY clause – grouping rows
  • Nesting group functions
  • HAVING clause – filter groups
• Module 7 – Operators
  • Operators – preface
  • Arithmetic operators
  • Operators for date fields
  • Operators for strings
  • Comparison operators
  • Operators for string patterns
  • Operators for ranges
• Module 8 – Functions
  • Functions – preface
  • The use of functions
  • String functions
  • Numeric functions
  • Nested functions
  • Date functions
  • Conversion functions
  • National Language Support
  • Miscellaneous functions
  • Cast

• Module 9 – Constraints
  • Constraints – preface
  • Definition of constraints
  • NOT NULL constraints
  • Unique key constraints
  • Primary key constraints
  • Foreign key constraints
  • Check constraints
• Module 10 – Multiple tables – joins
  • Joins – preface
  • Ordinary joins
  • Outer joins
• Module 11 – Multiple tables – ANSI joins
  • ANSI joins – preface
  • ANSI jointypes
• Module 12 – Multiple tables – subqueries
  • Subqueries – preface
  • Subquery types
  • Subqueries versus joins
  • EXISTS
  • Subqueries in a SELECT clause
  • Inline views
• Module 13 – SET Operators
  • SET Operators – preface
  • SET operator types
  • Nesting SET operators
• Module 14 – Extra data definition
  • Extra data definition – preface
  • Users and schemas
  • Object names
  • The Data dictionary
  • CREATE / ALTER / DROP VIEW – virtual tables
  • CREATE SYNONYM
  • RENAME
  • COMMENT- add information to an object
  • Sequences
  • Indexes
• Module 15 – SQL Scripts
  • SQL Scripts – Preface
  • Comments
  • Substitution variables