Learn SQL and Security(pen) testing from Scratch

• You will gain the ability to design any complex SQL to query a database- (SQL)
• In-depth understanding of GROUP BY, subqueries, aggregate functions, SQL server functions, and having clauses -(SQL)
• Understand the difference between INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN (SQL)
• Understand the Importance of the session hijacking mechanism and confidential data use – (security testing)
• Investigate application behavior with parameter tampering and brute-force attacks (security testing)
• Master all HTTP basics with that might cause attacking malicious inputs (security testing)
• Create or interact with existing databases and test them for schema validations (SQL)
• Detect request forgery designs (if present) in any web applications (Security Testing)
• Ace any SQL interview via the interview questions covered in the course (SQL)

No more boring slides or definitions. The author writes every SQL query in the course of his lecture and teaches every topic you’ll need to master SQL with practical examples. This tutorial will give you all you need to investigate and unlock security holes in web applications with a powerful penetration-testing approach.

This course covers:

•Introduction to SQL, and a MySQL overview

•Startup commands to set up database and tables

•Database testing to validate schemas

•Altering table schema operations

•Queries to retrieve logical data operators on queries

•Wildcard usage in queries

•SQL functions with real-time scenarios

•Importance of Group By in SQL

•Advanced SQL concepts

•Subquery syntax and usage

•Using SQL joins and their advantages

•Importance of views in databases

•SQL string functions

•Data constraints from a database testing perspective

•Practice exercises for interviews with solutions

•SQL glossary on topics discussed

Security Testing: Course Contents:

Basics of Security Testing—the terminologies involved in Security domain; top OWASP principles; cross-site scripting; XSS examples; cookies; caveats when stealing cookies; session hijacking; cross-site forgery; attack parameters; tampering; methods to Intercept requests; account management; password security guidelines; brute-force mechanism; and the importance of client-side validations.

All the code and supporting files for this course are available at – https://github.com/PacktPublishing/Learn-SQL-and-Security-pen-testing-from-Scratch

• This course fills a gap by teaching both topics and gives you an edge over other engineers at work.
• SQL and security testing are common skills and are tested in every software engineer Interview.