MySQL Database Development: SELECT Statement & Operators
MySQL 8.0
| Beginner
- 10 Videos | 1h 3m 39s
- Includes Assessment
- Earns a Badge
SELECT statements are used to retrieve data from MySQL tables or views. Explore the syntax and use of the most common SELECT statement elements, including SELECT, FROM, WHERE, and ORDER BY, as well as unions and joins.
WHAT YOU WILL LEARN
-
recognize the basic syntax of the SELECT statement and how it is used to retrieve datacreate SELECT statements using the WHERE and ORDER BY clauses to limit and order returned recordscreate INSERT INTO statements using SELECT to copy data between tablescreate SELECT statements using the JOIN clause to return records from multiple tablescreate SELECT statements using the UNION clause to combine the result of multiple SELECT statements into a single returned dataset
-
use comparison operators on both number and string values in SELECT statementsuse logical operators to test values in SELECT statementsuse assignment operators in SELECT statements to assign values to variablesuse control flow operators to control the results returned by SELECT statementswork with various operator types to create effective SELECT statements
IN THIS COURSE
-
1.SELECT Statement Fundamentals4m 45sUP NEXT
-
2.Record Filtering and Ordering8m 47s
-
3.The INSERT... SELECT Statement4m 53s
-
4.SELECT Statements and Joins10m 52s
-
5.SELECT Statements and Unions6m 15s
-
6.Comparison Operators6m 13s
-
7.Logical Operators5m 56s
-
8.Assignment Operators5m 13s
-
9.Control Flow Operators5m 43s
-
10.Exercise: Creating SELECT Statements5m 3s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.