Learn SQL +Security(pen) testing from Scratch

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
Who this course is for:

Any IT professional no matter in what field they are into
QA Testers who want to enhance their skill on Data base Testing and Security testing
Freshers/Graduates who want to learn computer science foundations

Requirements

******You need NOT have any proir SQL/Security testing knowledge to start this course*********
Though these are online Lectures.You will have Life Time instructor support.You can contact me any time for your Queries,Will respond back with in 12 hours
All Installation setup including Database basics is taken care as part of course
Theoretical Material,Code dump and Interview Guide are available for download

1. Course FAQ's	10. Understand SQL String functions and Views with examples	11. Miscelleanous SQL keywords(Union,Intersect,Exist, Case,UnionAll) and their usage
12. Importance of Data constraints for Database Validations	13. Importance of Foreign Key and Primary key with real time examples	14. Practise Exercises for Interviews with Solutions
15. JDBC Connectivity for Integration with Selenium (Basic Automation knowledge req	16. SQL Injection	17. Complete Unix Material
18. Important Note	19. Introduction to Security Testing - Phase 2	2. Introduction to SQL
20. Security Testing Basic Terminologies	21. XSS - Cross Site Scripting Vulnerability Testing	22. Importance of Cookies and their role in Security
23. Session Hijacking and Cross Site Forgery Attacks	24. Parameter Tampering to steal sensitive data	25. Account Security
3. CRUD operations on Database with Practical examples	4. Altering Table Schema operations	5. SQL Logical operators to retrieve Data
6. Regular expressions in writing Smart SQL Queries	7. Deeper Understanding on GroupBy, Aggregate functions with practical examples	8. Building SQL Sub queries with examples
9. SQL Joins, Inner Joins, Outer joins, Left&Right joins with Interview questions

Nie ma plików w tym folderze