お問い合わせを送信いただきありがとうございます!当社のスタッフがすぐにご連絡いたします。
予約を送信いただきありがとうございます!当社のスタッフがすぐにご連絡いたします。
コース概要
Introduction to Oracle Database 19c
- Overview of Oracle Database 19c
- Installation and configuration
- Oracle database architecture
- Tools for database management
SQL Review and Advanced Concepts
- Basic SQL review
- Select, insert, update, delete
- Joins, subqueries, and set operations
- Advanced SQL concepts
- Analytical functions
- Hierarchical queries
- Advanced grouping and aggregation
Introduction to PL/SQL
- Overview of PL/SQL
- PL/SQL block structure
- Variables, constants, and data types
- Control structures: if, loop, case
PL/SQL Program Units
- Procedures and functions
- Packages and package bodies
- Triggers and trigger management
- Autonomous transactions
Advanced PL/SQL Features
- Collections: associative arrays, nested tables, VARRAYs
- Bulk processing with BULK COLLECT and FORALL
- dynamic SQL with EXECUTE IMMEDIATE
- PL/SQL records and composite data types
Error Handling and Debugging
- Exception handling: Predefined and user-defined exceptions
- PL/SQL debugging techniques
- Using DBMS_OUTPUT and DBMS_DEBUG
Performance Tuning and Optimization
- SQL query optimization techniques
- Understanding execution plans
- Indexing strategies
- Using hints for query optimization
PL/SQL Best Practices
- Writing efficient PL/SQL code
- Coding standards and conventions
- Security considerations in PL/SQL
- Managing dependencies and version control
Advanced SQL Topics
- Advanced joins and subqueries
- Recursive queries
- Using regular expressions in SQL
- Implementing full-text search
Summary and Next Steps
要求
- Basic knowledge of SQL and relational database concepts
- Familiarity with Oracle Database 19c environment
Audience
- Database administrators
- Database developers
- SQL programmers
- IT professionals
28 時間
お客様の声 (3)
he explained very well, and gave guidance on the exercises.
Stoyan - OPEN COURSE
コース - Oracle Database 19c PL and Advanced SQL
I like everything.
Angel - OPEN COURSE
コース - Oracle Database 19c PL and Advanced SQL
I liked very much the format of the training, hands on, directly in sql developer.