Since 1998, Formerly ATC of CMC Academy
Data Analysis using SQL Duration 48 Hrs.
Program highlights and Objectives:
This Instructor-led live online classes or classroom training provides a complete understanding of Data Analysis using SQL. This analysis is used to improve business information and provide new insights to to drive an informed decision-making process.
Course highlights

Basic SQL

  • Introduction to RDBMS
  • SQL Types
  • Creating and Managing Tables
  • Manipulating Data
  • Basic SQL SELECT Statements
  • FETCH clause to limit the rows
  • Virtual column
  • Restricting and Sorting Data
  • SQL Operator
  • SQL Functions
  • Aggregating Data
  • Grouping sets expression
  • Grouping using ROLLUP and CUBE Clauses
  • SQL Joins

Advance SQL

  • CTE in SQL
  • Data Wrangling with SQL
  • Clean Data
  • SQL Windows Functions
  • Performance Tuning SQL Queries
  • Pivoting Data in SQL
  • REGXP_LIKE Condition
  • Working JSON in SQL
  • Data Import Export
Download detail curriculum
Career opportunity
There is a very high demand for data analysts, and it is easy to make the transition into the field without having to spend years of rigorous studying.
Placement
Successful candidates are eligible for placement assistance.
Enquiry: (Classroom / Online Training)
8337066108 | 9123080133 | 9830070014
9433258217 | (033) 24617112

Gariahat Kolkata-700029 India

Hi ! Send your detail for more information

Find us on google

Powered By, Phoenix Enterprise. All Rights Reserved.