Learn SQL and Security Pen Testing from Scratch

Syllabus of MySQL and Security Pen Testing Online Training Course

• 1. Introduction to DataBase
• 2. Introduction to SQL and MySQL
• 3. Downloading MySQL server with workbench
• 4. Overview of SQL Editor with basic features

• 1. Creating Database and pointing to it
• 2. Creating Tables in database
• 3. Inserting records into Table
• 4. Retrieving records from the Table

• 1. Adding and modifying records in a table
• 2. Deleting records and dropping database
• 3. Updating rows in a table
• 4. Modifying operations example

• 1. Select Distinct keyword in queris
• 2. SQL WHERE command usage
• 3. Logical operators on Queries AND OR - 1
• 4. Logical operators 'In' 'Between'- 2

• 1. Regular expressions Introduction
• 2. Wild cards usage in Queries -1
• 3. SORT by usage in Queries

• 1. Importance of Group By in SQL
• 2. Combination of GroupBy and SQL functions (Min,Max,Avg)
• 3. Usage of Having keyword with GroupBy and Aggregate functions
• 4. Difference between Having and Where keyword and when to use them
• 5. Practise Exercises on GroupBy,Having,Where and Aggregate functions keyword -1
• 6. Practise Exercises on GroupBy,Having,Where and Aggregate functions keyword- 2

• 1. SubQueries syntax and usage
• 2. SubQueries Example

• 1. SQL Joins usage and its advantages
• 2. SQL Joins Example
• 3. Relation on subqueries and Joins
• 4. Practical examples on Joins and subqueries
• 5. Left and Right joins importance in SQL
• 6. Practical example on Inner joins, Left join, Right Join

• 1. Importance of views in Database
• 2. views example on Database
• 3. String functions - 1
• 4. String functions - 2
• 5. String functions -3

• 1. Importance of Union and Union All SQL Keyword
• 2. Query to intersect records from two tables
• 3. Exists keyword usage in SQL
• 4. CASE Statement in SQL with example

• 1. NOT NUll constraint -1
• 2. Not Null Constraint Validations and Testing - 2
• 3. Default Constraint Validations and Testing - 3
• 4. Unique Constraint Validations and Testing - 4
• 5. Primary Key Constraint validation and Testing -5

• 1. Importance of Foreign Key constraint in SQL
• 2. Understand Foreign key rules and constraints with examples
• 3. On DELETE CASCADE Keyword to force rules on Foreign key deletion

• 1. Practise Practise Practise !!!

• 1. Jdbc odbc programming-Creating Project
• 2. Creating Database Tables and connecting to Jdbc java code
• 3. Retrieving data from Database with Java code

• 1. What is SQL Injecting
• 2. How to identify SQL loopholes in web application
• 3. Exposing Security loop holes with malcious SQL syntax
• 4. List of urls Pattern which can cause attack with SQL

• 1. Why security Testing gaining Importance day by day!

• 1. What is XSS? How it can damage Web sites
• 2. Detecting XSS Vulnerability for Websites - 1
• 3. Detecting XSS Vulnerability for Websites - 2
• 4. ByPassing Client Validation to perform XSS
• 5. Encoding all the inputs to avoid Attacks
• 6. Types of Attack - Reflected XSS
• 7. Types of Attack - Persisistence XSS
• 8. How to handle cross site scripting in IE browser

• 1. What are cookies and where are they stored
• 2. Session cookie sensitive data Threats
• 3. How can we stop Cookies hijacking
• 4. Methods to Prevent cookie steal -Secure Attribute
• 5. Preventing cookies steal -Http Attribute flag
• 6. Domain and path attribute to restrict cookies
• 7. Setting Timeperiod for Sessions- Security Safety Tip

• 1. What is CSRF? How can it cause threat?
• 2. Session Hijacking with illegal requests
• 3. Avoid Cross Site forgeries with Token Mechanism
• 4. Checklist for Pen Testers to check CSRF Attacks

• 1. Different sources to intercept requests
• 2. Importance of having Server-side Validations
• 3. Intercepting requests with fiddler tool

• 1. Steps to be taken for Password setting
• 2. List of Hacking Passwords and Precautions which need to be taken
• 3. Sources of Attacking Passwords
• 4. Best Practices to be followed in securing Account
• 5. Bruteforce attack handler Mechanism