Oracle Database: SQL Fundamentals part 1 (English)

Lesmethode :

Persoonlijk begeleid

Algemeen :

This SQL course from Vijfhart provides the skills to start working confidently with Oracle SQL right away. Learn how to retrieve, filter, combine, and analyse data within an Oracle database. All topics are aligned with real-world situations so everything learned can be applied immediately.

The content follows the official Oracle Fundamentals Part 1 learning path. Topics include writing SELECT statements, filtering results with WHERE, sorting data, summarising with aggregate functions, and combining tables using joins. Subqueries and commonly used SQL functions are also covered. Step by step, this builds a solid foundation in Oracle SQL.

Every assignment is focused on direct applicability. Building queries, applying filters, and combining data from multiple tables develops strong Oracle SQL skills and confidence in using them.

Doel :

Write clear and efficient SQL queries in Oracle independently. Select, filter, combine, and analyse data in a structured way. Build a strong base for more advanced query techniques and broader data analysis skills.

Doelgroep :

This SQL course is designed for database developers, data analysts, functional administrators, and IT professionals who work with Oracle databases or plan to do so. No prior SQL experience is required. Basic skills in Windows or an integrated development environment are sufficient.

Voorkennis :

There are no specific prerequisites for this course.

Onderwerpen :

Introduction to Oracle
Introduction to SQL
Data definition
Data manipulation
Retrieving information
Grouping
Operators
Functions
Constraints
Multiple tables - joins
Multiple tables - ANSI joins
Multiple tables - subqueries
SET Operators
Extra data definition
SQL Scripts