Introduction to Queries with MySQL Workbench & Sakila Sample Database

#mysql #workbench #query
alphabench.com/data/mysql-basic-queries.html
SQL or Structured Query Language is an expressive language used to interact with relational databases.

Please SUBSCRIBE:
youtube.com/subscription_center?add_user=mjmacarty

The tutorial covers basic querying techniques using MySQL, the world's second most common relational database management system. Examples use MySQl Workbench and the sakila sample database available to install with MySQL. If you don't have sakila it may be easiest to visit github.com/mjmacarty/mysql
Download:
sakila-schema.sql
sakila-data.sql

To install in Workbench go to the File menu and select Run SQL Script. First run the schema, and then the data file.

Basic querying of a single table covering :
SELECT
FROM
WHERE AND, OR, IN, LIKE
ORDER BY
LIMIT