Data Analyst

Data Analyst

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

Real Life Case Studies

Projects modeled on select use cases with implementation of diverse technology concepts

Assignments

Assignments

All guided classes and courses are mandatorily followed by useful practical assignments

24x7 Expert Support

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

Course Info

Estimated Duration 3/4 Weeks
Maximum Students 12
Levels Advanced

Social Share