Since 1998, Formerly ATC of CMC Academy
Data Analysis using SQL & Excel Duration 100 Hrs.
Program highlights and Objectives:
This Instructor-led live online classes or classroom training provides a complete understanding of Data Analysis using SQL & Excel. 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
  • DDL and DML Statements
  • Using SQL in Mode
  • SQL SELECT
  • SQL LIMIT
  • SQL WHERE
  • SQL Comparison Operators
  • SQL Logical Operators
  • SQL LIKE
  • SQL IN
  • SQL BETWEEN
  • SQL IS NULL
  • SQL AND
  • SQL OR
  • SQL NOT
  • SQL ORDER BY

Intermediate SQL

  • SQL Aggregate Functions
  • SQL COUNT
  • SQL SUM
  • SQL MIN/MAX
  • SQL AVG
  • SQL GROUP BY
  • SQL HAVING
  • SQL CASE
  • SQL DISTINCT

SQL Joins

  • SQL INNER JOIN
  • SQL Outer Joins
  • SQL LEFT JOIN
  • SQL RIGHT JOIN
  • SQL Joins Using WHERE or ON
  • SQL FULL OUTER JOIN
  • SQL UNION
  • SQL Joins with Comparison
  • Operators
  • SQL Joins on Multiple Keys
  • SQL Self Joins

Advanced SQL

  • Leveling up
  • SQL Data Types
  • SQL Date Format
  • Data Wrangling with SQL
  • Using SQL String Functions to Clean Data
  • Writing Subqueries in SQL
  • SQL Window Functions
  • Performance Tuning SQL Queries
  • Pivoting Data in SQL
  • Data Wrangling with SQL

Data Analysis using Excel

  • Data analysis terminology breakdown using excel
  • Complex functions
  • Pivot tables and charts
  • Insight generation and summary report
  • SQL Tutorial Conclusion
Download detail curriculum
Exit Profile
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