Lesson 2: Filtering, Grouping & Aggregating Data - Direct Connect

Home
Explore
- Pages
  Home Courses About Us Contact Us Careers Instructors Blogs
  Support
  FAQ Help Center Community
Courses
- Categories
  
  {"blocks":{"dp7tnsjl":{"visibility":true,"collapse":false,"name":"collection","title":"Collection","properties":{"tag":"div","dynamicContent":{"type":"courses","collectionType":"terms","items":10,"current_page":1,"pagination":true,"pagination_type":"numeric","filters":[],"sorting":[],"offset":0,"taxonomy":"course-category","inherit":false,"related":false,"relatedCollection":""},"symbolElPropId":"sepdx2ymh"},"styleIds":[],"className":"","source":"kirki","children":["dpeqcnfb","dpha65zn"],"id":"dp7tnsjl","parentId":"dp5wtt4t","stylePanels":{"typography":true,"composition":true,"size":true,"background":true,"stroke":true,"shadow":true,"effects":true,"position":true,"transform":true,"interaction":true,"animation":true},"template_mounted":true},"dpeqcnfb":{"visibility":true,"collapse":false,"name":"items","title":"Items","properties":{"attributes":[],"symbolElPropId":"seporcu2t"},"styleIds":["pathwise_dpk5psse"],"className":"","source":"kirki","children":["dpctx7su"],"id":"dpeqcnfb","parentId":"dp7tnsjl","stylePanels":{"typography":true,"composition":true,"size":true,"background":true,"stroke":true,"shadow":true,"effects":true,"position":true,"transform":true,"interaction":true,"animation":true},"template_mounted":true},"dpctx7su":{"styleIds":[],"visibility":true,"collapse":false,"name":"item","title":"Item","properties":{"tag":"div","attributes":[],"symbolElPropId":"sepwij6dk"},"className":"","source":"kirki","children":["dpk95pjk"],"id":"dpctx7su","parentId":"dpeqcnfb","template_mounted":true},"dpk95pjk":{"visibility":true,"collapse":false,"name":"link-block","title":"Link","properties":{"tag":"a","type":"href","attributes":{"href":"#","target":""},"symbolElPropId":"sep003ewd","isActive":false,"dynamicContent":{"type":"term","value":"link"}},"styleIds":["pathwise_dpqvbamu","pathwise_dp82bapa","pathwise_dpcerrre"],"className":"","source":"kirki","children":["dpd1w1bd"],"id":"dpk95pjk","parentId":"dpctx7su","stylePanels":{"typography":true,"composition":true,"size":true,"background":true,"stroke":true,"shadow":true,"effects":true,"position":true,"transform":true,"interaction":true,"animation":true},"template_mounted":true},"dpd1w1bd":{"styleIds":["pathwise_dpjnini0","pathwise_dpqyke5z","pathwise_dpk30lff"],"visibility":true,"collapse":false,"name":"text","title":"Text","properties":{"contents":["Web Development"],"tag":"span","symbolElPropId":"sepddxtt1","dynamicContent":{"type":"term","value":"name"}},"className":"","source":"kirki","id":"dpd1w1bd","parentId":"dpk95pjk"},"dpha65zn":{"visibility":true,"collapse":false,"name":"empty","title":"Empty","properties":{"attributes":[],"symbolElPropId":"sept5c5zi"},"styleIds":[],"className":"","source":"kirki","children":[],"id":"dpha65zn","parentId":"dp7tnsjl","stylePanels":{"typography":true,"composition":true,"size":true,"background":true,"stroke":true,"shadow":true,"effects":true,"position":true,"transform":true,"interaction":true,"animation":true}}},"styles":{"pathwise_dpk5psse":{"id":"pathwise_dpk5psse","type":"class","name":"pathwise_dph2deod","variant":{"md":"display:flex;flex-direction:column;row-gap:12px;","mobileLandscape":"row-gap:20px;"},"isSymbolStyle":true,"isDefault":false},"pathwise_dpqvbamu":{"id":"pathwise_dpqvbamu","type":"class","name":["pathwise_dpe2z44t"],"variant":{"md":"fill:rgba(89, 93, 126, 1.00);","mobile":"display:flex;flex-direction:row;align-items:stretch;"},"isGlobal":true,"isSymbolStyle":true,"isDefault":false},"pathwise_dp82bapa":{"id":"pathwise_dp82bapa","type":"class","name":["pathwise_hover-link"],"variant":{"md":""},"isSymbolStyle":true,"isGlobal":true,"isDefault":false},"pathwise_dpcerrre":{"id":"pathwise_dpcerrre","type":"class","name":["pathwise_header-line","pathwise_hover-link"],"isComboClass":true,"variant":{"md":"fill:var(--pathwise_dpipal1w);display:flex;flex-direction:row;font-weight:500;font-style:normal;text-decoration:none;cursor:pointer;font-size:14px;line-height:14px;color:var(--pathwise_dpipal1w);font-family:\"Epilogue\";align-items:center;column-gap:2px;transition-property:all;transition-duration:400ms;transition-delay:0ms;transition-timing-function:ease;justify-content:flex-start;","md_hover":"color:var(--pathwise_dpc1w8m7);fill:var(--pathwise_dpc1w8m7);text-decoration:underline;"},"isSymbolStyle":true,"isGlobal":true,"isDefault":false},"pathwise_dpjnini0":{"id":"pathwise_dpjnini0","type":"class","name":["pathwise_dplce6w3"],"variant":{"md":"fill:rgba(89, 93, 126, 1.00);margin:0px;","md_hover":""},"isGlobal":true,"isSymbolStyle":true,"isDefault":false},"pathwise_dpqyke5z":{"id":"pathwise_dpqyke5z","type":"class","name":["pathwise_text-color"],"variant":{"md":""},"isGlobal":true,"isSymbolStyle":true,"isDefault":false},"pathwise_dpk30lff":{"id":"pathwise_dpk30lff","type":"class","name":["pathwise_dplce6w3","pathwise_text-color"],"isComboClass":true,"variant":{"md":"fill:var(--pathwise_dpipal1w);transition-property:all;transition-duration:250ms;transition-delay:0ms;transition-timing-function:ease;","md_hover":"fill:var(--pathwise_dpc1w8m7);"},"isGlobal":true,"isSymbolStyle":true,"isDefault":false}}}
  
  Data & AI
  
  Development
  
  marketing
  Explore All Courses
