NYC IIBA Presents - BA Tools and Techniques - SQL - hands-on workshops for Business Analysts - Session #3

Warning message

Past event disabled.

NYC IIBA Presents - BA Tools and Techniques - SQL - hands-on workshops for Business Analysts - Session #3

Tuesday, October 12, 2021 -

18:00 to 20:00

Post-Meeting notes and Links
Meeting recording
https://sqliteonline.com/
https://www.analyticsisnormal.com/sql
Meeting covered advanced SQL topics extending and building on workshops 1 & 2.

Register in advance for this meeting: https://iiba-org.zoom.us/meeting/register/tZAkf-2gqzIjHtDExMBXYngqQfLhXHIzcu-g
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.

This third of three workshops will teach and offer the opportunity to practice SQL skills within business context examples.
Tuesday, Oct 12th, 6pm -8pm est

The following topics will be covered in this 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

Please do the following in advance of the workshop:
Explore online SQL editor at https://sqliteonline.com/

Instructor Bio:
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/

Registration:
Register in advance for this meeting: https://iiba-org.zoom.us/meeting/register/tZAkf-2gqzIjHtDExMBXYngqQfLhXHIzcu-g

Event Details:

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. This second of three workshops will teach and offer the opportunity to practice SQL skills within business context examples. Tuesday, Sep 28th, 6pm -8pm est The following topics will be covered in this session: Sorting data using ORDER BY Filtering data using WHERE Statement 5 Joins in SQL - Includes detailed explanation for interview questions 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/

Event Location:

Speaker:

Ekta Aggarwal

Location Name:

Zoom

Event Directions:

Event Type:

Online