Introduction of Hacking
Phases Of Hacking
Types Of Hackers
CIA Triad
Vulnerability Assessment
Phases Of Vulnerability Assessment
Penetration Testing
Phases Of Penetration Testing
What is Footprinting
Phases Of Footprinting
Footprinting Through Search Engines
Footprinting Through Archives
Email Footprinting
Footprinting Through Whois
Footprinting Through TraceRoute
Footprinting IP Address
Footprinting Through Social Engineering
Gathering Information Using Websites and Applications
IP Mapping and Tracing IP address
Active and Passive Methods
Detecting Web Server
Find weaknesses using Google
Hacking Using Google and other Search Engines
What is Scanning
TCP Communication Flags
TCP Three Way Handshake
TCP Connect/Full Open Scanning
Stealth/Half Open Scanning
Inverse TCP Flag Probe Scanning
XMAS Scanning
ACK Scanning
UDP Scanning
OS Authentication Architecture
OS Hash BruteForcing
OS Password Cracking
Windows Login Bypass
OSX Login Bypass
Data Stealing Techniques
Kali Linux Vs Other Pen Testing OS
Installation and setup of Kali Linux
System Architecture of Kali Linux
Network Configuration of Kali Linux
Essential Commands of Kali Linux
Malware
Types Of Malware
Worms
Type Of Worms
Protecting Yourself From Worms
Symptoms of Worms
Removal of Worms
Virus
Types of Virus
Damage Caused By Virus
Cause of Virus
Symptoms Of Virus
Removal of Virus
Different Type of Trojans
Making of Trojan(RAT)
Right Way to Configure Trojan
Online Trojan propagation
Analysis and Removal of Trojan
Introduction to Network Sniffing
Man in the Middle Attacks
MAC spoofing & Flooding
ARP Poisoning
Rogue DHCP
SSL Stripping
Session Hijacking
Introduction to SQL Database
Types of SQL Injections
Authentication Bypass Injection
Blind Injections
Error Based Injection
Union Based Injection
Stacked Query Injection
Time Based Injection
Wi-Fi Technical Details
Types of Encryptions
MAC Spoofing
Attacks on WEP, WPA, WPA2
Forged Authentication Attack
Replay Attack
De-Synchronization Attack
Evil Twin and Fake AP Attack
Types of Steganography
Techniques of Steganography
How Steganography Works
Image Steganography
Working with Tools
How XSS Attacks Work
XSS Attack via Email
Stealing Cookies via XSS
XSS Attack in Comment Field
Blog Post via XSS Attack
CSRF Attacks
Understanding an iFrame Attack
New iFrame Injection Method
Ads in hidden iFrame and pop-ups
Redirecting to a malicious server
Malicious script execution
How DoS Attack Works
Indications of DoS Attacks
DoS Attack Techniques
Tools for DDoS Attacks
Detection of DoS Attacks
Need of Penetration Testing?
Types of Pen Testing
Pen Testing Techniques
Security Audit
Vulnerability Assessments
Black Box Pen Testing
Gray Box Pen Testing
Monitoring Events and Exceptions
Inspecting Processes and Modules
Introduction to Reverse Engineering
Tools and Commands
Introduction to Firewalls
Network Firewalls
Web Application Firewalls
Weakness in Firewalls
Honey Pots and Security Misconfiguration
Configure Rule sets
Setup Network IDS/IPS
Writing Custom Rules
Setup Network IDS or IPS
Logs Analysis
DMZ Configuration
Intrusion Detection Systems and weakness
Intrusion Prevention Systems and weakness
Introduction To Cryptography
History of Ciphers
Symmetric And Asymmetric Ciphers
Block Ciphers
Data Encryption Standard
DES-X
Advanced Encryption Standards
Block Cipher Modes
Stream Ciphers - RC4
Asymmetric-Key Algorithms
RSA
ELGAMAL
HASH Functions
Digital Signature
Hybrid Schemes
Public Key Infrastructure
Implementing Public Key Infrastructure
What Will PKI Allow You?
EXERCISE: Certificates
Certificate life cycle
Planning the PKI
PKI Administration
Threat Modelling and Classification
What is a database?
A database is an area to store data.
A RDBS(Relational database system) stores data in tables.
What is SQL?
SQL is a language used in RDMS to retrieve and manipulate data.
SQL is for the structured query language.
SQL is the structured query language, a computer language for storing, manipulating, and retrieving data stored in a relational database.
SQL is the standard language for (relational database systems) RDBS. All RDBMS such as MySQL, Oracle, Sybase, Informix, Postgres, and SQL attendants use SQL as their standard database language.
Also, they are using different commands, such as -
MS SQL Server using T-SQL,
PL / SQL, using Oracle
The MS Access version of SQL is called JET SQL (native format) etc.
SQL applications-
As mentioned earlier, SQL is one of the most commonly used query languages on databases. I am going to list some of them here:
It allows users to access data in a relational database management system.
It allows users to describe data.
It allows users to define data in the database and manipulate that data.
Allows embedding within other languages using SQL factor, libraries, and pre-compilers.
Allows users to create and drop dB(database) and tables.
It allows users to create views, stored procedures, functions in the database.
It allows users to set acceptance on tables, processes, and views.
SQL process-
When you are executing the SQL command for any RDBMS, the system determines the best way to interpret the task to complete your request and the statistics of the SQL engine.
Various components are involved in this process.
These components are -
Query dispatcher
Optimization engine
Classic query engine
SQL Query Engine, etc.
SQL commands-
The SQL commands for interacting with relational databases(RDBS) are SELECT, INSERT, UPDATE, DELETE, and DROP. These orders can be classified into the following groups based on their nature -
DDL - Data Definition Language
1.CREATE - Creates a new table, a view of the table or another object in the database.
2.ALTER — Modifies an actual database object, such as a table.
3.DROP - Removes the entire table, the view of the table or other objects in the database.
DML - Data Manipulation Language
1.SELECT — Gets some records from one or more tables.
2.INSERT - Creates a record.
3. Update — Modifies the record.
4.DELETE-Deletes Record.
DCL - Data Control Language
1. gives digital-user a privilege.
2.REVOKE — Revokes the privileges received from the user.
Don't miss out!
Study Material
Quiz