Programming with PL/SQL (11G)
Live / Classroom SessionsDuration : 35 Days
Live Classes Fee
:
1500/-
1000/- *
Offline Classes Fee
:
3000/-
2300/-
Next Offline/Online Batch
- 21/12/2020
- |
- Tuesday
- |
- 03:30 AM
- 21/12/2020
- |
- Tuesday
- |
- 03:30 AM
Live Classes option is available for SSi Digital Academy annual subscribers, Know More about Annual Subscription..
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
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 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.
SSi Digital Benefits
Never miss
Daily session recordings to download
Relearn - Till you become expert
4 years unlimited access to classroom
We cover you
Lifetime access to online course/s with free updates
Practice & feedback
100s of practice assigments with solutions and code feedback
Projects
Live implementation of code
Free placement assistance for all
SSi Digital Academy is preferred placement partner of around 200+ organizations
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
Online Classes
-
Live Classes option is available for SSi Digital Academy annual subscribers, Know More about annual subscription..
- Completion Certificates
- Lifetime access to high-quality self-paced e-learning content and live class recordings
- Monitored assignments & projects
- Learner assistance
INR
1000/-
Offline Classes
- Completion Certificates
- Lifetime access to high-quality self-paced e-learning content and live class recordings
- Monitored assignments & projects
- Learner assistance
- 4 years of unlimited access
INR
999/-
