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

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.