MYSQL Training Beginners to Advanced + T-SQL

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