Learn SQL +Security(pen) testing from Scratch

Udemy

Acquire knowledge of the fundamentals of SQL for various pen testing and web security activities.

Online

₹ 4099

particular

details

                                    Medium of instructions
                                    English

                                    Mode of learning
                                    Self study

                                    Mode of Delivery
                                    Video and Text Based

Course FAQs

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 dropping database
Updating rows in a table
Modifying operations example
SQL Glossary on discussed topics

SQL Logical operators to retrieve Data

Select Distinct keyword in queries
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 Queries -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

Miscellaneous 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 validation 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

Practice Exercises for Interviews with Solutions

Practice, practice, practice !!!
Practice Exercise/Interview Questions- 1
Practice 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 loopholes with malicious 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 is security Testing gaining Importance day by day!

Security Testing Basic Terminologies

What is Http and Https?
How can we avoid Man in middle attacks?
Http Methods overview in talking to servers
Fiddler Demo- Monitoring Network traffic
Understanding Fiddler to intercept requests
Material for Reference

Importance of Cookies and their role in Security

What are cookies and where are they stored
Session cookie sensitive data Threats
How can we stop Cookies hijacking
Methods to Prevent cookie steal -Secure Attribute
Preventing cookies steal -Http Attribute flag
Domain and path attribute to restrict cookies
Setting Time Period for Sessions- Security Safety Tip
Material for Reference

Session Hijacking and Cross Site Forgery Attacks

What is CSRF? How can it cause threat
Session Hijacking with illegal requests
Avoid Cross SIte forgeries with Token Mechanism
Checklist for Pen Testers to check CSRF Attacks
Material for Reference

Parameter Tampering to steal sensitive data

Different sources to intercept requests
Importance of having Server side Validations
Intercepting requests with fiddler tool
Material for Reference

Account Security

Steps to be taken for Password setting
List of Hacking Passwords and Precautions which need to be taken
Sources of Attacking Passwords
Best Practices to be followed in securing Account
Bruteforce attack handler Mechanism
Material for Reference
Bonus Lecture

Popular Courses

Popular Platforms

Popular Searches

Learn SQL +Security(pen) testing from Scratch

Online

₹ 4099

Quick Facts

Course overview

The highlights

Program offerings

Course and certificate fees

Fees information

certificate availability

certificate providing authority

Who it is for

What you will learn

The syllabus

Course FAQs

Introduction to SQL

CRUD operations on Database with Practical examples

Altering Table Schema operations

SQL Logical operators to retrieve Data

Regular expressions in writing Smart SQL Queries

Deeper Understanding on GroupBy, Aggregate functions with practical examples

Building SQL Sub queries with examples

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

Understand SQL String functions and Views with examples

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

Importance of Data constraints for Database Validations

Importance of Foreign Key and Primary key with real time examples

Practice Exercises for Interviews with Solutions

JDBC Connectivity for Integration with Selenium (Basic Automation knowledge req

SQL Injection

Complete Unix Material

Important Note

Introduction to Security Testing - Phase 2

Security Testing Basic Terminologies

XSS - Cross Site Scripting Vulnerability Testing

Importance of Cookies and their role in Security

Session Hijacking and Cross Site Forgery Attacks

Parameter Tampering to steal sensitive data

Account Security

Instructors

Articles

Popular Articles

Latest Articles

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Thank You!

Download the Careers360 App on your Android phone