Home
New
York
 

BA Tools and Techniques - SQL

IIBA NYC Chapter is proud to anounce BA Tools and Techniques - a series of hands-on workshops for Business Analysts.
Data provides significant insight to a business and Business Analysts can use SQL to view and understand it.

The first three workshops will teach and offer the opportunity to practice SQL skills within business context examples.
These workshope and will be offered over the following three Tuesdays, and will run from 6pm to 8pm est:

  1. Tuesday, Sep 14th, 6pm -8pm est
  2. Tuesday, Sep 28, 6pm -8pm est
  3. Tuesday, Oct 12, 6pm -8pm est

The following topics will be covered:
September 14th session:

  • Creating a table in SQL
  • INSERTing data into a SQL table
  • Constraints in SQL
  • Primary Key in SQL
  • SELECT statement in SQL (Selecting some of the columns)
  • Aggregate functions and GROUP BY in SQL
  • GROUP BY and HAVING in SQL

September 28 session:

  • Sorting data using ORDER BY
  • Filtering data using WHERE Statement
  • 5 Joins in SQL - Includes detailed explanation for interview questions

October 12th session:

  • UNION , UNION ALL, INTERSECT and EXCEPT
  • Sub-Queries in SQL  - Includes detailed explanation for interview questions to Sub-queries in SQL
  • CASE WHEN (Proxy of IF-ELSE) in SQL - Detailed explanation for interview questions to CASE WHEN statements
  • Selecting top N rows in SQL
  • ALTER TABLE in SQL
  • UPDATE - SET in SQL
  • TRUNCATE, DROP and DELETE
  • COALESCE in SQL
  • String functions in SQL
  • CAST in SQL

Ekta Aggarwal is the instructor for these workshops. Ms. Aggarwal is a professional data scientist with 3 years of work experience. She is currently pursuing her Masters in Data Science at the University of Leeds. She has  worked with McKinsey & Company and Evalueserve for retail and healthcare clients. She has also helped people with the statistical analysis for their dissertations. She holds a Masters and Bachelors in Statistics from the University of Delhi, is an avid learner who is curious to learn more about Artificial Intelligence, Data Science and Business Analytics. She aims to disseminate knowledge about data science to enthusiasts for knowledge like herself.

Reference materials can be found at her website at: https://www.analyticsisnormal.com/