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