SELECT Statement & Operators

MySQL 8.0
  • 10 Videos | 1h 8m 9s
  • Includes Assessment
  • Earns a Badge
Likes 18 Likes 18
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 data
    create SELECT statements using the WHERE and ORDER BY clauses to limit and order returned records
    create INSERT INTO statements using SELECT to copy data between tables
    create SELECT statements using the JOIN clause to return records from multiple tables
    create 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 statements
    use logical operators to test values in SELECT statements
    use assignment operators in SELECT statements to assign values to variables
    use control flow operators to control the results returned by SELECT statements
    work with various operator types to create effective SELECT statements

IN THIS COURSE

  • Playable
    1. 
    SELECT Statement Fundamentals
    4m 45s
    UP NEXT
  • Playable
    2. 
    Record Filtering and Ordering
    8m 47s
  • Locked
    3. 
    The INSERT... SELECT Statement
    4m 53s
  • Locked
    4. 
    SELECT Statements and Joins
    10m 52s
  • Locked
    5. 
    SELECT Statements and Unions
    6m 15s
  • Locked
    6. 
    Comparison Operators
    6m 13s
  • Locked
    7. 
    Logical Operators
    5m 56s
  • Locked
    8. 
    Assignment Operators
    5m 13s
  • Locked
    9. 
    Control Flow Operators
    5m 43s
  • Locked
    10. 
    Exercise: Creating SELECT Statements
    5m 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.

YOU MIGHT ALSO LIKE

Likes 22 Likes 22  
Likes 38 Likes 38  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL Developer
Likes 152 Likes 152  
Likes 188 Likes 188