SQL and PL/SQL Schulung:
Discover the new features in Oracle Database 12c
The Oracle Database 12c: SQL and PL/SQL New Features training introduces you to the new features available in Oracle Database 12c. Expert Oracle University instructors will help you explore the latest features available in SQL language and feature enhancements in PL/SQL, data types, language performance and data warehousing. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.Learn To:Understand the FETCH clause to limit the rows returned by a SQL query.Take advantage of the invisible and hidden columns.Make use of the IDENTITY column to automatically generate the number column.Utilize the ACCESSIBLE BY clause to create a white list of PL/SQL units.Grant roles to PL/SQL packages and standalone stored procedures.Understand Synchronous Materialized Views.Identify ways to improve query performance against OLAP cubes.Gain an understanding of the Oracle Database Exadata Express Cloud Service.Benefits to YouWhen you walk away from this course, you will have gained a better understanding of the data warehousing new features available in Oracle Database 12c. This includes maintaining multiple partitions and SQL for pattern matching.A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.