SQL Relational Algebra Examples Link Page
SQL Relational Algebra Examples
You can use the Sample Database form the MySQL Tutorial Website to practice the activities illustrated in the links below.
Here is a Link to Download the My SQL Tutorial Sample Database
mysqlsampledatabase-1.sql Download mysqlsampledatabase-1.sql
SQL UNION Clause Example
http://www.mysqltutorial.org/sql-union-mysql.aspx Links to an external site.
SQL INTERSECT Example
http://www.mysqltutorial.org/sql-union-mysql.aspx Links to an external site.
SQL Difference Example
http://www.mysqltutorial.org/mysql-minus/ Links to an external site.
SQL JOIN Clause Example
http://www.mysqltutorial.org/mysql-join/ Links to an external site.
SQL INNER JOIN Clause Example
http://www.mysqltutorial.org/mysql-inner-join.aspx Links to an external site.
SQL LEFT JOIN Example
http://www.mysqltutorial.org/mysql-left-join.aspx Links to an external site.
SQL RIGHT JOIN Example
http://www.mysqltutorial.org/mysql-right-join/ Links to an external site.
SELF JOIN Example
http://www.mysqltutorial.org/mysql-self-join/ Links to an external site.