Practical example on Inner joins, Left join, Right Join

Learn SQL in Practical + DataBase Testing from Scratch

Course FAQ's

Why to learn SQL and Security Testing? and how this course is designed (6:55)

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

Select Distinct keyword in queris (6:50)
SQL WHERE command usage (9:27)
Logical operators on Queries AND OR - 1 (7:07)
Logical operators 'In' 'Between'- 2 (8:37)

Regular expressions in writing Smart SQL Queries

Regular expressions Introduction (7:18)
Wild cards usage in Qeuries -1 (8:04)
SORT by usage in Queries (5:23)
SQL glossary on discussed topics

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

SubQueries syntax and usage (8:08)
SubQueries Example (6:07)

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

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

Practise Exercises for Interviews with Solutions

Practise Practise Practise !!! (4:54)
Practise Exercise/Interview Questions- 1
Practise Exercise/Interview Questions- 2
Solutions for Exercise - 1
Solutions for Exercise -2

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

Jdbc odbc programming-Creating Project (7:03)
Creating Database Tables and connecting to Jdbc java code (16:48)
Retrieving data from Database with Java code (6:46)
jdbc code download

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

Unix for Beginners- 2

Important Note

Important Note

Introduction to Security Testing - Phase 2

Why security Testing gaining Importance day by day!

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

Teach online with

Practical example on Inner joins, Left join, Right Join

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock