NYC IIBA Presents - BA Tools and Techniques - SQL - hands-on workshops for Business Analysts
Past Event - Topic: NYC IIBA Presents - BA Tools and Techniques - SQL - hands-on workshops #1 of 3 - for Business Analysts
Start Time : Sep 14, 2021 05:39 PM
Post-Meeting notes and Links
Meeting recording
https://sqliteonline.com/
https://www.analyticsisnormal.
- Interview question: what is the sequence of commands? You cannot place “where” after “group by”
- /* FROM -- WHERE -- GROUP BY -- ORDER BY -- HAVING */
- Interview question: difference between Where and Having: not 100% clear, but Having can refer to formula, Where refers to actual field, cannot use formula with Where
count(loan_id) as number_of_applications,
avg(loanamount) as avg_loan_amt,
min(loanamount) as min_amt,
max(credit_history) as max_credit_history
FROM loan_data
WHERE property_area = 'Rural'
GROUP BY Gender, Married
HAVING avg(loanamount) > 120
- Tutorial for constraints: https://www.analyticsisnormal.
com/post/constraints-in-sql - Tutorial for primary key https://www.analyticsisnormal.
com/post/primary-key-in-sql - Attached exercise file
- Course code to use on IIBA website to claim credit for the class: b6152840-9afd-4
- Next session in 2 weeks, registration already open
Register in advance for this meeting: https://iiba-org.zoom.us/meeting/register/tZIof-Csqj4qHt0tPHOhdLWrYnWZJlHyXg3_
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 first of three workshops will teach and offer the opportunity to practice SQL skills within business context examples.
Tuesday, Sep 14th, 6pm -8pm est
The following topics will be covered in this 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
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.
Registration:
Register in advance for this meeting: https://iiba-org.zoom.us/meeting/register/tZIof-Csqj4qHt0tPHOhdLWrYnWZJlHyXg3_