お問い合わせを送信いただきありがとうございます！当社のスタッフがすぐにご連絡いたします。
予約を送信いただきありがとうございます！当社のスタッフがすぐにご連絡いたします。
コース概要
Create complex queries to databases
- Use available operators
- Queries with multiple conditions
Creating tables and references
- DDL commands (create, alter, and drop)
- Create referential integrity
- Normalization of tables (up to 3 normal form)
- anomalies and ways to avoid them
Changes in the structure of existing tables
- ALTER clause
Manipulation of data
- DML commands (insert, update, delete)
Creating new users and granting permissions
- DCL commands (grant, revoke)
Linking Tables
- Internal and external joins
Data Aggregation
- Features of grouping functions
- Use the GROUP BY clause and HAVING
- Grouping multiple column
Subqueries
- multi-column
- correlated
- WITH clause
要求
Basic knowledge in Oracle SQL
14 時間
お客様の声 (2)
I enjoyed the access to trainers individual support in resolving exercises.
Tomasz Czornak
コース - Oracle SQL Intermediate
Trainer provided some topic and support it with plenty of exercises. We had a chance to apply knowledge by doing them on our own.
