Introduction to SQL 2: Ordering, Summarizing, and Calculating Data
Introduction to SQL 2: Ordering, Summarizing, and Calculating Data Online
Remote workshop. Do you work with databases and want to understand them better or learn how to query them? Or do you work with spreadsheets and wonder if a relational database is for you? This introductory workshop sequence is designed for folks with no programming background. In the first class you will learn how to do the following:
- Review filtering in SQL
- Use SQL functions like
AVGin combination with clauses like
GROUP BYto aggregate values and return results for reports.
- Make calculations on fields using SQL.
- Understand how to build queries, and the order in which to build the parts.
For prerequisites, more information, or if you missed the first session, see the complete workshop description page here.