Oracle Database: SQL Fundamentals part 1 (English)

This SQL course from Vijfhart provides you with the knowledge and skills to start working with Oracle SQL right away. You will get acquainted with Oracle as a relational database and learn to work with SQL Developer, the tool used to write and execute queries.

Step by step,
you will learn to work with the different types of SQL statements. With Data Definition Language (DDL) you create and modify tables and structures (CREATE, ALTER, DROP, TRUNCATE). With Data Manipulation Language (DML) you manage data (INSERT, UPDATE, DELETE). You will then dive into retrieving and analyzing data using SELECT statements, WHERE filters, GROUP BY, and aggregate functions. You will also learn how to use joins and subqueries to combine data from multiple tables, and how to apply set operators such as UNION, INTERSECT, and MINUS. Finally, important topics such as constraints, operators, and functions will be covered.

You will practice in a personal training environment, where you will write queries, apply filters, combine tables, and use SQL scripts to work more efficiently. This way, you not only build a solid theoretical foundation but also develop the practical skills to confidently apply Oracle SQL in your daily work. The course is suitable for Oracle 12c and higher, with attention to version-specific features up to the current version 23ai.

This course is guaranteed to run.