Cart
0
Log in
Sign up

Lesson 2: Filtering, Grouping & Aggregating Data - Direct Connect

Home
Explore
- Pages
  Home Courses About Us Contact Us Careers Instructors Blogs
  Support
  FAQ Help Center Community
Courses
- Categories
  
  {"blocks":{"dp7tnsjl":{"visibility":true,"collapse":false,"name":"collection","title":"Collection","properties":{"tag":"div","dynamicContent":{"type":"courses","collectionType":"terms","items":10,"current_page":1,"pagination":true,"pagination_type":"numeric","filters":[],"sorting":[],"offset":0,"taxonomy":"course-category","inherit":false,"related":false,"relatedCollection":""},"symbolElPropId":"sepdx2ymh"},"styleIds":[],"className":"","source":"kirki","children":["dpeqcnfb","dpha65zn"],"id":"dp7tnsjl","parentId":"dp5wtt4t","stylePanels":{"typography":true,"composition":true,"size":true,"background":true,"stroke":true,"shadow":true,"effects":true,"position":true,"transform":true,"interaction":true,"animation":true},"template_mounted":true},"dpeqcnfb":{"visibility":true,"collapse":false,"name":"items","title":"Items","properties":{"attributes":[],"symbolElPropId":"seporcu2t"},"styleIds":["pathwise_dpk5psse"],"className":"","source":"kirki","children":["dpctx7su"],"id":"dpeqcnfb","parentId":"dp7tnsjl","stylePanels":{"typography":true,"composition":true,"size":true,"background":true,"stroke":true,"shadow":true,"effects":true,"position":true,"transform":true,"interaction":true,"animation":true},"template_mounted":true},"dpctx7su":{"styleIds":[],"visibility":true,"collapse":false,"name":"item","title":"Item","properties":{"tag":"div","attributes":[],"symbolElPropId":"sepwij6dk"},"className":"","source":"kirki","children":["dpk95pjk"],"id":"dpctx7su","parentId":"dpeqcnfb","template_mounted":true},"dpk95pjk":{"visibility":true,"collapse":false,"name":"link-block","title":"Link","properties":{"tag":"a","type":"href","attributes":{"href":"#","target":""},"symbolElPropId":"sep003ewd","isActive":false,"dynamicContent":{"type":"term","value":"link"}},"styleIds":["pathwise_dpqvbamu","pathwise_dp82bapa","pathwise_dpcerrre"],"className":"","source":"kirki","children":["dpd1w1bd"],"id":"dpk95pjk","parentId":"dpctx7su","stylePanels":{"typography":true,"composition":true,"size":true,"background":true,"stroke":true,"shadow":true,"effects":true,"position":true,"transform":true,"interaction":true,"animation":true},"template_mounted":true},"dpd1w1bd":{"styleIds":["pathwise_dpjnini0","pathwise_dpqyke5z","pathwise_dpk30lff"],"visibility":true,"collapse":false,"name":"text","title":"Text","properties":{"contents":["Web Development"],"tag":"span","symbolElPropId":"sepddxtt1","dynamicContent":{"type":"term","value":"name"}},"className":"","source":"kirki","id":"dpd1w1bd","parentId":"dpk95pjk"},"dpha65zn":{"visibility":true,"collapse":false,"name":"empty","title":"Empty","properties":{"attributes":[],"symbolElPropId":"sept5c5zi"},"styleIds":[],"className":"","source":"kirki","children":[],"id":"dpha65zn","parentId":"dp7tnsjl","stylePanels":{"typography":true,"composition":true,"size":true,"background":true,"stroke":true,"shadow":true,"effects":true,"position":true,"transform":true,"interaction":true,"animation":true}}},"styles":{"pathwise_dpk5psse":{"id":"pathwise_dpk5psse","type":"class","name":"pathwise_dph2deod","variant":{"md":"display:flex;flex-direction:column;row-gap:12px;","mobileLandscape":"row-gap:20px;"},"isSymbolStyle":true,"isDefault":false},"pathwise_dpqvbamu":{"id":"pathwise_dpqvbamu","type":"class","name":["pathwise_dpe2z44t"],"variant":{"md":"fill:rgba(89, 93, 126, 1.00);","mobile":"display:flex;flex-direction:row;align-items:stretch;"},"isGlobal":true,"isSymbolStyle":true,"isDefault":false},"pathwise_dp82bapa":{"id":"pathwise_dp82bapa","type":"class","name":["pathwise_hover-link"],"variant":{"md":""},"isSymbolStyle":true,"isGlobal":true,"isDefault":false},"pathwise_dpcerrre":{"id":"pathwise_dpcerrre","type":"class","name":["pathwise_header-line","pathwise_hover-link"],"isComboClass":true,"variant":{"md":"fill:var(--pathwise_dpipal1w);display:flex;flex-direction:row;font-weight:500;font-style:normal;text-decoration:none;cursor:pointer;font-size:14px;line-height:14px;color:var(--pathwise_dpipal1w);font-family:\"Epilogue\";align-items:center;column-gap:2px;transition-property:all;transition-duration:400ms;transition-delay:0ms;transition-timing-function:ease;justify-content:flex-start;","md_hover":"color:var(--pathwise_dpc1w8m7);fill:var(--pathwise_dpc1w8m7);text-decoration:underline;"},"isSymbolStyle":true,"isGlobal":true,"isDefault":false},"pathwise_dpjnini0":{"id":"pathwise_dpjnini0","type":"class","name":["pathwise_dplce6w3"],"variant":{"md":"fill:rgba(89, 93, 126, 1.00);margin:0px;","md_hover":""},"isGlobal":true,"isSymbolStyle":true,"isDefault":false},"pathwise_dpqyke5z":{"id":"pathwise_dpqyke5z","type":"class","name":["pathwise_text-color"],"variant":{"md":""},"isGlobal":true,"isSymbolStyle":true,"isDefault":false},"pathwise_dpk30lff":{"id":"pathwise_dpk30lff","type":"class","name":["pathwise_dplce6w3","pathwise_text-color"],"isComboClass":true,"variant":{"md":"fill:var(--pathwise_dpipal1w);transition-property:all;transition-duration:250ms;transition-delay:0ms;transition-timing-function:ease;","md_hover":"fill:var(--pathwise_dpc1w8m7);"},"isGlobal":true,"isSymbolStyle":true,"isDefault":false}}}
  
  Data & AI
  
  Development
  
  marketing
  Explore All Courses
