Struttura del corso
Introduction to SQL
- Overview of SQL
- Introduction to Oracle SQL Developer
- Basic SQL Syntax
Retrieving Data
- Viewing table data using SELECT statement
- Filtering data with WHERE clause
- Combining conditions with AND & OR clauses
- Sorting data with ORDER BY clause
- Filtering with the IN operator
- Ranges with the BETWEEN operator
- Pattern matching with the LIKE operator
- Handling NULL values
- Adding Comments to SQL code
Understanding Users and Schemas
- Overview of users and schemas in Oracle
- Working with the DUAL table
Joining Tables
- Understanding Primary and Foreign Keys
- Performing Inner Joins
- Exploring Outer Joins
- Handling Link Tables
- Implementing Non-standard Joins
- Self-joins for related table data
Working with Functions
- Using Text Functions for string manipulation
- Manipulating Date data with Date Functions
- Performing calculations with Aggregate Functions
- Conditional processing using DECODE & CASE functions
Sub Queries
- Understanding Nested Sub-queries
- Implementing Correlated Sub-queries
- Utilizing Inline Views (Common Table Expressions)
- Working with ANY, ALL, and EXISTS operators
Requisiti
Participants are expected to have a basic understanding of relational databases and familiarity with fundamental database concepts. No prior experience with Oracle SQL is required, making this course suitable for beginners. A basic understanding of computer operations and data management will be beneficial.
Recensioni (2)
Nel complesso una buona formazione che risponde alle mie esigenze. Ho ricevuto anche informazioni su Oracle VM VirtualBox che mi hanno permesso di continuare la pratica da solo.
Liviu
Corso - Oracle SQL LP - Fundamentals
Traduzione automatica
la parte pratica, il materiale trasmesso.
Roman
Corso - Oracle SQL LP - Fundamentals
Traduzione automatica