Sreelaxmi Chakkadath
Data Science Master's student
Indiana University Bloomington |
Sreelaxmi Chakkadath is a Data Science master's student at Indiana University Bloomington. Prior to this, she worked at Accenture as a senior data analyst for 4.5 years. Sreelaxmi worked majorly on US healthcare data. In addition to my master's degree, she currently works part-time as an associate instructor, teaching undergraduate students in SQL and basic statistics in R. She has held positions of leadership in a number of volunteer groups, including IEEE Women in Engineering and the IEEE Special Interest Group for Humanitarian Technologies. |
Workshop: Basic to Intermediate Level SQL
April 27, 2022; 8:45-9:30am PST
April 27, 2022; 8:45-9:30am PST
The workshop would focus on the basic to intermediate levels of SQL. We will start with querying a database, using filters to clean the data. Joining different tables. Aggregate functions and use of ‘CASE WHEN’ for better query performances. Subqueries and Common Table Expressions (CTEs) and a comparison between them. Use of window functions. Lead and lag functions and the scenarios when they can be used. Pivot tables and when not to use them!
Back to Workshop Instructors