Loading Events

  • This event has passed.

SQL+PL/SQL LIVE TRAINING

Core Idea: With a lot of data flowing into applications, it is expected of testers to test this data stored in the database.Understanding the process to communicate with the database systems becomes crucial here and this can be achieved using SQL. With complex systems and logics, queries are to be fine tuned and they must be intelligent enough to take inputs and combine with the programming techniques to fetch output for the complex logics written for a given application. And that is what PL/ SQL is all about, combining SQL with Programming techniques.

Intent: To get users evaluate and learn Basics and Advanced SQL concepts

Date and Time: Paid Training Sessions starts from 30th May to 13th June 2017 (Mon-Thu) @ 5.30 PM Pacific.

  • Advanced level training of SQL.
  • Perfect fit for those looking for Database or ETL testing.
  • Perfect course for beginners and QA Engineers who plan to move to backend testing
  • Basic to Advanced level training of SQL.

Note: If a non member wishes to opt for any of the individual course, then they will have to click on the amount chosen. Existing members can send us an email at learn@itelearn.com for the payment link.

Topic Presenter
  • Introduction to Programming Languages
  • Introduction to PL/SQL
  • The Advantages of PL/SQL
  • PL/SQL Architecture
  • PL/SQL Data types
  • Variable and Constants
  • Using Built_in Functions
  • Conditional and Unconditional Statements
  • Simple if, if… else, nested if..else, if..else Ladder
  • Selection Case, Simple Case, GOTO Label and EXIT
  • Iterations in PL/SQL
    • Simple LOOP,WHILE LOOP,FOR LOOP and NESTED LOOPS
    • SQL within PL/SQL
    • Composite Data types (Complete)
    • Cursor Management in PL/SQL
    • Implicit Cursors
    • Explicit Cursors
    • Cursor Attributes
    • Cursor with Parameters
    • Cursors with LOOPs Nested Cursors
    • Cursors with Sub Queries
    • Ref. Cursors
    • Record and PL/SQL Table Types
Mahesh
Advanced PL/SQL Mahesh
  • Procedures in PL/SQL :
  • STORED PROCEDURES
  • PROCEDURE with Parameters (IN,OUT and IN OUT)
  • POSITIONAL Notation and NAMED Notation
  • Procedure with Cursors
  • Dropping a Procedure
    • Functions in PL/SQL :
    • Difference between Procedures and Functions
    • User Defined Functions
    • Nested Functions
    • Using stored function in SQL statements
      • Packages in PL/SQL :
      • Creating PACKAGE Specification and PACKAGE Body
      • Private and Public Objects in PACKAGE
EXCEPTIONS in PL/SQL Mahesh
  • Types of exceptions :
  • User Defined Exceptions
  • Pre Defined Exceptions
  • RAISE_APPLICATION_ERROR
  • PRAGMA_AUTONOMOUS_TRANSACTION
  • SQL Error Code Values
Database Triggers in PL/SQL Mahesh
  • Types of Triggers
  • Row Level Triggers
  • Statement Level Triggers
  • DDL Triggers
  • Trigger Auditing
File Input/Output Mahesh
  • PL/SQL file I/O (Input/Output)
  • Using UTL_FILE Package
Implementing Object Technology Mahesh
  • What is Object Technology ?
  • OOPS-Object Instances
  • Creation of objects
  • Creating User Defined Data Types
  • Creating Object Tables
  • Inserting rows in a table using Objects
  • Retrieving data from Object based Tables
  • Calling a Method
  • Indexing Abstact Data type Attributes
Using LOBS Mahesh
  • Large Objects (LOBS)
  • Creating Tables-LOB
  • Working with LOB values
  • Inserting, Updating & Deleting Values in LOBs
  • Populating Lobis DBMS_LOB Routines
  • Using B-FILE
Using Collections Mahesh
  • Advantages of collection
  • Ref cursor (Dynamic Cursor)
  • Weak ref cursor
  • Strong ref cursor
  • Nested Tables VARRAYS or VARYING arrays
  • Creating tables using nested tables
  • Inserting, updating & deleting Nested
  • Table records
  • Nested table in PL/SQL
Oracle Database Architecture Mahesh
  • Introduction to Oracle Database Architecture
  • Physical structures Logical structures
  • DB Memory Structures Background Process
  • 2 Tire, 3 Tire, N-Tier Architecture
