Data Analyst

3803 Views

Technology

Overview

Curriculum

Features

Overview

A Data Analyst interprets data and turns it into information which can offer ways to improve a business, thus affecting business decisions. A Data Analyst performs various operations of Data Quality Checks, Data Profiling, Data Validation and Data Cleansing to provide additional information about data

Curriculum

SELECT
- What is T-SQL
- the query tools you use with it
- how to use the SELECT statement
INSERT, UPDATE and DELETE
- How to use the INSERT, UPDATE, and DELETE statements.
- Add, change, and delete data from tables.

AGGREGATION
- COUNT, MIN, MAX, AVG, and SUM.

GROUP BY
- How to use the GROUP BY clause in SELECT statements

JOINS
- INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN, and CROSS JOIN

CREATE
- Create your own tables.

VIEWS
- A view is merely a stored T-SQL statement that generates a result set when executed.
- When you query a view, you’re really querying the result set of a previously defined query.