Please enable JavaScript.
Coggle requires JavaScript to display documents.
TESTING SQL - Coggle Diagram
TESTING SQL
STATEMENTS
FULL JOIN
SQL is FULLY shared between Table 1 and Table 2
LEFT JOIN
SQL Fully shared on the left Table 1
INNER JOIN
Returns records that have matching values on BOTH tables
FROM table1
INNER JOIN table2 ON table1.column)name = table2.column_name;
SELECT column_name(s)
RIGHT JOIN
SQL Fully shared on the right Table 2
INFO
Each table has:
unique Primary key
not unique Foreign key
Connect two tables using a common key:
id in Users table
user_id in Playlists table
TESTING
Functional Testing
Non-Functional Testing
Structural Testing
SQL
CODE (statement)
0 means No
1 means Yes
NULL means 0