MySQL Database Course – Part V – (Video) “Group By”
The "Group By" statement groups identical values in a table. Learn how it works with COUNT, SUM, MAX and MIN in this video tutorial and step-by-step examples.
Tag: MySql
MySQL Database Course – Part IV – (Video) INNER JOIN
In this fourth part we explain how to "join" tables with the INNER JOIN statement using a foreign key. Watch the video tutorial and follow along.
MySQL Database Course – Part III – (Video) Definition/Manipulation
Learn the basics of SQL to work with databases. You need to tell apart the two types of statements: Data Definition and Data Manipulation Language.
MySQL Database Course – Part II (Video) – Entity-Relationship
In this second part of the database course, you'll learn how to create tables with MySQL Workbench and how to relate them (1:1, 1:N, N:M).