Descripción del Curso

Welcome! In this course you can learn to produce data reports on MYSQL server using MYSQL and T-SQL. In this course you will learn to return data sets by:

Accessing Data:

-All Columns, A single column and multiple columns of data from a Single Table

-All Columns, A Single Column and Multiple Columns from Multiple Table (Join Syntax)

-Unite queries to stack a queries results on top of another queries results

Filtering Data:

-Count total records in a table

-Display only Distinct values in a table (Remove Duplicates)

-Order data in a result set (Ascending / Descending)

-Unite query results to format results with result set totals

-Where Clause with Conditional and Logical operators to return data meeting specific conditions.

-Date Functions and formatting

-Combine entire table data into single rows with Aggregate Functions

Detalles del Curso
en
en
Mike Miller
Ritmo propio
Principiante
4 horas
Detalles del Curso
en
en
Mike Miller
Ritmo propio
Principiante
4 horas
Descripción del Curso

Welcome! In this course you can learn to produce data reports on MYSQL server using MYSQL and T-SQL. In this course you will learn to return data sets by:

Accessing Data:

-All Columns, A single column and multiple columns of data from a Single Table

-All Columns, A Single Column and Multiple Columns from Multiple Table (Join Syntax)

-Unite queries to stack a queries results on top of another queries results

Filtering Data:

-Count total records in a table

-Display only Distinct values in a table (Remove Duplicates)

-Order data in a result set (Ascending / Descending)

-Unite query results to format results with result set totals

-Where Clause with Conditional and Logical operators to return data meeting specific conditions.

-Date Functions and formatting

-Combine entire table data into single rows with Aggregate Functions