Introduction to Queries with MySQL Workbench & Sakila Sample Database

#mysql #workbench #query
SQL or Structured Query Language is an expressive language used to interact with relational databases.

Please SUBSCRIBE:

Download:

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

[dilanbarham]

This is the best MySQL tutorial on Queries I have seen so far, thanks for putting content like this.

[MsDelta]

Hi, Matt, good morning (for me at least)I am very pleased to have found your YouTube channel.I am checking many of your repositories .Sr - Matt according to my humble experience and
expertise in different fields. Your explanations, gradual speech, modulation and voice sound as well with its contents are EXCELLENT !!, Thanks you very much for your time in posting / conveying your KNOWLEDGE which I AM ABSORBING THEM!

[halalmeatshophk]

At 3:42, was the order by rating in alphabetic order? How come NC-17 comes after R ? Shouldn't N come first?

[vyetundebello]

This is the most explainative and concise MYSQL, thanks so much, really appreciate and will definitely follow u all the way.🙏🏽

[Liam]

Sakila is the gangster for providing us sample database for practice

[peternobody]

That’s exactly what I need. A quick dive in.

[saritaxsingh]

You are a gem. Thank you for your help

[dellyemaya]

Thank you, amazingly useful and well explained

[onlinesaidasa]

Namaste

Using Explain statement, we can review each query to check if it is written in best possible manner

[nathaniellynch]

Can I use Dynamic SQL in MySQL Workbench for Mavenmovies database?

[albhem_eh]

No values are visible when I say the command SELECT * FROM film; it shows as null. So does subsequent commands as well.
What am I doing wrong?\

[dpressley]

How did you get the ERD diagram of the database?

[JoseTorres-mcdy]

Awesome videos! Is there a way to get YYYY when given the YYYY-DD-DD date format?

[LisaPhilip-pt]

Can you show me how to insert movie information?

[ppokmon]

How do I even start writing query in Workbench?

[kwakuaboagye]

Can you help me with this question using case statement and sakila database.
Write a query that returns the alphabetized first letter of the customer's last name and the count of active and inactive customers. Limit the results to only those first letters that occur in the last_name column of the customer table.

[tysonbravo]

I can't even get it to run the sql script and import the db. Gives me the error: Error executing SQL script.
'>' not supported between instances of 'NoneType' and 'int'. - any ideas? Is this happening to anybody else?

[datascience]

Hi Matt. Great tutorial thank you. Just a question. I wonder what query I should use if I want to look for the actual fields (column names) that start with a specific letter. So not the records inside the columns, but the actual column names. How would I do that?