Oracle Database 23ai: SQL Workshop OCDBSQL23AI-QA

OCDBSQL23AI-QA
Price on request

This course is designed for Developers and Database Administrators, beginning with the foundational concepts of relational databases and the SQL programming language. It covers writing queries against single and multiple tables, manipulating data within tables, and creating database objects. Participants will learn how to create sequences, synonyms, indexes, and views, manage schema objects, and handle data using subqueries. The course also covers controlling user access and managing data in different time zones.

Understand the core concepts of Oracle Database 23c and its related products.
Learn relational database management concepts and terminologies.
Utilise SQL to query databases effectively.
Retrieve, restrict, and sort data using SQL statements.
Customise output using single-row functions.
Convert data types and use conditional expressions.
Report aggregated data using group functions.
Display data from multiple tables using joins.
Solve queries using subqueries.
Use set operators for data manipulation.
Manage tables using DML statements.
Create and manage database objects including sequences, synonyms, indexes, and views.
Control user access and privileges.
Manage data across different time zones.

Oracle Database 23ai: SQL Workshop

I am interested in selected QA course

GOPAS Praha

GOPAS Brno

GOPAS Bratislava

Business details