Data Analyst
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.
- FUNCTIONS
- GETDATE, DATENAME, and DATEADD
- LEFT, RIGHT, SUBSTRING, and REPLACE functions to manipulate strings.
- CASE
- The CASE function comes in two varieties: simple and searched.
- STORED PROCEDURE
- How to create and execute stored procedures
- Create Store procedure, Create Function, Create Trigger, Create View.
Features
Real Life Case Studies
Projects modeled on select use cases with implementation of diverse technology concepts
Assignments
All guided classes and courses are mandatorily followed by useful practical assignments
24x7 Expert Support
Every technical query is resolved on demand with readily available expert assistance
Instructor-led Sessions
Technical session conducted under the guidance of qualified and certified educationists
Related Course
Data Science
Overview Curriculum Features Overview Data Science
MS Excel & VBA
Overview Curriculum Features Overview VBA works
MS SQL Server & Business Intelligence
Overview Curriculum Features Overview Microsoft SQL
