SQL: Reporting and Analysis for beginners
Description
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
Udemy FREE Course for Limited Time HURRY UP
100%
Free
Course
