Learn SQL +Security(pen) testing from Scratch (Udemy.com)

Step by step Tutorial to learn SQL and Web Security testing with real time examples

Created by: Rahul Shetty

Produced in 2020

icon
What you will learn

  • You will gain the ability to design any complex SQL to query a database- (SQL)
  • Indepth understanding of GROUP BY,Subqueries,aggregate functions, SQL Server functions,HAVING clauses -(SQL)
  • Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN- (SQL)
  • You will understand the Importance of Session Hijacking Mechanisim and their confidential data use -(Security Testing)
  • You can investigate application behavior with Parameter Tampering and Brute force attacks-(Security Testing)
  • You will get the knowledge of all basics with Http that might cause attacking malicious inputs-(Security Testing)
  • Create or interact with existing databases and test the Database for schema validations - (SQL)
  • Detect Request forgery Designs if present any in Web applications --(Security Testing)
  • You can Clear any Interview on SQL with the Interview questions covered - (SQL)

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 84 / 100

icon
Course Description

SQL and Security Testing are Additional skills which every software Engineer need to have irrespective of their role in Project. And this course fulfills the gap by teaching both these topics and also gives you an edge compared to other Engineers at your work .And of course these are one of the common skills which are tested in every Software Engineer Interview.
  • What make this course special for beginners?
    "No more Boring slides or Definitions. I will write every SQL query before you in lecture and teach every topic needed to master in SQL with Practical examples
  • And also This Tutorial will give all the weapons you needed to investigate and unlock the Security Holes in the Web application with powerful Penetration testing approach
  • Course lectures are conceptually driven with root level explanations and bring you to the level where you can write any kind of SQL query and detect any kind of security bugs in the application

This course covers :

MYSQL :
Introduction to SQL -- MySQLOverview -- Start up commands to Setup Database andTables -- Database testing to validate Schema -- Altering Table Schema operations -- Queries to retrieve Data Logical operators on Queries -- Wild cards usage in Queries -- SQL Functions with real time scenarios -- Importance of Group By in SQL -- Advanced SQL Concepts -- SubQueries syntax and usage -- SQL Joins usage and its advantages -- Importance of views in Database -- SQL String functions -- Dataconstraints with DataBase Testing perspective -- Practise Exercises for Interviews with Solutions -- SQL glossary on discussed topics
Security Testing :
Course Contents: Basics of Security Testing Terminologies involved in Security Domain Top OWASP principles Cross site Scrpiting Xss examples Cookies Importance Danger with stealing of cookies Session Hijacking Cross site forgery Attacks Parameter Tampering Methods to Intercept requests Account Management Password security guidelines Brute force mechanism Importance of Client side validations Who this course is for:
  • Any IT professional no matter in what field they are into
  • QA Testers who want to enhance their skill on Data base Testing and Security testing
  • Freshers/Graduates who want to learn computer science foundations

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

icon
Instructor Details

Rahul Shetty

Nothing is Impossible . It all depends on how we are Trained on it!
Teaching is my Passion. And its my Profession. The only Business I know is Spreading the Knowledge
"Every software Professional have a desire to learn latest IT courses which are trending in the Market but some how 90% of them are giving up their thoughts
Its not due to the lack of courses available in the Market, but its about finding the right Mentor who can guide,teach and understand student's pulse with their background education"

So to full fill all these Gaps, I have established "Testing school" few years ago, And after successful completion of more than 300 offline Training batches.. I am finally
here at Udemy to share all my 13 Years IT Experience Knowledge to QA Colleagues and Students

And you know?? Already 1,00,000 Happy Students are taking advantage with my courses here at Udemy with overwhelmed responses
Below are the course I teach here in this platform and many more on the way!!
For Web Automation Testing :
1.Selenium Tutorial - In Java and Python
2. Protractor Tutorial - Java Script Automation for Angular
3.Selenium- Frameworks
4. Cucumber Framework Tutorial
For Mobile Automation Testing
3. Appium Mobile Testing Tutorial
For API Automation Testing :
4. SoapUI API Automation
5. Rest API

icon
Students also recommend

$59.99

Free

Free

icon
Reviews

4.2

49 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

The first part of the course (SQL) is very good, all concepts are explained with many details and practical exercises, but the second part (safety test) is only theory, does not share a practical example, they are only concepts about pentesting, another negative point is that they don't answer the questions or doubts

Very helpful Rahul. You are the saviour for any Job seeker and Software Automation Engineers/SDET. What a knowledge of Automation. Keep it up. I have enrolled 5 tutorials of yours including this and all are awesome.

All the lectures are so informative and detailed. Nice to have Guide like Mr. Rahul Shetty.

Very good are the courses from this school. I have subscribed in several of them , proud to note . Sometimes the explanations are too long, but it is probably necessary.

till here it was good but my opinion is now we have to concentrate little complex scenarios with groupby

Awesome till now. Very clear.Learnt thousand of things but still need to add interview questions session with hard coded conceptual questions.

Nice videos, easy to understand. But there is no difficult queries like fing nth, 2nd last salary etc which is always asked in the interview. Please ass some more tricky & moderate to difficult queried for the interview purpose.

Yes it is very usefull.

thank you for clearing concepts from scratch...Rahul ssir this is 9th course i am learning from you...share my friend ...Pournima jain and Nandkishor lokhade ..PLease check in db ...:)

Good !!!

Great experience getting the knowledge about the security testing and the cyber threats.

The SQL contents and classes are good however It would be great if we can show practical cases for Security testing as well.Hope you will add more details soon.Also for DB can you put some light on the stored procedures as well so that that does not remain a mystery when it is mentioned somewhere.