The Learning Edge

This lessons continues on by covering table cardinality and showing how to use ER diagrams as a means of joining MySQL tables. Part of a course available at www.sqlinfo.net/mysql/courses/DML-Querying_Data/Course-MySQL_DML-Querying_Data.php

Read More

As we begin learning about row restriction using the WHERE clause I introduce you to querying numeric data using the greater than and less than operators. You will also be introduced to creating compound row restriction using the AND operator. Part of a course available at www.sqlinfo.net/mysql/courses/DML-Querying_Data/Course-MySQL_DML-Querying_Data.php Video Rating: / 5

Read More

In this first segment I introduce you to joining and left joining tables in MySQL. I do this from the perspective of the data to better reinforce the mechanics of the syntax. Part of a course available at www.sqlinfo.net/mysql/courses/DML-Querying_Data/Course-MySQL_DML-Querying_Data.php Video Rating: / 5

Read More