Last updated
Kurskode
osqlint
Varighet
14 timer (vanligvis 2 dag inkludert pauser)
Krav
Basic knowledge in Oracle SQL
Oversikt
Publikum
Alle som ønsker å forbedre sine grunnleggende ferdigheter i Oracle SQL og også systematisere allerede fått kunnskap.
Kursets format
25% forelesninger, 75% laboratorier
Machine Translated
Kursplan
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
