Past Event - Topic: NYC IIBA Presents - BA Tools and Techniques - SQL - hands-on workshops for Business Analysts - Session #2
Start Time : Sep 28, 2021 06:00 PM
Post-Meeting notes and Links
Meeting recording
https://sqliteonline.com/
https://www.analyticsisnormal.com/sql

1. Instructor covered how to sort results, select records with matching value, matching any in a list of possible values, matching values beginning with..., how to select records with common values across data sets, identify missing records with missing information, identify all records except..., and records with fields in common - allowing duplicates or not.
2. We learned the types of joins: Inner, outer (full), Left, right, and cross.
3. Next and final session in 2 weeks; Register in advance for session 3 of 3: https://iiba-org.zoom.us/meeting/register/tZAkf-2gqzIjHtDExMBXYngqQfLhXHIzcu-g

We hope to see you there!
Please also consider joining the New York City chapter.

***

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

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/tZckdO2rqTojEtdUwgbGH6SkRgfUS4VrLo2w