MySQL Database Development: SELECT Statement & Operators

MySQL    |    Beginner
  • 10 videos | 1h 3m 39s
  • Includes Assessment
  • Earns a Badge
Rating 4.8 of 43 users Rating 4.8 of 43 users (43)
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

  • 4m 45s
    After completing this video, you will be able to recognize the basic syntax of the SELECT statement and how to use it to retrieve data. FREE ACCESS
  • 8m 47s
    In this video, find out how to create SELECT statements using the WHERE and ORDER BY clauses to limit and order the records that are returned. FREE ACCESS
  • Locked
    3.  The INSERT... SELECT Statement
    4m 53s
    During this video, you will learn how to create INSERT INTO statements using SELECT to copy data from one table to another. FREE ACCESS
  • Locked
    4.  SELECT Statements and Joins
    10m 52s
    Learn how to create SELECT statements using the JOIN clause to return records from multiple tables. FREE ACCESS
  • Locked
    5.  SELECT Statements and Unions
    6m 15s
    In this video, you will create SELECT statements using the UNION clause to combine the results of multiple SELECT statements into a single returned dataset. FREE ACCESS
  • Locked
    6.  Comparison Operators
    6m 13s
    During this video, you will learn how to use comparison operators on both number and string values in SQL SELECT statements. FREE ACCESS
  • Locked
    7.  Logical Operators
    5m 56s
    During this video, you will learn how to use logical operators to test values in SQL SELECT statements. FREE ACCESS
  • Locked
    8.  Assignment Operators
    5m 13s
    To assign values to variables in SELECT statements, use assignment operators. FREE ACCESS
  • Locked
    9.  Control Flow Operators
    5m 43s
    In this video, you will learn how to use control flow operators to control the results returned by SELECT statements. FREE ACCESS
  • Locked
    10.  Exercise: Creating SELECT Statements
    5m 3s
    In this video, you will learn how to work with various operator types to create effective SELECT statements. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course MySQL Database Development: Manipulating Data
Rating 4.4 of 80 users Rating 4.4 of 80 users (80)
Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Book Querying SQL Server: Run T-SQL Operations, Data Extraction, Data Manipulation, and Custom Queries to Deliver Simplified Analytics

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course MySQL Database Development: Stored Routines, Triggers, & the InnoDB memcached Plugin
Rating 4.4 of 15 users Rating 4.4 of 15 users (15)
Course Database Fundamentals: Getting Started with SQL
Rating 4.5 of 272 users Rating 4.5 of 272 users (272)
Course MySQL Database Development: Introduction
Rating 4.6 of 109 users Rating 4.6 of 109 users (109)