The ‘Learn SQL +Security(pen) testing from Scratch’ is a step by step tutorial that teaches SQL and Web Security testing with real time examples. The course will teach you all the fundamentals of SQL and also prepares you with the SQL interview questions.
By the end of this course, you will gain the ability to design any complex SQL query to a database. The course is usually available for INR 2,799 on Udemy but you can click on the link and get the ‘Learn SQL +Security(pen) testing from Scratch’ for INR 499.
Who all can opt for this course?
- IT professional, regardless of the industry they work in.
- QA testers looking to improve their abilities in security and data base testing.
- Graduates who want to master the basics of computer science.
Course Highlights
| Key Highlights | Details |
|---|---|
| Registration Link | Apply Now! |
| Price | INR 499 ( |
| Duration | 13 Hours |
| Rating | 4.6/5 |
| Student Enrollment | 16,420 students |
| Instructor | Rahul Shetty https://www.linkedin.com/in/rahulshetty |
| Topics Covered | SQL Operators, CRUD, Schema Operations, String Functions |
| Course Level | Beginner |
| Total Student Reviews | 2,588 |
Learning Outcomes
- You will be able to create any intricate SQL to query a database (SQL).
- Comprehensive knowledge of the GROUP BY, Subqueries, Aggregate, SQL Server, and HAVING clauses – (SQL).
- Recognize the variations between the FULL OUTER JOIN, LEFT/RIGHT OUTER JOIN, and INNER JOIN (SQL).
- You will comprehend the significance of session hijacking mechanisms and their usage of private information (Security Testing).
- Application behaviour can be investigated via parameter tampering and brute force assaults (Security Testing).
- You will learn all the fundamentals of HTTP that could be attacked by malicious inputs (Security Testing).
- Build new databases or connect with ones that already exist, then check the database for schema validations (SQL).
- Identify any Request forgery Designs in Web apps — (Security Testing).
- With the knowledge of the interview questions, you can succeed in any SQL interview (SQL).
Course Content
| S.No. | Module (Duration) | Topics |
|---|---|---|
| 1. | Course FAQ’s (07 minutes) | Why to learn SQL and Security Testing? and how this course is designed |
| Please Note | ||
| 2. | Introduction to SQL (29 minutes) | Introduction to DataBase |
| Introduction to SQL and MySQL | ||
| Downloading MySQL server with workbench | ||
| Overview of SQL Editor with basic features | ||
| SQL basic Material for reference | ||
| 3. | CRUD operations on Database with Practical examples (27 minutes) | creating Database and pointing to it |
| Creating Tables in database | ||
| Inserting records into Table | ||
| Retrieving records from the Table | ||
| SQL commands glossary on discussed Topics | ||
| 4. | Altering Table Schema operations (25 minutes) | Adding and modifying records in a table |
| Deleting records and droping database | ||
| Updating rows in a table | ||
| Modifying operations example | ||
| SQL Glossary on discussed topics | ||
| 5. | SQL Logical operators to retrieve Data (32 minutes) | Select Distinct keyword in queris |
| SQL WHERE command usage | ||
| Logical operators on Queries AND OR – 1 | ||
| Logical operators ‘In’ ‘Between’- 2 | ||
| 6. | Regular expressions in writing Smart SQL Queries (21 minutes) | Regular expressions Introduction |
| Wild cards usage in Qeuries -1 | ||
| SORT by usage in Queries | ||
| SQL glossary on discussed topics | ||
| 7. | Deeper Understanding on GroupBy, Aggregate functions with practical examples (01 hour 01 minutes) | Importance of Group By in SQL |
| Combination of GroupBy and SQL functions(Min,Max,Avg) | ||
| Usage of Having keyword with GroupBy and Aggregate functions | ||
| Difference between Having and Where keyword and when to use them | ||
| Practise Exercises on GroupBy,Having,Where and Aggregate functions keyword -1 | ||
| Practise Exercises on GroupBy,Having,Where and Aggregate functions keyword- 2 | ||
| SQL glossary on discussed topics | ||
| 8. | Building SQL Sub queries with examples (14 minutes) | SubQueries syntax and usage |
| SubQueries Example | ||
| 9. | SQL Joins, Inner Joins, Outer joins, Left&Right joins with Interview questions (01 hour 00 minutes) | SQL Joins usage and its advantages |
| SQL Joins Example | ||
| Relation on subqueries and Joins | ||
| Practical examples on Joins and subqueries | ||
| Left and Right joins importance in SQL | ||
| Practical example on Inner joins, Left join, Right Join | ||
| 10. | Understand SQL String functions and Views with examples (40 minutes) | Importance of views in Database |
| views example on Database | ||
| String functions – 1 | ||
| String functions – 2 | ||
| String functions -3 | ||
| SQL glossary on discussed topics | ||
| 11. | Miscelleanous SQL keywords(Union,Intersect,Exist, Case,UnionAll) and their usage (37 minutes) | Importance of Union and Union All SQL Keyword |
| Query to intersect records from two tables | ||
| Exists keyword usage in SQL | ||
| CASE Statement in SQL with example | ||
| SQL GLossary | ||
| 12. | Importance of Data constraints for Database Validations (36 minutes) | NOT NUll constraint -1 |
| Not Null Constraint Validations and Testing – 2 | ||
| Default Constraint Validations and Testing – 3 | ||
| Unique Constraint Validations and Testing – 4 | ||
| Primary Key Constraint validaton and Testing -5 | ||
| SQL glossary on discussed topics | ||
| 13. | Importance of Foreign Key and Primary key with real time examples (36 minutes) | Importance of Foreign Key constraint in SQL |
| Understand Foreign key rules and constraints with examples | ||
| On DELETE CASCADE Keyword to force rules on Foreign key deletion | ||
| SQL Glossary | ||
| 14. | Practise Exercises for Interviews with Solutions (10 minutes) | Practise Practise Practise !!! |
| Practise Exercise/Interview Questions- 1 | ||
| Practise Exercise/Interview Questions- 2 | ||
| Solutions for Exercise – 1 | ||
| Solutions for Exercise -2 | ||
| 15. | JDBC Connectivity for Integration with Selenium (Basic Automation knowledge req (31 minutes) | Jdbc odbc programming-Creating Project |
| Creating Database Tables and connecting to Jdbc java code | ||
| Retrieving data from Database with Java code | ||
| jdbc code download | ||
| 16. | SQL Injection (38 minutes) | What is SQL Injecting |
| How to identify SQL loop holes in web application | ||
| Exposing Security loop holes with malcious SQL syntax | ||
| List of urls Pattern which can cause attack with SQL | ||
| Material for reference | ||
| 17. | Complete Unix Material (01 seconds) | Unix for Beginners- 2 |
| 18. | Important Note (10 seconds) | Important Note |
| 19. | Introduction to Security Testing – Phase 2 (09 minutes) | Why security Testing gaining Importance day by day! |
| 20. | Security Testing Basic Terminologies (39 minutes) | What is Http and Https? |
| How can we avoid Man in middle attacks? | ||
| Http Methods overview in talking to servers | ||
| Fiddler Demo- Monitoring Network traffic | ||
| Understanding Fiddler to intercept requests | ||
| Material for Reference | ||
| 21. | XSS – Cross Site Scripting Vulnerability Testing (01 hour 13 minutes) | What is XSS? How it can damage Web sites |
| Detecting XSS Vulnerability for Websites – 1 | ||
| Detecting XSS Vulnerability for Websites – 2 | ||
| ByPassing Client Validation to perform XSS | ||
| Encoding all the inputs to avoid Attacks | ||
| Types of Attack – Reflected XSS | ||
| Types of Attack – Persisistence XSS | ||
| How to handle cross site scripting in IE browser | ||
| Material for Reference | ||
| 22. | Importance of Cookies and their role in Security (01 hour 13 minutes) | What are cookies and where are they stored |
| Session cookie sensitive data Threats | ||
| How can we stop Cookies hijacking | ||
| Methods to Prevent cookie steal -Secure Attribute | ||
| Preventing cookies steal -Http Attribute flag | ||
| Domain and path attribute to restrict cookies | ||
| Setting Timeperiod for Sessions- Security Safety Tip | ||
| Material for Reference | ||
| 23. | Session Hijacking and Cross Site Forgery Attacks (41 minutes) | What is CSRF? How can it cause threat |
| Session Hijacking with illegal requests | ||
| Avoid Cross SIte forgeries with Token Mechanisim | ||
| Checklist for Pen Testers to check CSRF Attacks | ||
| Material for Reference | ||
| 24. | Parameter Tampering to steal sensitive data (18 minutes) | Different sources to intercept requests |
| Importance of having Server side Validations | ||
| Intercepting requests with fiddler tool | ||
| Material for Reference | ||
| 25. | Account Security (46 minutes) | Steps to be taken for Password setting |
| List of Hacking Passwords and Precautions which need to be taken | ||
| Sources of Attacking Passwords | ||
| Best Practices to be followed in securing Account | ||
| Bruteforce attack handler Mechanism | ||
| Material for Reference | ||
| BONUS LECTURE |
Resources Required
- You do not need any prior understanding of SQL or security testing.
- The course includes care for every installation setup, including database fundamentals.
- There are download links for theoretical material, code dumps, and interview guides.
Featured Review
MD ALAM (5/5) : The course is excellent for both who want to be tester and DBA. The way of his teaching is awesome. The content is comprehensive and informative The instructor’s delivery is interesting and engaging.Easy and step by step method of teaching. I hope some more additional topics for database testing and he promised to add many more topics for both SQL query, DB Testing(With stored procedure) etc.If you want to learn sql & DB testing in short time and practical way I recommend this course for them. I think this will be an investment for your career.
Pros
- Navin Singh (5/5) : I have enrolled 5 tutorials of yours including this and all are awesome.
- Chidanand md (5/5) : After completion of all courses that Rahul’s set of courses is the best in the industry.
- Ashirbad Satapathy (5/5) : Rahul Shetty is one of the best trainers I have ever seen.
- Mo Ka (5/5) : best offline teacher to me is Mr. Rahul Shetty awesome way of teaching
Cons
- Kartik S. (1/5) : waste of money, there is nothing to learn in security testing only a few definitions are there which keep repeating by trainer again and again. I can’t understand why he telling the same thing 20-30 times. seriously disappointing.
- Salahaldin A. (1/5) : you didnt tell us everythings about how to test the data base, you given us how to develop.
- Udemyv4 T. (1/5) : Course has about only 1% of database testing as per my understanding. Lecture is more like on ‘Learning SQL Basics’.Very Disappointed.
- Chris K. (1/5) : This course doesn’t offer anything more than a free course would offer on basic SQL concepts.
About the Author
The instructor of this course is Rahul Shetty who is a Teacher over 650k+ QA Students| Founder of RahulShettyAcademy. With 4.6 Instructor Rating and 269,257 Reviews on Udemy, Rahul Shetty offers 29 Courses and has taught 689,226 Students so far.
- Rahul Shetty is a QA trainer with 15 years of expertise who has taught classes on Selenium, software testing (Jira), API testing, Cypress, Postman, Appium, Playwright, JMeter, and many other topics to students from 195 different countries.
- Rahul Shetty serve as the Lead Teacher at the Leading QA Ed Tech Platform (Rahul Shetty Academy), where he has assisted countless numbers of students in learning to test and automate in order to transform their lives and become Automation Engineers.
Comparison Table
| Parameters | Learn SQL +Security(pen) testing from Scratch | Linux(Unix) Command with Shell Scripting-Must for Testers/QA | Get Expertise in Database Testing(SQL) + Linux for Testers |
|---|---|---|---|
| Offers | INR 499 ( | INR 455 ( | INR 455 ( |
| Duration | 13.5 hours | 11 hours | 18.5 hours |
| Rating | 4.6/5 | 4.4/5 | 4.4/5 |
| Student Enrollments | 16,417 | 2,356 | 5,860 |
| Instructors | Rahul Shetty | Automation World | Automation World |
| Register Here | Apply Now! | Apply Now! | Apply Now! |
Leave feedback about this