Oracle Database (SA-301)
Description:
This course presents a comprehensive introduction to the Oracle database management system. It introduces the Oracle Client/Server development environment. Through the extensive hands-on exercises provided by the course, students will focus on practical applications using Oracle SQL Server and PL/SQL.
You Will Learn:
- Introduction to Oracle Database
- Constructing queries against relational and object tables
- Performing joins and grouping
- Updating object tables
- Enforcing business rules using declarative constraints
- Maintaining security
- Improving performance with indexes
- Defining nested tables and VARRAYs
- Controlling logic & handling exceptions
- Building PL/SQL procedures, triggers and packages
- Handling complex requirements with PL/SQL tables