Home └SQL Basics
SQL Basics

SQL Basics

This training provides a practical and structured introduction to working with Oracle SQL and PL/SQL.  

It is designed for beginners and advanced users who want to query, process, and analyze data effectively. 

Training Contents: 

This course offers a hands-on introduction to the world of relational databases with a focus on Oracle SQL. Participants will learn the basics of database structure and functionality, as well as the first steps in working with SQL queries. The goal is to build a solid foundation for the safe and effective handling of data.

Private Course
Please sign in to contact responsible
Responsible Oliver Fels
Last Update 06/19/2025
Completion Time 3 hours 20 minutes
Members 4
  • Modul 1 - Introduction to databases
    6Lessons · 1 hr 5 min
    • Einführung in relationale Datenbanken
      10 xp
    • Tables & Data Structures
      10 xp
    • Visualization and Modeling
      10 xp
    • Relations
      10 xp
    • Key Events
      10 xp
    • Database Languages
      10 xp
  • Modul 2 - SQL Queries
    5Lessons · 1 hr
    • Introduction to the example data model
    • Select Statement
      10 xp
    • Data Filtering
      10 xp
    • Weitere Formate
    • DISTINCT Selection
  • Modul 3 Funktionen
    2Lessons · 50 min
    • Date comparisons & conditional statements
      10 xp
    • Character & numeric functions
      10 xp
  • Modul 4 Unterabfragen und Unions
    2Lessons · 25 min
    • String operations & Formatting
    • Combining with Union
      10 xp
  • Modul 5 - Tabellenverknüpfung und JOINS
    2Lessons ·
    • INNER JOIN, LEFT JOIN, RIGHT JOIN
    • INNER JOIN, LEFT JOIN, RIGHT JOIN
  • Modul 6 – Funktionen, Systemelemente & Null-Werte
    3Lessons ·
    • LIMIT, FETCH FIRST, ROWNUM
    • Aggregate Funktionen & GROUP BY
    • HAVING, EXISTS & related
  • Modul 7 – DDL & DDM: Tabellen, Views & Datenmanipulation
    1Lessons ·
    • MERGE