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, Operator
  • Creating and Managing Tables
  • Constraints
  • Manipulating Data
  • Basic SQL SELECT Statements
  • FETCH clause to limit the rows
  • Virtual column
  • Restricting and Sorting Data
  • SQL Functions
  • Aggregating Data
  • GROUP BY and HAVING clause
  • Grouping sets expression
  • ROLLUP, CUBE and GROUPING_ID
  • Merge Statement
  • Subqueries
  • SQL Joins

Advance SQL

  • CTE in SQL
  • Data Wrangling with SQL
  • Creating Views
  • Clean Data
  • SQL Windows Functions
  • Performance Tuning SQL Queries
  • Explain Plan
  • Indexing
  • 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.

Class-room Training | Live Online Training
8337066108 | 9123080133 | 9830070014
Hi ! Send your detail for more information

Find us on google

Powered By, Phoenix Enterprise.
All Rights Reserved.