|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/pl-sql-interview-questions/
课程评论：没有评论
课程名称：PL/SQL面试问题及实例 课程概述：在当今的求职市场中，ETL开发者、数据库开发者及其他与ETL相关职位的候选人经常需要回答Oracle PL/SQL和性能调优相关的问题。本课程适合想快速学习PL/SQL的学员，或是正在准备面试的人士。课程全面涵盖了PL/SQL的各个主题，并结合使用SQL Developer等实时开发工具进行示例讲解。课程内容经过多年数据库领域的经验精心设计，旨在增强学习者的信心。 课程主要包括与Oracle SQL及PL/SQL相关职位面试中常见的问题。每个章节通过解释和实例详细说明了相应的概念，涵盖了基于实际应用的案例。同时，课程还涉及Oracle提供的内置包及其子程序的讲解，帮助学员全面理解各个主题。 除了基本的面试问题，课程还介绍了一些性能调优的概念，如EXPLAIN_PLAN、Oracle提示等。主要涵盖的主题包括： - 基础面试问题：讲解18个最常见的问题及其答案和实例，涵盖SQL与PL/SQL中的主要主题。 - DBMS_JOB：介绍DBMS_JOB包中主要子程序的用法与示例。 - DBMS_RANDOM：展示DBMS_RANDOM包的主要子程序及实例。 - DBMS_OUTPUT：解析DBMS_OUTPUT包的主要子程序及实例。 - UTL_FILE：讨论UTL_FILE包的主要子程序及实例。 - DBMS_SQL：提供动态SQL的基本理解，并描述一些子程序的实例。 - DBMS_PIPE、DBMS_UTILITY、DBMS_LOB：详细介绍光标的使用及类型，结合实例说明。 - BULK OPERATIONS：面试准备中的重要主题，课程中有详细解释和实例。 - MATERIALISED VIEWS及AUTONOMOUS TRANSACTIONS：经常被问及的主题，课程对其进行了深入讲解。 - TRIGGERS：介绍触发器的用法及其类型，附以实例。 - 性能调优：最后，课程将涉及DBMS_PROFILER、EXPLAIN PLAN和ORACLE HINTS的内容。 这门课程将为学员提供全面的知识基础和实际应用能力，帮助他们在求职过程中脱颖而出。
Now days it is very common that you will be asked Oracle PLSQL and performance tunning questions at any Interviews for ETL developer or Database Developer or any other positions related to ETL jobs. You can take this course weather you want to learn PLSQL quickly but practical way or you preparing for Interviews. This course covers all PLSQL topics along with examples using real time development tools like SQL Developer. I have created all these important topics very carefully and after several years of experience in Database field which will bring you lot of confidence.This course mainly includes various questions asked during Interview for Oracle SQL and PL SQL related positions.Each session explains the concept by providing explanation and examples.Course includes all questions with explanation using real world practical examples.Also it includes explanation for inbuilt Oracle supplied packages and the subprograms provided by them. You can get the good understanding of topics which are explained with number of examples.Also Course includes some performance tuning concepts like EXPLAIN_PLAN, Oracle hints etc.Topics Covered -Basic Interview Questions: This will present 18 most frequently asked questions will answers and examples.These questions covers most of the main topics in SQL and PLSQL.DBMS_JOB: This presents the main subprograms provided by package DBMS_JOB with examples.DBMS_RANDOM: This presents the main subprograms provided by package DBMS_RANDOM with examples.DBMS_OUTPUT: This presents the main subprograms provided by package DBMS_RANDOM with examples.UTL_FILE: This presents the main subprograms provided by package DBMS_RANDOM with examples.DBMS_SQL: It will provide you with basic understanding of Dynamic SQL and describe some of the subprograms with examples.DBMS_PIPE: DBMS_UTILITYDBMS_LOBCURSORS: This details on the use of cursors, types with examplesBULK OPERATIONS: This is majorly an important topic if you are preparing for an interview. You may find detailed explanation with examples in tutorial. MATERIALISED VIEWS AUTONOMOUS TRANSACIONS: This is a good topic frequently asked during interviews. You can understand it well while going through tutorialTRIGGERS: This details on the use of Trigger, its types with examplesPerformance Tuning: Last but not least, we will cover -DBMS_PROFILER, EXPLAIN PLAN & ORACLE HINTS
