MYSQL Training Beginners to Advanced + T-SQL - Udemy
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