The Oracle Database: SQL Workshop II course will help students enhance their skills as Application developers by learning to manage the database objects, data dictionary views and multicolumn subqueries. Students also learn to write more efficient queries using the functions supporting the timezone and regular expressions.
Learn To:
Grant and revoke privileges and roles.
Manage schema objects and data dictionary views.
Write efficient and complex subqueries.
Use the in-built functions supporting the usage of regular expressions and time zone.
BENEFITS TO YOU
This course is designed for application developers with basic SQL language skills. Students learn how to use the advanced features of SQL in order to query and manipulate data within the database. Students will also learn how to control privileges at the object and system level. Advanced querying and reporting techniques are explained. Students will learn to use the regular expression support in SQL.
Students benefit by using Oracle SQL Developer as the main environment tool for writing SQL. SQL*Plus is introduced as an optional tool. Demonstrations and hands-on practice reinforce the concepts.
Don't worry we won't spam you ! You'll only receive one mail per month.
DATUM ACADEMY NEWSLETTER
Thank you for your interest ! Almost done !
We value your privacy and therefore we have send you an email to ask for your permission in order to finalize your newsletter subscription.
We value your privacy!
In order to function properly, our website uses cookies. We process personal data such as IP addresses and cookie identifiers for security reasons but also to understand how you interact with our website and improve your user experience. To continue, we need your agreement by clicking on the button below.