Cart
0
Log in
Sign up

Sign Up for Newsletter

Quick Links

Home Courses Contact us Blogs

Popular Categories

{"blocks":{"dplcf53d":{"visibility":true,"collapse":false,"name":"collection","title":"Collection","properties":{"tag":"div","dynamicContent":{"type":"courses","collectionType":"terms","items":10,"current_page":1,"pagination":true,"pagination_type":"numeric","filters":[],"sorting":[],"offset":0,"taxonomy":"course-category","inherit":false,"related":false,"relatedCollection":""},"symbolElPropId":"sepdx2ymh"},"styleIds":[],"className":"","source":"kirki","children":["dp6ot60l","dplmfk9c"],"id":"dplcf53d","parentId":"dphpbd4c","stylePanels":{"typography":true,"composition":true,"size":true,"background":true,"stroke":true,"shadow":true,"effects":true,"position":true,"transform":true,"interaction":true,"animation":true},"template_mounted":true},"dp6ot60l":{"visibility":true,"collapse":false,"name":"items","title":"Items","properties":{"attributes":[],"symbolElPropId":"seporcu2t"},"styleIds":["pathwise_dpk5psse"],"className":"","source":"kirki","children":["dp4s8w92"],"id":"dp6ot60l","parentId":"dplcf53d","stylePanels":{"typography":true,"composition":true,"size":true,"background":true,"stroke":true,"shadow":true,"effects":true,"position":true,"transform":true,"interaction":true,"animation":true},"template_mounted":true},"dp4s8w92":{"styleIds":[],"visibility":true,"collapse":false,"name":"item","title":"Item","properties":{"tag":"div","attributes":[],"symbolElPropId":"sepwij6dk"},"className":"","source":"kirki","children":["dpfevvar"],"id":"dp4s8w92","parentId":"dp6ot60l","template_mounted":true},"dpfevvar":{"visibility":true,"collapse":false,"name":"link-block","title":"Link","properties":{"tag":"a","type":"mailto","attributes":{"href":"","target":""},"symbolElPropId":"sep003ewd","isActive":false,"dynamicContent":{"type":"term","value":"link"}},"styleIds":["pathwise_dpqvbamu","pathwise_dpv6lyyd","pathwise_dpprze59"],"className":"","source":"kirki","children":["dpc01ojj","dpl58ww3"],"id":"dpfevvar","parentId":"dp4s8w92","stylePanels":{"typography":true,"composition":true,"size":true,"background":true,"stroke":true,"shadow":true,"effects":true,"position":true,"transform":true,"interaction":true,"animation":true},"template_mounted":true},"dpc01ojj":{"visibility":true,"collapse":false,"name":"svg","title":"Shape","properties":{"tag":"svg","svgOuterHtml":"<svg viewBox=\"0 0 14 14\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n    <path\n        d=\"M9.70898 7.45996L10.168 7L9.70898 6.54004L6.20898 3.04004L5.28906 3.95996L8.3291 7L5.28906 10.04L6.20898 10.96L9.70898 7.45996Z\"\n        fill=\"#595D7E\" \/>\n<\/svg>","symbolElPropId":"sepls7mj5"},"styleIds":["pathwise_dprp4z3j","pathwise_dpzytutu","pathwise_dp76vg67"],"className":"","source":"kirki","id":"dpc01ojj","parentId":"dpfevvar","stylePanels":{"typography":true,"composition":true,"size":true,"background":true,"stroke":true,"shadow":true,"effects":true,"position":true,"transform":true,"interaction":true,"animation":true}},"dpl58ww3":{"styleIds":["pathwise_dpxawptk"],"visibility":true,"collapse":false,"name":"text","title":"Text","properties":{"contents":["Programming & Tech"],"tag":"span","dynamicContent":{"type":"term","value":"name"},"symbolElPropId":"sep62tasp"},"className":"","source":"kirki","id":"dpl58ww3","parentId":"dpfevvar","stylePanels":{"typography":true}},"dplmfk9c":{"visibility":true,"collapse":false,"name":"empty","title":"Empty","properties":{"attributes":[],"symbolElPropId":"sept5c5zi"},"styleIds":[],"className":"","source":"kirki","children":[],"id":"dplmfk9c","parentId":"dplcf53d","stylePanels":{"typography":true,"composition":true,"size":true,"background":true,"stroke":true,"shadow":true,"effects":true,"position":true,"transform":true,"interaction":true,"animation":true}}},"styles":{"pathwise_dpk5psse":{"id":"pathwise_dpk5psse","type":"class","name":"pathwise_dph2deod","variant":{"md":"display:flex;flex-direction:column;row-gap:12px;","mobileLandscape":"row-gap:20px;"},"isSymbolStyle":true,"isDefault":false},"pathwise_dpqvbamu":{"id":"pathwise_dpqvbamu","type":"class","name":["pathwise_dpe2z44t"],"variant":{"md":"fill:rgba(89, 93, 126, 1.00);","mobile":"display:flex;flex-direction:row;align-items:stretch;"},"isGlobal":true,"isSymbolStyle":true,"isDefault":false},"pathwise_dpv6lyyd":{"id":"pathwise_dpv6lyyd","type":"class","name":["pathwise_dpg5y458"],"variant":{"md":""},"isSymbolStyle":true,"isDefault":false},"pathwise_dpprze59":{"id":"pathwise_dpprze59","type":"class","name":["pathwise_dpya9v8n","pathwise_dpg5y458"],"isComboClass":true,"variant":{"md":"fill:var(--pathwise_dpipal1w);display:flex;flex-direction:row;font-weight:500;font-style:normal;text-decoration:none;cursor:pointer;font-size:16px;line-height:23px;color:var(--pathwise_dpipal1w);font-family:\"Epilogue\";align-items:center;column-gap:2px;transition-property:all;transition-duration:400ms;transition-delay:0ms;transition-timing-function:ease;","md_hover":"color:var(--pathwise_dpc1w8m7);fill:var(--pathwise_dpc1w8m7);text-decoration:underline;"},"isSymbolStyle":true,"isDefault":false},"pathwise_dprp4z3j":{"id":"pathwise_dprp4z3j","type":"class","name":["pathwise_dpxx2os9"],"variant":{"md":"min-width:auto;min-height:auto;width:150px;height:auto;max-width:none;"},"isGlobal":true,"isSymbolStyle":true,"isDefault":false},"pathwise_dpzytutu":{"id":"pathwise_dpzytutu","type":"class","name":["pathwise_dpznaaxw"],"variant":{"md":""},"isSymbolStyle":true,"isDefault":false},"pathwise_dp76vg67":{"id":"pathwise_dp76vg67","type":"class","name":["pathwise_dpfrgse9","pathwise_dpznaaxw"],"isComboClass":true,"variant":{"md":"min-width:auto;min-height:auto;width:14px;height:14px;max-width:none;display:none;"},"isSymbolStyle":true,"isDefault":false},"pathwise_dpxawptk":{"id":"pathwise_dpxawptk","type":"class","name":["pathwise_nav-text-2"],"variant":{"md":"fill:rgba(89, 93, 126, 1.00);transition-property:all;transition-duration:250ms;transition-delay:0ms;transition-timing-function:ease-out;margin:0px;","md_hover":"fill:rgba(24, 63, 225, 1.00);"},"isGlobal":true,"isSymbolStyle":true,"isDefault":false}}}

Support

FAQ Help Center Community

Company

About Us Careers

© 2026 Direct Connect All rights reserved.

Terms & Conditions Privacy Policy Cookie Settings