SQL: Reporting and Analysis for beginners

This introductory beginners course will help you master SQL for Data Reporting & daily data analysis by learning how to select,

filter & sort data, customize output, & how you can report aggregated data from a database!

The course, we will focus on ANSI(American National Standards Institute) SQL that works on

every database like Oracle, MySQL, Microsoft SQL Server, etc.

SQL has become a requirement for most data science jobs that include:

data analyst, BI (Business Intelligence) developer, programmer, database programmer.

SQL will let you communicate with the database and work with your data.

What You will learn include:

• Writing SQL SELECT Statements

• Eliminating duplicate rows using DISTINCT

• Restricting and Sorting Data

• WHERE clause, wildcard like IN, LIKE

• Analysing data using various SQL Operators

• Sorting data  using ORDER BY clause

• Character Functions

• Concat   Functions

• Using LIMIT Operator

• Reporting Aggregated Data Using the Group Functions

• AVG, COUNT, MIN, MAX...

• Using GROUP BY and HAVING Clauses

• Displaying Data From Multiple Tables

• inner-join, right outer-join, left outer-join, self-join

• Analysing data Using Subqueries

• Analysing data Using nested Subqueries