1. Course FAQ's/1. Why to learn SQL and Security Testing and how this course is designed.mp439.46MB
10. Understand SQL String functions and Views with examples/1. Importance of views in Database.mp443.22MB
10. Understand SQL String functions and Views with examples/2. views example on Database.mp423.34MB
10. Understand SQL String functions and Views with examples/3. String functions - 1.mp4105.04MB
10. Understand SQL String functions and Views with examples/4. String functions - 2.mp4121.94MB
10. Understand SQL String functions and Views with examples/5. String functions -3.mp445.49MB
11. Miscelleanous SQL keywords(Union,Intersect,Exist, Case,UnionAll) and their usage/1. Importance of Union and Union All SQL Keyword.mp4103.3MB
11. Miscelleanous SQL keywords(Union,Intersect,Exist, Case,UnionAll) and their usage/2. Query to intersect records from two tables.mp4128.28MB
11. Miscelleanous SQL keywords(Union,Intersect,Exist, Case,UnionAll) and their usage/3. Exists keyword usage in SQL.mp467.34MB
11. Miscelleanous SQL keywords(Union,Intersect,Exist, Case,UnionAll) and their usage/4. CASE Statement in SQL with example.mp4136.85MB
12. Importance of Data constraints for Database Validations/1. NOT NUll constraint -1.mp415.73MB
12. Importance of Data constraints for Database Validations/2. Not Null Constraint Validations and Testing - 2.mp450.55MB
12. Importance of Data constraints for Database Validations/3. Default Constraint Validations and Testing - 3.mp433.66MB
12. Importance of Data constraints for Database Validations/4. Unique Constraint Validations and Testing - 4.mp447.66MB
12. Importance of Data constraints for Database Validations/5. Primary Key Constraint validaton and Testing -5.mp479.25MB
13. Importance of Foreign Key and Primary key with real time examples/1. Importance of Foreign Key constraint in SQL.mp447.12MB
13. Importance of Foreign Key and Primary key with real time examples/2. Understand Foreign key rules and constraints with examples.mp4242.69MB
13. Importance of Foreign Key and Primary key with real time examples/3. On DELETE CASCADE Keyword to force rules on Foreign key deletion.mp496.14MB
14. Practise Exercises for Interviews with Solutions/1. Practise Practise Practise !!!.mp411.53MB
15. JDBC Connectivity for Integration with Selenium (Basic Automation knowledge req/1. Jdbc odbc programming-Creating Project.mp433.29MB
15. JDBC Connectivity for Integration with Selenium (Basic Automation knowledge req/2. Creating Database Tables and connecting to Jdbc java code.mp4122.99MB
15. JDBC Connectivity for Integration with Selenium (Basic Automation knowledge req/3. Retrieving data from Database with Java code.mp446.72MB
16. SQL Injection/1. What is SQL Injecting.mp433.99MB
16. SQL Injection/2. How to identify SQL loop holes in web application.mp4105.89MB
6. Regular expressions in writing Smart SQL Queries/2. Wild cards usage in Qeuries -1.mp437.74MB
6. Regular expressions in writing Smart SQL Queries/3. SORT by usage in Queries.mp428.7MB
7. Deeper Understanding on GroupBy, Aggregate functions with practical examples/1. Importance of Group By in SQL.mp4204.99MB
7. Deeper Understanding on GroupBy, Aggregate functions with practical examples/2. Combination of GroupBy and SQL functions(Min,Max,Avg).mp4101.5MB
7. Deeper Understanding on GroupBy, Aggregate functions with practical examples/3. Usage of Having keyword with GroupBy and Aggregate functions.mp4177.67MB
7. Deeper Understanding on GroupBy, Aggregate functions with practical examples/4. Difference between Having and Where keyword and when to use them.mp4194.97MB
7. Deeper Understanding on GroupBy, Aggregate functions with practical examples/5. Practise Exercises on GroupBy,Having,Where and Aggregate functions keyword -1.mp4127.53MB
7. Deeper Understanding on GroupBy, Aggregate functions with practical examples/6. Practise Exercises on GroupBy,Having,Where and Aggregate functions keyword- 2.mp4151.34MB
8. Building SQL Sub queries with examples/1. SubQueries syntax and usage.mp424.05MB
8. Building SQL Sub queries with examples/2. SubQueries Example.mp441.73MB
9. SQL Joins, Inner Joins, Outer joins, Left&Right joins with Interview questions/1. SQL Joins usage and its advantages.mp428.38MB
9. SQL Joins, Inner Joins, Outer joins, Left&Right joins with Interview questions/3. Relation on subqueries and Joins.mp4127.1MB
9. SQL Joins, Inner Joins, Outer joins, Left&Right joins with Interview questions/4. Practical examples on Joins and subqueries.mp4148.01MB
9. SQL Joins, Inner Joins, Outer joins, Left&Right joins with Interview questions/5. Left and Right joins importance in SQL.mp4123.46MB
9. SQL Joins, Inner Joins, Outer joins, Left&Right joins with Interview questions/6. Practical example on Inner joins, Left join, Right Join.mp4239.96MB