Practise Exercises on GroupBy,Having,Where and Aggregate functions

Learn SQL in Practical + DataBase Testing from Scratch

Course FAQ's

Introduction to SQL

Introduction to DataBase (9:55)
Introduction to SQL and MySQL (6:27)
Downloading MySQL server with workbench (7:29)
Overview of SQL Editor with basic features (5:26)
SQL basic Material for reference

CRUD operations on Database with Practical examples

creating Database and pointing to it (4:47)
Creating Tables in database (8:01)
Inserting records into Table (7:55)
Retrieving records from the Table (6:22)
SQL commands glossary on discussed Topics

Altering Table Schema operations

Adding and modifying records in a table (6:57)
Deleting records and droping database (4:48)
Updating rows in a table (7:32)
Modifying operations example (5:55)
SQL Glossary on discussed topics

SQL Logical operators to retrieve Data

Regular expressions in writing Smart SQL Queries

Deeper Understanding on GroupBy, Aggregate functions with practical examples

Importance of Group By in SQL (12:38)
Combination of GroupBy and SQL functions(Min,Max,Avg) (7: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 (7:53)
Practise Exercises on GroupBy,Having,Where and Aggregate functions keyword- 2 (9:31)
SQL glossary on discussed topics

Building SQL Sub queries with examples

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

SQL Joins usage and its advantages (5:46)
SQL Joins Example (7:30)
Relation on subqueries and Joins (9: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

Importance of views in Database (7:55)
views example on Database (7:18)
String functions - 1 (9:23)
String functions -3 (6:11)
String functions - 2 (8:48)
SQL glossary on discussed topics

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

Importance of Union and Union All SQL Keyword (8:02)
Query to intersect records from two tables (10:12)
Exists keyword usage in SQL (6:16)
CASE Statement in SQL with example (12:39)
SQL GLossary

Importance of Data constraints for Database Validations

NOT NUll constraint -1 (6:12)
Not Null Constraint Validations and Testing - 2 (8:10)
Default Constraint Validations and Testing - 3 (6:28)
Unique Constraint Validations and Testing - 4 (5:43)
Primary Key Constraint validaton and Testing -5 (9:45)
SQL glossary on discussed topics

Importance of Foreign Key and Primary key with real time examples

Practise Exercises for Interviews with Solutions

JDBC Connectivity for Integration with Selenium (Basic Automation knowledge required)

SQL Injection

What is SQL Injection (7:32)
How to identify SQL loop holes in web application (13:19)
Exposing Security loop holes with malcious SQL syntax (9:20)
List of urls Pattern which can cause attack with SQL (7:34)
Material for reference

Complete Unix Material

Important Note

Introduction to Security Testing - Phase 2

Security Testing Basic Terminologies

What is Http and Https? (9:58)
How can we avoid Man in middle attacks? (6:52)
Http Methods overview in talking to servers (9:28)
Fiddler Demo- Monitoring Network traffic (3:19)
Understanding Fiddler to intercept requests (7:31)
Material for Reference

XSS - Cross Site Scripting Vulnerability Testing

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

Importance of Cookies and their role in Security

What are cookies and where are they stored (8:48)
Session cookie sensitive data Threats (9:43)
How can we stop Cookies hijacking (7: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 (6:01)
Material for Reference