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:
Get hands-on with 1400+ tech skills courses.