Next Batch -
  • 21/12/2020
  • |
  • Tuesday
  • |
  • 03:30 AM
Register For Free Demo

Course Features

  • Complimentary Life time Access to Core Java Online course
  • Course mentored by Industry expert
  • Project-based learning which will add stars to your resume
  • Course completion certificate
  • 1 Minor Project based on real-world applications

Course Overview

  • This course will help you to learn Python Programming Language which is basic to build Scientific Computing, Data Science, Data Analytics, Machine Learing and AI models and general purpose web applications.. The course will be mentored & guided by an Industry expert having hands-on experience in the design, development & maintenance of Java based web applications.The course includes 2 minor projects based on real-world applications with guided lab sessions.
  • It will be an online live (Live Stream) class, so you can attend this class from any geographical location. It will be an interactive live session, where you can ask your doubts to the instructor (similar to an offline classroom program).
  • Pre-requisites: Will to learn
  • Recommended for: Anyone who wants to learn and build Data Analytics/ ML/ AI Model or Python-based web applications, specifically
    • 1. College students who are looking for training in Python/ NumPy/ Pandas/ Matplotlib/ Django/ Flask
    • 2. Working Professionals who want to learn backend development with Python / Django/ Flask or Data Analytics

Course Mentor

  • Nitesh Sir, synonymous for C, C++, Data Structure and Python Training is a very seasoned trainer loved by students from last 11 years. His knowledge and delivery style for any entry level programming languages training for beginners specifically ' C, C++, Data Structure & Python ' is appreciated not only by graduates, undergraduates but by professionals also who are working on these technologies. He is the most preferred trainer of beginners.

Course Content

  • Explain the need for PL/SQL
  • Explain the benefits of PL/SQL
  • Identify the different types of PL/SQL blocks
  • Output messages in PL/SQL
  • Recognize valid and invalid identifiers
  • List the uses of variables,declare and initialize variables,use bind variables
  • List and describe various data types using the %TYPE attribute
  • Identify lexical units in a PL/SQL block
  • Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions Describe when implicit onversions take place and when explicit conversions have to be dealt with
  • Write nested blocks and qualify variables with labels
  • Write readable code with appropriate indentation
  • Create PL/SQL executable blocks using DML and transaction control statements
  • Make use of the INTO clause to hold the values returned by a SQL statement
  • Identify the uses and types of control structures (IF, CASE statements and expressions)
  • Construct and identify loop statements
  • Apply guidelines when using conditional control structures
  • Create user-defined PL/SQL records
  • Create a record with the %ROWTYPE attribute
  • Create an INDEX BY table and INDEX BY table of records Describe the differences among records, tables, and tables of records
  • Distinguish between usage of implicit and explicit cursors, use SQL cursor attributes
  • Declare and control explicit cursors, use simple loops and cursor FOR loops to fetch data
  • Declare and use cursors with parameters
  • Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause
  • Define PL/SQL exceptions
  • Recognize unhandled exceptions
  • Handle different types of exceptions (pre-defined exceptions, non-redefined exceptions and user-defined exceptions)
  • Propagate exceptions in nested blocks and call applications
  • Differentiate between anonymous blocks and subprograms
  • Create a simple procedure and invoke it from an anonymous block
  • Create a simple function
  • Create a simple function that accepts a parameter
  • Differentiate between procedures and functions
  • Differentiate between anonymous blocks and subprograms, use a modularized and layered subprogram design,and identify the benefits of subprograms
  • Create a simple procedure and invoke it from an anonymous block
  • Work with procedures Handle exceptions in procedures, remove a procedure, and display a procedure's information
  • Differentiate between a procedure and a function
  • Describe the uses of functions
  • Work with functions (create, invoke and remove functions)t
  • Identify the benefits and the components of packages
  • Work with packages (create package specification and body, invoke package subprograms, remove a package and display package information)
  • Overload package subprograms, use forward declarations
  • Create an initialization block in a package body
  • Manage persistent package data states for the life of a session and use PL/SQL tables and records in packages
  • Describe how the DBMS_OUTPUT package works
  • Use UTL_FILE to direct output to operating system files
  • Describe the main features of UTL_MAIL
  • Describe the execution flow of SQL statements
  • Use Native Dynamic SQL (NDS)
  • Use the DBMS_SQL package
  • Create standard constants and exceptions
  • Write and call local subprograms
  • Control the run-time privileges of a subprogram
  • Perform autonomous transactions
  • Use NOCOPY hint, PARALLEL ENABLE hint and DETERMINISTIC clause
  • Use bulk binding and the RETURNING clause with DML
  • Describe different types of triggers and their uses
  • Create database triggers
  • Manage triggers
  • Create triggers on DDL statements
  • Create triggers on system events
  • Create triggers on system events
  • Describe and use conditional compilation
  • Hide PL/SQL source code using dynamic obfuscation and the Wrap utility
  • Track and manage procedural dependencies
Next Batch -
  • 21/12/2020
  • |
  • Tuesday
  • |
  • 03:30 AM
Register For Free Demo

Connect with us on Wats app

Programming with PL/SQL (11G)

Duration : 30 Days

This module is intended for quality assurance engineers test engineers technical managers software engineers customer support engineers and anyone who needs to learn manual testing and also prepare for software testing certifications offered by ISTQB, QAI such as CTFL, CAST, etc

Login to Register
5999
2999