SQL: Grouping, joins and Injections
Learn how to group tables using different joins and safeguard the database from SQL injections.
We'll cover the following...
Let’s finish our introduction to SQL by learning ways to aggregate data from multiple records and even multiple tables in our queries.
Grouping
We can aggregate multiple records to get statistical analysis. We do this by using the group functions. The most common of them is count()
.
Here’s how we can get the count of all the plays from our database:
Access this course and 1400+ top-rated courses and projects.