Database Testing SQL+PL/SQL

Database testing is very important in a testing cycle of a tester, it is basically used to check the values extracted from the table of a web based or desktop application. The main aim behind drafting this 10 hours of course was to help a beginner level professional to lay a perfect foundation in his/her Testing Career.

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.

Trainer : Karthik & Mahesh

Karthik Kosireddi (Personal Profile) : Software professional with experience in many reputed companies both as techie and admin. A trainer, enjoying the reputation of creating hundreds of software testing experts around the world.

Database Testing SQL+PL/SQL: Course Content

  • Chapter 1 : SQL Overview
  • Outlining SQL as the cornerstone of database activity.
    Applying the ANSI/ISO standards.
    Describing the fundamental building blocks: tables, columns, primary keys and foreign keysl.

  • Chapter 2 : Building the Database Schema
  • Creating tables and columns.
    Building tables with CREATE TABLE.
    Modifying table structure with ALTER TABLE.
    Adding columns to an existing table.
    Removing tables with DROP TABLE.

  • Chapter 3 : Protecting data integrity with constraints.
  • Guaranteeing uniqueness with primary key constraints.
    Enforcing integrity with foreign key constraints.
    Imposing business rules with check constraints.

  • Chapter 4 : Improving performance with indexes.
  • Expediting data retrieval with indexes.
    Recommending guidelines for index creation.

  • Chapter 5 : Manipulating Data.
  • Modifying table contents.
    Adding table rows with INSERT.
    Changing row content with UPDATE.
    Removing rows with DELETE.

  • Chapter 6 : Applying transactions.
  • Controlling transactions with COMMIT and ROLLBACK.
    Deploying BEGIN TRANSACTION in SQL Server.

  • Chapter 7 : Working with the SELECT Statement.
  • Writing Single Table queries.
    Retrieving data with SELECT.
    Specifying column expressions.
    Sorting the result with ORDER BY.
    Handling NULL values in expressions.

  • Chapter 8 : Restricting rows with the WHERE filter.
  • Testing for equality or inequality.
    Applying wildcard characters.
    Avoiding NULL value pitfalls.

  • Chapter 9 : Querying Multiple Tables.
  • Applying the ANSI/ISO standard join syntax.
    Matching related rows with INNER JOIN.
    Including nonattached rows with OUTER JOIN.
    Creating a Cartesian product with CROSS JOIN.

  • Chapter 10 : Combining results with set operators.
  • Stacking results with UNION.
    Identifying matching rows with INTERSECT.
    Utilizing EXCEPT to find nonmatching rows.

  • Chapter 11 : Employing Functions in Data Retrieval.
  • Chapter 12 : Processing data with row functions.
  • Conditional formatting with the CASE expression.
    Utilizing the CASE expression to simulate IF tests.
    Dealing with NULL values.

  • Chapter 13 : Performing analysis with aggregate functions.
  • Summarizing data using SUM, AVG and COUNT.
    Finding the highest/lowest values with MAX and MIN.
    Defining the summary level with GROUP BY.
    Applying filter conditions with HAVING.

  • Chapter 14 : Constructing Nested Queries.
  • Applying subqueries in filter conditions.
    Correlated vs. no correlated subqueries.
    Testing the existence of rows.
    Including subqueries in expressions.
    Placing subqueries in the column list.
    Creating complex expressions containing subqueries.
    Handling subqueries that return no rows.

  • Chapter 15 : Developing In-Line and Stored Views.
  • Breaking down complex problems.
    Selecting data from a query result set.
    Subqueries in the FROM clause.
    Creating views in a database.
    Materialized Views.

  • Chapter 16 : PL/SQL content – Click Here

  • Coming Soon

No videos cannot be downloaded. Videos can only be be streamed online using your secure Member login.

We only provide online trainings as my participants are spread across the world. I do not have any classroom trainings.

Please visit our webpage – https://www.itelearn.com/pricing-option for pricing details

Go to https://www.itelearn.com/wp-login.php There is a member login on the home page. Please login with your credentials.

  • Member Testimonials

    Padmaja Addepalli

    My feedback about ITElearn: 1. The teaching is extremely good. There is no comparison. 2. I learnt a lot from your classes and gained lot... Read More
    2017-08-07T06:42:48+00:00
    My feedback about ITElearn: 1. The teaching is extremely good. There is no comparison. 2. I learnt a lot from your classes and gained lot of interest in automation. 3. The demo videos itself is enough to get into the job. 4. I am very very happy with the course.

    Padmaja Addepalli

    The Informatica class is very interesting and very good teaching. Thank you.
    2017-06-30T12:00:22+00:00
    The Informatica class is very interesting and very good teaching. Thank you.

    Anuradha Velpuri

    I was part of the webinar. I was impressed by the quality, content and very impressed with Mr. Shanker's knowledge. We learned all the terminology,... Read More
    2017-06-30T12:42:59+00:00
    I was part of the webinar. I was impressed by the quality, content and very impressed with Mr. Shanker's knowledge. We learned all the terminology, test scripts and bug reporting. Looking forward to work on HP's QC.

    Suresh Gadepalli

    "It gives me lot of confidence and interest to learn whenever I hear your training videos...I always feel that your effort towards the training is... Read More
    2017-06-30T11:37:22+00:00
    "It gives me lot of confidence and interest to learn whenever I hear your training videos...I always feel that your effort towards the training is 100% undoubtedly but it is me or we  that need to put our 100%. I would like to mention that the quality of audio/video sessions are really good. Your voice is very clear and understandable.No background score which is really appreciated. These positive factors are increasing the trainee's concentration towards the session. I was not able to put my complete effort because of  both project and personal commitments.However, I am moving ahead and gaining knowledge as much as possible from your training videos. I am really blessed to hear someone like you teaching us as if  we are preparing for some board exams. I appreciate all the efforts you are taking to help QA folks across the globe. I wish you all the best!"

    Saleem Arakkal

    I have been learning QA for three months from other source. That course was not enough for me to get an IT job as beginner.... Read More
    2017-06-27T11:54:27+00:00
    I have been learning QA for three months from other source. That course was not enough for me to get an IT job as beginner. While I was searching more tutorials, I accidently found Mr.Karthik's lecture on You Tube. It is very interesting, the free tutorials are very easy to understand, elaborated, the step by step explanation shows that anybody can learn any software if our teacher would be Karthik. So, I joined this course, I hope this is a great opportunity for me. So, I am ready to work hard.

Leave a Reply

Your email address will not be published. Required fields are marked *