Course FAQ's
- Why to learn SQL and Security Testing? and how this course is designed
- Please Note
Introduction to SQL
- 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
CRUD operations on Database with Practical examples
- 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
Altering Table Schema operations
- 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
SQL Logical operators to retrieve Data
- Select Distinct keyword in queris
- SQL WHERE command usage
- Logical operators on Queries AND OR - 1
- Logical operators 'In' 'Between'- 2
Regular expressions in writing Smart SQL Queries
- Regular expressions Introduction
- Wild cards usage in Qeuries -1
- SORT by usage in Queries
- SQL glossary on discussed topics
Deeper Understanding on GroupBy, Aggregate functions with practical examples
- 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
Building SQL Sub queries with examples
- SubQueries syntax and usage
- SubQueries Example
SQL Joins, Inner Joins, Outer joins, Left&Right joins with Interview questions
- 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
Understand SQL String functions and Views with examples
- Importance of views in Database
- views example on Database
- String functions - 1
- String functions - 2
- String functions -3
- SQL glossary on discussed topics
Miscelleanous SQL keywords(Union,Intersect,Exist, Case,UnionAll) and their usage
- 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
Importance of Data constraints for Database Validations
- 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
Importance of Foreign Key and Primary key with real time examples
- 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
Practise Exercises for Interviews with Solutions
- Practise Practise Practise !!!
- Practise Exercise/Interview Questions- 1
- Practise Exercise/Interview Questions- 2
- Solutions for Exercise - 1
- Solutions for Exercise -2
JDBC Connectivity for Integration with Selenium (Basic Automation knowledge req
- Jdbc odbc programming-Creating Project
- Creating Database Tables and connecting to Jdbc java code
- Retrieving data from Database with Java code
- jdbc code download
SQL Injection
- 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
Complete Unix Material
- Unix for Beginners- 2
Important Note
- Important Note
Introduction to Security Testing - Phase 2
- Why security Testing gaining Importance day by day!
Security Testing Basic Terminologies
- What is Http and Https?
- How can we avoid Man in middle attacks?
