password : almutmiz.net

Request course

طلب كورس

Lynda

[Lynda] Oracle Database 12c: Advanced SQL

password : almutmiz.net

   

Request course

طلب كورس

Written by Curss Curss

password : almutmiz.net

   

Request course

طلب كورس

Author

image of author David YahalomDavid Yahalom

Released

3/29/2018

Mastering SQL is an essential skill for any Oracle professional—and the first step in becoming a true Oracle expert. In this course, Oracle instructor and consultant David Yahalom covers advanced aspects of coding using SQL in an Oracle Database 12c environment. David goes over key topics that can help you develop your Oracle SQL expertise, including database concurrency; transactions; Oracle-specific schema objects such as indexes and PL/SQL procedures, functions, and packages; and table partitioning.

Topics include:

  • Setting up the Oracle Database 12c environment
  • Writing subqueries and inline views
  • Creating table indexes to boost query performance
  • Using the Oracle Data Dictionary
  • Database transactions
  • Creating sequences and triggers
  • Table partitioning benefits
  • Using LIST, RANGE, and HASH partitions
Skill Level Intermediate

2h 36m

Duration

57,706

Views
Show More Show Less
Size: 340.43M

password : almutmiz.net

   

Leave a Comment