Mô tả

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 

Bạn sẽ học được gì

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)

Yêu cầu

  • ******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

Nội dung khoá học

25 sections

Course FAQ's

2 lectures
Why to learn SQL and Security Testing? and how this course is designed
06:55
Please Note
00:13

Introduction to SQL

5 lectures
Introduction to DataBase
09:55
Introduction to SQL and MySQL
06:27
Downloading MySQL server with workbench
07:29
Overview of SQL Editor with basic features
05:26
SQL basic Material for reference
00:01

CRUD operations on Database with Practical examples

5 lectures
creating Database and pointing to it
04:47
Creating Tables in database
08:01
Inserting records into Table
07:55
Retrieving records from the Table
06:22
SQL commands glossary on discussed Topics
00:25

Altering Table Schema operations

5 lectures
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 Glossary on discussed topics
00:22

SQL Logical operators to retrieve Data

4 lectures
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
Regular expressions Introduction
07:18
Wild cards usage in Qeuries -1
08:04
SORT by usage in Queries
05:23
SQL glossary on discussed topics
00:37

Deeper Understanding on GroupBy, Aggregate functions with practical examples

7 lectures
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
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 glossary on discussed topics
00:34

Building SQL Sub queries with examples

2 lectures
SubQueries syntax and usage
08:08
SubQueries Example
06:07

SQL Joins, Inner Joins, Outer joins, Left&Right joins with Interview questions

6 lectures
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
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

Miscelleanous SQL keywords(Union,Intersect,Exist, Case,UnionAll) and their usage

5 lectures
Importance of Union and Union All SQL Keyword
08:02
Query to intersect records from two tables
10:12
Exists keyword usage in SQL
06:16
CASE Statement in SQL with example
12:39
SQL GLossary
00:15

Importance of Data constraints for Database Validations

6 lectures
NOT NUll constraint -1
06:12
Not Null Constraint Validations and Testing - 2
08:10
Default Constraint Validations and Testing - 3
06:28
Unique Constraint Validations and Testing - 4
05:43
Primary Key Constraint validaton and Testing -5
09:45
SQL glossary on discussed topics
00:12

Importance of Foreign Key and Primary key with real time examples

4 lectures
Importance of Foreign Key constraint in SQL
10:21
Understand Foreign key rules and constraints with examples
15:28
On DELETE CASCADE Keyword to force rules on Foreign key deletion
10:33
SQL Glossary
00:17

Practise Exercises for Interviews with Solutions

5 lectures
Practise Practise Practise !!!
04:54
Practise Exercise/Interview Questions- 1
02:43
Practise Exercise/Interview Questions- 2
02:39
Solutions for Exercise - 1
00:01
Solutions for Exercise -2
00:00

JDBC Connectivity for Integration with Selenium (Basic Automation knowledge req

4 lectures
Jdbc odbc programming-Creating Project
07:03
Creating Database Tables and connecting to Jdbc java code
16:48
Retrieving data from Database with Java code
06:46
jdbc code download
00:40

SQL Injection

5 lectures
What is SQL Injecting
07:32
How to identify SQL loop holes in web application
13:19
Exposing Security loop holes with malcious SQL syntax
09:20
List of urls Pattern which can cause attack with SQL
07:34
Material for reference
00:37

Complete Unix Material

1 lectures
Unix for Beginners- 2
00:01

Important Note

1 lectures
Important Note
00:10

Introduction to Security Testing - Phase 2

1 lectures
Why security Testing gaining Importance day by day!
09:26

Security Testing Basic Terminologies

6 lectures
What is Http and Https?
09:58
How can we avoid Man in middle attacks?
06:52
Http Methods overview in talking to servers
09:28
Fiddler Demo- Monitoring Network traffic
03:19
Understanding Fiddler to intercept requests
07:31
Material for Reference
02:10

XSS - Cross Site Scripting Vulnerability Testing

9 lectures
What is XSS? How it can damage Web sites
09:49
Detecting XSS Vulnerability for Websites - 1
08:14
Detecting XSS Vulnerability for Websites - 2
06:14
ByPassing Client Validation to perform XSS
09:08
Encoding all the inputs to avoid Attacks
10:02
Types of Attack - Reflected XSS
08:30
Types of Attack - Persisistence XSS
09:58
How to handle cross site scripting in IE browser
10:22
Material for Reference
01:15

Importance of Cookies and their role in Security

8 lectures
What are cookies and where are they stored
08:48
Session cookie sensitive data Threats
09:43
How can we stop Cookies hijacking
07:41
Methods to Prevent cookie steal -Secure Attribute
13:56
Preventing cookies steal -Http Attribute flag
11:44
Domain and path attribute to restrict cookies
11:53
Setting Timeperiod for Sessions- Security Safety Tip
06:01
Material for Reference
03:39

Session Hijacking and Cross Site Forgery Attacks

5 lectures
What is CSRF? How can it cause threat
11:50
Session Hijacking with illegal requests
10:22
Avoid Cross SIte forgeries with Token Mechanisim
08:47
Checklist for Pen Testers to check CSRF Attacks
08:42
Material for Reference
01:28

Parameter Tampering to steal sensitive data

4 lectures
Different sources to intercept requests
05:35
Importance of having Server side Validations
06:00
Intercepting requests with fiddler tool
06:48
Material for Reference
00:15

Account Security

7 lectures
Steps to be taken for Password setting
08:46
List of Hacking Passwords and Precautions which need to be taken
05:57
Sources of Attacking Passwords
08:06
Best Practices to be followed in securing Account
09:20
Bruteforce attack handler Mechanism
12:36
Material for Reference
00:26
BONUS LECTURE
01:21

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.