Oracle Database: SQL Fundamentals part 1 (English) (Active Learning)

Vijfhart IT-Opleidingen

Follow the Oracle SQL course and learn SQL Developer, DDL, DML, SELECT, joins and subqueries. Practice in a personal environment to apply Oracle SQL in your work.

Prijs

vanaf € 3.845

Niveau

Niet opgegeven

Soort

Training

Thema

Automatisering en ICT

Meer informatie en aanmelden bij Vijfhart IT-Opleidingen

Beschrijving

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.