Learn SQL +Security(pen) testing from Scratch
4.5 (1,175 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
7,634 students enrolled

Learn SQL +Security(pen) testing from Scratch

Step by step Tutorial to learn SQL and Web Security testing with real time examples
Bestseller
4.5 (1,175 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
7,634 students enrolled
Created by Rahul Shetty
Last updated 7/2020
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 13 hours on-demand video
  • 26 articles
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You will gain the ability to design any complex SQL to query a database- (SQL)
  • Indepth understanding of GROUP BY,Subqueries,aggregate functions, SQL Server functions,HAVING clauses -(SQL)
  • Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN- (SQL)
  • You will understand the Importance of Session Hijacking Mechanisim and their confidential data use -(Security Testing)
  • You can investigate application behavior with Parameter Tampering and Brute force attacks-(Security Testing)
  • You will get the knowledge of all basics with Http that might cause attacking malicious inputs-(Security Testing)
  • Create or interact with existing databases and test the Database for schema validations - (SQL)
  • Detect Request forgery Designs if present any in Web applications --(Security Testing)
  • You can Clear any Interview on SQL with the Interview questions covered - (SQL)
Course content
Expand all 118 lectures 13:31:04
+ CRUD operations on Database with Practical examples
5 lectures 27:30
Creating Tables in database
08:01
Inserting records into Table
07:55
Retrieving records from the Table
06:22
+ Altering Table Schema operations
5 lectures 25:34
Adding and modifying records in a table
06:57
Deleting records and droping database
04:48
Updating rows in a table
07:32
Modifying operations example
05:55
+ SQL Logical operators to retrieve Data
4 lectures 32:01
Select Distinct keyword in queris
06:50
SQL WHERE command usage
09:27
Logical operators on Queries AND OR - 1
07:07
Logical operators 'In' 'Between'- 2
08:37
+ Regular expressions in writing Smart SQL Queries
4 lectures 21:22
Regular expressions Introduction
07:18
Wild cards usage in Qeuries -1
08:04
SORT by usage in Queries
05:23
+ Deeper Understanding on GroupBy, Aggregate functions with practical examples
8 lectures 01:01:42
Importance of Group By in SQL
12:38
Combination of GroupBy and SQL functions(Min,Max,Avg)
07:49
Usage of Having keyword with GroupBy and Aggregate functions
11:24
Get Social with Rahul Shetty
00:31
Difference between Having and Where keyword and when to use them
11:21
Practise Exercises on GroupBy,Having,Where and Aggregate functions keyword -1
07:53
Practise Exercises on GroupBy,Having,Where and Aggregate functions keyword- 2
09:31
+ SQL Joins, Inner Joins, Outer joins, Left&Right joins with Interview questions
6 lectures 01:00:03
SQL Joins usage and its advantages
05:46
SQL Joins Example
07:30
Relation on subqueries and Joins
09:34
Practical examples on Joins and subqueries
10:25
Left and Right joins importance in SQL
10:33
Practical example on Inner joins, Left join, Right Join
16:15
+ Understand SQL String functions and Views with examples
6 lectures 40:11
Importance of views in Database
07:55
views example on Database
07:18
String functions - 1
09:23
String functions - 2
08:48
String functions -3
06:11
SQL glossary on discussed topics
00:36
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
Description

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