|
via Udemy |
Go to Course: https://www.udemy.com/course/plsqltuning/
Certainly! Here's a comprehensive review and recommendation for the Coursera course "PL/SQL Tuning": --- **Course Name:** PL/SQL Tuning **Platform:** Coursera **Overview:** "PL/SQL Tuning" is an in-depth course designed for database professionals, developers, and SQL enthusiasts seeking to optimize their PL/SQL code for better performance and efficiency. This course provides over 30 practical tips with clear explanations and demonstrations, making complex concepts accessible and applicable. **Course Content and Highlights:** The course covers a wide array of essential topics, including: - Using the `DBMS_TRACE` package to analyze execution times and optimize SQL calls within PL/SQL blocks. - Identifying the most performant numeric data types based on compilation type. - Pinning objects in the shared pool using `DBMS_SHARED_POOL`. - Leveraging the `RETURNING` clause for faster SQL statements within stored procedures. - Optimizing large object calls with the `Hint NOCOPY`. - Deciding when to use functions considering code reuse versus performance. - Implementing dynamic SQL efficiently. - Utilizing bind variables for optimized and secure queries. - Understanding native compilation modes for enhanced execution speed. - Applying the Function Result Cache and Pipelined Table Functions for performance gains. - Implementing bulk binding operations for processing large datasets. - Using `CURRENT OF` to streamline data update operations. - When to prefer pure SQL over PL/SQL for better performance. - Working with deterministic functions and short-circuit logic. - Best practices for employing stored procedures in transactional environments. **Review:** This course stands out for its practical approach, focusing on real-world scenarios and standard best practices. The breakdown of tips is methodical, and the accompanying demonstrations make complex optimization techniques understandable. Whether you’re an experienced DBA or a developer looking to fine-tune your PL/SQL code, this course offers valuable insights that can significantly impact your application's performance. The absence of a formal syllabus may be a drawback for those who prefer structured outlines, but the comprehensive nature of the content compensates for this. The focus is exclusively on tuning and optimization, making it ideal for learners who want targeted knowledge. **Recommendation:** I highly recommend "PL/SQL Tuning" to anyone working with Oracle databases and PL/SQL programming. The course provides actionable tips that can lead to immediate improvements in code efficiency, reduce execution time, and optimize resource utilization. Whether you aim to improve existing codebases or develop new high-performance applications, this course is a valuable resource. **Conclusion:** "PL/SQL Tuning" on Coursera offers a thorough exploration of practical optimization techniques that are essential for modern database development and management. The combination of theoretical insights and practical demonstrations makes it a must-take course for professionals committed to maximizing their PL/SQL code performance. --- Feel free to ask if you'd like a shorter summary or specific details about any of the topics!
Mais de 30 dicas com explicações e demonstrações para você otimizar código PL/SQL:1- Package DBMS_TRACE: Como utilizar o package DBMS_TRACE para analisar o tempo de execução de blocos PL/SQL, (inclusive o tempo de instruções SQL que são chamadas dentro de blocos PL/SQL).2- Tipos de dados numéricos: Quais os tipos de dados numéricos mais performáticos (conforme tipo de compilação utilizada).3- Package DBMS_SHARED_POOL: Como utilizar o package DBMS_SHARED_POOL para pinar objetos na Shared Pool.4- Cláusula RETURNING: Como utilizar a cláusula RETURNING para otimizar instruções SQL, em Stored Procedures.5- Hint NOCOPY:Como otimizar chamadas de funções e procedures que recebem objetos grandes (Ex.: Collections).6- Uso de funções: Quando utilizar funções considerando reutilização de código X performance.7- SQL dinâmico: Quando utilizar SQL dinâmico considerando escrever menos código X performance.8- Variáveis bind: O que são variáveis bind, como e quando utilizá-las.9- Compilação em modo nativo: O que é compilação em modo nativo, como e quando utilizá-lo.10- Function Result Cache: O que é "Function Result Cache", como e quando utilizá-lo.11- Pipelined Table Function: O que é "Pipelined Table Function", como e quando utilizá-lo. 12- Bulk binding: O que é "Bulk binding", como e quando utilizá-lo. 13- Cláusula CURRENT OF: Como utilizar a cláusula CURRENT OF para otimizar blocos PL/SQL que atualizam dados utilizando processamento IF/UPDATE/INSERT. 14- Quando evitar PL/SQL: Dicas e exemplos de quando escrever SQL puro, ao invés de código PL/SQL, para otimizar código. 15- Funções determinísticas: O que são Funções determinísticas, como e quando utilizá-las. 16- Short-circuit: O que é short-circuit, como e quando utilizá-lo. 17- Stored procedures: Quando utilizar Stored Procedures para otimizar transações.