MySQL: Querying Data Using the SELECT Statement


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
Viewing, retrieving and editing data from database objects are some of the most common tasks involved with MySQL databases. In this course, you’ll learn basics of the SELECT statement and how to work with multi-table queries. You’ll also be introduced to Functions and Grouping and how to work with Visual Query Builders.

Target Audience
Personnel at all levels of an enterprise seeking to attain competency in MySQL

Prerequisites
None

Expected Duration (hours)
3.4

Lesson Objectives

MySQL: Querying Data Using the SELECT Statement

  • start the course
  • use basic syntax of the SELECT statement for data retrieval
  • define the comparison operators, simple calculated fields, and aliases
  • describe how to use online help to view information about functions and operators
  • define the SELECT statement and the Limit clause
  • define the SELECT statement with the WHERE and ORDER BY clause
  • define the SELECT statement with the range filtering
  • define the SELECT statement using all components
  • use character-based comparison to filter data
  • use numeric-based comparison to filter data
  • define character expression and aliases
  • define Numeric expression and aliases
  • apply the basic and common functions
  • define the Group By clause and Aggregate Functions
  • apply the basic functions such as the Round function
  • apply the system functions such as the basic time and date functions
  • apply the character functions to change the display of characters
  • apply the date and time functions to change how they display
  • apply the GROUP BY and aggregate functions to create collections of data based on common value
  • apply the COUNT function and its syntax
  • apply the MIN and MAX functions and their syntax
  • apply the SUM and AVERAGE functions and their syntax
  • apply different functions to achieve a detailed summary of information
  • define Multi-Table Queries to select data from more than one table
  • apply join statements and select data from two different tables
  • apply multi-table and multi-join queries to retrieve data from different tables
  • apply advanced join types to seek values located on one side of the join
  • define Visual Query Builders to connect to a database and create a query from a 3rd party visual query builder application
  • use the SELECT statement to perform different types of queries
  • Course Number:
    df_mysq_a02_it_enus

    Expertise Level
    Beginner