Advanced Features Mahesh
  • 9i Joines
  • New Date function
  • Rename column
  • Inner Join/Natural Join
  • Left Outer Join/Right Outer Join
  • Full Outer Join
  • Multiple Inserts
  • Insert All Command
  • Merge statement
  • NVL2(), NULLIF(), COALESCE()
  • CASE expression of Select Command
  • Temporary Tables/Global Tables
  • New Function EXTRACT()
  • Autonomous Traction
  • Pragma _ Autonomous_ Transaction()
  • Bulk Collect
  • About Flash Back Queries
  • Dynamic SQL
  • New data types, Flash back Command
  • Purge Command, Recyclebin
  • Regular expressions, DML Error Logging
  • Data Pump, Virtual Columns
  • Read only tables, Cross tab Views using
  • Pivot/Unpivot operators, Follows Clause
  • Compound triggers, New data types
DBA CONCEPTS Mahesh
  • Database
  • Tablespace
  • Types of tablespaces

  • Videos: ($75)
  • Live+Videos: ($100)

Duration

12 hours

Eligibility

– Anyone looking for an IT job.
– Basics of MS Office (MS Word and MS Excel)

Ideal Trainees

– Non IT
– Manual Testers
– Job Seekers
– Automation Testers
– Business Analyst

  • Member Testimonials

    Prasad Mysore

    Karthik, I feel I am behind your shoulder and learning the job. I cannot wait my status to get so that I  can enroll... Read More
    2017-06-30T12:19:22+00:00
    Karthik, I feel I am behind your shoulder and learning the job. I cannot wait my status to get so that I  can enroll in your training program. 3 of my friends are joining for your program on my suggestion.Kudos to your knowledge tranfer. According to my survey on QA training, yours is one stop learn.Thanks for free videos.

    Suhasi Nair

    Karthik, u r really great in explaining, superb videos, have learnt some techniques n watching the chain to become an expert,thnx a lot
    2017-06-30T12:16:37+00:00
    Karthik, u r really great in explaining, superb videos, have learnt some techniques n watching the chain to become an expert,thnx a lot

    Pardhiva

    When I spoke about Web Edit Object, Web Button Object, Methods to perform such as SET, CLICK, XPath, Differenciating Index being 0, 1 for similar... Read More
    2017-06-30T11:36:39+00:00
    When I spoke about Web Edit Object, Web Button Object, Methods to perform such as SET, CLICK, XPath, Differenciating Index being 0, 1 for similar objects in the interviews, it gave a good impression with employers of me. I owe it to Karthik only. Also a golden lesson of asking us to practice 2 to 3 times, helped me personally. I do not have programming language experience. At the Third time practice, I could understand what Karthick was telling in QTP and Selnium (I took QTP course and repeated QTP course and took videos option for QTP. I took Selenium Course and am considering to repeat or video access for Selnium Course) Generally It also helps to give permission to Students to access videos for 12 months at a time with affordable fees like 100 dollars per year for QTP and 100 dollars per year for Selenium so that we can stay in touch with Vb Script in QTP and Java in Selenium, I will highly be interested in taking video option again for QTP and Selenium and also will take new courses like Secuirty Testing, Web Services Testing offered by Karthick when they start.

    Testimonial 1

    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam vitae imperdiet neque, nec elementum diam. Integer vel libero nunc. Vestibulum enim eros, tincidunt non dignissim... Read More
    2017-08-01T09:55:37+00:00
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam vitae imperdiet neque, nec elementum diam. Integer vel libero nunc. Vestibulum enim eros, tincidunt non dignissim eu, aliquam eu libero. Nulla scelerisque, mi ac laoreet facilisis, nisl nulla tristique mi, non laoreet est nisl sit amet velit.

    Guy Noel

    I am enjoying ITeLearn videos day by day. It's a very informative program. I was able to handle 3 interviews about Selenium after viewing videos... Read More
    2017-06-30T11:37:41+00:00
    I am enjoying ITeLearn videos day by day. It's a very informative program. I was able to handle 3 interviews about Selenium after viewing videos from the first 3 sessions. I believe that I will master Selenium by the end of the last video. Thank you for sharing your knowledge.
  •