Learn SQL +Security(pen) testing from Scratch

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

4.56 (3020 reviews)
Udemy
platform
English
language
Software Testing
category
instructor
Learn SQL +Security(pen) testing from Scratch
18,859
students
13.5 hours
content
Aug 2021
last update
$139.99
regular price

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)

Why take this course?

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 

Screenshots

Learn SQL +Security(pen) testing from Scratch - Screenshot_01Learn SQL +Security(pen) testing from Scratch - Screenshot_02Learn SQL +Security(pen) testing from Scratch - Screenshot_03Learn SQL +Security(pen) testing from Scratch - Screenshot_04

Our review

---- ### Overall Course Review The global rating for this SQL and Security Testing course stands at an impressive **4.55**, with all recent reviews reflecting a positive reception. The course is lauded for its clear, concise, and practical approach to teaching SQL concepts and security testing principles. It is particularly noted for its real-time scenarios and examples that aid in understanding complex topics. **Pros:** - **Excellent Teaching Quality**: The course is praised for its clarity and depth in explaining SQL concepts, making it suitable for beginners as well as those looking to deepen their knowledge. - **Comprehensive Coverage**: Each SQL topic is covered in detail, with practical examples that facilitate learning and retention. - **Real-World Application**: The course emphasizes the application of concepts in real-time scenarios, which helps learners to understand and apply what they've learned. - **Highly Recommended**: Many reviews recommend Rahul Shetty's teaching style and content, noting that it has significantly improved their understanding of SQL and security testing. **Cons:** - **Limited Security Testing Scope**: Some users feel that the course could cover more advanced security testing areas and tools, such as automated scanning or specific security testing frameworks. - **Quality Concerns**: A few reviews mention the quality of video editing and graphics, suggesting improvements for clearer visual aids. - **Expectation Mismatch**: Some users expected a course more similar in style and depth to other courses by the same instructor, like the Java Selenium course. - **Outdated Content**: A couple of reviews indicate that the course recordings may not be the most recent or updated. ### Detailed Course Insights **Content and Delivery:** - The course is well-received for its simple and effective explanation of SQL concepts, making it accessible to beginners. - Rahul Shetty is commended for his expertise and ability to teach with clarity and depth. - The course includes practical examples and encourages learners to test their knowledge through assignments. **Security Testing Aspect:** - The security testing part of the course is new to some users, and it is appreciated as a valuable addition to SQL knowledge. - Some users suggest that more elaborate explanations or updates on the latest security testing trends would be beneficial. **Practical Application:** - Learners report being able to confidently solve queries and apply their newfound SQL skills in real-world scenarios after completing the course. **Course Material:** - The visual aids used in some instances, such as graphics made with tools like Paint, are suggested to be replaced with clearer graphics for better understanding. - A few users have highlighted that while the theoretical explanations of penetration testing are provided, there is a lack of practical application using tools like Burp Suite. **Learner Experience:** - The course is highly recommended by many learners who have gained significant insights into SQL and security testing. - Some users express that their fear of learning SQL was eliminated after taking this course, thanks to the clear explanations provided. **Expectations vs. Reality:** - A few reviews indicate a slight disappointment when comparing this course to others by the same instructor, expecting a more comprehensive or updated approach. **Additional Feedback:** - Some users have requested additional content on security testing and for the course to be updated with the latest trends in the field. --- In conclusion, this SQL and Security Testing course is a valuable resource for learners looking to understand both the theoretical and practical aspects of SQL, with a solid foundation in security testing. While there are areas for improvement, particularly in updating content and enhancing visual aids, the overall feedback from users is positive, reflecting a course that effectively educates its participants.

Charts

Price

Learn SQL +Security(pen) testing from Scratch - Price chart

Rating

Learn SQL +Security(pen) testing from Scratch - Ratings chart

Enrollment distribution

Learn SQL +Security(pen) testing from Scratch - Distribution chart

Related Topics

508764
udemy ID
5/22/2015
course created date
9/11/2019
course indexed date
Bot
course submited by