Can I read SQL Data Recovery and Joins Guide on EtoBox?

SQL Data Recovery and Joins Guide by Angel Limachi is a document available to read on EtoBox.

What is SQL Data Recovery and Joins Guide about?

This document summarizes SQL techniques for joining and grouping data from multiple tables. It covers Cartesian products, equality joins, non-equality joins, outer joins, self joins, natural joins, joins using ON and USING clauses. It also discusses grouping functions, creating groups with GROUP BY, restricting groups with HAVING, and nesting functions. Finally, it covers subqueries in the WHERE and FROM clauses, comparison operators for single-row and multi-row subqueries, and correlated subqueries.

Author

Angel Limachi

Language

EN