MySQL DML - Querying Data

LESSON 2: Basic Data Analysis

In this lesson I cover some fundamentals of how to analyze data and offer some tips and trips. In this lesson you wll learn how to count the rows in a table and how to use SELECT DISTINCT.


MySQL Topics Covered

  • SELECT COUNT(*)
  • SELECT DISTINCT

MySQL Workbench Functionality Covered

  • Sorting the grid
  • Getting the next 1000 rows
  • Dismiss a query tab