In this course, you will learn :
- About their structure, how to talk about them in database jargon, and how to start an analysis by selecting and summarising columns from database tables using simple SQL commands.
- Discover how to use basic comparison operators, combine multiple criteria, match text patterns, and much more.
- How to Use Aggregate Functions to Summarize Data and Gain Insight In addition, you'll learn about SQL arithmetic and How to use aliases to make your results more readable.
- Selecting columns
- Filtering rows
- Aggregate Functions
- Sorting and grouping