Format:   Facilitated hands on training
Duration:   3 days
Hours:   09h00 to 16h00
Materials:    Complete learners guilde with learner excercises
Prerequisites:    Completion of Introduction to Oracle SQL
Location:   Midrand training facility
Price:   R 6,400 (computer provided by AppLinks)
R 5,400 (computer provided by learner)
All prices are exclusive of VAT
Limitation:   Minimum of 4 learners is required for course scheduling

Once you know the basics of SQL, it’s time to delve deeper. SQL is extremely powerful and usually the basics aren’t quite enough. There is not many data questions that cannot be answered and outputted by SQL. The course will take you through some advanced concepts in Oracle SQL.

Course Outline

  • Using DECODE and CASE statements
  • Using UNION, INTERSECT, and MINUS operations
  • Writing subqueries and correlated subqueries
  • Using DISTINCT, EXISTS and NOT EXISTS
  • Advanced joins
  • Coding queries on portioned data
  • Advanced data grouping
  • Oracle analytic functions
  • Using the MODEL clause
  • Using CONNECT BY
  • Regular expressions in SQL
  • Using date and time functions
  • XML and XMLType
  • Using WITH, MERGE, HAVING and RETURNING clauses
  • Using ROW_NUMBER, RANK and DENSE_RANK

Registration

Advanced Oracle SQL 1

Advanced Oracle SQL 1
9-11 October 2019
Please type your name.
Please type your Surname.
Invalid email address.
Please insert company name
Please insert company name
Invalid Input

Contact Us

Please let us know your name.
Please let us know your email address.
Invalid Input
Please write a subject for your message.
Please let us know your message.
Invalid Input

Contact Us

Our Address

AppLinks (Pty) Limited
20 Wildebees Street
VerWoerdpark
Alberton, South Africa
+27 (0) 11 902 3688
+27 (0) 83 276 3315