یکی از تخصص‌های ضروری برای Programmerها و DBAهای پایگاه‌داده دانش SQL Tuning است. SQL Tuning یکی از حرفه‌ای‌ترین و پیچیده‌ترین اموری است که یک متخصص SQL در هر جایگاهی می‌تواند انجام دهد. این تخصص عمدتاً هم از DBAای بالاتر است و هم از برنامه‌نویسی به خصوص در شرکت‌های بزرگ که امروزه با توجه به حجم کثیر اطلاعات دارای افت کارایی و عملکرد می‌باشند.

امروزه عملیات Tuning در کشور های خارج از ایران، یکی از مهمترین و پر درآمدترین مشاغل IT می باشد، و تسلط بر این دانش در استخدام‌ها یک مزیت بزرگ محسوب می‌شود.

دوره Oracle Database 11g: SQL Tuning Workshop دانشگاه اوراکل به این تخصص مهم می‌پردازد.

What you will learn

This Oracle Database 11g: SQL Tuning Workshop Release 2 training assists database developers, DBAs and SQL developers in identifying and tuning inefficient SQL statements. You’ll explore investigative methods to reveal varying levels of detail about how the Oracle database executes the SQL statement; this helps you determine the root causes of the inefficient SQL statements.

Learn To:

– Use Oracle tools to identify inefficient SQL statements.
– Use Automatic SQL Tuning.
– Use Real Time SQL monitoring.
– Write more efficient SQL statements.
– Monitor and trace high load SQL statements.
– Manage optimizer statistics on database objects.
– Interpret execution plans, and the different ways in which data can be accessed.

Benefits to You

Gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data. These features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects.

Explore the Optimizer

Expert instructors will also help you explore how the optimizer chooses the path. You’ll also learn how to influence the optimizer to ensure the best method is used.

Automatic SQL Tuning Tools

This course covers Automatic SQL Tuning tools and resources available in the Automatic Workload Repository. Furthermore, take advantage of bind variables, trace files and different types of indexes.

Note: this course is based on Oracle Database 11g Release 2.

ادامه مطلب

Oracle Database: SQL Fundamentals II

Duration: 2 Days

What you will learn
This Oracle Database: SQL Fundamentals II training is designed for application developers with basic SQL language
skills. Expert instructors will teach you how to add new users with different levels of access privileges, use scalar and
correlated subqueries and more.

Learn To:

– Control privileges at the object and system level.
– Create indexes, constraints and alter existing schema objects.
– Create and query external tables and use the advanced features of SQL to query and manipulate data within the
database.
– Use the dictionary views to retrieve metadata and create reports about their schema objects.
– Write SQL statements that include the new functions introduced in Oracle Database 11g to enhance regular expression
support functionality.
– Use Oracle SQL Developer as the main tool; SQL*Plus is available as an optional tool.
– Control database access to specific objects.
– Manage schema objects.
– Manipulate large data sets in the Oracle database by using subqueries.
– Manage data in different time zones.
– Retrieve data by using advanced subqueries.
– Use the regular expression support in SQL to search, match, and replace strings in terms of regular expressions.

Benefits to You

Gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data. These features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects.

دریافت سرفصل‌ها
حجم: 32.5 کیلوبایت

ادامه مطلب

Oracle Database: SQL Fundamentals I

Duration: 3 Days

What you will learn

This course is now offered as part of a 5-day course /a/b/p/p/b/pulli/lili/lili/lili/lili/lili/li/ul/b/p/p/p/p/p/

Audience

Application Developers End Users Forms Developer Functional Implementer PL/SQL Developer Portal Developer Reports Developer Technical Consultant

Related Training

Required Prerequisites Familiarity with data processing concepts and techniques.

دربافت سرفصلها
حجم: 31.3 کیلوبایت

ادامه مطلب