▶ C'mon over to https://realpars.com
where you can learn PLC programming faster and easier than you ever thought possible!
▶ Check out the full blog post over at https://realpars.com/inner-join/
If you are just now joining along with this series of videos, please note that you are going to learn about SQL programming basics.
If you would like to follow along with us, please review the RealPars video, “How to install MySQL and import a sample database”, on how to download and setup MySQL database on your computer.
“What are SQL Where and Like statements basics” (https://realpars.com/sql-where/), continues where we left off within the “What are SQL programming basics” video for our series of lessons covering SQL programming.
In the previous video, What are the SQL Order By Clause and Expression statement language elements? (https://realpars.com/sql-order-by/),
we learned about the structure of SQL defining the clauses, expressions defining the overall statement.
In this video, you will learn about some of the more advanced SQL statements and clause commands such as Inner Join, AND, OR, Having, and Between. We will also learn more about the SQL syntax or rules of the SQL language.
The AND operator is a logical operator that combines two or more Boolean expressions and returns true only if both expressions evaluate to true.
The OR operator is a logical operator that combines two or more Boolean expressions and returns true when either condition is true.
The BETWEEN operator is a logical operator that allows you to specify whether a value is in a range or not.
The INNER JOIN clause matches rows in one table with rows in other tables and allows you to query rows that contain columns from both tables.
The HAVING clause is used in the SELECT statement to specify filter conditions for a group of rows or aggregates.
Now the department asks us to write the SQL statement, using the HAVING clause from the Order details table, with results displaying the Order number column data with two calculated columns for the quantity and total amount paid for each order only having totals greater than 1000 and quantity greater than 600.
Review the MySQL minimum hardware requirement web page here: https://forums.mysql.com/read.php?11
Download the MySQL Installer: https://dev.mysql.com/downloads/installer/
Download the sample database SQL file from here: https://realpars.com/wp-content/uploads/2019/12/realparssampledatabasev2.zip
Download the sample database diagram file from here: https://realpars.com/wp-content/uploads/2020/01/RealParsSampleDatabaseV2-Diagram.zip
Missed our most recent videos? Watch them here:
How to Install MySQL and Import a Sample Database (Part 1) https://realpars.com/mysql
What are SQL Programming Basics? (Part 2) https://realpars.com/sql
What are SQL Where and Like Statements Basics? (Part 3) https://realpars.com/sql-where
What are the SQL Order By Clause and Expression Statement Language Elements? (Part 4) https://realpars.com/sql-order-by/
To stay up to date with our last videos and more lessons, make sure to subscribe to this YouTube channel:
TWEET THIS VIDEO https://ctt.ac/A5xN5
Like us on Facebook: https://www.facebook.com/therealpars/
Follow us on Twitter: https://twitter.com/realpars
Follow us on LinkedIn https://www.linkedin.com/company/realpars
Follow us on Instagram https://www.instagram.com/realparsdotcom/
#RealPars #SQL #MySQL