MySQL: Querying Data Using the SELECT Statement

Overview/Description
MySQL is fast, reliable, easy to use, free to download and supports standard SQL. In this course, you’ll be introduced to MySQL and learn how to initially configure My SQL using the MySQL Workbench. You’ll also be introduced to the core concepts of relational database management systems (RDBMS) as well as core design concepts including table and column design.

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

Prerequisites
None

Expected Duration (hours)
3.0

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