Description
After a brief description of relational concepts and Oracle objects, we will discuss in detail how to manipulate data from an Oracle database using SQL Data Manipulation Language (DML) statements. In addition to the basic SELECT form, the student also learns how to build more complex queries (joins, subqueries, group functions). Afterwards, the statements for changing the data are discussed (INSERT, UPDATE, DELETE).
In the second part, the student learns to use the Data Definition Language (DDL) to create database objects (tables, views, indexes, sequences, synonyms). He learns how to guarantee the integrity of the database based on constraints. The consultation of the data dictionary is briefly discussed. Finally, the most important concepts of Oracle security are mentioned.
The exercises and demos use the Oracle LiveSQL environment. Only a local browser is required.
Audience
Analyst programmers, technical designers, DBAs, functional analysts.
Methods
Classroom training interspersed with exercises.
Contents
- Introduction
- Data manipulation language
- SELECT
- Basic shape
- SELECT DISTINGUISH
- CASE
- Expressions and conditions
- SORT BY
- IN, IN BETWEEN, LIKE
- NULL values
- Driving features
- Group functions and GROUP BY... HAVE
- Data types
- Hierarchical queries
- PARTICIPATE (CROSS, INSIDE, OUTSIDE)
- UNIQUE, CUT, MINI
- Subqueries: IN, ALL, ANY/SOME, EXISTS
- UPDATE
- INSERT
- MERGE
- DELETE
- Data definition language
- SHOVEL
- TABLE
- INDEX
- VIEW
- MATERIALIZED VIEW
- ORDER
- COMMENTARY
- SYNONYMOUS
- CLUSTER
- AGE
- DROPLET
- Data Dictionary Views
- Integrity
- Primary keys and entity integrity
- Foreign keys and referential integrity
- The role of database triggers in integrity monitoring
- Data Management Language
- COMMIT
- SAVE
- ROLLBACK
- Safety
- Users and roles
- Privilege management via GRANT and REVOKE
- Exercises
Certification
Participation certificate: At the end of the training, participants will receive a certificate that they have completed this course.