Oracle Database SQL And PL/SQL New Features Ed 1 Course

Oracle Database SQL And PL/SQL New Features Ed 1 Training

The Oracle Database 12c: SQL and PL/SQL New Features training introduces you to the new features available in Oracle Database 12c. 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.

80% of Global Fortune 500 organizations are expected to adopt DevOps by 2021 – CA.

ADP, BBC News, Ebay, GE, ING, Intuit, PayPal, Splunk, Uber & Other MNCs worldwide use DevOps.

Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Oracle Database Sql Pl UpComing Batches

Nov-17 - Dec-29

Weekend
SOLD OUT

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Nov-10 - Dec-22

Weekday
SOLD OUT

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Nov-23 - Jan-04

Weekend
FILLING FAST

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Nov-30 - Jan-11

Weekday
FILLING FAST

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-07 - Jan-18

Weekend

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-14 - Jan-25

Weekday

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now
Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Course Curriculum

DOWNLOAD BROCHURE

Oracle Database SQL and PL/SQL

SELF PACED

The Oracle Database 12c: SQL and PL/SQL New Features training introduces you to the new features available in Oracle Database 12c. 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.

  • WEEK 5-6
  • 10 Modules
  • 6 Hours
Course Content

Topics:
  • Course Agenda.
  • Review the Oracle Database 12c SQL and PL/SQL Documentation and Additional Resources.
  • Course Objectives.
  • Schemes Used in this Course.
  • Classroom Account Information.

Topics:
  • SQL Row Limiting Clause.
  • Enhanced DDL Capabilities using ONLINE Keyword.
  • Invisible and Hidden Columns.
  • Additional Features in SQL Language.


Topics:
  • Using SQL IDENTITY Column.
  • Increased Length Limits of Data Types.
  • ANYDATA Type Enhancements.
  • SQL Column Enhancements.
  • GATEWAY Enhancements.


Topics:
  • Additional PL/SQL Enhancements.
  • What is a White List?
  • PL/SQL Functions that Run Faster in SQL.
  • Granting Roles to PL/SQL Packages and Standalone Stored Subprograms.
  • Understanding Invoker's Right and Definer's rRght.


Topics:
  • Multi Partition Maintenance Operations.
  • Improving Query Performance Against OLAP Cubes.
  • Review of Partitioned Indexes.
  • Overview of Synchronous Materialized View Refresh.
  • SQL for Pattern Matching.


Topics:
  • What is in Exadata Express?
  • Evolving from On-premises to Exadata Express.
  • Cloud Deployment Models.
  • Introduction to Oracle Cloud & Oracle Cloud Services.
  • Exadata Express for Users & Developers.
  • Getting Started with Exadata Express.
  • Service Console & Web Access through Service Console.

Program Syllabus

Curriculum

You can also view the program syllabus by downloading this program Curriculum.

Curriculum

Course Description

About The Course
What is SQL and PL/SQL New Features Ed 1 Certification Training about? 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.
When 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.
Objectives Of Our Online PySpark Training Course
What are the objectives of SQL and PL/SQL New Features Ed 1 Certification Training ?
  • Create Invisible and Hidden columns in a table.
  • Understand enhanced DDL capabilities using ONLINE keyword.
  • Identify additional new features available in SQL Language.
  • Identify the increased length limits of data types.
  • Configure database for extended data type.
  • Understand SQL IDENTITY Column.
  • Identify SQL Column enhancements defaulting on explicit NULL and using a sequence.
  • Identify additional feature available in Data Types such as ANYDATA, and GATEWAY.
  • Understand fine grained access controls for packaged procedures.
  • Define invoker's rights function that can be result cached.
  • Implement ACCESSIBLE BY clause.
  • Grant roles to PL/SQL packages and standalone stored subprograms.
  • Identify PL/SQL functions that can run faster in SQL.
  • Maintain Multiple Partitions,Use FETCH clause in SQL queries.
  • Gain an understanding of the Oracle Database Exadata Express Cloud Service.
Go For Online Spark Training
Who is SQL and PL/SQL New Features Ed 1 Certification Training for?
  • Application Developers.
  • Database Administrators.
  • System Analysts.
  • Project Manager.
Learning With Our PySpark Certification Training
What are the prerequisites for SQL and PL/SQL New Features Ed 1 Certification Training? Suggested Prerequisite:-
  • Knowledge of Oracle Database.
  • Structured Query Language(SQL).
  • Basic programming concepts such as IF-THEN statements, loops, procedures, and functions.

Course Certification

OL Tech Edu’s Certificate Holders work at top 500s of companies like

certificate

Features

Explore step by step paths to get started on your journey to Jobs of Today and Tomorrow.

Instructor-led Sessions

30 Hours of Online Live Instructor-Led Classes.
Weekend Class : 10 sessions of 3 hours each.

Real Life Case Studies

Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various real life solutions / services.

Assignments

Assignments

Each class will be followed by practical assignments.

24 x 7 Expert Support

24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.

Certification

Certification

Towards the end of the course, OL Tech Edu certifies you for the course you had enrolled for based on the project you submit.

Course FAQ's

Enroll, Learn, Grow, Repeat! Get ready to achieve your learning goals with OL Tech Edu View All Courses
Top Courses
Stands by you all the way to ensure that you achieve your learning goals.

Top Courses

Partner Courses

Certifications

HELP & SUPPORT

Connect With Us

Get In Touch     Address: 5th Floor(Tower B), A-40, Ithum Tower Sector - 62, Noida Uttar Pradesh   Phone: +91-9654136060   Email: info@oltechedu.com  

© 2015 - 2024 OL Tech Edu. All Rights Reserved.
Designed, Developed & Powered by MNJ SOFTWARE

The website is best experienced on the following version (or higher) of Chrome 31, Firefox 26, Safari 6 and Internet Explorer 9 browsers